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.

I’ll cover three points which are often the source of misunderstandings.

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, sign up here).

In the midst of a discussion about the cost of attending conferences, Benni De Jagere shared the following tweet from Cathrine Wilhelmsen:

Did you know that ALL the session recordings from PASS Summit 2017 (and earlier) are available for free? :) Get your learning on here: https://pass.org/Learning/Recordings/Listing.aspx?category=Summit #SQLPass #PASSsummit #SQLFamily

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.

In the hour-long session below, I explore what executives mean when they describe a ‘digital transformation’, why this transformation is happening across all industries, and how understanding this gives developers and database administrators an advantage in building their careers.

Even if you hate buzzwords, the big ones signify critical cultural changes. Digital transformation is one of those buzzwords, and it’s worth understanding what it really means.

Continue reading

Do 75 Percent of Data Breaches Really Come from Insiders?

There’s a lot of information out there on data breaches. I’ve written before about one source that I trust: the Verizon Data Breach Report (DBIR).

Continue reading