Upcoming Events

Level Up Your Deployments for SQL Source Control – Thu, Feb 20 at 4pm GMT/ 11 AM Eastern – Free webinar

SQLBits – Core Best Practices for High Performing DevOps Teams (Session) – March 31 to April 4 – London, UK –  Register

Data Grillen 2020 – May 28, 29 –  Lingen, Germany – sold out – schedule

Data Ceili – July 10 – Dublin, Ireland – Free! Register

Recent Recordings

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

Key findings from the 2020 State of Database DevOps Report – Watch

Managing and Automating Test Datasets for DevOps  with Jeffrey Palermo – Watch

How to Make Your 2020 Monitoring Strategy a Success, with BMW’s Tony Maddonna – Watch

Essential Practices for High Performing Database DevOps Teams – 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

Thinking About Robert Davis

It’s been more than a year and a half since Robert Davis passed away. I wrote a bit about Robert’s passing last April. I haven’t written about him since, but I think about Robert a lot. I think about Robert when I work on a tough problem that he would have found interesting, when chatting about database nerdery on Twitter, when preparing for a conference or training that I know he would have been excited to attend. I remember him when I get a great new photo of one of my dogs, because I know he would have loved to see it. When I remember Robert now, I remember how delighted he was to solve all sorts of puzzles, and I remember the sound of his laughter. He helps me try to remember to be kind. To be more helpful to others. I don’t have a big takeaway or piece…
Read More

Building my schedule for PASS Summit 2019

1 Comment
It’s just ten days until PASS Summit 2019 begins in Seattle. The schedule is up and there are loads of good sessions. Here’s what I’m putting on my calendar to make sure that I don’t miss it — along with some things that I wish I could attend that I’ll be sure to catch the videos of afterwards. Monday, Nov 4: “Redgate SQL in the City Summit Seattle” Pre-Con Day – Room 3AB This is going to be a fantastic day — loads of DevOps learning and sharing. I’ll be talking about implementing and improving Database DevOps with some of my very favorite DevOps and SQL Server specialists: Steve Jones, Grant Fritchey, Ike Ellis, Hamish Watson, and Arneh Eskandari. The great thing about having a list of speakers like this is that you get to hear about varied real-world experiences and different takes on topics, plus there is loads of…
Read More

Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (video with transcript)

No Comments
I am living the dream, y’all: yesterday I was finishing up my workday and needed to record a video, but realized that our puppy had spent enough time in her crate for the day already. So, I did the obvious: she’s my co-star in the video. This is what YouTube is for, right? In this video, Freyja the puppy and I talk about a recent workshop which I facilitated at the IDC DevOps conference in London. We cover: 01:45 The workshop methodology: about the Lightning Decision Jam Session, by AJ&Smart / Jonathan Courtney. I think this is a great format, and you may want to use this yourself for a workshop with your team (on any problem-solving topic)05:33 Key findings from our group about how to overcome the top obstacles to Continuous delivery for databases A transcript of the session is below the video. Transcript (edited a bit for clarity)…
Read More

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar about Redgate’s solutions. (Shameless plug: the webinar is free.) Part of the demo does the following magic, using a branch policy and pull request automation trigger, combined with some of Redgate’s extensions: Builds/validates database codeCreates a lightweight clone of the “production” database (I’m using a copy of StackOverflow, thanks Brent & the folks at Stack)Creates a release artifact summarizing the changes that’ll be deployed to the clone, exports it, then deploys the changes This combination of actions is lovely — reviewers of the pull request have validation that the code builds, they know it deploys successfully, and they can even look at…
Read More

Git Command Line Tutorial with SQL Change Automation for SSMS (video)

I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create precise scripts to apply changes to your database. If you’re curious about what I mean by “migrations-first”, read more about this approach, and how it compares to a state-first approach here. I’ve been working with SQL Change Automation with Git for a while in Microsoft Visual Studio. Visual Studio contains a lot of integration by default with Git and Azure DevOps, so I’ve been using its graphical tools, for the most part. The new SQL Change Automation extension for SSMS works with the Version Control System (VCS) of your choice, but this initial release provides only “working folder” support That means that you set up your version control outside of SSMS, then point SQL Change Automation at your working folder. This…
Read More

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

1 Comment
The Accelerate: State of DevOps Report 2019 has just been published. This report is the latest in six years of research. With more than 31,000 survey responses, Accelerate is the longest running study of DevOps in academia or industry. In the 2019 edition, research continues to show that DevOps drives business value: high performers at DevOps are “twice as likely to meet or exceed their organizational goals.” While this isn’t a new finding, it’s very important that this continues to be true: why invest in improving at DevOps if it doesn’t drive business value? While there are a ton of valuable insights in the report, in this post I will focus in on the findings which I believe are most relevant to those of us who work “close to a database.” There are three very interesting aspects of the research which hit close to home: Speed and stability are not…
Read More