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
675 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
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers