The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Our editors honor the standout SQL Server–related product vendors of the Best of TechEd 2006 Awards and recognize the hits of the database universe by holding the first annual Editors’ Choice Awards.
By Michael Otey
Will Visual Studio Team Edition for Database Professional bring the discipline to database development for the SMBs and other organizations running a SQL Server environment?
By Bill McEvoy
Here's a stored procedure that searches the syscomments, sysobjects, syscolumns system tables in the local database for any reference to the string you specify.
Now that Microsoft has added database mirroring to SQL Server 2005 SP1, check out how this important high-availability feature works to automate switching between databases.
By Kalen Delaney
SQL Server 2005 lets you exceed the 8060-byte row limit for data in variable-length columns. Gain insight into how SQL Server stores the overflow data.
By Brian Moran
SQL Server 2005 offers two options that help you optimize database performance: forced parameterization and plan guides. Find out how to use these options.
By Itzik Ben-Gan
Find the pattern in this sequence of integers and how the pattern should continue.
AdventureWorks sample database used to be included with SQL Server 2000, but now it's a separate download.
This helpful but overlooked T-SQL option lets you include groups that have no members, even when the WHERE clause filters them out.
By Brian Larson
Is foul play behind the excessive number of wrist injuries at a local manufacturing company? Can B.I. Powers convince the company's president to use Analysis Services to secure access to data?
Find out how to use SQL Server 2005's forced parameterization and plan guides to change SQL query behavior.
By Gary Zaika
Pointing LAN and mobile users to different instances of an application database on different servers helped one organization improve performance for LAN users without major application or database changes.
By
Throughout the year, SQL Server Magazine keeps you informed about database-related products, tools, and services. In our first annual Editors' Choice Awards, we pick the hits from all the products we've covered in the past year.
Microsoft’s Patrick Conlan gives tips on how to maintain good performance when executing distributed queries between SQL Server instances.
Microsoft’s Gert Drapers provides a script that creates backup filenames that display the date and time of the backup, complete with leading zeros for easy reading.
In June, SQL Server Magazine and Windows IT Pro conducted the fifth-annual Best of TechEd Awards, honoring standout vendors at Microsoft’s megashow. Here are the Microsoft partners that provide the top SQL Server–related products.
advertisement