Actively hiring
Databases & DBMS
Freelance Developers & IT Professionals
Follow
Overview
News
Salaries
Products
People
Growth
Offices
Financials
Overview
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 parameter sniffing and memory grant, but I decided to open it to public.
News
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 parameter sniffing and memory grant, but I decided to open it to public. And you may say "M
Read more
Report
When Do You Reach For A #temp Table?
Disclaimer: Rather than spending time writing a test scenario from scratch, I used Claude Code to generate the test scenarios for this article. I wanted a certain behavior to demonstrate a couple of differences between #temp and @table. You can download t
Read more
Report
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 me, and probably for many DBAs, that's the hardest part. You know security matters, but wit
Read more
Report
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 sensible thing to do. Let's say this is the first time you're asking for somebody's help. You decid
Read more
Report
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 workloads, hardware, data distribution, application behavior, and configuration. E
Read more
Report
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 lightweight app. See the documentations for the limits. I will not be responsible for your u
Read more
Report
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 on your machine. The problem: proving a migration wo
Read more
Report
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 card required! Everything will work seamlessly when you deploy your application to an Azure SQL D
Read more
Report
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 to MacBook, you are probably missing your SQL Server. Sometimes it's just nice to have a sandbox that
Read more
Report
Deploy a SQL Server 2025 Container on macOS Using OrbStack
This is how I built my SQL Server 2025 sandbox on macOS using OrbStack
Read more
Report
Show more news
