The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,361 reads
Tim Mitchell
ETL Error Handling
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
767 reads
Survey Results: Skipping the Holidays
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
379 reads
Survey: Skipping the Holidays?
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
378 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
KPIs in SSRS 2016
Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...
2016-12-30 (first published: 2016-12-22)
1,746 reads
Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
566 reads
The Trails We Leave
Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...
2016-12-19
349 reads
SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
SSIS Execution Status Lookup
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
413 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