Tag Archives: administration

Checking Database Compatability = #SQLNewBlogger

Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple and hopefully serves as an example for people trying to get … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The Case for Patching

Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn’t see it. Then I realized that I was on SQL Server 2019 CU 2 on … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

The Useful Cloud Tags

One of the things I’ve seen in working with cloud based resources is that you get a lot of them in your account quickly. A database might end up with a server, an IP address, a network, security groups, and … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Migrating a Large Database

I have upgraded lots of SQL Servers from one version to the next, and for the most part, the process has been smooth. That’s not always the case, and there have been some long nights where the Operations staff had … Continue reading

Posted in Editorial | Tagged | Comments Off on Migrating a Large Database