SSIS Catalog Project Versioning
If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all...
2016-11-15 (first published: 2016-11-11)
1,840 reads
Tim Mitchell
ETL Atomicity
I still remember the first real ETL process I developed. I was working for a hospital at the time, going...
2016-11-04
750 reads
Webinar on Change Tracking for Data Warehouse Loads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
414 reads
PASS Summit 2016 Recap
It has been a fantastic week here in Seattle at the annual PASS Summit. I’ve spent the last five days...
2016-10-28
781 reads
PASS Summit 2016: Day 2 Keynote
This week I’m attending the SQL PASS Summit in Seattle. I’ll be live blogging each of the keynote presentations on...
2016-10-27
548 reads
PASS Summit 2016: Day 1 Keynote
This week I’m attending the SQL PASS Summit in Seattle. I’ll be live blogging each of the keynote presentations on...
2016-10-26
407 reads
Studying Failures
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,312 reads
Speaking at DevConnections 2016
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of...
2016-07-22
378 reads
Get Your Email Out of my ETL
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My...
2016-07-14
674 reads
ETL Modularity
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,087 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