Increasing ColumnStore compression ratio for archival and “Cold storage”

At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...

The Demo Setup–Attaching Databases with Powershell

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...

“Thing IS NOT NULL” isn’t the same as “Thing != NULL”

I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...

Review of Minion Reindex

Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...

Review of Minion Reindex

Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...

How To Speak At SQL Saturday Events

The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...

There are #temp tables and then there are ##temp tables.

Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...

Iterating Through Excel Worksheets with Biml

Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...

Statistics on UNIQUEIDENTIFIER columns

During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...

Date Range Challenge in sql

Hi Folks,

When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...