DevOps & IT Processes

Upcoming Free Webinars on Database Development and Operations

No Comments
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment on YouTube Stop by to chat! In this session I’ll be talking about what I’ve learned lately, what’s new in Redgate products, and whatever comes up with those who stop by live. Weds, Nov 20th – 9:30 am Pacific – YouTube Link (30 minutes)Weds, Nov 27th – 9:30 am Pacific – YouTube Link (30 minutes) How to Make Your 2020 Monitoring Strategy a Success Tomorrow, tomorrow, tomorrow! I’ll be chatting with BMW’s Tony Maddonna about monitoring in the real world. (The invite says my name is Arneh Eskandari, but I’ll be subbing in for Arneh as he’s been called away to Jury Duty.) Wed, Nov 20th – 8 AM Pacific / 11 AM Eastern – Register Essential Practices for High Performing…
Read More

Links and Resources from “How to Architect Successful Database Changes”

1 Comment
Group exercises beginning around the room Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day. Here are some links and resources from the day… Suggestion for configuration option to make SQL Server Developer Edition act like Standard Edition This has been requested by the community for many years, but now is the right time to please vote up this suggestion. After all, Microsoft just made Transparent Data Encryption as well as a whole slew of other cool things available in Standard Edition in SQL Server 2019. Things have really changed in Microsoft, and your voice matters — voting and commenting helps! The unnecessary evil of the shared development database Troy Hunt‘s amazing post from 2011 is…
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

2 Comments
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

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

Azure DevOps: How to Set a Custom Release Branch Folder Filter in Build Pipeline Triggers (video)

This is the first in a series of posts about simple things that I had a hard time figuring out in Azure DevOps services. It can be very useful to enable Continuous Integration for multiple folders in your DevOps pipeline — say, for every branch created under releases/ or features/. But configuring this can be strangely confusing! In this video, I show how to get a custom release branch folder set in your triggers for both build and release pipelines. Then I show a quick test of the automation at work in my demo pipeline. Spoiler: the fix is to type directly into the filter box and hit enter. It looks like that box is only for filtering existing branches, but you can use it for edits! The fix starts in the video at 1:50 if you only want to see that bit.
Read More
Menu