Monthly Archives: August 2025

Carrots and Sticks

Often,  we work on projects that might span a significant amount of time. Weeks, months, even years can be devoted to working on one system, or the same system. We may find that our motivation rises and wanes at different … Continue reading

Posted in Editorial | Tagged , | Comments Off on Carrots and Sticks

Adding a Named Default Constraint to a Table: #SQLNewBlogger

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

Storage Enhancements

There was a time when I knew a lot about the various storage technologies available for a database. It was important when designing a server around the various requirements for size and performance balanced against the limitations of hardware. The … Continue reading

Posted in Editorial | Tagged | 1 Comment

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

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