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

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

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
Menu