Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Transparent Data Encryption (TDE) SQL Server 2008 Expand / Collapse
Author
Message
Posted Sunday, May 03, 2009 1:48 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
Comments posted to this topic are about the item Transparent Data Encryption (TDE) SQL Server 2008

-Roy
Post #709018
Posted Sunday, May 03, 2009 10:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 08, 2013 5:39 PM
Points: 263, Visits: 862
Thanks for the article Roy. It's concise, interesting, informative and well-written. 5 stars for you!


James Stover, McDBA
Post #709172
Posted Sunday, May 03, 2009 10:41 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:12 PM
Points: 22,518, Visits: 30,269
Excellent article Roy. We are just now starting to look at the possibility of moving to SQL Server 2008. Turns out in the next tools release of PeopleSoft that SQL Server 2008 will be supported. I'm not sure about using TDE on our databases, but this does provide some vital info should we move that direction.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #709174
Posted Monday, May 04, 2009 3:43 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:46 AM
Points: 3,241, Visits: 4,987
Very Informative Article. And the most appreciating thing is that the writer have clearly mentioned the pros and cons of the subject with respect to the latest release of SQL Server 2008.



----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #709263
Posted Monday, May 04, 2009 7:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:11 PM
Points: 32,810, Visits: 14,959
Excellent Job, Roy! I looked back over this for some checking of the book I'm tech editing.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #709354
Posted Monday, May 04, 2009 7:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:40 AM
Points: 13, Visits: 145
Excellent article. Quick question, is TDE available in standard edition? or do we need to have the enterprise edition?

Thanks!
Post #709387
Posted Monday, May 04, 2009 8:18 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
Thank you all... It is nice to get feedbacks from all of you..
JRamussen, If I am not mistaken, it is available only in the enterprise edition. I will look it up and let you know.




-Roy
Post #709398
Posted Monday, May 04, 2009 8:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 14,825, Visits: 27,299
Great article Roy. Well written and informative.

I was kind of hoping you had a fix to the problem with removing TDE though.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #709410
Posted Monday, May 04, 2009 8:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
Hahahahaha.... I did some experiment and blew up my test DB...
If you and Microsoft cant fix it, you really think I could do it??


-Roy
Post #709411
Posted Monday, May 04, 2009 8:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 14,825, Visits: 27,299
You also performed a service linking to Connect. Hopefully this'll get some more votes.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #709417
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse