Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
186 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
186 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
2 reads
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-12
2 reads
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
6 reads
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-05
7 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-04 (first published: 2022-05-03)
54 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-03
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
332 reads
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
21 reads
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
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...
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