Tag Archives: administration

Restore with Standby–#SQLNewBlogger

Posted on August 30, 2023 by way0utwest

A customer had a question about restoring with standby, so I wrote a quick post to explain how this works. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

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