Upcoming Events

Weekly Database DevOps Live Chats – a new experiment on YouTube

How to Make Your 2020 Monitoring Strategy a Success – Wed, Nov 20th – 8 AM Pacific / 11 AM Eastern – Register

Essential Practices for High Performing Database DevOps Teams – Tue, Nov 26th – 8 AM Pacific / 11 AM Eastern – Register

Why the Database is at the Heart of DevOps Success – Fri, Nov 29 – 6:00 AM Pacific / 9:00 AM Eastern / 3PM CET – ScaleUp 360 online conference – Register

Managing and Automating Test Datasets for DevOps – Weds, Dec 4 – 7:30 AM Pacific / 10:30 AM Eastern – Register

Recent Recordings

Redgate Evangelist YouTube Channel: Tutorials on Database DevOps -New videos each week – Watch

Fast and Reliable Development with Redgate Solutions for SQL Server – Watch

Implementing Data Masking for NIST Compliance – 1 hour – Watch

How Developers and DBAs Collaborate in a DevOps World – 40 minutes – Watch

How DevOps Keeps DBAs Safe from Being Automated Out of a Job – 1 hour – Watch

DevOps: What, who, why and how? – 1 hour – Watch

Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch

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

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

No Comments
One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem, but with a history of reporting tools ranging from temperamental Infopath forms to websites where you painstakingly click here and there for hours, there have been reasons for the complaints. This year I decided to try out using PowerShell to add my contributions. This has been available for about a year thanks to François-Xavier Cat and a few friends, but I’d completely forgotten that it was possible until William Durkin reminded me about it on Twitter. First time ever, I didn’t wait until the last minute to start thinking about my annual contributions. Instead, I took a little time to learn about how this works — and now I’ll keep my contributions in a spreadsheet and then upload them right before…
Read More