Upcoming Events

IDC DevOps ConferenceSept 26, London, UK

SQL PASS SummitNov 4-8, Seattle, WA

Recent Recordings

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

Paying down technical debt

One of the cool things that I do as an Evangelist at Redgate is to periodically visit company headquarters in Cambridge. The other Evangelists and I get to meet with every software developer, product manager, and UX designer at Redgate over a series of meetings. That’s really cool. We talk about things that they’ve released lately, what they’re looking at doing in the near future, and we get to give feedback based on what we hear from the community and from folks in the sales process. We also get to share what we personally think should happen in these products now. As you might imagine, I have a wish list for features in a variety of different Redgate products Our products are great, and one of the things about great products is that users are always inspired to want to use them in new ways, so I never lack for…
Read More

What is Automation?

Photo by 수안 최 on Unsplash Today I got a bit closer to a meaningful definition of automation, as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why should licensing an automation product be related to the number of users? A few weeks ago, I was chatting a bit in the SQL Server Community Slack Channel.✣ One community member was frustrated with running into situations with per-user licensing for monitoring and automation products. This isn’t the first time I’ve heard grumbling about per-user licensing, of course — with any licensing model, you’re going to hear grumbling about it, that’s just how licensing goes. But I think per-user licensing can make a lot of sense when it comes to automation products, because of the nature of automation. I work for Redgate, which does…
Read More

Should release cadence be slowed if you don’t have database load testing?

I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development go without load or performance testing?” I got a follow-up question from my friend Chris Randvere at Redgate: he asked for more information about what the question meant? I realized that my wording had been pretty unclear. I had meant to ask the panelists what their thoughts were on release cadence when a team lacks tooling to do automated load and performance testing outside of production. Should the lack of automated performance testing ability change the rate at which we deploy software? In other words, if we can’t do performance and load testing, does that mean that we should or shouldn’t deploy a change to a database every weekday? I don’t think we covered this super-well in the panel because I…
Read More

Upcoming full day training: “How to Architect Successful Database Changes”

I’m excited to be teaching a full day session with Steve Jones at the SQL PASS Summit on Tuesday, November 5, in Seattle. Steve and I will be discussing proven patterns to version and deploy changes successfully Read more about this precon session, or check out the video below where I give a brief overview of what Steve and I will cover. Will you teach me how to use Redgate tools? Nope– not in this session. While Steve and I both work for Redgate, we will be showing patterns and approaches that work with both vendor and custom tooling, and we’ll do demos with a variety of tools, including free tools when possible. This is absolutely not a product-specific session, and the patterns discussed have been proven in the industry by developers and DBAs using a wide variety of tooling. If you’d like to learn more about Redgate tools, check…
Read More

Take the 2019 State of SQL Server Monitoring Survey: Here’s What’s in It For You

Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers. Take the survey before April 5, 2019. Your time is valuable. The survey will take 5 – 10 minutes to complete. That’s not a ton of time, but it’s a noticeable part of your day, and there should be something in it for you. Here’s why it’s worthwhile to take the survey. Database use patterns and monitoring trends are valuable to everyone in the community — and we’ve been missing out on this trend information! This isn’t the only survey from Redgate — you may also have heard of the annual State of Database DevOps Report. But this survey is different in important ways: it asks how you manage and monitor your SQL Server database environment, regardless of whether you think about DevOps at all. Redgate shared the results…
Read More

Why to Avoid Using the Current Database Name in Object Definitions in SQL Server

I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. Hello, my name is FINE In the article, I discuss: Why referencing the current database name creates a dependencyWhat ‘deferred name resolution’ is, and why the dependency may be more noticeable in views and some functions (rather than stored procedures)Which activities are most likely to break if you place dependencies on the current database name Read the full article here.
Read More
Menu