DH Unlimited
Portfolio Blog Login

DH Unlimited is comprised solely of me, Dave. I've been doing freelance web development since 2010, mainly for the purpose of expanding my technical skill set.

Site Updated

Bye 2012

Saturday, December 29, 2012 2:36 pm

It’s been a long year but a good year. Instead of focusing on the negative I will focus on the positive for this post. The list below is in no particular order.


  • Went to New Orleans for the first time
  • Reconnected with some old friends
  • Met some new friends
  • Got a new job
  • Finally got some use out of that SQL Server 2008 book I bought a few years ago
  • Improved my web programming skills
  • Ate some really good food
  • Learned to be more patient in life and not be so down on myself all the time

Tag(s): Life 

I passed!

Thursday, December 27, 2012 5:21 pm

I now have my MCITP for SQL Server 2008!

Tag(s): SQL Server  Personal 

Debugging SQL Server Stored Procedures

Wednesday, December 26, 2012 2:21 pm

I’ve written probably 100,000 lines minimum of SQL Server stored procedures.  I had to.  Otherwise they wouldn’t have paid me.  Some of those stored procedures took hours to run.  So if I was debugging them I couldn’t necessarily wait that long on the PRINT function in SQL Server to show me what results I was expecting because that function does not produce output until the stored procedure is over.  So I turned to the RAISERROR function.  It’s kind of a “hack” as it’s designed to show errors mainly (I think) but I use it since it has the option of NOWAIT which should be pretty explanatory.  Below is an example:

raiserror ( ‘text goes right here’ , 0 , 1 )

with nowait

Tag(s): SQL Server 

Oracle 11g Client Install on Windows 7 x64

Wednesday, December 26, 2012 12:18 pm

After many hours trying to get Oracle to work with SQL Server I decided to give up with the current software installed and reinstall the client for 11g.  Long story short the only way I was able to get this to work was running the setup on the command line as follows:  

setup -ignoresysprereqs 

And then….SUCCESS!

Tag(s): Oracle  SQL Server 

I'm Still Here

Friday, December 21, 2012 3:37 pm

The world didn’t end (yet).  It’s 12 – 21 – 2012!

Tag(s): Life 
Back to the Top