2023-09-25
466 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,620 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
324 reads
2015-10-19
1,330 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)
927 reads
Blogs
PASS Keynote Shots
By Steve Jones
Rodney Kidd took some great shots of the keynote and published an album here:...
Microsoft AI Red Teaming Course
By Brian Kelley
here is the compiled video of the Red Teaming course Microsoft put together.
What’s New at AWS re:Invent 2025 – Day2 Highlights
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
Forums
Veeam Backup DAG issue. Access to availability group is not permitted.
Hi all, Has anyone encountered an issue whereby using a distributed availability group...
need to kill long running SPIDs
hi, i have seen in my server sometimes some SPIDs get stuck. so we...
Improving update statistics process for 6 big tables
Recently I was asked to investigate the update statistics process on a particular database....
Question of the Day
Adding a Lot of Seconds
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers