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

PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas

Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three sessions between now and March 31, 2019. I’m currently in the process of sketching out my ideas for what sessions that I’d like to submit, and I thought I’d share my process here. Generating ideas: what am I interested in spending six months thinking about? I’m a bit selfish when it comes to topic selection, and I think that’s fine: it needs to be something that I’m interested in thinking about for more than half a year. That does NOT mean that it needs to be super-advanced rocket science content. Figuring out how to present introductory level content clearly, in an easy-to-understand way takes a lot of time. The topic simply needs to compelling enough for me to stay interested. A…
Read More

Contest: Tell Your Database Development Disaster Story (5 winners get $150 USD or more each)

Redgate is building a library of real-world stories about database development disasters. Your mission: Tell us a true story in 500 words or less about a time when you were involved in an Agile or DevOps project that went full steam ahead in speeding up delivery of application code, but didn’t modernize database development practices. Did trouble follow? Check out the prizes and give us the scoop here before March 20, 2019. Enter today, time’s almost up! Share your story using the form hereThe story must be true – but never fear, we will anonymize all stories and the names of the winnersEnter as often as you’d like (but each person may only win once) Need inspiration? Grant’s sample entry (the short version) “Our organization built a new application using an Object Relational Mapping (ORM) tool. The team worked without any DBAs or database developers for speed. We ended up…
Read More

Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)

I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn more about how everything works and what your options are to fix the situation when things go sideways. In this 9 minute video, I ignore SQL Source Control’s valiant attempts to keep me out of trouble, and put the database code in my local git repository into an inconsistent state. Can I fix it? (Spoiler: yes I can.)
Read More

New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation

No Comments
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and working with a project in one of my favorite Redgate tools: SQL Change Automation. The awesome thing about SQL Change Automation is that it gives you two things: Fine-grained control to tune and order the execution of changes to your database with a migrations-first approach to source controlling your codeA view of the state of your database, which is crucial for code reviews, controlling environment drift, and communicating about changes between developers and database administrators The tricky thing is that there’s a lot to learn when starting out with SQL Change Automation if you haven’t used a migrations-first approach in the past, or aren’t used to working in Visual Studio. That’s where these videos come in: you can follow along with…
Read More
Bust of Developocritus, the Forgotten Greek Philosopher

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

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