Upcoming Events

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

Recent Recordings

Redgate Evangelist YouTube Channel: Tutorials on Database DevOps -New videos each week – 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

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

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