Tag Archives: administration

Bare Metal

Posted on July 10, 2023 by way0utwest

At the first job I had as a DBA, I had to build a new server. This was in the days of SQL Server 4.2, and I was combination DBA, sysadmin, and general help desk at a small company. With … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Bare Metal

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