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
542 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,379 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
948 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,057 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
351 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,538 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
880 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
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
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...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
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...
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