Friend of Redgate – 2017
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2017-02-05
1 reads
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2017-02-05
1 reads
Proactive Reporting for SQL Server If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big...
2017-02-04
3 reads
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for...
2017-01-19
348 reads
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...
2017-01-17 (first published: 2017-01-06)
2,983 reads
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include...
2017-01-15
651 reads
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include the latest in SQL Server and other things in...
2017-01-15
2 reads
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...
2017-01-13
683 reads
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-01-13
1 reads
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction log their databases generate. *Roughly*, this is going to...
2017-01-06
2 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
We are planning on a fairly big code deployment to set the stage for...
Experts, I am hoping to get some help and feedback. I have a server...
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