Tag Archives: administration

The Choice of SQL Server Version

Posted on July 22, 2023 by way0utwest

Every quarter Brent Ozar publishes some data from his SQL ConstantCare® service. This is a service where companies contract with Brent to install a service on their instance, collect data, and give them simple, short daily emails on things they … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Choice of SQL Server Version

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