Blog Archives

Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers

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,

Posted in PowerShell, Security, SQL Server

Securely Administer Your Remote Windows Network using RDP over SSL

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

Posted in Security, Windows

Setup an SSTP SSL VPN in Windows Server 2012 R2

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

Posted in Security, Windows

Super Cheap SSL Certs for Your Home Lab or Small Business

I <3 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

Posted in Security

NetScaler VPX Kinda Quick Start

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

Posted in Security

Use Windows Authentication to Connect to SQL Server in OpenSuSE 12.3 x64

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

Posted in Active Directory, Linux, Security, SQL Server

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