Upcoming Events

2019 Highlights and Learnings – Weds, Dec 18, 8 AM Pacific / 11 AM Eastern / 4PM GMT –  Register

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

Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server

No Comments
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things got more complicated: we got more types of indexes. We got ONLINE options for schema changes that don’t involve indexes. We got more options for managing things like blocking, because online operations are really only mostly online — generally there’s going to be at least a short period where an exclusive lock is needed to update metadata. We now have some RESUMABLE operations coming in, too, for those big operations that are tough to handle. Along the way, I fell behind. Because these features have steadily come out over a period of time, my brain simply didn’t register them all, or possibly I missed seeing them amid other announcements. Having realized this, I did a little inventory: here’s my rundown of…
Read More

What would you say you do here?

No Comments
The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the chart he created which explains how Product Marketing Managers work with Product Managers — what each role focuses on, and where they collaborate. I realized that my own role as an Advocate can also be hard to understand. I did a podcast episode a while back on the topic — at the time, my role was called “Evangelism” rather than “Advocacy” — but I don’t expect my colleagues to listen to a podcast to figure out what value I can provide. Why does it matter if people know what you do? I work in a very collaborative role, but I’m not special: all roles which work with databases are increasingly collaborative. Even if you act more as a service provider than…
Read More

Installing Redgate SQL Toolbelt with Chocolatey (video with transcript)

No Comments
Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line. Spoilers: The command I show in the video is simply: choco install sqltoolbelt Fun fact, you can also upgrade: choco upgrade sqltoolbeltAnd uninstall: choco uninstall sqltoolbelt The rest of the 6.5 minutes is about related tools you may want to install, and why this is all needed. Links from the video — check these out while you watch https://chocolatey.org/products#fosshttps://chocolatey.org/packages/SqlToolbelt Gists with sample commands for useful installs for Microsoft Data Platform database folks: Aaron Nelson’s ListKendra’s List (forked from Aaron’s to track my own preferences)Rob Sewell’s List Video explaining Chocolatey and showing how to install SQL Toolbelt (6.5 minutes) Transcript Hello and welcome to this live stream episode. My name is Kendra Little and I am a DevOps Advocate at Redgate. Today I’m going to show you something…
Read More

My Git CLI Cheat Sheet

1 Comment
I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video. I find the Git CLI to be very friendly and easier to learn than a GUI interface. Setup Download git CLI: https://git-scm.com/downloads git clone <url> Clone a remote repo (maybe an empty one) into your local directory. Ref. git init If not cloning, you might initialize a fresh repo locally. Ref. .gitignore file I often show people how to use Git with Redgate’s SQL Change Automation. For that tool, you can download and unzip the .gitignore file to the folder where your .sqlproj file lives: https://documentation.red-gate.com/display/sca4/Version+control. Another great resource for figuring out what to ignore is http://gitignore.io/ Essentials git status Lists modified or added files, with status as to whether they are staged. Ref. git add . Stages all modified or added files. You must stage before…
Read More

Upcoming Free Webinars on Database Development and Operations

No Comments
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment on YouTube Stop by to chat! In this session I’ll be talking about what I’ve learned lately, what’s new in Redgate products, and whatever comes up with those who stop by live. Weds, Nov 20th – 9:30 am Pacific – YouTube Link (30 minutes)Weds, Nov 27th – 9:30 am Pacific – YouTube Link (30 minutes) How to Make Your 2020 Monitoring Strategy a Success Tomorrow, tomorrow, tomorrow! I’ll be chatting with BMW’s Tony Maddonna about monitoring in the real world. (The invite says my name is Arneh Eskandari, but I’ll be subbing in for Arneh as he’s been called away to Jury Duty.) Wed, Nov 20th – 8 AM Pacific / 11 AM Eastern – Register Essential Practices for High Performing…
Read More

Links and Resources from “How to Architect Successful Database Changes”

1 Comment
Group exercises beginning around the room Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day. Here are some links and resources from the day… Suggestion for configuration option to make SQL Server Developer Edition act like Standard Edition This has been requested by the community for many years, but now is the right time to please vote up this suggestion. After all, Microsoft just made Transparent Data Encryption as well as a whole slew of other cool things available in Standard Edition in SQL Server 2019. Things have really changed in Microsoft, and your voice matters — voting and commenting helps! The unnecessary evil of the shared development database Troy Hunt‘s amazing post from 2011 is…
Read More
Menu