SQL Server Magazine August 2006
[Focus]
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.
By Editors
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.
By Editors
[Features]
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 Gary Zaika
[SQL Server Savvy]
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 Brian Moran
Find out how to use SQL Server 2005's forced parameterization and plan guides to change SQL query behavior.
By Brian Moran
AdventureWorks sample database used to be included with SQL Server 2000, but now it's a separate download.
By Brian Moran
[Editorial]
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 Michael Otey
[Reader to Reader]
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.
By Bill McEvoy
[Inside SQL Server]
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 Kalen Delaney
[T-SQL Black Belt]
This helpful but overlooked T-SQL option lets you include groups that have no members, even when the WHERE clause filters them out.
By Itzik Ben-Gan
[SELECT TOP(X)]
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 Michael Otey
[Ask Microsoft]
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.
By Microsoft's SQL Server Development Team
Microsoft’s Patrick Conlan gives tips on how to maintain good performance when executing distributed queries between SQL Server instances.
By Microsoft's SQL Server Development Team
[From the Casebook of B.I. Powers, Consulting Detective ...]
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?
By Brian Larson
|
