Better Secure Hashing – SHA3

I’ve been giving an encryption talk over the last year, focusing on educating DBAs on the various features and capabilities...

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter.
Here is the PowerPoint presentation: Data Warehouse...

How to migrate a SQL Server database to a lower version

Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...

Looping through multiple servers in SSIS Part 3

Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...

My Favourites Of Paul Randal

As a new blogger, It is a little pain for me to blog on a technical topic.  
It starts from learning, exprimenting, being comfortable with topic,...

PASS 2012 Announcements

Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...

Quick Tip: SSIS and SAP BW

Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...

Recent Presentation Session Files

Recent Presentation Session Files
Session Files – A Little Behind

I’ve been a little tardy about getting my session files posted, and I’m...

Rules of Holes #3: A Better Shovel is NOT the Answer!

You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...

Rules of Holes #3: A Better Shovel is NOT the Answer!

You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...