T-SQL Tuesday 73 – Naughty or Nice?

Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you. Is...

Learning R: Foundations

Learning a programming language is largely an act of using that language to do stuff. Done.
However, the big thing about...

Monday Morning SQL Break – December 7, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...

Powerful SQL Queries for SQL Server

New Year, new powerful SQL queries!
Start the New Year off with some great Transact-SQL training and join me for...

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...