Automating SQL Service Account/Password Changes

I received a customer request to put together some PowerShell scripts to automate the SQL service account and password changes you can do through the SQL Configuration Manager GUI.  The notes below were written using a SQL 2008R2 machine on Windows Server 2008R2. The reference material I used to start were these links:   http://msdn.microsoft.com/en-us/library/ms162567(v=sql.105).aspx   http://sqlblog.com/blogs/allen_white/archive/2013/02/12/t-sql-tuesday-39-managing-your-sql-server-services-with-powershell.aspx   http://technet.microsoft.com/en-us/library/Microsoft.SqlServer.Management.Smo.Wmi(v=sql.105).aspx Based on what I…

1

I Never Have to Worry About Upgrading the OS on My Azure PaaS Roles, or do I?

You may think that if you’re running a platform as a service application on Azure (PaaS), you never have to worry about the version of the operating system it is running because Microsoft upgrades it for you. This is true within an OS family if you have configured your operating system version for your PaaS…

1