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
45 reads
The Scary DBA
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
228 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
11 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
5 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)
139 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)
221 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
3 reads
PGSQL Phriday #001: Two Truths and a Lie
As a part of my own journey of learning within PostgreSQL, I’ve decided that I’m going to take part in PGSQL Phriday as often as I can, just as...
2022-10-21 (first published: 2022-10-07)
183 reads
DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...
2022-10-14 (first published: 2022-10-04)
110 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...