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
15 reads
Bert Wagner
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
37 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
9 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
2 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
3 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
12 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
5 reads
When Is It Appropriate To Store JSON in SQL Server?
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
11 reads
The Ultimate SQL Server JSON Cheat Sheet
This post is a reference of my examples for processing JSON data in SQL Server. For more detailed explanations of these functions, please see my post series on JSON...
2017-03-07
122 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons
This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...
2017-02-21
11 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Is Adenoz Injection safe for patients with low blood pressure?
Adenoz Injection is used to treat specific heart rhythm disorders, but it must be...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers