By Kalen Delaney, 04/20/2006
The database snapshot feature in SQL Server 2005 lets you query your databases and run system health reports without blocking end users.
By Blake Eno, 04/20/2006
Check out new and improved SQL Server–related products.
By Michael K. Campbell, 04/20/2006
We weren't able to include SmartDBA in our comparative review. Here's how to find information about the product.
By Michael Otey, 04/20/2006
The Excel Add-in for SQL Server Analysis Services is a free download that works with Microsoft Excel 2003 and Excel 2002 to let you build custom reports that access data from SQL ...
By Michelle A. Poolet, 04/20/2006
The useful NULL condition lets you represent unknown values in a database, but you might worry about its effect on database performance. Never fear: You can use NULL sensibly.
By Itzik Ben-Gan, 04/20/2006
In this second part of a four-part series about custom aggregations, we look at a class of solutions that relies on pivoting techniques.
By Itzik Ben-Gan, 04/20/2006
You run a PIVOT query in the Northwind database, and the results aren't what you expected. Can you identify the bug in the code and suggest a solution?
By Brian Moran, 04/20/2006
Check for fragmentation in database files on the disk array. It could be causing some of your performance problems.
By Michael Otey, 04/20/2006
All the major Microsoft Office 2003 applications include tools that let you incorporate and use data from a SQL Server database. These instructions for importing data into Word, ...
By Michael K. Campbell, 04/20/2006
Check out this comparative review of two hefty database-adminstration products, in which we examine how well Embarcadero Technologies' DBArtisan and Quest Software's Quest Central ...
By Michelle A. Poolet, 04/20/2006
Find out why the Common Language Runtime (CLR) environment in Microsoft Visual Studio 2005 makes it easier to incorporate nullability checks in your code.
By Dennis Hurst, 04/20/2006
Learn what SQL injection is, how it happens, and how to protect your organization from it.
By Itzik Ben-Gan, 04/20/2006
Given a few integers and some basic arithmetic operators, you need to come up with an expression that evaluates to 28. Can you do it?
By Douglas McDowell, 04/20/2006
Here's a tip about defining relationships between key and non-key attributes in your dimensions.
By Michael Otey, 04/20/2006
Definitely worth a look, Neverfail for SQL Server might be the high availability solution you've been seeking.
By Michelle A. Poolet, 04/20/2006
Learn about how the use of the NULL condition affects SQL Server performance.