Introducing ChaosLoad
Scripted Simulation of SQL Server Loads
When blogging, presenting or testing an idea, one issue I constantly have is that my...
2019-01-17 (first published: 2019-01-11)
2,339 reads
Blog Posts
PowerShell to Simulate Load
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,332 reads
When the query plan hash is deceptive
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
769 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps...
2019-01-16
230 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps made for a terrible looking blog.Fortunately I found that...
2019-01-16
19 reads
Data Modeling Webcast Rescheduled
Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with...
2019-01-16
142 reads
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,840 reads
Database modelling in a post-SSMS world: dbForge Studio
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
235 reads
Inspector V1.3 hotfix
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
177 reads
Short Circuiting Your Session
It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we...
2019-01-16 (first published: 2019-01-05)
2,067 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers