By Lisa Vaas – One reason the Slammer worm was able to wreak so much havoc is database administrators are loathe to install patches that haven’t been thoroughly tested.

by Brad M. McGehee – This is part eight of the series on how to perform a SQL Server performance audit. In this installment, you will learn how to perform a performance audit on Transact-SQL and application code that interacts with SQL Server.

Join Scalability Experts for a FREE online one-hour Web Seminar titled, “SQL Server 2000 Security,” Wednesday, April 16 at 11:00am (ET), brought to you by SQL Server Magazine University (SSMU) e-Learning Center. Learn how to leverage the security features of SQL Server 2000 to build intelligent, fle

By Lisa Vaas – Relational database heavyweights are pushing the XQuery standard for querying XML documents, with IBM and Microsoft Corp. expected to present a test suite for the standard to the W3C on Friday, and Oracle Corp. recently having posted a prototype of the standard on its site.

XMLTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML Template file and the ADO Command object.

One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter).

Discover how to handle different users with different priorities when using Microsoft SQL Server 2000.

I’m looking for shareware or an inexpensive tool that will let me maintain a SQL Server data dictionary. I’ve used sophisticated data-modeling tools that provide this functionality. However, I’m now in an organization that has many SQL Server databases but no data dictionary and no budget to buy exp

We will begin this session by reviewing some of the legislation factors that are driving corporate initiatives for securing data. We will also outline security threats that are specific to databases, identify solutions for role based security and securing specific data such as salary information. We

Mission-critical backup and data protection can cause interruptions in business operations, but Microsoft suggests adding functionality to SQL Server with HP OpenView OmniBack II, the market leader in enterprise storage management solutions. This white paper explains why Microsoft is working with Co