5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition
In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise...
2014-03-26
1,151 reads
Richard Douglas
Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
91,777 reads
Speaking at Luxembourg SQL Server User Group
Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting...
2014-03-25
780 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 3
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned previously, this post has...
2014-03-27 (first published: 2014-03-20)
1,576 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 2
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has...
2014-03-24 (first published: 2014-03-19)
1,458 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 1
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one...
2014-03-18
757 reads
A Tale of Two SQL Server Webcasts
Things have been quiet on my blog of late (hosting issue) but now things are back online. Talking of online,...
2014-03-17
754 reads
PASS Performance Virtual Chapter Webcast
A quick check of my calendar this morning reminded me that I am presenting a session for the PASS Performance...
2013-12-02
831 reads
SQL Server events in the UK – December 2013
The Christmas countdown has begun for a number of us. This doesn’t mean it’s time to relax, there’s still plenty...
2013-12-02
596 reads
SQL Cruise competition, and the winner is …
Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win...
2013-11-26
717 reads
Blogs
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
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