2025-09-24
228 reads
2025-09-24
228 reads
Today Steve wonders what you might do with extra time if the AI can give it to you.
2025-09-24
27 reads
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...
2025-09-24
3 reads
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...
2025-09-23
10 reads
Downtime causes a lot of problems, not all of which are financial for an organization.
2025-09-22
67 reads
When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.
2025-09-22 (first published: 2014-03-27)
538 reads
A short look at the MSSQL extension for VS Code, getting started with connections and running queries.
2025-09-22
6,629 reads
Open offices have an interesting side effect: less collaboration.
2025-09-22 (first published: 2018-08-27)
72 reads
A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual...
2025-09-22
7 reads
We will all make mistakes, but practice can help reduce the errors we cause.
2025-09-22 (first published: 2017-11-27)
118 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers