Tag Archives: administration

Finding Encrypted Stored Procedures–#SQLNewBlogger

Posted on August 9, 2023 by way0utwest

I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts that show how to decrypt these and also how Flyway helps. … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

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