Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
737 reads
Blog Posts
How To Participate In The PASS Summit When You Can't Be There
Bummed that you can't go to the PASS Summit in Seattle this year? Turn that frown upside down because there...
2010-11-03
686 reads
Kilt Day
A week from now will be Kilt Day at the PASS Summit. It’s probably way too late to order a...
2010-11-03
667 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
838 reads
More PASS Summit Tips For First Timers
Yesterday I posted my tips for PASS Summit First Timers, and of course as soon as I did I remembered...
2010-11-03
1,785 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
661 reads
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,752 reads
PASS Update #45 (Agenda for SQLSaturday Roundtable)
If you’re attending the 2010 Summit and are interested in helping improve SQLSaturday, I hope you’ll register and attend our...
2010-11-03
338 reads
PASS Update #46 (What Should PASS Be?)
I’ve been wanting to write this for a while, and I haven’t because I felt that I just didn’t quite...
2010-11-03
399 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
969 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