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

Setting Up a Publication for Transaction Replication

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...

Slides from 24 Hours of PASS – Data Security

As promised, here are my slides from the 24 Hours of PASS on Data Security:
S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)
S7 – Brian...

Some stuff with Date and Time in SQL Server

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...

Some stuff with Date and Time in SQL Server

I’m writing this post because I want to put some more stuff around dates and times in one place. I...

Some stuff with Date and Time in SQL Server

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...

Splitting Strings on SQL Server 2016

A small change, but a great one, in SQL 2016 is native support for splitting strings.
This has to be about...

SSDT Dev in Visual Studio Code

I have been quite interested by vs code and have been using it more and more recently. I use it...

T-SQL Tuesday #90 — Bringing Continuous Delivery to a ‘brownfield’ database system

This blog post is part of  T-SQL Tuesday #90 – Shipping Database Changes.
I have decided to write about  a client’s SQL...

T-SQL Tuesday #90 – Shipping database changes

TweetG’day,

 
Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by...