By Anne Grubb, 12/18/2006
One of our 2006 SQL Server Magazine Innovators contest winners brought levity to his workplace by developing SQL Server Funeral Services, a procedure that lets users bid adieu to ...
By Itzik Ben-Gan, 12/18/2006
Can a third-party T-SQL editor match the performance of SQL Server's native tools? That's what our reviewer set out to discover.
By Blake Eno, 12/18/2006
Check out new and improved SQL Server-related products.
By Editors, 12/18/2006
Our editors share insights from their conversations with DataDirect, CA, and Symantec.
By Itzik Ben-Gan, 12/18/2006
Four people need to cross a dark tunnel before their flashlight runs out. Find a strategy to get them safely to the other side.
By Michael Otey, 12/18/2006
SQL Server logs can make troubleshooting problems simpler—if you know where to look. Here are 5 SQL Server 2005 log files that might come in handy.
By Kalen Delaney, 12/18/2006
In SQL Server 2005, a single-table query can show as a join operation in a query plan, even when no JOIN operator is specified. Learn more about how the optimizer treats such ...
By Brian Moran, 12/18/2006
Welcome to our new performance-tuning column, your essential source of foundational, need-to-know information to keep you up to speed.
By Dan Sawyer, 12/18/2006
Start with this stored procedure for tracking 15 commonly monitored checkpoints--and build on it by adding your own checks.
By Anne Grubb, 12/18/2006
The winners of this year's SQL Server Magazine Innovators contest epitomize ingenuity, developing fresh solutions to business problems ranging from change management to scheduling ...
By Erik Veerman, 12/18/2006
Thanks to the SQL Server community, you have an alternative DTS migration route.
By Michelle A. Poolet, 12/18/2006
By using the Master Data Management approach to integrate data into a single, trusted source, you'll be able to capitalize on missed business opportunities.
By Kevin Kline, 12/18/2006
Security guru Chip Andrews was frustrated by the need to repeatedly button up SQL Server 2000 security holes. To ensure a fast, effective way to reduce security risks, he created ...
By Itzik Ben-Gan, 12/18/2006
Learn coding techniques to create a virtual auxiliary table of integers that you can use in T-SQL queries.
By Erik Veerman, 12/18/2006
Intimidated by the prospect of migrating from DTS to SSIS? Now that SQL Server 2005 is more than a year old, the process is fairly well documented. But here's how to accomplish a ...
By Michael Otey, 12/18/2006
Does it seem like Microsoft keeps releasing the same SQL Server editions with different names? SQL Server 2005 Compact Edition is similar to its predecessors, but the new name ...