SQL Server Magazine

		Options
Best Products of 2009 Explore the top products voted by editors and the community in backup and recovery, business intelligence, database management, database monitoring, development, server hardware, storage, SharePoint, training and certification, and virtualization.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

2009 SQL Server Magazine Editors' Best and Community Choice Awards

We paired off top product picks from editors and the community in 11 categories, including business intelligence, database management, and virtualization.
By Editors 

Administer WSS 3.0 Content Databases from SQL Server

Find out how to use specific T-SQL queries to pull useful information out of tables in SharePoint’s content databases.
By Wendy Henry 

Building Your First Cube

Jump into advanced BI by using this step-by-step guide to making your first cube.
By Derek Comingore 

DBCC CHECKDB for Very Large Databases

Running DBCC can be problematic on VLDBs. Use the author's Admin/Worker Job approach to ease the process.
By David Paul Giroux 

Passing NULL Parameters

Have you ever had a stored procedure that could accept a NULL value as a parameter but didn't seem to work correctly when you did so? Here's what might have gone wrong.
By William Vaughn 

Is SQL Server 2008 R2 For You?

Some things to consider in making a decision to upgrade to SQL Server 2008 R2.
By Michael Otey 

Calculating Concurrent Sessions, Part 2

Itzik presents a set-based solution with linear complexity that performs better than the previous solutions. He also discusses a set-based solution that will outperform all other solutions once SQL Server supports it.
By Itzik Ben-Gan 

SQL Server PowerShell Extensions

Automate even the most difficult SQL Server administrative tasks using this free PowerShell script set.
By Kevin Kline