Data Musings by Marlon Ribunal
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 Continue reading The post Demo for Parameter Sniffing and Memory Grant Feedback first appeared on SQL, Code, Coffee, Etc. .
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 there are a lot of discussions around #temp tables and @table variables, especially around when one might be a better choice over the other. Continue reading The post When Do You Reach For A #temp Table? first appeared on SQL, Code, Coffee, Etc.…
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 Continue reading The post SQL Server Security Hardening Guide Using the DoD STIG Checklist first appeared on SQL, Code, Coffee, Etc. .
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. Even if you reproduce an issue in a test environment, there's no guarantee the same solution will produce identical results in production. So,…
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 Continue reading The post How to Provision an Azure SQL Database first appeared on SQL, Code, Coffee, Etc. .