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…]

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…]