Presenting at SQLSaturday Tampa
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
497 reads
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
497 reads
Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to...
2014-02-03
1,341 reads
Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations...
2014-01-31
1,221 reads
Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He...
2014-01-31
1,150 reads
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...
2014-01-30
1,095 reads
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,286 reads
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
543 reads
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
789 reads
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
975 reads
Over the past week there has been information finally coming out about how the Target breach occurred. This write up...
2014-01-24
930 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