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...
2017-05-23
17 reads
Bert Wagner
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,...
2017-05-16
26 reads
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...
2017-05-09
43 reads
How to fix your terribly slow SQL job
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
17 reads
Three Changes You Should Always Make Before Checking In Any Code
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
How to write understandable code for your future self
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
11 reads
Will Technology Eliminate Your Tech Job?
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
5 reads
[Video] JSON Usage and Performance in SQL Server 2016
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
6 reads
Who Stuck These Letters In My DateTimes?
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
15 reads
C#'s foreach ruined my afternoon
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
7 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers