Warning: Use of undefined constant ’WP_POST_REVISIONS’ - assumed '’WP_POST_REVISIONS’' (this will throw an Error in a future version of PHP) in /homepages/10/d210128362/htdocs/wp-config.php on line 109

Warning: Declaration of Suffusion_MM_Walker::start_el(&$output, $item, $depth, $args) should be compatible with Walker_Nav_Menu::start_el(&$output, $item, $depth = 0, $args = Array, $id = 0) in /homepages/10/d210128362/htdocs/wordpress/wp-content/themes/suffusion/library/suffusion-walkers.php on line 39
Mar 132014

In case you missed it, I wrote a post about Disaster Recovery planning on my employers blog this week. You can read the full article here: http://www.rdx.com/Blog/dba_tips/2014/03/disaster-recovery-planning/

Jul 162013
Pittsburgh SQL Saturday 2013

Preparations are well under way for this year’s Pittsburgh SQL Saturday. If you’ve never heard of or been to SQL Saturday, it is well worth the time. It is an all day, FREE training/technical conference devoted to Microsoft SQL Server. (there is a $10 charge to help offset the cost for lunch) This year’s Pittsburgh [Keep reading…]

Feb 122013
Powershell: delete files older than X days

On a recent project, I needed to delete archive folders that were older than a specified number of days. The thing that made this a little more challenging is that there were Daily, Weekly, and Monthly folders (similar to the screenshot below); each of which had a different retention period. I found several scripts to [Keep reading…]

Jan 162013
SSIS execute task only on Tuesday

I’ve started working with SSIS a lot more lately.  I am going to attempt to document here some of the quirks that took me a little while to figure out along the way. In this tidbit, I have a multi-step SSIS package that needs to be run on a daily basis.  However, one step of [Keep reading…]

Sep 302012
SQL Saturday Pittsburgh

Wow, somehow I managed to not post anything here for 6 months!  I started a new job since then, which has kept me really busy, and I did not make the time for posting anything on my blog.   The big news is that Pittsburgh’s SQL Satuday is this Saturday October 6 at La Roche in [Keep reading…]

Mar 132012
SQL Tuesday #028 – Jack of All Trades, Master of None

This month’s TSQL Tuesday is hosted by Argenis Fernandez.  This month’s topic:  “blog about your experience. Tell us why you specialized, or why you’d like to specialize. If you don’t think that specialization is a good thing, tell us why. Discuss. Argue your point(s).” ================================================= My first job out of college was a Network Administrator for [Keep reading…]

Mar 122012

This is a quick one today as a follow-up to my previous post on using the SSMS Template explorer.  While I do like the convenience of using the template explorer to store frequently used scripts, one of my biggest  complaints was the fact that all the scripts are buried several directories down under the C:\users directory (windows [Keep reading…]