By Parthasarathy Mandayam – Did you know that you can use a query to document your SQL Server database? This simple query on the system tables will do just that. You can easily cut and paste the results into a Word document and improve the look and feel. Imagine the amount of typing you will save! I

by Manish Rawat – Learn the basics of when to add indexes to SQL Server tables. Includes an introduction to how to read graphical execution plans.

by Kimberly Tripp-Simonnet – In SQL Server 7.0 and later, the best way to improve performance is to create the right data structures for how you use data. How you use the data always dictates the data structures, indexes, procedures, and so on, for your database.

By Margie Semilof – Microsoft this week started readying its sales channel for some new licensing options for small to midsized customers. The plan will kick in next spring.

By Michael Otey – Already, 64-bit SQL Server running on the Itanium 2 processor with Windows 2000 Advanced Server Limited Edition 1.2 has set a new SAP SD-user benchmark score.

by Brad M. McGehee – Data security is a hot topic. Virtually every computer-related journal has one or more articles devoted to this topic in every issue, IT shops have been scrambling to boost their data’s security and hiring security officers, and vendor’s have been patching older products and iss

by Klaus Aschenbrenner – The SQLXML Managed Classes enable developers to access SQLXML technology from .NET applications. This article describes some of these classes and how to use them.

By Baya Pavliashvili – SQL Server 2000 has a multitude of options that let you tweak its behavior to your advantage. Some of these options, however, might adversely affect your applications’ performance. Knowing more about configuration options can help you avoid such pitfalls.

By Brian Moran – Online peer support is a great option and can meet your support needs much of the time, but it isn’t always the best option. Sometimes paying a small fee and taking advantage of Microsoft’s paid product-support can save the day–and your database.

By David Willson – Demonstrates how adding Microsoft SQL Server Notification Services as a feature can enhance an existing application. Gives an overview of an existing, simplified library management Web application, and the process of designing the notification service features for the library.