Is it just me or does msdb feel a lot like a user database?
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
657 reads
Blog Posts
Microsoft Azure and Oracle Cloud
Microsoft and Oracle recently announced a joint cloud partnership (I have seen the word multi/cross-cloud to explain this) which I found very fascinating to read. It is currently in...
2019-08-07
25 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
In the...
2019-08-06
7 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
In the...
2019-08-06
5 reads
A Day in the Life (4/?) - August 2, 2019
This is my fourth installment in a series responding to Steve Jones’s (blog | twitter) #SQLCareer challenge. I jotted down most of what I did through the day, filling...
2019-08-06
1 reads
Azure Service Logging in the Modern Data Warehouse
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-08-06 (first published: 2019-07-16)
1,368 reads
Azure SQL Database Clustered Columnstore Index
You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/). I won’t rehash the material but high level, these index types are optimized for analytical queries and high compression of data...
2019-08-06
158 reads
Short circuiting an AND
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
713 reads
spark-dotnet how to manually break a file into rows and columns
I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...
2019-08-06
13 reads
spark-dotnet how to manually break a file into rows and columns
I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...
2019-08-06
2 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