SQL Server Data File Extensions

It is a basic concept, but an important one, the extensions we use on our data and log files don't matter to SQL Server, but they DO matter to the next DBA who won't appreciate it that we've decided to use 'BAK' as the extension for our database files. We'll cover that plus a quick tour of adding a secondary data file and how to examine all the files for a database using the system catalog.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

ricardoacaraujo@hotmail.com on 3/24/2010

Muito Bom

Ed Svastits on 3/24/2010

You could have also shown that when you attach a database file, the Attach Databases wizard actually looks for MDF files by default. Yet another reason to name your (primary) database files with the default (MDF) file extension. Why didn't you discuss the file extensions of the backup files?

01EFFB45CF on 3/24/2010

I am amazed almost daily how many DBAs don't know the basics. I am glad you are presenting a variety of info at different levels.

AFF1BFD275 on 3/24/2010

Gazoontite!

D Scharton on 3/24/2010

Please edit out the sneeze near the end of the video.

Madhavi on 3/24/2010

The video was getting struck in the middle

Madhavi on 3/24/2010

The video was getting struck in the middle

Andy Warren on 3/25/2010

Sorry about the sneeze:-)

Adolfo Santiago on 3/25/2010

The sneeze (or cough) at the end of the video blew me away!

Sathya Rani on 4/1/2010

Hi i'm new to Integration Services.... can any one help me out in how to retrieve one particular field or column from Excel into SQL Database using integration Services??? Thanks in Advance....

P JOYCE on 5/18/2010

the instructor sneezes; can't this be edited out?