Category Archives: Blog

Using SQL Compare to Revert a Stored Procedure

Posted on August 13, 2025 by way0utwest

Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do you fix this? We’ll use SQL Compare since most of you … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using SQL Compare to Revert a Stored Procedure

Adding a Named Default Constraint to a Table: #SQLNewBlogger

Posted on August 11, 2025 by way0utwest

As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a constraint, however, I want to ensure this is named explicitly and … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding a Named Default Constraint to a Table: #SQLNewBlogger

Just a few weeks to PASS on Tour and the Redgate Summit

Posted on August 6, 2025 by way0utwest

It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back to New York City this year. I’ve been there a few … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Just a few weeks to PASS on Tour and the Redgate Summit

Sabbatical 3 – A week of work

Posted on August 4, 2025 by way0utwest

I hadn’t made many plans on the sabbatical, and that was fine with me. It’s been a busy year, and I wanted to be unwired and unwind. It turned out this has been a good test of retirement for me … Continue reading →

Posted in Blog | Tagged | 3 Comments