Upcoming Events

SQL PASS Summit – Nov 4-8, Seattle, WApricing

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

How to Persuade Your Company to Change

Like a lot of developers and database administrators, I do a fair amount of short-term problem solving during the course of my normal work week. I get to join some Redgate sales calls, often during Proof-of-Concept exercises, and this frequently involves helping brainstorm about the best way to use our tools to solve a specific need for monitoring, database development, or automation. I also pick up customer questions from the #Redgate channel in the SQL Server Community Slack and answer forum questions for Redgate when I can. Inevitably, when you do a regular amount of troubleshooting and brainstorming with customers, you start to notice patterns and have ideas about how to make things easier, faster, or better in some ways. Sometimes this is an idea for a new process or a new product, or it might be a big change to existing processes or products. The challenge is getting it…
Read More

Managing Cross-Database Dependencies in Builds (Redgate video)

Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects in some databases which is dependent upon objects in other databases — or even circular dependencies. In this 20 minute video, I give an overview of the two most popular options that Redgate customers use to manage cross-database dependencies when building SQL Server databases with Redgate’s SQL Change Automation.
Read More

How Developers and DBAs Collaborate in a DevOps World (video)

You’re a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for automation? Or should you instead re-think how your two teams work together? In this 40 minute episode, Kendra discusses DevOps team topologies, the changing role of DBA teams in DevOps, and the opportunities available in creating communities of practice around database development. Prefer to listen on the go? You can get this episode on iTunes, download the audio file, or find Dear SQL DBA in your favorite podcast app. Bookmarks of topics covered 00:30 – Our question, from a DBA 7:00 – Why bother with DevOps? 9:23 – Team topologies, aka rethinking how the teams work together. This discussion includes notes on where and when DBAs review changes and talk about architecture in a DevOps way of working. 21:20 – Changing…
Read More

A letter to my 20 year-old self

This post is a part of #tsql2sday, a monthly community ritual where a topic is proposed by a community member and everyone is invited to join in. This month’s topic is from Mohammad Darab, who encouraged us to: “Write your 20 year old self a letter. If you could go back in time and give yourself advice, what would it be?” The advice I would give to my 20 year old self is the same advice I give to myself today, more than 20 years later: You are a person who throws yourself into your work — ALL the way into your work You tend to define yourself by your professional activities, and you expect your work to be consistently of very high quality. One of your greatest strengths is that you are a creative person, but when you narrow your focus too much, when you make your life too…
Read More

DBAs: Stop Denying Sysadmin to Developers

I recent chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical — it’s a process problem. The issue is that these folks are trying to configure a build for their SQL Server databases using Redgate tools, but they aren’t allowed sysadmin permissions on any SQL Server instance in their organization (even in development environments), because of a policy set by the Database Administrators in IT. Why do DBAs deny sysadmin permissions in development? You may find this type of policy puzzling — and for good reason. After all, if you don’t trust developers to keep their own development environment running, why would you ever trust any code they’ve written enough to deploy it to production? In that question is a bit of an answer: this policy occurs when there is a fundamental lack of trust between development and operations. The policy that…
Read More

What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People

My friend and colleague, Kathi Kellenberger, taking questions in her SQL Saturday session on Machine Learning for beginners Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us had attended the event in the past, and whether or not event attendees were engaged with presenters and vendor representatives. My immediate thought was: of course the attendees were engaged, because the event is a SQL Saturday.  I’ve never been to a SQL Saturday where the attendees weren’t engaged. But, I realized that it’s a fair question. This level of interaction isn’t a given for events, much less tech events I’ve been to other tech events — from free events to very expensive ones — where attendees didn’t interact much with anyone else. Mostly people worked away on their laptops/phones/tablets quietly (maybe taking…
Read More
Menu