SQL Saturday Presentation – SSIS Dev: Improving package reliability

Posted on April 10, 2011 by reagan

I had a great time at the SQL Saturday #73 in Huntington Beach, CA yesterday. Not only was I was able to attend some amazing sessions from the likes of @MrDenny, @denisemc06 and @cgkunz – I got to present on a topic very close to my heart: “SSIS Development: Improving package reliability.”

Posted in Uncategorized | Leave a comment

I Passed the MS Certified IT Professional Exam (70-452) in SQL Server 2008!

Posted on March 25, 2011 by reagan

I need to take a second to actually let this sink in by writing out that I am now an MCITP in SQL Server 2008 Business Intelligence. Done.

As I’ve done on my previous posts on certification tests, I’m going to use this opportunity to reflect and provide some feedback on what to expect on the Microsoft SQL Server 2008 – Business Intelligence exam – 70-452.

Posted in Uncategorized | Leave a comment

I passed the Microsoft MCTS 70-448 (SQL Server 2008 BI) exam!

Posted on March 11, 2011 by reagan

I passed the Microsoft SQL Server 2008: Business Intelligence Implementation & Maintenance (70-448) exam this morning.

I passed this test on SQL Server 2005 back in 2010, and was expecting a lot of overlap in content but I’m suprised how much more difficult it was. I commend the MS certification exam committee for continually making these tests more challenging.

Posted in Uncategorized | Leave a comment

Catching SQL Script Errors from an SQL Job

Posted on September 21, 2010 by reagan

When structuring scripts to execute in production, I often wrap a transaction around the contents of my statements. This is done to keep data integrity in-tact and to make things simpler to support in the event that the execute fails. Here is a quick example:

Posted in SQL Server | Leave a comment

Crystal Reports – Row Level Security

Posted on September 17, 2010 by reagan

Recently I was asked to take a look at a slow running Crystal Report.  This report makes use of row-level security and only returns records the report executor has been granted permissions to see. I was told this report was originally migrated to production with adequate performance (~2-3 second range), but over the past month users have been complaining of a slowdown (~20 seconds).

Posted in Crystal Reports, Report Security | Leave a comment