Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...
2026-08-13
91 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than simply creating one and using it. As I started digging into the topic, I realized...
2026-08-11
150 reads
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where do you start when evaluating the security of your SQL Server? If you are like...
2026-08-06
332 reads
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-04
196 reads
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-08-14 (first published: 2026-07-30)
309 reads
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against a local Azure SQL Database Developer container — the same engine as the cloud, running...
2026-08-10 (first published: 2026-07-26)
748 reads
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test locally at no cost. This means NO Azure subscription to deal with and NO credit...
2026-08-03 (first published: 2026-07-23)
200 reads
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack container in a Macbook. If you are like me who switched from a Windows laptop...
2026-07-29 (first published: 2026-07-20)
595 reads
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do and, still, nothing works. So, you decide that calling in for help is the next...
2026-07-24 (first published: 2026-07-16)
496 reads
Install SQL Server 2025 Container on macOS Using OrbStack
My old Dell XPS that I used for personal stuff started to degrade; well, it's old, and it has already served past its useful life. So, a few months...
2026-07-22 (first published: 2026-07-13)
223 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
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...
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