The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Michelle A. Poolet
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 William Vaughn
Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
By Itzik Ben-Gan
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.
When you're gathering requirements in the Discover phase of creating a data warehouse project here is a handy checklist.
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 David Paul Giroux
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 Megan Keller
CodePlex offers hundreds of great free SQL Server 2008 and 2005 projects and samples at the Microsoft SQL Server Community Projects & Samples page.
Idera offers more than 20 free PowerShell scripts at the Free PowerShell scripts for SQL Server DBAs page.
By Michael Otey
Learn how to use SQL Server 2008’s linked server functionality to connect to an Oracle 11g database.
Find out how to work around two of the most common problems you might run into when configuring the Oracle client software.
Use these T-SQL commands to create and manage linked servers.
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.
What you need to know to purchase the right thirty-party reporting and analysis tool for your organization.
By
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!
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.
advertisement