Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,465 reads
Blog Posts
Alpha Version of SQLPing3 Command Line Available
Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...
2007-10-25
2,305 reads
SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,398 reads
Steve Jones Finally Reads My Blog!
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,460 reads
Views for Abstraction Posted on SSC
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,353 reads
Untitled Pages in ASPX
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,471 reads
Be Pithy
I'm tech editing a book, working late as usual, football game on and kids in bed. As I was going...
2007-10-22
1,391 reads
Requiring Columns Over 900 Bytes to Be Unique
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,450 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,835 reads
SQLSaturday Update - 215 Registered!
We're at 215 registered with 3 weeks to the big day! This week I'll be having the last planning meeting...
2007-10-21
1,459 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