It's obvious that I love PowerShell and SQL Server. Together, they allow SQL Server DBA's to solve just about any problem. Most of my projects have come from questions posted in Reddit's SQL Server subreddit, including my most recent project, Reset-SqlSaPassword, which allows you to regain sysadmin access to your SQL …

Back in 2013, I wrote a blog post about setting up RD Gateway in Windows 2012 using an AD domain certificate. This post is directed to Windows 2012 R2. There isn't much difference, but in this tutorial, I'll demonstrate how to setup RD Gateway with a globally recognized SSL certificate. Like my previous post about …

So here's what's awesome about Secure Socket Tunneling Protocol SSL VPNs: they give your connecting client an IP and make it a full-on part of the network. And this is all done over port 443, a commonly used port which is often enabled on firewalls. SSTP SSL VPNs are not like some fake "SSL VPNs" that just …

I <3 cheapsslsecurity.com. They (and probably others) sell globally recognized $5.99 annual certs. Now, all of my lab stuff (Lync/RD Gateway/NetScaler/SSL VPN) is encrypted, and I no longer have to manually install my Domain CA's root cert on my phones/other devices. They don't have an affiliate program, so I'm not …

Using a NetScaler within home lab is beneficial, mostly because you can use the same IP over and over for different services. Imagine providing VPN, Lync Autodiscover, Exchange Autodiscover, and SharePoint all over port 443. That's what a NetScaler VPX can do for you, for free. Below is a tutorial that will help you …

One of the things I love most about SuSE is how well it integrates with Active Directory. Joining a domain is easy when using yast. First I ensured that the Linux server's DNS server is pointed to my DC, then yast -> Network Services -> Windows Domain Membership. yast-wdm Note that if "Windows Domain …

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 SSL certificates on Windows-based vSphere related products using PowerShell and a Windows Domain …

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 cert automation project to see if it was possible to use only these tools and …

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.

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 which calls SviConfig.exe. You just gotta put in a few variables, run the script …