![\"Blythe](\"https:\/\/www.sqlinthewild.co.za\/wp-content\/uploads\/2009\/11\/Blythecookies.jpg\" "\\"Blythe")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
PASS 2009 is underway!<\/p>\n
It\u2019s getting to the point that these conferences feel like a family reunion (where the family members are people that you like). Last night, coming to registration there was a whole crowd of people that I know from previous conferences, newsgroups, blogs and forums. I\u2019m not going to name everyone I ran into last night, simply because I\u2019ll forget someone.<\/p>\n
There were a lot of insider sessions today, but the only one that I attended was the introduction. Most of the topics were ones I wasn\u2019t overly interested in. Rather spent the day at\u00a0 Adam\u2019s CLR pre-con. CLR is an area that I\u2019ve barely looked at and have little experience with, so it was a good choice.<\/p>\n
Some very interesting info on CLR table valued functions. Apparently there\u2019s no temp table\/table variable involved. The CLR function streams the values back one row at a time. Might well remove the impact that the multi-statement table valued function has. Needs testing.<\/p>\n
Late morning was spent at a Chapter Leaders meeting. Some of the resources available I didn\u2019t know about. Things to look at when I get home. Also need, next month, to write up a report for the regional mentors on the meetings that we\u2019ve had and what the attendance numbers look like. Something else to add to the to-do list.<\/p>\n
Jack Corbett was at the meeting. One more person that I\u2019ve chatted with online located. Ran into Steve and Bob right after lunch. Good to see Steve again. Will run into Bob later today and chat.<\/p>\n
Some of the comments on CLR and Attention events was interesting. Basically, the CLR doesn\u2019t receive attention events, so a timeout or a SSMS stop can result in orphaned CLR objects that will hang around for a while until the garbage collector comes across the object and collects it.<\/p>\n
Very interesting sample code for collecting system performance counters using a CLR proc (unsafe CLR proc because it uses dlls that aren\u2019t on the safe list.)<\/p>\n
CLR Triggers. Just say no. Well, if it\u2019s a ddl trigger with xml manipulation of the EventDate() maybe. Possibly. Perhaps.<\/p>\n
Or maybe not. SQL DDL trigger with a CLR function to do the xml manipulation.<\/p>\n
Some very interesting discussion of Code Access Security, Host Protection Attributes, Trustworthy and signed assemblies. It\u2019s possible to have safe assemblies calling unsafe (external access) assemblies with the minimum amount of code marked unsafe (external access), have the database untrustworthy and still have everything working. Lots and lots of work though.<\/p>\n
Day ended with the opening party (and the quiz bowl) followed by the SSC party. Good fun all.<\/p>\n
Some photos from the day<\/p>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n