Tag Archives: administration

Securing All Your Connections

Posted on June 28, 2023 by way0utwest

I read an interesting blog from the cyber security team at Microsoft, noting you should use TLS for your SQL Server connections. I would assume most professionals know that using TLS and secure protocols across the network is important. I … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Securing All Your Connections

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