Local Database Issues
Steve Jones talks about the issues with using a local database in your application.
2016-11-14
67 reads
Editorial
2016-11-11
159 reads
2016-11-10
119 reads
How Do You Act When You Need to Learn New Technology?
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
468 reads
I can ODBC clearly now
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
2016-11-07
108 reads
What's Your Backup Speed?
This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.
2016-11-04
204 reads
Server Hardware or Coffee?
Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.
2019-12-20 (first published: 2016-11-03)
260 reads
Generating Our Own Bad Data
We depend on data quality to run our businesses efficiently. However, it's a problem when we mess that data up on purpose.
2016-11-02
76 reads
The Forever Technology War
The differences in our understanding of technologies can make for some communication challenges.
2020-11-05 (first published: 2016-11-01)
160 reads
Analysis Services Lives On
The release of Analysis Services in Azure means the platform has a future.
2016-10-31
65 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