Re: Using EFS with SQL Databases

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 07/01/04


Date: Thu, 1 Jul 2004 21:43:41 +0100

Be aware this will cause a performance hit, how much depends on your
workload and hardware but when I played with this it was fairly noticeable
even with relatively small workloads. I'm afraid I don't have the exact
figures anymore but it was enough to put me off ever recommending it, that
much I do remember :-)

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Keith" <Keith@Loyd.com> wrote in message
news:23f8101c45eda$cc393840$a501280a@phx.gbl...
> Can anyone point me to a good resource for using EFS to
> encrypt a SQL database?
>
> Thanks,
> Keith
>


Relevant Pages

  • RE: Management Studio update (2005 / SP1)
    ... Thanks Keith. ... Microsoft SQL Server ... How can I just update the client i.e. Management Studio? ... Which build and version of SQL Server 2005 ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server problem on sbs 2K3 + wss sp2
    ... Keith wrote: ... I intended on *upgrading* from using MSDE for SharePoint to using SQL Server so I can do full-text searches and put the companyweb content on a NAS device. ... During the installation of SP3a, though, at step 4, I selected SharePoint and clicked next. ... A message box appeared that said "SHAREPOINT has a newer version of Service pack installed. ...
    (microsoft.public.windows.server.sbs)
  • Re: Emailing SQL 2000 maintenance report via SMTP?
    ... > "Keith Kratochvil" wrote in message ... You can create jobs within the SQL Server Agent that will ... >>> DB maintenance plan just stops doing what it should, ... >>> today) where I find my backups haven't been working for a month!!! ...
    (microsoft.public.sqlserver.programming)
  • Re: very slow view
    ... I was wondering if maybe there was a significant enough change in the data to cause autostats to kick in. ... "Expert SQL Server 2008 Encryption" ... "Keith G Hicks" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Where Can I Buy Entereprise Manager?
    ... did it the correct way when you bought EM last time. ... Tibor Karaszi, SQL Server MVP ... > "Keith Kratochvil" wrote in message ... Perhaps the SQL Server Web Data Administrator will do ...
    (microsoft.public.sqlserver.tools)