The Future for Database Administrators
Today Steve Jones talks about the job changes and prospects for those that manage IT systems.
2016-08-24
199 reads
Editorial
Security Leaks from Websites
No matter what we do to secure our databases, we need to be sure our applications are well written, both with secure coding, but also good information handling.
2016-08-23
108 reads
2016-08-22
90 reads
Is Rollback Feasible for Database Changes?
Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
486 reads
What's Your Smoke Test?
A smoke test can be a good way to ensure complex systems are working as expected after maintenance or changes.
2016-08-19
936 reads
Designing for the Public
The way that governments build software and work with data must change if we want to be more efficient.
2016-08-18
56 reads
2016-08-16
115 reads
2016-08-15
81 reads
Point-in-time data
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
80 reads
A Visit to Microsoft and SQL Server 2016
Today we have a guest editorial from Andy Warren as Steve is on vacation. Andy talks about a trip to Microsoft for the SQL Server 2016 launch.
2016-08-12
137 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