Upcoming Events

Level Up Your Deployments for SQL Source Control – Thu, Feb 20 at 4pm GMT/ 11 AM Eastern – Free webinar

SQLBits – Core Best Practices for High Performing DevOps Teams (Session) – March 31 to April 4 – London, UK –  Register

Data Grillen 2020 – May 28, 29 –  Lingen, Germany – sold out – schedule

Data Ceili – July 10 – Dublin, Ireland – Free! Register

Recent Recordings

Redgate Evangelist YouTube Channel: Tutorials on Database DevOps -New videos each week – Watch

Key findings from the 2020 State of Database DevOps Report – 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 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

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”

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

Why I Make Animated Gifs for Presentation Demo Backups

PASS Summit 2019 starts up next Monday with pre-conference sessions. I’ve got my schedule all set, and I’m going to be busy: I’m speaking in two full-day pre-conference sessions, giving two regular sessions, judging the ever-exciting Speaker Idol competition, and also spending time at the Redgate booth in the expo hall. Oh, and I scored a little PASS-TV interview to talk about Redgate right before the keynote on the first day. (SQUEE!) I am super lucky to have all these awesome activities lined up, but one thing is clear… I need to be PREPARED I will not have a lot of time to react if something goes wrong, such as laptop failure, a critical VM that won’t boot up, poor internet connection, etc. When it comes to my talks, I keep copies of my presentations in the cloud and on USB keys in case my laptop fails– that’s no big…
Read More