Speaking

A collection of the resources mentioned in my PASS Data Community Summit session Backup Basics with PowerShell and dbatools, including bonus content!

I am thrilled to announce that I will be speaking at this year’s PASS Data Community Summit! This year’s event runs November 8th through 12th. I am thrilled to announce that I will be speaking at this year’s PASS Data Community Summit!

I had a great time speaking at the Kansas City SQL Server User Group on Thursday, February 18th. The more I present my Backup Basics with PowerShell and dbatools session, the more I enjoy it. And each time, I’ve learned something new myself.

In one of the demos I show how Restore-DbaDatabase selects and restores the most recent backup of a database when pointed at a directory holding several backups of a single database. Dan Maenle (twitter) asked how the function knows which one is the most recent. Timestamps? Filenames? Really good guesses? My takeaway from the session was to confirm the method in use.

I will be presenting my session “Backup Basics with PowerShell and dbatools” this Thursday, February 18th at 2:30 PM Central Time at the Kansas City SQL Server User Group. I’m looking forward to getting this demo-rich session out in front more of folks to show how easy dbatools makes some of these common backup-related tasks.

Come check it out! Or, if you’d like to see this or one of my other presentations at another user group meeting, please drop me a line!

I had the honor of presenting a new session, Backup Basics with PowerShell and dbatools, at the first Ohio North Database Training meeting this evening. Thank you to the group leaders for the opportunity and to everyone who attended.

Because this was both a brand new session and an attempt at a new way of delivering the presentation, I had a couple tech glitches but things went pretty well once they were understood and ironed out. Definitely room for improvement next time!

A couple months ago I delivered a short (15 minute) presentation at work about the importance of having a good professional network and how I’d found mine. As I was developing it, I had to keep redirecting myself as the theme would start trending towards how great the #SQLFamily is. To be fair, that’s what inspired the topic in the first place, but 15 minutes of stories about my friends is not what my co-workers signed up for.

This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed & his team did a terrific job with organizing it. Communication for both attendees and speakers was excellent, and as far as I can tell, everything ran very smoothly.

My Presentation

I presented Keys to a Healthy Relationship with SQL Server in the 3:30 PM session block. I’ve uploaded my slides to the SQL Saturday site. This is targeted primarily at application and database developers and I had a pretty good-sized turnout for the session. I promised folks answers to questions they asked in the session so let’s address those right now:

For the second consecutive year, I will be speaking at SQL Saturday Albany 2020 on July 25th, 2020. I will be presenting “Keys to a Healthy Relationship with SQL Server” at 3:30 PM.

Abstract

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

Thank you to everyone who came out to see my presentation Keys to a Healthy Relationship with SQL Server at SQL Saturday Cleveland. I had a great time and I hope each of you learned at least one new thing.

Here are the links I mentioned in the session, as well as a couple that contributed to some of the things I mentioned.

• Slide deck uploaded to the SQL Saturday website
• Emoji as server object names
• Michael J. Swart’s (blog | twitter) Ten Percent Rule
• Telling Entity Framework to select specific columns
• RunAs Radio #673, Writing Good T-SQL in 2020 with Pam Lahoud and Pedro Lopes

Thank you to everyone who made SQL Saturday Cleveland possible - the organizers, sponsors, my fellow speakers, and all our attendees. Special shout-out to Eric Blinn (blog | twitter) and Paul Popovich (twitter) for finding a way, against all odds, to pull my name three times in the closing raffle.

A few years ago, I wrote about my first experience speaking at SQL Saturday. Recently I had a conversation with one of our first-timers speaking at SQL Saturday Rochester 2020 and realized I should do a follow-up with some additional tips.

Use the FAQ

Did you know that PASS has an FAQ section for speakers on the SQL Saturday site? But don’t limit yourself to that - look through the whole FAQ, you might get some new insights into SQL Saturday.