By Michelle A. Poolet, 10/26/2006
Are you unsure how to use supertypes and subtypes to your advantage? Learn why they are used and how to implement them correctly.
By Kimberly L. Tripp, 10/26/2006
In a database performance-engineering process, applying the right design techniques will ensure smooth-running operations. Here’s a laundry list of essential technical items you ...
By Kalen Delaney, 10/26/2006
Row-level versioning can stress your tempdb database—but you can mitigate the increased demand by monitoring tempdb usage using SQL Server 2005 tools.
By Michael Otey, 10/26/2006
Using Microsoft's virtual labs, you can get hands-on experience with SQL Server 2005—but which of the 17 SQL Server 2005 virtual labs should you try first? Here's a quick preview ...
By Itzik Ben-Gan, 10/26/2006
T-SQL randomization isn't particularly straightforward. But some improvements in SQL Server 2005—the use of TOP with input expressions, the APPLY operator, and the TABLESAMPLE ...
By Kevin Kline, 10/26/2006
A free Microsoft change-management and trending tool helps you head off potential performance problems and get the most out of your multi–SQL Server environment.
By Itzik Ben-Gan, 10/26/2006
How many hands did my wife shake at a party of eight? The answer lies in pure logic.
By Michael K. Campbell, 10/26/2006
Check out DBMoto 5.0 if you're looking for a replication solution that's highly scalable and had been designed to help you move and copy data between heterogeneous database ...
By Michael Otey, 10/26/2006
Despite media rumors, Intel's Itanium is still alive and well. Find out how its high-end power will save it from demise.
By Rick Dobson, 10/26/2006
ASP.NET 2.0 lets you use Visual Studio login controls with a SQL Server membership provider to dramatically simplify Web-site membership management.
By Brian Larson, 10/26/2006
The ReportViewer control is a powerful tool for integrating reports into Windows and Web form applications. You can make it even more powerful if you're willing to write a few ...