Tag Archives: administration

Checking Database Compatability = #SQLNewBlogger

Posted on September 21, 2022 by way0utwest

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 , , | Comments Off on Checking Database Compatability = #SQLNewBlogger

The Case for Patching

Posted on August 20, 2022 by way0utwest

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 , , | Comments Off on The Case for Patching

The Useful Cloud Tags

Posted on July 1, 2022 by way0utwest

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

Posted on April 27, 2022 by way0utwest

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