This article expands on the following two Microsoft Knowledge Base Articles: INF: Moving SQL Server Databases to a New Location with Detach/Attach (Q224071) and INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files (Q240867). Whilst these articles focus on moving the actual databas

by Brad M. McGehee – In the past, tools such as Microsoft Access, Microsoft Excel, and Crystal Reports have been used by end-users, but each of these have a fairly steep learning curve, and have their own limitations. Are there any tools that are easy enough for non-technical users to access SQL Ser

This is a book for DBAs who want to delve deep into SQL Server 7.0/2000 performance tuning. Vyas takes a closer look at this SQL Server performance tuning guide from Microsoft Press.

by Brad M. McGehee – If you have been a DBA for any time at all, you know how “users” sometimes make claims that may not be all that “truthful.” For example, the user tells you, I changed a record yesterday, but today, it went back to its original value. As a DBA, you know that a record can’t myster

Mark Litchfield of Next Generation Security Software (NGSSoftware)discovered a vulnerability in SQL Server 2000 when used in conjunction with the Microsoft Jet 4.0 database engine that can lead to an attacker executing arbitrary code on the vulnerable system.