Problem The last T-SQL Tuesday a lot of data professionals shared their favorite PowerShell scripts including functions, but some DBAs are new to PowerShell and don’t know how to use the functions. So this post will cover how to create a PowerShell module so you can store the functions you
The Problem Our databases autogrow because we have thousands of databases and before we know we have databases with high VLF counts in the transaction logs. If you don’t know why that is bad refer to the resources section of this article. Update – November 5, 2017 I have added
This month Rob Sewell (Twitter | Blog) is hosting T-SQL Tuesday and wants us to automate more with PowerShell or at least learn PowerShell. My favorite thing to automate using PowerShell is checking on the status of things on multiple servers. For example, after patching your environment running a quick