SQL Server Code Name “Denali” CTP 3 is now available. Get it here. Continue reading SQL Server Code Name “Denali” CTP 3 Released Today
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.
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