Tag Archives: administration

Assembling Your Own Toolbox

Posted on October 7, 2022 by way0utwest

Last month Brent Ozar posted that September was community tools month. He had a number of posts that highlighted tools and a number of other people (Francesco, Erik, VladDBA ) did as well. I didn’t do any blogging because, well, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Assembling Your Own Toolbox

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