31 Days of SSIS – UnPivot Alternative (12/31)
31 Days of SSIS
This is the twelfth post in the 31 Days of SSIS blog series. This post is going...
2011-01-12
999 reads
StrateSQL
31 Days of SSIS – UnPivot Transformation (11/31)
31 Days of SSIS
The last post discussed the Pivot transformation – that leads us to this post which will be on...
2011-01-11
1,152 reads
MCM Live Blog – Week January 10
Watching videos?! Su-ure!
Week five and it seems like time is going by faster than I had expected it would. As...
2011-01-11
284 reads
T-SQL Tuesday 14: Resolutions #TSQL2sDay
Time for the first T-SQL Tuesday of 2011. This month Jen McCown (Blog | @midnightdba) is hosting the event. The topic...
2011-01-11
563 reads
31 Days of SSIS – Pivot Transformation (10/31)
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,179 reads
PASSMN Call for Presenters and Sponsors
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
413 reads
31 Days of SSIS – Merge Join Is My Friend (8/31)
31 Days of SSIS
Welcome to day eight post for the 31 Days of SSIS. If you are just joining the...
2011-01-09
832 reads
31 Days of SSIS – Override Variables (9/31)
Day number 9 of the 31 Days of SSIS. If you missed the first week then start by reading the...
2011-01-09
1,036 reads
31 Days of SSIS – What The Sorts?! (7/31)
31 Days of SSIS
Welcome to day seventh day of the 31 Days of SSIS. If you are just joining the...
2011-01-07
547 reads
Speaking at EDMPASS This Month
If you are up in Edmonton around January 26th, you can hear my voice at the EDMPASS January user group...
2011-01-07
426 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
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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