By Kurt Survance, 01/21/2010
Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management ...
By Itzik Ben-Gan, 01/20/2010
Learn why the intuitive queries that address a common tree path request are optimized inefficiently, and discover alternative solutions with improved performance.
By Michelle A. Poolet, 01/20/2010
At some point in your career you might get a request, possibly in the form of a court order, to hand over electronically stored information that’s under your care. What can you do ...
By Michael Otey, 01/15/2010
Microsoft’s Dave Campbell explains how SQL Azure combines the features of traditional iron with the cloud to enable rapid provisioning and quick surges for data. Data gathered on ...
By Shaunt Khaldtiance, 12/14/2009
By Uttam Parui, 12/11/2009
By Ryan Christensen, 12/09/2009
Implement this solution to provide data owners with a way to audit access to data they’re responsible for.
By Denny Cherry, 12/08/2009
Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.