Answers to Advanced SSIS Interview Questions
Last week I wrote a set of Advanced SSIS Interview Questions. Here are the answers I came up for these. ...
2009-06-12
52,828 reads
Blog Posts
Mentors and Perspective
We had my organization's semi-annual combined IT and financial meeting this morning. At the end of these meetings awards and...
2009-06-12
669 reads
Passive Influence
I study karate on a regular basis, and over the years I've practiced a number of different martial arts, most...
2009-06-12
688 reads
A $200 Knife
While I was in Pensacola last weekend, I sat next to Andy Warren and I was telling him about getting...
2009-06-11
698 reads
Book Review: American Promethius: The Triumph and Tragedy of Robert Oppenheimer
I picked up a copy of this from the local library after reading The Making of the Atomic Bomb. Oppenheimer...
2009-06-11
605 reads
Book Review: First Man: The Life of Neil A. Armstrong
First Man: The Life of Neil A. Armstrong ($14 @ Amazon) was a good book, enjoyed reading it. Some interesting tidbits...
2009-06-11
356 reads
Call for Speakers and Registration for SQLSaturday #17 in Baton Rouge on August 1, 2009
Patrick Leblanc is the event lead for SQLSaturday #17 coming up soon on August 1st. Patrick emailed me just a...
2009-06-11
541 reads
Planning for a Disaster
Early last week, my church suffered a lightning strike that did quite a bit of damage (relatively speaking) to computer and...
2009-06-11
834 reads
Tagged: The Desert Island Scenario
I was tagged by Scary DBA and recent MVP awardee Grant Fritchey with the latest viral question:
“So You’re On A...
2009-06-11
1,341 reads
Why You'll Want to Create Your Temp Tables Before Populating them
The point of this post is to cleary explain how the combination of the use of data definition language for your temporary...
2009-06-11
1,107 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