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
I now have my MCITP for SQL Server 2008!
Debugging SQL Server Stored Procedures
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 )
Oracle 11g Client Install on Windows 7 x64
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:
I'm Still Here
The world didn’t end (yet). It’s 12 – 21 – 2012!