Using SQL Server 2012 FileTables

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...

Generating Surrogate Keys With SSIS

A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...

Excellent SSIS 2012 Upgrade Video

This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC...

Inspirational Database Administration Requirements

 
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...

SQL Server 2012 Installation Guide

This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...

I don’t care and why that is good for my blog

I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn't Apply to Dropped Databases or Does...

Is That Your Code? [Copyright Considerations]

Think about that last SQL statement that you wrote.  Did you originally write it?  Are you sure you wrote it? ...

Presenting at PASS Summit 2012

I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”.  I...