Category Archives: SQL 2012

Is a Deprecated feature making my job more difficult?

By definition, a “deprecated” feature refers to a feature or specific function in a piece of software that will be replaced with a newer function/feature or just flat out will be no longer available. Microsoft is notorious for changing and/or … Continue reading

Posted in SQL, SQL 2012, SQL 2014 | Tagged , | Leave a comment

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

Playing with SQL 2012…(and a rookie mistake)

So I thought I would install SQL 2012 Express with Advanced Services on a Windows 2008 R2 box in the hopes of playing with the new edition and using it as a platform for a new SQL Monitor Solution I … Continue reading

Posted in SQL, SQL 2012 | Leave a comment