Presenting On Basics Is Difficult
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
The Scary DBA
PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?
Very excited to take part in my third #PGSQLPhriday blogging event, even more so because it’s a topic that’s quite near and dear to my heart, community. To say...
2022-12-02
12 reads
Sale on SQL Server 2022 Query Performance Tuning
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
36 reads
SQL Server 2022 Query Performance Tuning
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
194 reads
Validating Backups: PGSQL Phriday #002
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
8 reads
Weaponizing Query Store
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don’t...
2022-10-31
1 reads
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
134 reads
Monitor Cardinality Feedback in SQL Server 2022
It’s possible for you to see new technology at work if you use Extended Events to monitor cardinality feedback. To put it simply, cardinality, the number of rows being...
2022-10-26 (first published: 2022-10-17)
216 reads
Query Store at PASS Data Community Summit
While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for...
2022-10-11
2 reads
Check Every Metric
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
2 reads
Blogs
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
What I Love About My Job
In June this year I took redundancy from the company I’d worked at for...
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Forums
Backing Up Master
Comments posted to this topic are about the item Backing Up Master
Window Function Basics - PARTITION BY
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Focus on Growth in Your Career
Comments posted to this topic are about the item Focus on Growth in Your...
Ask SSC