Category Archives: Blog

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode and see what you think, but one thing that Pat asked … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Advice I Like: In 100 Years

In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself today is “what might I be wrong about?” – from Excellent … Continue reading

Posted in Blog | Tagged , | 4 Comments

RANK() vs DENSE_RANK(): #SQLNewBlogger

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 , , , | Leave a comment

The Book of Redgate: SQL Server Central

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