SQL Server Code Name “Denali” CTP 3 is now available. Get it here. Continue reading SQL Server Code Name “Denali” CTP 3 Released Today
Month: July 2011
SQL Server 2008 R2 Service Pack 1 Released
Today SQL Server 2008 R2 Service Pack 1 is released today.
Get it here.
- Dynamic Management Views for increased supportability.
- ForceSeek for improved querying performance.
- Data-tier Application Component Framework (DAC Fx) for improved database upgrades.
- Disk space control in PowerPivot for SharePoint.
- Support for 512e Drives.
- Fixed various issues.
SQL Server Decryption
In a previous post, I displayed one method to encrypt data. This post is to show how to show the decrypted data. This post refers to the objects used/created in the previous post. Continue reading SQL Server Decryption
SQL Server Encryption
Recently I had to show that data can be encrypted in SQL Server 2008 database. The purpose was to not store the raw value in a table where anyone with access could see the sensitive data. The original process truncated the destination table and then populated the destination table with data pulled from the source table. Seeing that as an issue, I made a change to the process in addition to adding encryption. Continue reading SQL Server Encryption