Blog Archives

[SOLVED] Degraded Performance on HP DL580 G7 on BIOS v. 7/01/2013

After a December 2013 patching downtime, I noticed an abrupt decrease of almost 50% in the performance of 2 SQL Servers.  Both servers were running on HP DL580 G7s.  After many hours of testing and data collection, we finally updated

Posted in SQL Server, Windows

PowerShell Get-WinEvent Bug Workaround on Windows 2008 R2 Server — Importing Windows Forwarded Events into SQL Server using PowerShell

This is sort of a continuation of my earlier post, Importing Windows Forwarded Events into SQL Server using PowerShell, where I mentioned that I was unable to get the script to work on Windows 2008 R2 due to a known

Posted in PowerShell, SQL Server, Windows

Importing Windows Forwarded Events into SQL Server using PowerShell

Over the past couple weeks, I’ve looked into a number of ways of parsing and importing Windows Forwarded Events into SQL Server: from using SSIS to LogParser to PowerShell to setting up a linked server to the “Forwarding Events.evtx” file.

Posted in PowerShell, SQL Server, Windows

Centralizing Windows Events using a Collector Initiated Subscription

So it seems like the best way to go about centralizing Windows Events in an Enterprise is to use GPO, but if you can’t or don’t want to involve Active Directory GPOs, here’s a guide on using one server to

Posted in Windows

HOW-TO Setup Windows 2012 Server Core Remote Desktop Services to Securely Administer Windows over RDP and SSL

Alright, so I’ve wanted to setup a Remote Desktop Gateway for years, but the configuration seemed so.. time-intensive. Then I moved to Belgium, my living situation changed and I didn’t want to setup a whole new VPN server to access

Posted in IIS, Security, Windows

MS BizTalk 2006 & 2009 Installation and Configuration Errors

I recently installed BizTalk 2006 and 2009 on a few servers at work. I found the process to be very painful for some reason. In regards to the BizTalk 2006 installation, I was running into an issue where the installer

Posted in Windows

FIX: Windows 7 Login Error "The trust relationship between this workstation and the primary domain failed."

Recently, my workstation was suddenly unable to logon to my Windows 2008 domain. After entering my domain username and password at startup, I was presented with the error: “The trust relationship between this workstation and the primary domain failed.” Ahh,

Posted in Active Directory, Windows

SQL 2008 Installation Failure on Reporting Services

Recently, SQL Server 2008 was uninstalled from a Windows 2008 Server machine due to some configuration issues with Reporting Services. Attempts to re-install SQL Server with the Reporting Services option would fail. I was tasked with the re-install and as

Posted in SQL Server, Windows

Setup WebDAV in Apache2 on SuSE Linux to Support Windows (XP/Vista/7) Clients

Earlier today, a colleague told me that she doesn’t like using my servers because I don’t have FTP setup thus, she couldn’t map my server as a drive. Well, I showed her. I stand firmly against using FTP as any

Posted in Apache, Linux, Security, Windows

Solved: Missing Hard Drive Space in Windows Server 2008

Tonight, I uninstalled Exchange Server 2007 from a development server and was surprised to see that, after the uninstall was complete (and not without a few workarounds), only 50GB of an 80GB hard drive remained. Explorer showed 25GB free, but

Posted in Exchange, Windows