Murder and XE Train in Louisville

I am about to set sail on a new venture with my next official whistle stop.  This year has been...

WaitForSql (to start)

In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...

SQL Server: utilize partitioning to purge large tables

Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...

Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!

Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/

I'll be doing an update to...

Introduction To Query Store In SQL Server 2016 – Part 2

Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...

How do different types of functions compare performance wise?

A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...

SSC Editorial: Is the Golden Age of Information Technology Almost Over?

Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential...

Next oPASS Meeting is July 23, 2015 with David Crook

The next OPASS meeting is July 23, 2015, featuring David Crook from Microsoft doing a presentation on predicting home value...

SSMS 2015

Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...

Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...