Learning R: Foundations

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

Performance Tuning with sp_BlitzIndex

Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...

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

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

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

Run T-SQL in Parallel

Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...

Run T-SQL in Parallel

Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...

Speaking at SQLSaturday Nashville in January 2016

I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...

Question of the Day: Check, Please

This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....

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