Unzip Files with SSIS
In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....
2016-12-16
581 reads
Tim Mitchell
Zip Files in SSIS
Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...
2016-12-15
396 reads
SSIS Package Validation in the Catalog
Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package....
2016-12-14
678 reads
SSIS Data Taps
One of my favorite testing features of SSIS is also one of the most underutilized. SSIS data taps were introduced...
2016-12-13
418 reads
A Shortcut for Parameterizing Settings in SSIS
I’ve written quite a bit about the benefit of externalizing changing values in SSIS packages. Moving static values such as...
2016-12-12
348 reads
The Eleven Days of Festivus
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
300 reads
On Being Disruptive
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,727 reads
A Better Way to Execute SSIS Packages with T-SQL
There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way...
2016-12-02 (first published: 2016-11-28)
3,945 reads
Video: Introduction to SQL Server Change Tracking
SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...
2016-11-25 (first published: 2016-11-18)
1,464 reads
SQL Server 2016 Service Pack 1 Changes Everything
Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...
2016-11-16
477 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers