2023-09-25
462 reads
Compatibility level
Actively Choosing Compatibility
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
2023-06-14
1,211 reads
Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
305 reads
2015-10-19
1,327 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
923 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Sustainable Procurement Best Practices for ESG-Driven Supply Chains
In today’s business world, Environmental, Social, and Governance (ESG) criteria are no longer optional. Customers, investors,...
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
Comments posted to this topic are about the item Shining a Light on Shadow...
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers