Tag Archives: administration

Upgrading SQL Server Central

Posted on December 14, 2022 by way0utwest

The decision to upgrade database servers can be a complicated one that involves features, costs, and support requirements. While I think many people would love to run database systems for ten years, often there are concerns about support, which effectively … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

T-SQL Tuesday #157–The End of Year

Posted on December 13, 2022 by way0utwest

It’s that time of the month, and I’m late. I’ve been on holiday for a week, so this is a quick post for T-SQL Tuesday. This month is hosted by Garry Bargsley, and is a fitting topic for the last … Continue reading →

Posted in Blog | Tagged , , | Comments Off on T-SQL Tuesday #157–The End of Year

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