Categories
Geeky/Programming

Microsoft SQL Server 2005 Summit

Microsoft SQL Server 2005 Summit – Twin Cities…

Went to this all day Thursday in the cites. Went to the developer track. Learned about programming with SQL 2005, then about the new
SQL Server Integration Services and how to do data mining and things like that. Then learned about Advanced SQL Server Reporting Services and the changes in 2005, and then
learned about the new Service Broker Service in SQL 2005, and finished up by learning about SQL Server Express 2005, the replacement for MSDE 2000. Also there were two keynotes, in the
beginning and then the end, the first one was on IT infrastructure and how the Windows Server System can make it easier, etc. The last one was on SQL Server Tips and Tricks..Overall
it was a good experience, learning about SQL Server 2005 that will come out later this year, and how we can use it in our organization to make things easier and more efficient.

Categories
Geeky/Programming

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 up the default website on port 8080, and then Reporting Services installed. I then stopped the default website, but to my surprise, the virtual directories for Reporting Services were under my second website running on port 80. WTF are they checking for? My guess is a website that has a default directory for c:inetpubwwwroot – Everything else on my second website was the same as the default except for that. It would be nice if they let you choose where you wanted to put the website, like if you already had a website running on IIS, just to choose which website you want the virtual directories installed.

weird!~

SQL Server 2000 Reporting Services

Categories
Geeky/Programming

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 comparing the results to SQL Server 2000.

The NAnt presentation was ok, but not really anything I would use. I really don’t understand scripting out script. Why not just write the script out in the first place?

The Analytical functions presentation was more interesting. It went over ROW_NUMBER, RANK, DENSE_RANK, and NTILE(x) functions in SQL Server 2005 and how you can use them to speed up some things that you might be doing in SQL Sever 2000, etc. One thing I can see is automatically ranking team wins and losses by sorting by the wins and losses and adding a RANK column. Pretty sweet.

Finally, we stopped at the Granite City Food and Brewery in Maple Grove for a beer to see how it compares to the one in Saint Cloud. Pretty nice, but kinda crowded.

Categories
Geeky/Programming

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 something here??