Tag Archives: administration

Actively Choosing Compatibility

Posted on June 14, 2023 by way0utwest

SQL Server databases have had a compatibility level for a long time. This is a setting that enables the database to process code as if it were a particular version. The levels go from 80 (SQL Server 2000) to 160 … Continue reading →

Posted in Editorial | Tagged | Comments Off on Actively Choosing Compatibility

Scaling Up Monitoring

Posted on May 31, 2023 by way0utwest

Monitoring databases is important when it’s the systems that are in production. Operations departments know that catching issues early, being proactive, and having data to troubleshoot issues make their job easier. Not having these things makes their job much more … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Scaling Up Monitoring

Validating Password Expiration

Posted on May 27, 2023 by way0utwest

I would guess that the majority of instances I’ve had to manage in my career were those that I didn’t initially install and configure. I’ve inherited more instances than I would bother to count, and I often need to double-check … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

Restore One Backup From Many in a Device–#SQLNewBlogger

Posted on May 17, 2023 by way0utwest

I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that is simple and hopefully serves as an example for people trying … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment