Select Page

Month: December 2016

PowerShell – My way to prepare a SQL Server VM

As I get called on a lot of to do SQL Server installations, I’ve come up with what I’ve found works best for me. Every location has different infrastructure, security, networks and their way of doing things. Since I’m the one doing the installation, and I know I’ll get called back in the future at some point to upgrade, troubleshoot or manage the SQL Server environment, I like to have a set of standards. Documentation, I actually do enjoy writing it (yes I may be sick), but having a self-documenting PowerShell script is even better!

Read More

PowerShell – Start-Service, Stop-Service, they work, but not always well enough!

Well as the title suggests, I’m happy with the code, but I always find myself adding more and more code around the cmdlets. Service control in Windows has been pretty straight forward for the past few decades. Obviously PowerShell can control the state and configuration of services, but one thing I’ve always run into with service control is reacting to how the service stops and starts and also managing the state of dependent services. I’m sharing some short code functions that I use.

Read More
  • 1
  • 2