SQL Server Magazine

		Options
Running SQL Server on Hyper-V Organizations are increasingly using virtualization to cut costs and increase efficiency. Learn why running SQL Server on Hyper-V makes sense, and how to optimize it if you do.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Running SQL Server on Hyper-V

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 

Create Pivoted Tables in 3 Steps

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 

Lessons Learned from Poor Data Warehouse Design

Here are the business and design factors that you need to consider and address when designing your data warehouse.
By Michelle A. Poolet 

SharePoint Security for DBAs

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.

The New Oracle Threat

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 

Improving the Index_Evaluation_USP Stored Procedure

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 

Seven Tips for SQL Server Production DBAs

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 

CLR-Based Solution for Running Aggregates

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 

Using SQL Server 2008's FILESTREAM Data Type

The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.
By Michael Otey 

YourSQLDba

This free tool uses T-SQL to more easily perform database maintenance tasks.
By Kevin Kline 

Review: SQL defrag manager 2.5

Use this product to quickly analyze indexes and automate index defragmentation.
By Michael K. Campbell 

Diving Deeper into Wait Stats

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