Ignoring Comments in SQL Compare
Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as...
2020-12-14 (first published: 2020-12-02)
216 reads
Blog Posts
What exactly is a modern data warehouse?
G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...
2020-12-14
18 reads
ETL Antipattern: Processing Too Much Data
In my continuing series on ETL Antipatterns, I’ll discuss the problem of loading too much data in extract-transform-load processes. ETL Antipattern: processing too much data A common design flaw...
2020-12-13
14 reads
ETL Antipattern: Start With Writing Code
In this first post in my series on ETL Antipatterns, I’m going to discuss one of the most common missteps when building an extract-transform-load (ETL) process: jumping straight into...
2020-12-12
30 reads
The Eleven Days of Festivus 2020
We’re rounding the corner to the second half of December, which means it’s time for my favorite holiday: Festivus! Like many of you, I enjoy gathering around the Festivus...
2020-12-12
7 reads
Basic JSON Queries–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I saw Jason Horner do a presentation...
2020-12-11 (first published: 2020-11-30)
557 reads
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to build my own Kubernetes cluster running on Raspberry Pis. I’ve been playing around with Kubernetes...
2020-12-11 (first published: 2020-11-30)
558 reads
Closure with the Professional Organization for SQL Server
I know that this isn’t the correct name, though the by-laws still list this as the corporation. Perhaps this is one more sign of the failure to evolve and...
2020-12-11
47 reads
Daily Coping 11 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-11
30 reads
Is On-premises SQL Server Still Relevant?
Unequivocally, yes on-premises SQL Server Instances are still relevant. While I’m a firm believer that the cloud is not a fad and is not going away, it’s just an...
2020-12-11
39 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers