SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
446 reads
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
446 reads
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
175 reads
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
362 reads
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
252 reads
I’m both excited and frankly relieved to say that I’ve found a new position. Starting Wed Nov 2nd I’ll be ... Continue reading
2022-10-28
10 reads
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
652 reads
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
302 reads
What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading
2022-10-19 (first published: 2022-10-06)
234 reads
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
14 reads
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
110 reads
By Chris Yates
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...
By Steve Jones
I’m honored to be speaking at the PASS Data Community Summit in Seattle this...
By Brian Kelley
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item We Gave Memory-Optimized Tables a...
Comments posted to this topic are about the item Always On AG Latency for...
You're responsible for managing a SQL Server environment using Always On Availability Groups across two data centers. During a recent planned failover to the secondary replica, you noticed increased application latency and errors related to read-only routing. Upon investigation, you discover that read-only routing continues pointing to the former primary, now a secondary, for a period of time after the failover.
Which of the following best explains this behavior and how to resolve it?