SQL Server Magazine July 2009

[Focus]
Organizations have been slow to use virtualization to consolidate SQL Server systems. Here are some compelling reasons for embracing Hyper-V and what you need to know if you decide to do so.
By Michael Otey
[Features]
If you want to create pivoted tables but found the PIVOT operator syntax in SQL Server Books Online (BOL) confusing, try this three-step approach to creating a PIVOT query. This query uses a common table expression (CTE).
By Kathi Kellenberger
Here are the business and design factors that you need to consider and address when designing your data warehouse.
By Michelle A. Poolet
Control access to SharePoint’s functionality and external systems by defining Active Directory service accounts and assigning administrative permissions to users and groups on SharePoint’s internal security layers.
By Matt Ranlett , et al.
[Editorial]
Oracle recently announced a surprising acquisition of Sun Microsystems. Unlike the aborted IBM-Sun merger, this one makes a lot of sense. Oracle is a technology leader, and Sun will strengthen Oracle in a number of fundamental ways.
By Michael Otey
[Reader to Reader]
Some refinements to Index_Evaluation_USP make this T-SQL stored procedure more effective and easier to use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
By Gabriela Nanau
Here are seven tips on how you might use some of the available tools and techniques to make your job as a SQL Server production DBA easier.
By Louis Nguyen
[T-SQL Black Belt]
If performance is your main goal, you should use the set-based solution only with very small partition sizes; otherwise, you should use the CLR-based solution.
By Itzik Ben-Gan
[SELECT TOP(X)]
The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.
By Michael Otey
[Tool Time with Kevin Kline]
This free tool uses T-SQL to more easily perform database maintenance tasks.
By Kevin Kline
[Review]
Use this product to quickly analyze indexes and automate index defragmentation.
By Michael K. Campbell
[PTO for the Rest of Us]
In two previous articles, I've discussed SQL Server 2005 waits and showed you some of the more common ones. Now, let's dive down for a deeper view of what each connection or even thread in the SQL Server instance is waiting on.
By Andrew J. Kelly
|