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,839 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
749 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
413 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
780 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
547 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
406 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,311 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
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers