SQL Server Magazine

		Options
Mega Guide to Free SQL Server Tools Looking for an easier way to do routine tasks or the perfect solution for a gap in SQL Server's functionality? Consult this massive list for free tools related to administration, compliance, BI, change management, performance, security, and much more.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

The Mega Guide to Free SQL Server Tools

Consult this huge list of free SQL Server tools that will help you solve specific SQL Server problems or fill holes in SQL Server’s functionality.
By Megan Keller 

Connecting SQL Server and Oracle Using Linked Servers

Learn how to use SQL Server 2008’s linked server functionality to connect to an Oracle 11g database.
By Michael Otey 

Importing Access Reports into SQL Server Reporting Services

Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
By William Vaughn 

Utilities Assess Data-File Usage and Provide Commands So You Can Do Something About It

Here are two tools you can use to quickly determine the amount of free space in your databases' data files. Moreover, they provide commands that you can execute to decrease or increase the size of your data files.
By David Paul Giroux 

The Data Warehouse Project Discovery Phase

Gathering requirements is absolutely necessary in the discovery phase of successful data warehouse project. In this article, we'll walk through the highlights of gathering requirements for the three project tracks—Technology, Data, and Application Layer.
By Michelle A. Poolet 

Using Nested Iterations and the OVER Clause for Running Aggregates

Until SQL Server supports the OVER clause, your best solutions for running aggregates are a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.
By Itzik Ben-Gan 

8 SQL Server 2008 Downloads

From SQL Server 2008 SP1 to SQL Server Express to SQL Server 2008 Upgrade Advisor, our 8 favorite downloads should find a place in your SQL Server toolbox.
By Michael Otey 

Best of TechEd 2009 Award Winners

The Best of TechEd Awards recognize the most innovative products and services offered by Microsoft partners that exhibited at TechEd 2009, held in June 2009 at the Los Angeles Convention center. Here are our winners!
By Editors 

SQL Server Reporting and Analysis Solutions

What you need to know to purchase the right thirty-party reporting and analysis tool for your organization.
By Megan Keller