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

Speaking at SQL Saturday 159 in Kansas City!

Come to Kansas City on August 4th for SQL Saturday 159 and hear us speak!

At 2:30pm, I will be speaking...

SQL Saturday Dallas–BI Edition (again!)

I’m happy to announce that the North Texas SQL Server User Group will be hosting our fourth SQL Saturday event...