T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Brent Ozar (blog | twitter) asks us to talk about data types. Your mission: write a blog post about your favorite data type, and schedule it for next Tuesday, March 9. Mad about money? Feverish about float? Tell us what you use your favorite data type for, and what people need to know before they get started using it.
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.
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!
While presenting Backup Basics with Powershell and dbatools at ONDT, I mentioned a caveat with the -ReplaceExisting switch for Install-DbaMaintenanceSolution. This switch drops all of the objects installed by the Maintenance Solution, including the CommandLog table. If you use that table to produce evidence that the various maintenance tasks are being performed on a regular basis or use it to track performance of those tasks over time, dropping that table presents a problem.
I got a merge a while back that included a change I wasn’t expecting from one of my developers. All they were doing was renaming a column on a table. We had names settled a while ago. What’s up with that? Turns out, when I created the table, I named one of the fields BrithYear. This merge request corrected it to BirthYear. The misspelling slipped past me, past everyone else, it was only discovered because when this developer was building the a new query into their code, they spelled the field as one would expect, and the query threw an error.
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month James McGillivray (blog | twitter) asks us about our views on vacations, escapes, or other breaks. I’d like to know about your own views on vacations, escapes or other breaks. Whether it’s work, technology, or any other situation that you need to get away from. Plans, memories, or relaxing activities, I want them all!
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.
Yeah, so…that was a hell of a year, wasn’t it? Short-Form Reviews of Year 2020 Reviewer #1: 👎 Reviewer #2: ★✩✩✩✩, would not recommend Best Laid Plans… The year started out really well. I was getting into a good groove at the new job, I spoke at SQL Saturday Cleveland and SQL Saturday Rochester ran smoothly. My session for SQL Saturday Raleigh was accepted too, I submitted a session for SQL Saturday Albany, and I was invited to present remotely for SQL Professionals of Chattanooga.
Chrissy LeMaire (blog | twitter) pinged me earlier this week to tell me about Github Discussions. It’s a new feature of Github which is similar to Stack Exchange, but much more focused - it’s just for your project/repository! Get help, start discussions, share tips & tricks. She’s enabled this feature for the dbatools repository and it’s open for business. Go check it out and start posting questions, answers, or both!
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh in my mind. This is also my long-form event evaluation. We’ve Moved! We’re Closed! The announcement that Summit 2020 was to be held in Houston brought was both disappointment and excitement. I enjoy visiting Seattle and have gotten to know little bits of it.