Created by: Alexander Chigrik – This script will generate script for all tables and all dependent objects for the given database. You can pass the Server name, user name, user password, database name and file name into GenerateScript stored procedure

Several people have asked since SQL Server Live! Spring 2002 what the site was that was used in several of the demonstrations. The site is entirely SQL Server-driven, and the backend is millions of rows of data that is searched and used to find the issues about your car. It was challen

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 – 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 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 – 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.

By Alexander Chigrik – In this article, I want to tell you about some general Microsoft SQL Server replication’s topics: replication topologies, replication types, replication agents; and about Snapshot replication: how to check necessary conditions for this replication type, how to backup and resto

Book by Graeme Malcolm – Use XML and SQL Server® to turn business data into powerfully integrated solutions for employees, customers, and partners.

By Shylon Ray Hunter – Web sites require functionality, flexibility, and usability, though usability is often emphasized over other attributes. Notice that I didn’t mention a database. A database back end is a tool that helps fulfill a Web site’s requirements. Whether a Web site needs a database bac