Creating the SSIS Catalog
If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...
2017-07-03
704 reads
Tim Mitchell
Trying to Solve the Wrong Problem
Some time back, while pulling into a local coffee shop, I spotted a stranded motorist in the parking lot. Per...
2017-06-29
544 reads
My SQL Server Development Toolbox
Having the right tools for the job makes the work much more efficient. However, for those just starting out in...
2017-07-07 (first published: 2017-06-27)
2,380 reads
Using ETL Staging Tables
Most traditional ETL processes perform their loads using three distinct and serial processes: extraction, followed by transformation, and finally a...
2017-06-14
951 reads
Deleting a Package from the SSIS Catalog
Among the new features of SSIS 2016, one of my favorite is incremental package deployment. This new functionality allows the...
2017-05-31
3,124 reads
SSIS Training for Summer 2017
This summer, I will be delivering my popular full-day training class Building Better SSIS Packages in three different cities across...
2017-04-25
353 reads
The Dead Tree Database
“We have all of that information. It’s in a database in my office.” This phrase was music to my ears....
2017-04-27 (first published: 2017-04-17)
1,546 reads
SSIS Catalog Logging Tables
Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging...
2017-03-31
882 reads
What Is A Day?
When designing a data warehouse or reporting architecture, the smallest questions can pose some of the biggest challenges. Identifying what...
2017-03-29
612 reads
Why Before How
I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry...
2017-03-28 (first published: 2017-03-20)
1,889 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