Podcast Interview: Is the On-Premises Data Warehouse Dead?
Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse...
2016-06-29 (first published: 2016-06-27)
1,118 reads
Tim Mitchell
What if Your Employer Won’t Support Your Career?
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t...
2016-07-01 (first published: 2016-06-23)
2,042 reads
Join Me at PASS Summit 2016
It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but...
2016-06-22
350 reads
Bad Data Can Kill
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,954 reads
ETL Data Lineage
Before I began my technical career over a decade and a half ago, I spent several years working in law...
2016-05-06
1,268 reads
SSIS Training Classes for Summer 2016
If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of...
2016-05-05
578 reads
Refocus
Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I...
2016-05-04
458 reads
ETL Auditing
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,290 reads
ETL Logging
If you were to poll data professionals on which tasks they enjoy working on the most, ETL logging would probably...
2016-03-22 (first published: 2016-03-14)
2,401 reads
Polishing The Silverware
A few weeks ago I met a couple of my business partners in a moderately upscale restaurant in the Washington,...
2016-03-08
391 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