The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Sometimes the best way to solve a problem is to find a product that does the job and provides great ROI. But how do you find the right product for the job? Our editors examined all the products we've covered in the past year and highlight their picks.
By Kevin Kline
The Performance Dashboard Reports let you easily diagnose performance problems without incurring a lot of overhead.
By Allan Hirt
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 Michael Otey
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 Omri Bahat
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.
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 Karen Forster
Microsoft’s BI manager explains why the company is targeting its new business-performance management application at business decision makers rather than DBAs.
By Kalen Delaney
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 Itzik Ben-Gan
Get the solution to July's puzzle "Catching a Train," and prepare your mind for August's puzzle, which involves a sadistic warden and some switches.
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.
Differences between encoding and encryption mean that decoding objects that were created WITH ENCRYPTION can be relatively straightforward.
By
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.
Use a stored T-SQL procedure called ResetIdentities.sql to globally reset all identity values in a database to their initial seed value.
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.
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.
advertisement