(Randy Dyess) Roles should be in foremost in your mind when planning the security of your SQL Server environments. Auditing inherited SQL Server installations is a relatively easy thing to accomplish and all DBAs should audit their environment and create documentation if they have not already done s

By Joe Lax – In this 10-Minute Solution I will cover some of the basics of views and show you how to use them to solve thee two issues I raised above. My examples are based on the sample pubs database that works with SQL Server 7 and SQL Server 2000.

by Randy Holloway – Learn how to use SQLXML 3.0 and its managed classes in .Net to extend Web services’ functionality with SQL Server.

By Jonathan Lurie – Certification demands a great deal of time and money, so you want to be careful about the accreditations you pursue. Before you register for one of those costly immersion courses, let me tell you which certification investments have worked for me.

by Roger Jennings – Filling elements in a crosstab array solves the missing value problem with SQL Server aggregate queries and executes muy pronto.

XML is where things are going relative to data retrieval and manipulation in SQL 2000 and, in the future, the Yukon product release. SQLXML is an add-on that you can download from Microsoft and begin working immediately against SQL Server with XML, etc. Previously available in beta rel

A quick listing of the general strategies to try when maximizing the performance of any database.

(Edward Whalen) In this article the fundamental concepts and tuning of SQL Server I/O subsystems will be explored. By understanding the limitations of the I/O subsystem, you will be able to design and properly size it so that performance can be optimized.

By Barbara Darrow – Microsoft Project 2002, which adds a server component for centralized data management, will be generally available next month… The product line now includes a server that runs atop SQL Server 2000 to store and manage resource data. “You can now run portfolio management and anal

Enter to win a FREE copy of SQL Server DTS from New Riders Publishing!This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another.