Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....
2011-12-17
3 reads
Blog Posts
Why you may or may not consider using Database Snapshots!
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,248 reads
Counting Merge Replication Article Changes
One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...
2011-12-16
2,030 reads
Factless fact table
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,634 reads
Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
2,048 reads
My first blog post!
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
534 reads
Open_transaction_count in sys.dm_exec_sessions
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,392 reads
Re-blog – December 9 – December 15
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-16
612 reads
The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine
If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...
2011-12-16
36,921 reads
T-SQL Tuesday #25 – T-SQL Tricks
It’s time for T-SQL Tuesday again, and this time Allen White (@SQLRunr | blog) is asking for your tricks. If you...
2011-12-16 (first published: 2011-12-13)
2,748 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