SQL Data Generator –Specific Domains for a Column

I was mocking up some test data and wanted to limit my list of values to specific items. In this...

TOP 1 killed my performance; Rob Farley helped me resurrect it.

tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...

What’s New in Power BI Webinar Recording is Available

Thank you to everyone that attended my webinar with the PASS Excel BI Virtual Chapter today! I’d also like to...

.Net 4.6.1 and MultiSubnetFailover

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...

Enhanced Threading Framework V3 for SSIS

I decided to revisit my framework to see if I could improve the performance and possibly increase the number of scenarios this framework could be used in.  Turns out...

Enormous response from the last promotional campaign

After I posted this blog MDX Cookbook is a popular book, I received another email from my MDX book publisher.

...

PASS Board 2016: Update #2

Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...

SQLBITS 2016 Agenda has been Published

The agenda for this year’s SQLBITs has been published you can find it here  http://sqlbits.com/information/event15/Agenda.aspx?20160507
Our very own David Postlethwaite has...

SQLSaturday Belgium: slidedeck

The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...

SSC Editorial: On Time, or Not

Is being on time important? I think that might be a revealing interview question. The answer might or might not...