Tag Archives: administration

Running a Service

Posted on September 27, 2023 by way0utwest

Many of us work for some organization and we’re responsible for managing a database or coding some application or some other data related position. Perhaps we ensure reports work for our users or move data around. In many cases, we … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Running a Service

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