Database Cattle
Steve Jones says you should treat your database servers like cattle. It makes life easier.
2017-03-09
333 reads
Editorial
The Migration Checklist
Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.
2017-03-08
12,048 reads
2017-03-07
80 reads
Containing the Work
Containers are valuable in many software domains. Are there places we, as data professionals, would like to use software containment?
2017-03-06
83 reads
Creative IT Learning
If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?
2017-03-06
89 reads
Null Defaults
Today Steve Jones asks what default values you might choose for new columns in a table.
2017-03-03
117 reads
Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
2017-03-02
547 reads
Detecting Issues
How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.
2017-03-01
113 reads
2017-02-28
221 reads
The Secure Medical Data Challenge
This week Steve looks at the challenges of security for medical data.
2017-02-27
79 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