Posts by Kendra Little

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

Why I Make Animated Gifs for Presentation Demo Backups

2 Comments
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

Thinking About Robert Davis

4 Comments
It’s been more than a year and a half since Robert Davis passed away. I wrote a bit about Robert’s passing last April. I haven’t written about him since, but I think about Robert a lot. I think about Robert when I work on a tough problem that he would have found interesting, when chatting about database nerdery on Twitter, when preparing for a conference or training that I know he would have been excited to attend. I remember him when I get a great new photo of one of my dogs, because I know he would have loved to see it. When I remember Robert now, I remember how delighted he was to solve all sorts of puzzles, and I remember the sound of his laughter. He helps me try to remember to be kind. To be more helpful to others. I don’t have a big takeaway or piece…
Read More
Menu