Changes to the SSIS Slowly Changing Dimension Component

Probably not the kind of change you're expecting.  I've recently been contacted by the Kimball Group, and they've asked me...

Finding Compressed Tables

Have you been working with compression?  Have you inherited a database that may or may not have some tables compressed?  On occasion you may want to know what the...

Finding Compressed Tables

Have you been working with compression?  Have you inherited a database that may or may not have some tables compressed?...

Help Promote SQLRally!

In case you’re in need of some images to help us promote the largest PASS event on the East Coast...

PASS Update #53 (Bylaws)

This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...

Selecting Speakers for SQL Saturday #70

The Call for Speakers for SQL Saturday #70 - Columbia, SC, ended on February 17, 2011. We wanted to put the...

Some Suggested SQL Server 2008 R2 Instance Configuration Settings

Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...

SQLskills Immersion Event on Internals and Performance – Day 4

Overview
We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing...

Test Complete – MCM

I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience....

“Apparently, you signed a software services agreement without fully understanding it.”

I am not a lawyer. Let me say that again, I am not a lawyer.

Todays Dilbert has prompted me...