The Scary DBA

Every Execution Plan Is An Estimated Plan

• by Grant Fritchey

• The Scary DBA

I consider myself to be the most responsible for making such a huge deal about the differences between what is labeled as an Estimated Plan and an Actual Plan....

2019-10-22

13 reads

Database Fundamentals #24: Filtering Data

• by Grant Fritchey

• The Scary DBA

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...

2019-10-21 (first published: 2019-10-14)

482 reads

SQL in the City/PASS Summit

• by Grant Fritchey

• The Scary DBA

My great organization, Redgate, is doing things a little different this year at PASS Summit. Instead of hosting our own event, we’ve decided to host a pre-con at the...

2019-10-08

25 reads

SQL Injection Mitigation in SQL Server 2019

• by Grant Fritchey

• The Scary DBA

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

143 reads

Humbled

• by Grant Fritchey

• The Scary DBA

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

23 reads

Database Fundamentals #22: Using the Join Operator, CROSS JOIN

• by Grant Fritchey

• The Scary DBA

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)

899 reads

Get the Last Actual Plan With sys.dm_exec_query_plan_stats

• by Grant Fritchey

• The Scary DBA

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)

487 reads

Techorama Netherlands 2019

• by Grant Fritchey

• The Scary DBA

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

2 reads

20 Years of Redgate Software

• by Grant Fritchey

• The Scary DBA

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

23 reads

Certifications are a Bonus, Not A Path to Employment

• by Grant Fritchey

• The Scary DBA

I’ve never been terribly shy about my beliefs about IT certifications. I sincerely believe they are largely a waste of time. I do recognize that one thing they do...

2019-08-26

171 reads