Kicking the Tires on SSIS 2016
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...
2015-10-19 (first published: 2015-10-07)
3,021 reads
Tim Mitchell
Advanced SSIS Training Course Preview
If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...
2015-10-02 (first published: 2015-09-28)
2,032 reads
Webinar: Kicking the Tires on SSIS 2016
The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating...
2015-09-23
582 reads
Ryan Adams for SQL PASS Board
It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those...
2015-09-15
566 reads
Webinar: Change Tracking for Data Warehouse Loads
For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing...
2015-09-14
518 reads
Building Better SSIS Packages Class in Dallas
I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...
2015-09-15 (first published: 2015-09-08)
1,602 reads
Sixty Days to Summit–Are You Ready?
In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a...
2015-08-28
657 reads
Above All, Good Judgment
What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...
2015-08-24
578 reads
We Don’t Trust This Data
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,982 reads
Downloading SFTP Files with SSIS
If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...
2015-08-03
7,711 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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