SQL Server Magazine February 2010

    Options
Report Builder 2.0
The second iteration of Report Builder is much easier to use than Microsoft's first version. Learn how to build and manage reports, plus explore specific tasks such as modifying a cataloged report and creating a locally hosted report. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

Report Builder 2.0

This reincarnated tool is easy to use but creates certain security risks when users modify reports.
By William Vaughn 



[Features]

Gathering Deadlock Information with Deadlock Graph

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 

Security Reporting for SQL Server Analysis Services

Implement this solution to provide data owners with a way to audit access to data they’re responsible for.
By Ryan Christensen 

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

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]

Iron and Cloud

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]

Filtering DML Statements


By Shaunt Khaldtiance 

Installing Client Tools on a SQL Server 2008 Failover Cluster


By Uttam Parui 



[Solutions by Design]

E-Discovery Q & A for Data Warehouse Administrators

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]

Handling the Tree Path Request

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]

Tableau BI Suite

The Tableau suite of BI applications enable anyone to easily create and share interactive data visualizations, dashboards, and analytics.
By Derek Comingore 



 

ADS BY GOOGLE