SQL Server Database Administration

Why I Make Animated Gifs for Presentation Demo Backups

1 Comment
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

Building my schedule for PASS Summit 2019

1 Comment
It’s just ten days until PASS Summit 2019 begins in Seattle. The schedule is up and there are loads of good sessions. Here’s what I’m putting on my calendar to make sure that I don’t miss it — along with some things that I wish I could attend that I’ll be sure to catch the videos of afterwards. Monday, Nov 4: “Redgate SQL in the City Summit Seattle” Pre-Con Day – Room 3AB This is going to be a fantastic day — loads of DevOps learning and sharing. I’ll be talking about implementing and improving Database DevOps with some of my very favorite DevOps and SQL Server specialists: Steve Jones, Grant Fritchey, Ike Ellis, Hamish Watson, and Arneh Eskandari. The great thing about having a list of speakers like this is that you get to hear about varied real-world experiences and different takes on topics, plus there is loads of…
Read More

Git Command Line Tutorial with SQL Change Automation for SSMS (video)

I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create precise scripts to apply changes to your database. If you’re curious about what I mean by “migrations-first”, read more about this approach, and how it compares to a state-first approach here. I’ve been working with SQL Change Automation with Git for a while in Microsoft Visual Studio. Visual Studio contains a lot of integration by default with Git and Azure DevOps, so I’ve been using its graphical tools, for the most part. The new SQL Change Automation extension for SSMS works with the Version Control System (VCS) of your choice, but this initial release provides only “working folder” support That means that you set up your version control outside of SSMS, then point SQL Change Automation at your working folder. This…
Read More

SQL Server Management Studio is as Relevant as Ever

1 Comment
Sometimes you keep a classic around After almost fifteen years of heavy usage by developers and database administrators (DBAs), it might seem like Microsoft’s free tool, SQL Server Management Studio (SSMS), is about to go out of style. After all, SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to develop their new tool, Azure Data Studio (the artist formerly known as SQL Operations Studio), since November 2017. Azure Data Studio is built on the modern foundation of Microsoft’s VS Code, whereas SQL Server Managed Studio is related to the legacy Visual Studio Shell. Based on this overview, it might seem like a new SQL Server DBA or developer should primarily learn Azure Data Studio, not SSMS. And it might similarly seem like vendors should focus on developing new tooling only for Azure Data Studio. But when you look into the details of…
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

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