My Most Embarrassing SQL Moment

T-SQL Tuesday #92: Lessons Learned the Hard Way

This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for...

How to Automatically Purge Historical Data From a Temporal Table

Watch this week's video on YouTube
Temporal Tables are awesome.
They make analyzing time-series data a cinch, and because they automatically track row-level history, rolling-back from an "oops" scenario doesn't mean...

How to Put SQL Column Names Onto Multiple Lines in SSMS

SQL in 60 Seconds is a series where I share SQL tips and tricks that you can learn and start using in less than a minute.

Watch this week's video...

5 Business Problems You Can Solve With Temporal Tables

Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...

Behind the Scenes of an Online Presentation

Last week I presented my session "DBAs vs Developers: JSON in SQL Server 2016" at the online GroupBy Conference.
As I prepared for the event, I thought about all of...

5 Things You Need to Do When Performance Testing JSON in SQL and C#

Watch this week's video on YouTube
Want to learn more about using JSON in SQL Server? Watch me present at the online GroupBy conference on June 9, 2017 at 8am.
I've...

How To Roll-Back Data in a Temporal Table

Watch this week's video on YouTube
So you've started using temporal tables because they make your point-in-time analysis queries super easy.
Your manager is happy because you're getting historical data to...

How To Use Temporal Tables For Easy Point-In-Time Analysis

Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...

XML vs JSON Shootout: Which is Superior in SQL Server 2016?

Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...

One SQL Cheat Code For Amazingly Fast JSON Queries

Watch this week's video on YouTube
Recently I've been working with JSON in SQL Server 2016 a lot.
One of the hesitations many people have with using JSON in SQL Server...