SQL Server Magazine September 2002
[Focus]
Don't wait until a disaster hits your company. Make a solid backup plan and test it now to make sure that your data will survive a crash.
By Kimberly L. Tripp
Before you move your database to a new server, be sure you know how to solve one of the most common restore problems: mismatched usernames and logins.
By Kalen Delaney
[SQL Server Savvy]
Solutions that assume positioning of particular rows within a result set aren't easy for T-SQL, but learning how to handle such solutions is important.
By Brian Moran
With the release of SQL Server 2000 Service Pack 1, the behavior of SQL:StmtCompleted changed. Learn what to expect when you try to capture events within a procedure.
By Brian Moran
Why does SQL Server Profiler seem to miss some events when you're processing a heavy load?
By Brian Moran
Got some free time? Take a look at the information schema views in the master database to learn undocumented tips and cool T-SQL tricks.
By Brian Moran
Learn what you can do to recover a database when you don't have the log file.
By Brian Moran
[Editorial]
A shake-up in the database market has yielded a new database champ in terms of new license revenue: IBM. But on the fast-growing Windows platform, SQL Server claims the number-one spot and shows no signs of slowing.
By Michael Otey
[SQL Seven]
Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.
By Michael Otey
[Inside SQL Server]
Don't let your transactions get locked out. Use the best indexes for multiuser queries to help SQL Server avoid blocking problems.
By Kalen Delaney
[Mastering Analysis]
Developers who are using Visual Studio .NET to develop production applications are discovering .NET and COM interoperability isn’t simple. Here’s how to avoid a couple of common problems when you try to integrate .NET with your existing COM applications.
By Russ Whitney
[Solutions by Design]
Learn how to take advantage of pre-existing forms of identification such as Social Security numbers, define and use domains, and pick an appropriate primary key in this multifaceted approach to tracking student movement between schools.
By Michelle A. Poolet
[T-SQL Black Belt]
This set-based T-SQL query might not solve all your financial problems, but it can help you compute balances and track index growth.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team tells a reader how to propagate primary and foreign keys in both SQL Server 2000 and 7.0.
By Microsoft's SQL Server Development Team
What’s your algebra quotient? Microsoft’s SQL Server development team explains how relational algebra comes into play when you update specified columns from a second table.
By Microsoft's SQL Server Development Team
[Exploring XML]
If you use SQLXML in your development environment and need to transfer projects between computers, here’s a handy script that quickly duplicates your virtual directories.
By Rich Rollman
[Letters]
Readers write in about speedier solutions for missing number queries and more Query Analyzer shortcuts.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
