I did not need actual data; an empty copy of the latest database would suffice. I could easily add a few test records for the demonstration after installing the database on my laptop. I created a copy ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

If you desire a sample database with a larger data size, use the source scripts to create a new sample database, and tweak the parameters in step 6 to increase the data size. Get started Download and ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.