The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
The verdict is in! Check out the results of SQL Server Magazine's Readers' Choice awards and see what you decided were the best products in more than 50 categories! Also learn how to automate data analysis with SQL Server 2005's new BI tools, and more!
By Dawn Cyr
Readers choose their favorite developer tools.
By Brian Moran
It is possible to use an indexed view in SQL Server Standard Edition.
Readers chose disaster-prevention and recovery tools that help them comply with governmental legislation for data protection.
Check out new and improved SQL Server–related products.
By Jessica Heckathorn
Available in a seemingly endless array of memory, networking, storage, processor, and expandability options, Readers' Choice voters selected Dell server systems because they best suited their needs.
By Brian Larson
SQL Server 2005’s BI tools might seem intimidating to relational database developers. But three new tasks offer and easy introduction to automating data analysis and data mining.
By Itzik Ben-Gan
Learn the solution to August's puzzle, Covering a Chessboard with Domino Tiles, and see whether you can find The Missing Buck in September's puzzle.
SQL Server professionals need technical resources that provide quality, in-depth content in an easy-to-digest format. Readers' Choice voters selected winners in two technical-resource categories.
Capacity, availability, and speed are the most important considerations when choosing storage products. Readers' Choice voters chose Dell and EMC products as their top storage solutions.
By Michelle A. Poolet
In an optimized data model, thin tables give good performance because lean tables require fewer I/O rounds and less storage space. To improve your database performance, take a look at the “thinner is better” concept and learn how to put tables on a diet.
By Phillip Yale
Error handling is an essential part of T-SQL code, but the use and misuse of error-handling routines is poorly understood. Use these error-handling templates to avoid pitfalls and catch errors before they snag your production code.
The proliferation of interconnected applications sharing data across intranets and the Internet, makes security more crucial than ever to organizations of all types. The following winning products help make databases and their applications more secure.
Learn to slim down fat tables by using data-model optimization techniques.
By
Administrative tools can make a SQL Server DBA's job heaven or hell. Find out which products our readers voted as the most help in managing their servers.
By Dianne Russell
Get an overview of the Readers' Choice Awards program and see which vendors took the top 5 honors in this year's contest.
By Kalen Delaney
There’s so much to know about metadata in SQL Server 2005—and plenty of changes, too. How do you find everything you’re looking for?
The concepts of NULL and UNKNOWN are difficult to understand, especially in T-SQL code. However, if you become familiar with their subtleties, they can be quite useful.
By Michael Otey
In sharp contrast to most of Microsoft and the computer industry in general, SQL Server posted double-digit growth numbers for Q3 2005. This marked the 11th straight quarter that SQL Server achieved double-digit revenue growth.
It's patching time for SQL Server DBAs everywhere! Michael Otey shares six important updates that SQL Server 2000 Service Pack 4 (SP4) includes.
Many people don't know that using sp_configure to change a configuration value causes SQL Server to issue a DBCC FREEPROCCACHE statement.
Voters choose Microsoft's built-in BI tools as their favorites.
advertisement