2019-01-07
127 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
2018-11-15
685 reads
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
63 reads
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
1,329 reads
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
2018-10-12
152 reads
What is the best way to on-board (train) a new junior employee?
It is important to train new people, so what is the best way to go about doing it?
2018-09-06
356 reads
Why not take a risk and try something new?
When we risk failure, we also have the opportunity for success, so try something new today.
2018-08-30
76 reads
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
403 reads
How much database normalization is enough?
Normalization is important for relational databases, but sometimes too much of a good thing can be bad.
2018-07-23
2,406 reads
2018-05-17
104 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