By Michelle A. Poolet, 07/24/2009
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 ...
By William Vaughn, 07/22/2009
Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
By Itzik Ben-Gan, 07/20/2009
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 ...
By Michelle A. Poolet, 07/19/2009
There are certain things you should NOT do when developing your data warehouse project. Here's a short list of nine musts to avoid.
By Michelle A. Poolet, 07/19/2009
When you're gathering requirements in the Discover phase of creating a data warehouse project here is a handy checklist.
By David Paul Giroux, 07/14/2009
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 ...
By Megan Keller, 07/08/2009
Idera offers more than 20 free PowerShell scripts at the Free PowerShell scripts for SQL Server DBAs page.
By Megan Keller, 07/08/2009
CodePlex offers hundreds of great free SQL Server 2008 and 2005 projects and samples at the Microsoft SQL Server Community Projects & Samples page.
By Michael Otey, 07/07/2009
Learn how to use SQL Server 2008’s linked server functionality to connect to an Oracle 11g database.
By Michael Otey, 07/07/2009
Use these T-SQL commands to create and manage linked servers.
By Michael Otey, 07/07/2009
Find out how to work around two of the most common problems you might run into when configuring the Oracle client software.
By Michael Otey, 06/22/2009
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 Megan Keller, 06/17/2009
What you need to know to purchase the right thirty-party reporting and analysis tool for your organization.
By Editors, 06/11/2009
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 ...
By Megan Keller, 06/04/2009
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.