SQL Server Magazine August 2007
[Focus]
SQL Server Magazine gives you information about database-related hardware, software, and services in every issue. In our second annual Editors' Choice Awards, we honor the best of the best from all the products we've covered in the past year.
By Editors
The sixth annual Best of TechEd Awards took place in June and highlighted outstanding products from Microsoft partners. Here are the top SQL Server-related product winners.
By Editors
[Features]
Developers and software vendors use the WITH ENCRYPTION clause to obscure the underlying schema of their products. However, advanced users can still access the code. Here’s a simple do-it-yourself T-SQL algorithm that unlocks encrypted database objects.
By Omri Bahat
About to implement failover clustering in your environment? One of your most important considerations will be the disk configuration. Here's how to get it right.
By Allan Hirt
Microsoft’s BI manager explains why the company is targeting its new business-performance management application at business decision makers rather than DBAs.
By Karen Forster
[Editorial]
Believe it or not, the next release of SQL Server—SQL Server 2008—is right around the corner. But releases aren't necessarily good news for customers.
By Michael Otey
[Reader to Reader]
This reader’s remote client needed a new virtual SQL Server 2005 machine within 24 hours to test a project release update. Learn how he added this server from 200 miles away.
By Readers
Use a stored T-SQL procedure called ResetIdentities.sql to globally reset all identity values in a database to their initial seed value.
By Readers
[Inside SQL Server]
Two query hints in SQL Server will autoparameterize queries so that query plans can be reused, but you need to keep a close eye on query performance to get the most benefit from these hints.
By Kalen Delaney
[T-SQL Black Belt]
In our effort to uncover the truth about temporary objects and debunk some popular myths, we offer a two-part series that begins by providing a general overview of each temporary object type as well as general recommendations for when to use each.
By Itzik Ben-Gan
[SELECT TOP(X)]
SQL Server 2005 offers several high availability options to choose among, from clustering to database mirroring and more—here are a few favorites from our SQL Server expert.
By Michael Otey
[Tool Time with Kevin Kline]
The Performance Dashboard Reports let you easily diagnose performance problems without incurring a lot of overhead.
By Kevin Kline
|
