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,...
2017-05-16
25 reads
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...
2017-05-09
42 reads
How many times have you written a program, ETL, analysis job, etc… that seemed like it would never finish running?
Although poor performance can be caused in a multitude of...
2017-05-02
16 reads
This story originally appeared in Hacker Noon on March 11, 2017.
A code refactor always leaves me with a feeling of accomplishment. Although major refactorings are the most satisfying, every...
2017-04-25
40 reads
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
10 reads
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 SQL users to share ideas about...
2017-04-11
4 reads
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
5 reads
Parsing, creating, and modifying JSON in SQL Server 2016 is really easy. JSON dates and times are not.
Coming from a predominantly SQL background, the JSON DateTime format took some...
2017-03-28
14 reads
The other afternoon I ran into some nightmarish debugging with the following code:
private static void StartThreads()
{
var values = new List<int>() { 1, 2, 3 };
...
2017-03-21
6 reads
Every once in a while I hear of some technologist say that relational databases are dead; instead, a non-table based NoSQL storage format is the way of the future....
2017-03-14
12 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers