The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Learn how you can sync your data and development with this tour of new features and functionality in Visual Studio 2008.
By Anne Grubb
Readers share their thoughts about recent Community Dialogs, and Itzik Ben-Gan helps a reader out by creating a special "lottery" query.
By Andrew J. Kelly
You know how to collect and report on wait stats. Now, let’s focus on a few wait stats that typically account for most overall system waits.
By Itzik Ben-Gan
Circumvent unsupported logical phases, work around SQL Server 2005’s lack of INTERSECT ALL and EXCEPT ALL, and take advantage of the INTERSECT and EXCEPT operations’ treatment of NULLs.
By Jeff James
Check out new and improved SQL Server-related products from Datanamic Solutions B.V., CNS International, Caber Computing, and Microsoft.
Get the solution to March’s puzzle “Too Clever by Half,” and prepare your mind for April’s puzzle, which involves calculating distance.
By Michael Otey
While SQL Server Magazine can give you info on SQL Server 2008, Microsoft's Webcasts also assist. Here are some links to our favs.
Visual Studio 2008 offers support for three different editions of SQL Server 2005.
By William Sheldon
Build efficient queries using LINQ, which is included in Visual Studio 2008.
Get a taste of the new Visual Studio 2008 development features by downloading one of the free Visual Studio 2005 Express products.
By Pinalkumar Dave
Get answers to your questions about SQL Server 2005 Surface Area Configuration tools that can help you protect the SQL Server surface area from security breaches perpetrated by unauthorized users or applications.
By Kalen Delaney
Uncover more valuable metadata that can aid you in troubleshooting and performance-tuning your queries.
Find out how Sun Technologies' acquisition of MySQL means for the database market.
By Michelle A. Poolet
Save yourself from having to deal with large, difficult-to-manage fact tables by partitioning the rows.
By Allan Hirt
A SQL Server expert takes a detailed look at three popular SQL Server backup compression tools.
By Bill McEvoy
If you have to perform a full index analysis, here are two T-SQL stored procedures you can use to get detailed information about the indexes in a single table or an entire database.
Itzik Ben-Gan helps out a reader by creating a T-SQL query that generates winning lottery numbers.
Using a database named MyDB, a table named MyTable, and some dummy tables, you can learn how to create T-SQL queries that insert new data, update existing data, and delete old data.
advertisement