DH Unlimited
Portfolio Blog Login
X

About
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
01/06/2016

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