Blog Archives

SQL Server Solution Least Likely to Work, Actually Did

Two of my SQL Servers stopped working after an unexpected power outage. When I attempted to start them, they gave me an Access Denied error. These are two totally different machines (diff Win & diff SQL version) that both, after

Posted in SQL Server, VMware

PowerShell: Per-user VMware Thinapp Registration Login Script

I’m not super familiar with ThinApping, but converted portions of this VMware login script at the request of a consultant. I tried to automate the script a bit more than the one from VMware’s blog. Their script required that you

Posted in PowerShell, VMware

Summary Post: Update VMware vSphere SSL Certs

After speaking with a colleague today, I expect this list will grow as I work more with the vSphere suite. But until then, here is a consolidated list of posts and scripts that I’ve written to ease the replacement of

Posted in PowerShell, Security, VMware

Update VMware Horizon View SSL Certs with your own Windows Domain CA Certificates using PowerShell

Well, this script was different. Unlike the other posts in this series, I was required to use only Microsoft command line tools instead of OpenSSL. Not that I’m opposed to using certreq and certutil — I actually started this whole

Posted in PowerShell, Security, VMware

Update VMware Site Recovery Manager SSL Certs with your own Windows Domain CA Certificates using PowerShell

Next in the series of replacing vSphere related SSL scripts is the VMware Site Recovery manager script. This script generates the SSL certificates based off of the WebServer Certificate Template and runs a batch file to perform the actual replacement.

Posted in PowerShell, Security, VMware

Update VMware View Composer SSL Certs with your own Windows Domain CA Certificates using PowerShell

Next in the series of replacing vSphere related SSL scripts is the VMware View Composer script. This one is rather simple, and uses certutil and certreq to generate the certificates, as opposed to OpenSSL. It also generates a batch script

Posted in PowerShell, Security, VMware

Update NetApp Virtual Storage Console SSL Certs with your own Windows Domain CA Certificates using PowerShell

Ahhh, it seems like replacing SSL certificates in vSphere is a never–ending process. My vSphere farm was not prompting me about untrusted SSL certs until I installed the NetApp Virtual Storage Console. Using the template from my previous posts, however,

Posted in PowerShell, Security, VMware

Update vSphere 4.1U3 and 5.0 SSL Certs with your own Windows Domain CA Certificates using PowerShell

While it took quite awhile to figure out how to replace vSphere 5.1 and 5.1U1’s SSL certs, converting that script to work with 4.1U3 and 5.0. It probably helps that SSO doesn’t exist (or I couldn’t find it — I

Posted in PowerShell, Security, VMware

Migrating SQL Server?

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command.


Available from dbatools.io and github

SQLPS Needs You

SQLPS now has a dedicated engineer and Microsoft is asking for our input!


 
Upvote priorities and cmdlets now

Authors


Chrissy LeMaire


Brandon Abshire
View Brandon Abshire, MCDBA's profile on LinkedIn

Awards

Chrissy has been awarded the Microsoft MVP for her work in the PowerShell community.

Join us!

Belgian PowerShell
User Group

  SQL PASS PowerShell
Virtual User Group

 

Upvotes Needed

Help persuade Microsoft to open source SQL Server's PowerShell module, SQLPS.


 
Upvote now on Microsoft Connect