2016-12-12
89 reads
Editorial
The One Metric to Rule Them All
Measuring the performance of systems isn't always just CPU, RAM, and Disk IO. Today Steve Jones looks at business based metrics.
2016-12-09
100 reads
Testing Coders
It seems that everyone has a different idea on how to interview people. Today Steve Jones looks at the technique of having someone improve some code in real time.
2016-12-08
99 reads
What do you do when you inherit a mess at work?
I have seen three common responses to database messes. My favorite is nuclear.
2016-12-06
256 reads
Work/Training Balance - The hidden balancing act
Should we be considering our Work/Training Balance as part of our careers?
2021-06-23 (first published: 2016-12-05)
228 reads
2016-12-05
93 reads
First Class Jobs
This week Steve Jones examines the idea of making jobs in SQL Server, first class citizens.
2016-12-02
102 reads
Learn to Earn
Learning more about your craft can translate into more earnings, but it won't be easy.
2016-12-01
106 reads
The Pressure to Compromise Ethics
There are always people that ask workers to deceive, defraud, or mislead customers. This is true for software developers as well.
2016-11-30
97 reads
Finally, Create or Alter
Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.
2016-11-29
162 reads
Blogs
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...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
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