SQL Server Alias Registry Settings June 13, 2013 POST In this post we will discuss where SQL Server Aliases, defined through the SQL Server Configuration Manager, are stored in the Windows registry.
SSIS Multi-Environment Configration June 13, 2013 POST This post describes a method of managing multiple SQL Server Integration Services (SSIS) package configurations across environments using a single SQL Server table.
SQL Server Database Mirroring Troubleshooting Notes June 11, 2013 POST In this post we will highlight a collection of troubleshooting notes related to SQL Server database mirroring.
SQL Server Database Mirroring Failover Notes June 10, 2013 POST In this post we will highlight some techniques on executing a failover when using SQL Server database mirroring.
How To Upgrade Windows Server 2008 from Standard Edition to Datacenter Edition June 7, 2013 POST This post describes a process for upgrading a Microsoft Windows Server 2008 R2 Standard edition to the Datacenter edition using generic Key Management Server (KMS) keys.
Failed to Communicate with Debug Host Process in BIDS May 23, 2013 POST In this post we will discuss how to fix the “cannot communicate with the debug host process” error when trying to debug SQL Server Integration Services projects using the Business Intelligence Development Studio (BIDS).