grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘SQL’

SQL Server 2000 Reporting Services

Today I took part in installing SQL Server 2000 Reporting Services. One quirky thing. I had the default website stopped. I had another website running on port 80. Reporting Services wouldn’t install. I couldn’t run both websites on the same port (it was internal, no DNS set to have subdomains). I had to start [...]

Comments (2) | 88 views

SQL Server User’s Group

Tonight I went to the SQL Server User’s group at the Microsoft Office in the Twin Cities. As always they had the pizza and beer (hmmmmmmm beeer).
Anyways, there were two presentations. One on NAnt for automating SQL Server deployment, and then one given by Itzik Ben-Gan on analytical functions in SQL Server 2005 (Yukon) and [...]

Leave a Comment | 86 views

SQL Exception Handling in .NET

In .NET , Microsoft introduced the Try, Catch, Finally exception handling. In all books and examples I have seen, you catch an exception like so:
Try
…some code
Catch ex as Exception
…some error handling code
End Try
Well, what happens when you are catching a SQL Exception?
Try
…some code
Catch sEx as SqlException
…some error handling code
End Try
Is Microsoft trying to tell us [...]

Leave a Comment | 39 views