What I'm Up To

Upcoming Events
New Recordings
  • SQL in the City Streamed – Free Redgate training livestreamWatch
  • How DevOps Keeps DBAs Safe from Being Automated Out of a JobWatch
  • Redgate Evangelist YouTube Channel: Tutorials on Database DevOps –New videos each week – Watch
  • DevOps: What, who, why and how? – 1 hour – Watch
  • Get Inspired: Celebrate the Careers of Three DevOps Heroes – 1 hour – Watch
  • What ‘Digital Transformation’ means, and how you can use it to advance your career– 1 hour – Watch
  • Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch
  • SQL In the City Streamed – Watch the whole stream
    • Crucial data privacy and protection insights for 2010 – with Richard Macaskill – 45 minutes – Watch
    • The four keys to unlocking DevOps – 30 minutes – Watch
  • The Best of 2018 and Predictions for 2019 (Panel with Steve, Grant, and Kathi) – 1 hour – Watch
  • What We’ve Learned about Adopting Database DevOps, and What to Avoid (MVP Panel with Guest Panelist Tony Maddonna) – 1 hour – Watch
Bust of Developocritus, the Forgotten Greek Philosopher

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

2 Comments
Bust of Developocritus, the Forgotten Greek Philosopher 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 timeMigrations – An Aristotelian view of the database defined as a series of scripts which generate change over time Yeah, I never really liked arguing about philosophers, either. Scratch all that. There’s a simple question that you can use to decide whether a state-based or migrations-based approach is right for a given database. Here’s that question: Do you want at least 95% of your database changes to deploy using auto-generated code? There you go, that’s it. Look back on your life-long experience with Clippy,…
Read More

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

No Comments
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. The webcast will be held on Wednesday, Jan 23 at 8 am Pacific / 11 am Eastern. Click here to register and get a reminder to attend the live webcast, or to watch the recording after it airs. I’ll share a lot of information in the talk. As a preview, here are three points which are often the source of misunderstandings: Developer productivity is a top concern of C-level executives Implementing DevOps isn’t something you do in an afternoon. Often, DevOps implementations begin from the C-suite as part of a digital transformation effort. DevOps can also be originated from small teams in the company who transform their own practices, share their success with the company, and enlist executive support to spread these…
Read More

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

1 Comment
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, 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://t.co/zDJ9DAyr1U #SQLPass #PASSsummit #SQLFamily— Cathrine Wilhelmsen (@cathrinew) January 14, 2019 I follow Cathrine, but apparently I need to follow her more closely, as I’d missed this tweet on the 14th. I had no idea these recordings were free and searchable. These free sessions include way more than the Summits I checked out which recordings are available, and my mind was blown — it’s not just past PASS Summit recordings (excluding the 2018 Summit, most of which are not currently free), but also user…
Read More

Watch: Can This Team Succeed at DevOps? Panel discussion

No Comments
I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about how to make three different teams successful at database DevOps: Abstract: DevOps sounds great in theory, but in reality it’s tricky to transform your people, process, and tools. In this interactive, poll-packed panel discussion, we will use real-world scenarios to clarify what DevOps principles are and how they help reduce manual work and improve productivity for software developers and database administrators. We’ll step through situations that are tricky when it comes to making database changes, sharing patterns to avoid and how to approach and conquer problematic entrenched processes. This session is designed to be accessible to both beginners and advanced practitioners: we’ll talk through definitions of DevOps terms and patterns and will encourage audience discussion. Your panelists: Kendra Little – Product Evangelist, RedgateHamish Watson…
Read More

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. Check out more free GroupBy sessions here. Session abstract: Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kendra Little will explain 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. You will learn what motivates CEOs to modify their business models in a digital transformation, and patterns and anti-patterns of companies that have attempted these transformations – with different results. You’ll leave the session with an understanding of the core ideas and philosophies behind digital transformation that will help you prioritize what to learn, guide your interactions at work,…
Read More

Do 75% 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). The 2018 DBIR studied a sample of 2,216 confirmed data breaches, and of these it found that 28% involved internal actors. The DBIR uses a publicly accessible database of security incidents, and applies quality filters to data before including it in the report. Only 28%? I heard that 75% of breaches come from “insiders” Different studies sample different breaches, so it’s natural that there would be some variance on findings about who is behind breaches. However, I heard about a report where the variance was enough that I wanted to look into it: a presentation at the PASS Summit in 2018 cited a 2017 article which found that three quarters of data breaches came from “insiders.” This figure seems very high to me. Every…
Read More
Menu