Category Archives: Blog

RANK() vs DENSE_RANK(): #SQLNewBlogger

Posted on February 18, 2026 by way0utwest

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way. You’ll see how I checked on RANK() vs DENSE_RANK() below. Another … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on RANK() vs DENSE_RANK(): #SQLNewBlogger

The Book of Redgate: SQL Server Central

Posted on February 13, 2026 by way0utwest

It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak for themselves. I have a copy of the Book of Redgate … Continue reading →

Posted in Blog | Tagged , , | 6 Comments

Setting FK Constraints in Data Modeler

Posted on February 11, 2026 by way0utwest

One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy, but they encountered a few errors. Here is how this worked … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Webinar: Navigating the Database Landscape in 2026

Posted on February 10, 2026 by way0utwest

For a number of years, we’ve produced the State of the Database Landscape report, based on surveys and research we do every year. I have found it very interesting to see how people respond and what we learn from the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Webinar: Navigating the Database Landscape in 2026