SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
781 reads
Blog Posts
The Perfect is the Enemy of the Good (Again)
I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...
2010-02-17
507 reads
The Power Grid (No, Not THAT Power)
Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...
2010-02-17
748 reads
Buck Woody on Code Writing Code
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
779 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
872 reads
Job Quality
Through a circuitous route, I encountered a meaningful, thought-provoking quote lately: "... the best way to predict the future is to...
2010-02-16
1,519 reads
Panic Attack
I had a minor panic attack recently where I was getting ready for bed and all of a sudden thought...
2010-02-16
888 reads
Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
644 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-16
2,600 reads
Review: Windows Live Writer Backup
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers