Importing Data With PowerShell and dbatools

I've found myself working with PowerShell more frequently as of late, in no small part due to the amazing dbatools module. This has led to me trying to figure out how else I can utilize it for some of my personal internal processes. I like to use public datasets for experimentation and presentation demos, especially data that people can easily understand and relate to. For some, keeping them up-to-date was a manual process of downloading files, loading tables, and merging. There are of course many better ways to do this, some of which are more automated than others. I could…
Read More

T-SQL Tuesday #15: Automation

This Month's T-SQL Tuesday is being hosted by Pat Wright (blog | twitter) and Pat is asking about tips and tricks for making life easier through automation using either T-SQL or PowerShell. Recently I have been doing more and more work in PowerShell in order to get familiar with it. So far I've been quite happy. Batch scripting always seemed rather clumsy to me, and PowerShell represents a much-needed improvement, especially coming from a .Net programming background like I do. One of the processes I've found particularly helpful to automate in PowerShell is the testing of database backups. A backup…
Read More