Tag Archives: administration

Ten Database Commandments

Posted on November 20, 2023 by way0utwest

I love the Notorious B.I.G. His music isn’t for everyone, but I enjoy it. This piece takes one of his songs (NSFW – Ten Crack Commandments) and applies the list to databases. Each item from the song is listed, along … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Ten Database Commandments

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