On Tuesday, December 13th, I was privileged to give a talk to the San Diego SQL Server Users Group. It was a great experience and there was a lot of discussion about how some of the new T-SQL and CLR features of SQL Server 2005 can be utilized. A couple of the biggest hits were ROW_NUMBER, RANK, and Common Table Expressions. Given that this was a administrator heavy group there was some healthy discussion about the use of CLR objects in SQL Server. Although there was some hesitation about using CLR objects, I found that discussing the when and where it is appropriate to use the CLR mitigated that somewhat.
With the holidays it has taken me a little longer to package up the slides and code. Alas, the slides and code can be downloaded here:
http://employees.claritycon.com/akarcher/SDSQLUG_Dec2005.zip
Microsoft has just released a diagram for the SQL Server 2005 System Views. It is a pretty good reference if you want to dig into some of the details of SQL Server. You can download the PDF here:
http://www.microsoft.com/downloads/details.aspx?familyid=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en
I have the privilege of speaking at the December meeting of the San Diego SQL Server Users Group.
I will be presenting two sessions:
T-SQL Enhancements in SQL Server 2005
SQL CLR in SQL Server 2005
All the details can be found on their web site here.
It will be a lot of information to get through in 2 hours, but it will be a lot of fun and something that I am really looking forward to presenting. So if any of you happen to find yourself in San Diego on Tuesday swing by the meeting and say hi!
Andrew