MSDN Ultimate Subscription Winner
It’s been a busy week and I haven’t been able to put the time in to picking the winner for...
2010-08-07
770 reads
Blog Posts
SQL Saturday 40 – Behind the Music
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-07
275 reads
SQL Server Object Dependency Viewer Revisited
A year ago I blogged about building a SQL Server 2008 Object Dependency Viewer based on a script by PowerShell...
2010-08-07
1,678 reads
Week in Review - August 8, 2010
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-07
344 reads
eReaders - Kindle v Nook v iPad
A friend of my wife’s posted a note asking what people thought of the various devices and which one would...
2010-08-06
1,195 reads
Free SQL Server Training for the Week of August 9, 2010
Monday
SQL Lunch - SSIS Design Patterns 1a: Introduction to SSIS Design Patterns - Andy Leonard
Tuesday
PASS Application Development Virtual Chapter - Where the bl**dy...
2010-08-06
1,219 reads
Hands Off System Databases
I saw a post earlier this week from Buck Woody called Don’t Mess with the System Databases and I agree....
2010-08-06
351 reads
Inconsistent NullIF Behaviour ?
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the...
2010-08-06
671 reads
Planning for Maintenance
On Monday, Microsoft released an out-of-band security patch to address the .LNK vulnerability. This affects Windows XP, including Windows XP...
2010-08-06
687 reads
Simple Script to Determine Who To Kill (SPIDs)
I'm mostly working now supporting the building of SSIS packages for ETL. And on one particular project we've been making heavy...
2010-08-06
752 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers