SQL Injection Mitigation in SQL Server 2019
I’ve been teaching a lot more about SQL Injection lately (including blog posts). I’ve been doing this because, despite this being a 21 year-old problem with well defined solutions,...
2019-10-07
186 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Database Fundamentals #22: Using the Join Operator, CROSS JOIN
While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you...
2019-10-03 (first published: 2019-09-23)
1,037 reads
Celebrate Success
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
169 reads
Humbled
I’ve received several notes of thanks over the last couple of weeks. I’m not sure exactly what’s prompted this sudden outpouring because it’s all been about stuff I’ve done...
2019-09-27
39 reads
Thanking the Volunteers
Grant takes a moment to thank the SQL Saturday organizers that put on these amazing events.
2019-09-27
115 reads
Get the Last Actual Plan With sys.dm_exec_query_plan_stats
I’ve always felt responsible for making such a big deal about the differences between estimated and actual plans. I implied in the first edition of the execution plans book...
2019-09-18 (first published: 2019-09-09)
550 reads
How Do You Make DevOps Succceed?
I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...
2019-09-09 (first published: 2019-08-19)
325 reads
Techorama Netherlands 2019
You only have a few more weeks to sign up for one of my favorite events, Techorama. This year is the second time the event will be held in...
2019-09-03
13 reads
20 Years of Redgate Software
Yeah, Redgate is only one year younger than my children. What’s really frightening is that I’ve been using Redgate’s products since my kids were a year old. I was...
2019-09-02
32 reads
Profiler and Trace vs. Extended Events
It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...
2019-08-28 (first published: 2019-08-19)
725 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Finding a Database Master Key
Comments posted to this topic are about the item Finding a Database Master Key
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers