Blogs

State vs Migration for Database Source Control - decide based on one question

One controversial topic in database development is how to properly store and deploy database changes.

This is generally described as choosing between two options, which are approximately as easy to understand as Greek philosophy:

  • State based - A Platonic view of the database as a snapshot of a set of forms in a given state at a point in time
  • Migrations - An Aristotelian view of the database defined as a series of scripts which generate change over time

Continue reading

DBA Jobs: Threats and Opportunities (Dear SQL DBA Episode 66)

Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.

Continue reading

3 Key Points from My Upcoming Talk: DevOps: What, Who, Why, and How?

Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders.

Click here to watch.

Continue reading

Watch all my free PASS Summit recordings-- and more videos at Pass.org

A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here).

Continue reading

Watch: Can This Team Succeed at DevOps? Panel discussion

I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter.

Watch our discussion about how to make three different teams successful at database DevOps.

Continue reading

What ‘Digital Transformation’ Means, and How You Can Use It to Advance Your Career (video)

I recently spoke at the GroupBy free online conference. It was loads of fun, and the recordings from the event are now available. Here’s the hour long session I presented.

Continue reading

Watch: The Best of 2018 and Predictions for 2019 (video)

I recently got together with fellow Microsoft Data Platform MVPs Steve Jones, Kathi Kellenberger and Grant Fritchey to discuss the highlights of innovations we’ve seen in 2018 and predictions for 2019.

Continue reading

Adding Microsoft MVP Contributions with PowerShell - Lessons Learned using the MVP API

One of the things that brings Microsoft MVPs together each year is complaining about reporting community contributions to Microsoft.

Continue reading

Where do data breaches come from?

I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and a bit of what I learned.

Continue reading