Regain Access to SQL Server When Locked Out July 8, 2015 POST This post describes how to regain access to a SQL server when you are denied access and the sa password has been lost.
SQL Server 2012 Restore Error March 30, 2015 POST This post describes an error that may occur when you are transferring database backup files from a SQL 2008 server to a SQL 2012 server and you are using SQL Server Management Studio (SSMS) to perform the restores.
Error Running SQL 2012 Best Practice Analyzer June 15, 2014 POST In this post we will discuss how to address a permissions problem when attempting to run the SQL Server 2012 Best Practice Analyzer.
Class Not Registered Error Using Excel Connection Manager April 17, 2014 POST In this post we will discuss how to address a “Class Not Registered Error” when using a Microsoft Excel Connection Manager in a SSIS package.
Designer Stops Working in BIDS January 13, 2014 POST This post describes how to fix the Business Intelligence Development Studio 2008 error that occurs when trying to view the design surface of a SSIS package.
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.