SQL Cruise Caribbean 2016 is almost here!

Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...

T-SQL Tuesday #73 Invitation – Naughty or Nice?

Hello Dear Reader!  This is the first Tuesday of the month and you know what that means.  It’s time to...

What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)

What's New in SQL Server 2016

Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...

The Discomfort Zone

Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...

Why would you want to name a transaction?

Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...

Atlanta BI Edition SQL Saturday Precon

The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...

Changing Course On Learning

With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...

Puzzled by T-SQL

Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...