By , 05/18/2012
Microsoft recently launched Trust Services for Windows Azure, an application-level encryption framework that can be used to protect sensitive data stored on the Windows Azure ...
By Mark Kromer, 05/18/2012
by Mark Kromer This is a follow-up from my blog post last month here on SQL Server Pro about utilizing common traditional reporting tools like Excel and Report Builder with the ...
By Kevin Kline, 05/18/2012
I recommend that you set your SQL Server to use the startup traceflag DBCC TRACEON (3226) to disable backup success message...
By Kevin Kline, 05/17/2012
An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint.
By Paul S. Randal, 05/16/2012
Question: I came across a weird case recently where we had a server that was running at 100% across all CPUs for a time but when I used the DMVs to look at wait statistics I ...
By Kalen Delaney, 05/16/2012
Every SQL table and index has at least one Index Allocation Map (IAM). Learn more about IAMs and how much space is actually allocated to a SQL Server table.
By Denny Cherry, 05/16/2012
Recently I was shown a whitepaper from EMC titled "Backup and Recovery for Microsoft SQL Server Using EMC Data Domain Deduplication Storage Systems". Over all the whitepaper ...
By Michael Otey, 05/15/2012
The best free SQL Server downloads to help you do your job.
By Paul Randal, 05/09/2012
Question: I’ve been wondering about record storage in indexes and how SQL Server maintains the ordering. At what point do records get moved around on the index pages so that ...
By Paul Randal, 05/01/2012
Question: We recently tried to attach a SQL Server 2008R2 database to SQL Server 2012 and the upgrade failed because one of the filegroups in the database is set to read-only. ...