SQL Server Magazine August 2008
[Focus]
For our seventh annual awards issue, our judges traveled to Orlando to take a close look at the finalists in our Best of TechEd awards process and bring you the top third-party SQL Server development products. The envelope, please!
By Jeff James
After many sleepless nights, our editors have compiled the best products of 2008 in 12 categories, including Product of the Year. Find out who earned the highest honors in our annual Editors' Best awards.
By Editors
[Features]
A new column begins, focusing on Microsoft's highly touted Windows Home Server.
By Eric B. Rux
Learn how WHS simplifies and automates the thorough backup of your home systems.
By Eric B. Rux
Explore some lesser-known SQL Server Management Studio features that can help you better manage queries, organize scripts and other task resources, and report database and server statistics.
By Roman Rehak
Among the most useful changes to Microsoft Excel 2007 is Excel Services, which lets businesses share spreadsheets across the enterprise by moving the heavy lifting and security off the local desktop and into a server environment.
By Paul R. Vaughn
By Pinalkumar Dave
Did you know that using SQL Server Profiler can have an impact on the performance of your production servers? Check out these test results comparing SQL Server Profiler with a server-side trace.
By Andrew J. Kelly
Creating a table "the old fashioned way" leads to a better understanding of the table and its columns. Plus, the resulting T-SQL code documents the table's structure and lets you easily recreate the table.
By Bill McEvoy
Love Visual Studio 2008? Hardly. The author points out where Microsoft needs to fix VS 2008's shortcomings such as the inability to access the new SQL Server data types of ADO.NET features.
By William Vaughn
[Editorial]
Now that Microsoft supports direct migration from SQL Server 2000 to SQL Server 2008, you must decide: Should I migrate from SQL Server 2000 to SQL Server 2005, or should I migrate directly to SQL Server 2008?
By Michael Otey
[Reader to Reader]
Having to modify stored procedures when an object name changes can be tedious. Here's a T-SQL stored procedure that eliminates the tedium from this task.
By Readers
This T-SQL stored procedure searches all the databases on your server for the string you specify and returns a list of the objects that contain it.
By Readers
Here's a T-SQL stored procedure that finds and moves the clustered-indexes user tables you specify from old file groups to new file groups.
By Eli Leiba
[Solutions by Design]
Learn the best way to index the dimensions, and fact tables, and staging databases in your data warehouse to reduce query response time.
By Michelle A. Poolet
[T-SQL Black Belt]
Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.
By Itzik Ben-Gan
[SELECT TOP(X)]
Tour SQL Server 2008’s extended T-SQL feature set and learn how the new statements DECLARE, MERGE, and INSERT can make a DBA’s job easier.
By Michael Otey
[Tool Time with Kevin Kline]
Check out two SQL Server tools that help you find locking and blocking problems in your SQL Server instances, as well as records that have values in the foreign key column of your database tables that don't exist in the parent table.
By Kevin Kline
[Sqlmag.com Community Dialog]
Stay tuned for videos from SQL Server experts on ITTV.net, and be on the lookout for helpful nuggets of information in online article comments on Sqlmag.com.
By Anne Grubb
|
