By Kathi Kellenberger, 06/23/2009
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 ...
By Michael Otey, 06/22/2009
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 ...
By Brendon Schwartz, 06/22/2009
Control access to SharePoint’s functionality and external systems by defining Active Directory service accounts and assigning administrative permissions to users and groups on ...
By Andrew J. Kelly, 06/13/2009
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 ...
By Itzik Ben-Gan, 06/11/2009
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 Kevin Kline, 06/09/2009
This free tool uses T-SQL to more easily perform database maintenance tasks.
By Louis Nguyen, 06/04/2009
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 Gabriela Nanau, 06/04/2009
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 ...
By Michael K. Campbell, 06/03/2009
Use this product to quickly analyze indexes and automate index defragmentation.
By Michael Otey, 05/11/2009
Using SQL Server's multiple instances feature and running instances of SQL Server on virtual machines (VMs) might seem very similar, but there are some substantial differences.
By Michael Otey, 05/11/2009
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 ...
By Michael Otey, 05/11/2009
The licensing for Microsoft products is complicated and virtualization doesn't make the task any easier. Here are the basics.
By Michael Otey, 05/06/2009
The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.