Monthly Archives: August 2023

Quickly Creating a tsqlt Test for a Query

Posted on August 28, 2023 by way0utwest

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if a chance or enhancement has broken anything. This usually requires a … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Power BI and Git

Posted on August 28, 2023 by way0utwest

When Power BI was released, I was working with customers to try and adopt DevOps for their database code. At that time, I thought the Microsoft developers had made an extremely poor decision with the PBIX format in that it … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Power BI and Git

Friday Flyway Tips: More Config Options

Posted on August 25, 2023 by way0utwest

Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway 6.5.4. I’ve been working with Flyway Desktop for work more and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Friday Flyway Tips: More Config Options

Removing Weak Security from SQL Server

Posted on August 25, 2023 by way0utwest

I was checking some arguments in the RESTORE command for SQL Server and saw that the MEDIAPASSWORD option was deprecated and marked as being removed at some point. That made sense, and I assumed that PASSWORD was the option to … Continue reading →

Posted in Editorial | Tagged | Comments Off on Removing Weak Security from SQL Server