SQL Server Magazine February 2010

[Focus]
This reincarnated tool is easy to use but creates certain security risks when users modify reports.
By William Vaughn
[Features]
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 Studio or review in XML for more detailed information.
By Kurt Survance
Implement this solution to provide data owners with a way to audit access to data they’re responsible for.
By Ryan Christensen
Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.
By Denny Cherry
[Editorial]
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 a surge may be one day be provided by datasets in the “Dallas” program.
By Michael Otey
[Reader to Reader]
By Shaunt Khaldtiance
By Uttam Parui
[Solutions by Design]
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 to prepare for this eventuality?
By Michelle A. Poolet
[T-SQL Black Belt]
Learn why the intuitive queries that address a common tree path request are optimized inefficiently, and discover alternative solutions with improved performance.
By Itzik Ben-Gan
[Review]
The Tableau suite of BI applications enable anyone to easily create and share interactive data visualizations, dashboards, and analytics.
By Derek Comingore
|