If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly out of PowerShell v2. I’ll add a little bit to the hint, don’t try running this on your XP boxes. It doesn’t hurt anything, but you get a helpful little message “Get-Counter : This cmdlet can only run on Vista and above.”
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s a short post, but worth the read.
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share my initial impressions. I’ll be capturing trace events from the database over the next couple of weeks, so I’ll be following up on the behavior of nHibernate within this database as well.
The first thing I saw & thought was, “Foreign key constraints. Thank the gods.” That really is good news. I was frankly concerned that they might go with the “let the code handle it” approach. There are quite a few null columns. I’m also seeing tons & tons of nvarchar(255) which must the default string size. Lots of bit fields too. They also used bigint in a lot of places too. None of this is definitively good or bad, just observations.
There are tables that lack a primary key. That raises a bit of a concern. The primary keys I’ve looked at have all been clustered, which isn’t too problematic since that’s probably the primary access path. There are a few unique constraints on some of the tables too.
Overall though, I don’t see anything that, at first glance, makes me want to run screaming from the room (or pick up a big stick & start looking for developers). The devil is no doubt in the details. Time to get started looking at the trace events.
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed out our online registrations at 500, an accomplishment by itself. During registration on the day of the event, we shut down registration and just started waving people through the door at 300. Our best guess at the total attendance was 340 (not the 375 I tweeted during the delirium of the day). There were a couple of minor glitches and one major one. The major glitch was not enough vegetarian food. We just ran out. Everyone else seemed to get a meal. We had just a few, read that 3 or 4, sandwhiches at the end of the day.
I want to personally thank Adam Machanic for all the hard work he did putting the thing together. It wouldn’t have happened at all without him and it was as good as it was because of him. Just as much thanks goes out to Jim O’Neil of Microsoft for all his assistance putting things together. We also had a lot of help from Chris Bowen, also of Microsoft. Thanks guys.
Our sponsors were excellent people. In no particular order, Confio, Expressor, Microsoft, PASS, Idera and Quest all stepped up and helped us out. I want to thank them personally, and if you attended the event and got anything useful out of it, you should thank them as well. Around the same time next year guys, please.
I also want to thank the speakers. We had industry heavy weights and people speaking for the first time and everything else in between. I didn’t see all the speakers or all the rooms, but I made a point of getting around and sitting through sessions when I could. I learned stuff. I saw great presentations and I saw full rooms. You guys rocked and rocked hard. Good job and thank you for all your time and effort.
Finally, I want to thank everyone who came. It was a great community event and everyone I spoke with seemed to have managed to pull something out of it, networking, learning, or teaching.