By Brian Moran – In the aftermath of the Slammer worm, Microsoft Vice President of SQL Server Gordon Mangione explores why customers aren’t applying patches, shares how Microsoft plans to solve these problems, and looks to the future of security for SQL Server.

by Greg Ewing and Jon Rauschenberger – The .NET Framework includes several new data access APIs, each of which has varying levels of support for accessing data residing in SQL Server as XML. Selecting the right API for your needs can make a big difference in how your solutions perform and how much c

Often people in newsgroups ask about some comparison of Access and SQL Server databases. In this article, Alexander Chigrik shows you the differences.

(Randy Dyess) Article that explains the basics of identifying and deleting duplicate information from your database.

You can move the transaction log by using SQL Server stored procedures for detaching and attaching the database. You need to detach the database, move the log file, then reattach the database.

by Andew Novick – I recently answered a posting asking how to get the columns from the primary key of a table along with the column’s data type information. It turns out to be pretty easy to find. Everything needed is in the INFORMATION_SCHEMA views.

On April 24, Microsoft announced the first single-system TPC-C benchmark result to surpass the 600,000 tpmC mark. SQL Server 2000 Enterprise Edition (64-bit) on a Hewlett-Packard (HP) Superdome server running Windows Server 2003 Datacenter Edition returned a tpmC score of 658,277 at a price/performa

Greg Larsen continues his series on date/time data by exploring how to use different SQL Server functions to display dates and times in different formats. Learn how to display a date any way you need it by using the CONVERT function along with one or more additional SQL Server functions.

(Randy Dyess) While there is no doubt of the benefits of adding indexes to your tables, and for the most part you have to do little work to keep the indexes maintained, some maintenance is required as indexes can become fragmented during data modifications. This fragmentation can become a source of

When you run an ADODB command stream and specify SQL SELECT with the FOR XML AUTO clause, an XML document stream is fetched from SQL Server, sent to the response object, and piped to the client.