Tag Archives: development

T-SQL Tuesday #158–Implementing Worst Practices

Posted on January 10, 2023 by way0utwest

Not that I’m looking to do this, but that’s the invitation from Raul Gonzalez this month. This is the monthly blog party where we write on a topic chosen by the host. All topics are tracked at T-SQL Tuesday, and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #158–Implementing Worst Practices

A SQL Compare Picklist

Posted on December 19, 2022 by way0utwest

Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them. This post covers a process I suggested to them to tackle … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on A SQL Compare Picklist

Paid Flyway Advantages–Undo and Check

Posted on October 31, 2022 by way0utwest

The Community edition of Flyway has some nice basic features, and it works well for many people. However, it requires you to do a lot of the heavy lifting of building and deploying scripts. There are some advantages of the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Paid Flyway Advantages–Undo and Check

DevOps–Fixing Poorly Named Constraints

Posted on July 26, 2017 by way0utwest

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement. ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC] The problem was that … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments