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…

Read More Slides & Demos for Backup Basics with PowerShell & dbatools

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…

Read More New-DbatoolsQuestion | Invoke-DbatoolsDiscussion -Platform Github

A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with different logins, users, and permissions between the two instances. Backup & restore to copy the database is easy enough, but because users & permissions are kept…

Read More Restoring Database Users After Copying the Database

Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time moving data in this direction, so we had some extra work to do. After installing the SSIS package and the MySQL .NET connector in the development…

Read More Write It Down!