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.

Continue reading

Kendra Breaks and Fixes SQL Source Control in 9 Minutes

I love breaking technology.

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.

Continue reading

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

I’m excited to have just clicked ‘publish’ on four new videos in the brand new Advocate 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.

Continue reading

What a Software Evangelist Does and Where the Job Is Going (Dear SQL DBA Episode 67)

I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software company? In 21 minutes, I explain the core mission of Evangelists, and why I think being part of the sales process is an important part of the future of software evangelism.

Continue reading

State vs Migration for Database Source Control: Decide Based on One Question

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 time
• Migrations: An Aristotelian view of the database defined as a series of scripts which generate change over time

Continue reading

DBA Jobs: Threats and Opportunities (Dear SQL DBA Episode 66)

Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.

Continue reading

3 Key Points from My Upcoming Talk: DevOps: What, Who, Why, and How?

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.

I’ll cover three points which are often the source of misunderstandings.

Continue reading