The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Organizations are increasingly using virtualization to cut costs and increase efficiency. Learn why running SQL Server on Hyper-V makes sense, and how to optimize it if you do.
By Kathi Kellenberger
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 query uses a common table expression (CTE).
By Brendon Schwartz
Control access to SharePoint’s functionality and external systems by defining Active Directory service accounts and assigning administrative permissions to users and groups on SharePoint’s internal security layers.
By Michael Otey
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 will strengthen Oracle in a number of fundamental ways.
By Andrew J. Kelly
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 thread in the SQL Server instance is waiting on.
By Itzik Ben-Gan
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
This free tool uses T-SQL to more easily perform database maintenance tasks.
By Gabriela Nanau
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 indexes that aren't being used efficiently.
By Louis Nguyen
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 Michael K. Campbell
Use this product to quickly analyze indexes and automate index defragmentation.
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.
The licensing for Microsoft products is complicated and virtualization doesn't make the task any easier. Here are the basics.
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 decide to do so.
The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.
advertisement