Utah Code Camp Spring 2012

This last Saturday was the most recent iteration of Utah Code Camp  and I have to say it was a resounding success.  In addition to speaking, I was invited to participate in an “Ask a DBA” panel discussion and also had the opportunity to have SQL Solutions Group sponsor the event.  So it was a […]

By |March 12th, 2012|SQL Group, SQL Server|0 Comments

Expired Passwords and the Oracle Provider

I ran into a problem a while back that caused me a lot of grief so I thought I’d post it here. The package in question was used to traverse hundreds of Oracle databases and run the same query on all of them. This data was then loaded into a data mart. The databases all […]

By |January 15th, 2011|SQL, SQL Group, SQL Server|1 Comment

EPM Framework Tips and Tricks

I just got done implementing the EPM Framework for a client and thought I’d post a few things here I learned along the way.  Nothing earth shattering but stuff worth noting.

SQL Server Version

The SQL Server 2008 instance serving as the EPM Framework hosting instance must be 2008 SP1 CU3 or higher. What is interesting about […]

By |November 4th, 2010|SQL Group, SQL Server|0 Comments

Converting a Hex value to an integer using the CLR

As an old-school DBA who has been around the block more times than I’d like to admit, I am always a bit slow to jump on the bandwagon with new features and technology.  I’m the guy that still doesn’t like the idea of virtualizing databases for example.  The CLR was no different when it came […]

By |November 4th, 2010|SQL Group, SQL Server|0 Comments