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,841 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
751 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
422 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
556 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,318 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
676 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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers