Category Archives: SQL 2005

Where is the key to the LOCK?

This past Friday evening, a simple data import process (that has been working for several months), decided to not work correctly.  Because there was no “early warning” type of notifications systems on the SQL 2005 server, the SQL Agent Job … Continue reading

Posted in SQL 2005, SQL 2008, SQL 2012, SQL Jobs | Leave a comment

Back to the Basics (B2B: Intro)

On occasion, an IT personnel (non-DBA) is tasked with providing SQL support.  Either with installation, upgrading, backups, restores, moving databases or other tasks that normally would not fall under their “job description”.  Trust me I have been there.  We call … Continue reading

Posted in SQL, SQL 2005, SQL 2008, SQL 2012 | Leave a comment

MS SQL Reporting Services 2005 and Host Headers

MS SQL Reporting Services is a very valuable and powerful reporting engine; however, “personalizing” or “branding” it is not the easiest task.  The following MSDN article was very helpful in configuring SSRS using a DNS Alias and a host header … Continue reading

Posted in SQL 2005 | Leave a comment