The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Our editors save you the drudgery of evaluating products to find the best fit for your situation at the right price, in our annual Editor’s Best awards issue. Here are the winning products for 2008.
By
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 Itzik Ben-Gan
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 Michael Otey
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 William Vaughn
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 Paul R. Vaughn
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 Bill McEvoy
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.
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 Jeff James
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 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 Anne Grubb
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.
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 Eli Leiba
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.
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 Michelle A. Poolet
Learn the best way to index the dimensions, and fact tables, and staging databases in your data warehouse to reduce query response time.
By Andrew J. Kelly
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 Pinalkumar Dave
By Eric B. Rux
Learn how WHS simplifies and automates the thorough backup of your home systems.
A new column begins, focusing on Microsoft's highly touted Windows Home Server.
advertisement