Experts at TechEd (AU)

I was talking to Dave Lemphers, and he told me he only has about 9 experts so far. It’s probably fair enough, he only put the call out a few days ago. But I figured I’d ask around too. Hopefully the number will be going up in the next few weeks. The idea is that if you register to be an expert at the Ask The Experts night at TechEd AU in August, then you make yourself available to talk to people that night. I figure that I would be doing this anyway, so I may as well register to help out.

If you’re going, and you know your stuff, then why not register too? I think I’m going…

Corrupt Paul Randal in Adelaide

Ok, not so much _in_ Adelaide as, umm… well… Ok, he’s going to be presenting a session remotely, about corruption in Microsoft. Or at least, the way that Microsoft handles corruption in SQL Server.

Paul Randal must be corrupt himself, because he’s Kimberly Tripp‘s other half. So if you’re going to be in Adelaide on Jun 14th, come along and listen to him talk. Register at: http://www.sqlserver.org.au/Events/RegisterMeeting.aspx?EventId=257

SQL Server vNext – codename "Katmai"

The next version of SQL Server (codenamed “Katmai” – which is a volcano in Alaska) has a website, and information is starting to leak out.

http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

One of the features that has come out that I guess I can now talk about is around spatial awareness. I still can’t say much yet, but I’m sure we’ve all had times when we’ve wanted to store locations or geometric positions in our database effectively. Of course we can easily store them just by having x & y co-ordinates, or longitude and latitude, but in “Katmai” this will be handled natively. Why is this good? Well, it bring consistency to the way that we store this information, and it understands the fact that we’re on a spherical world. Functions will be provided to let the database hook into applications like Virtual Earth, and Indexing will be far richer than just sorting points east-west or north-south.

I think there will be a whole lot more information becoming available after TechEd US next month. 

System Monitor (Perfmon) shows numbers instead of counter names

I came across this the other day. It was during a course I was teaching, so the timing couldn’t have been worse. I don’t have a screenshot, because I just wanted to get it sorted and didn’t think “Ooh, I’ll grab that to make my blog post better”.

But essentially, in the “Add Counters” dialog box of Performance Monitor / System Monitor, all the drop-down lists were full of numbers, no names.

There’s a way to unload the counter details for groups of counters and load them back in again, using “unlodctr.exe <group>” and “lodctr.exe <counter description file>” (or something like that). But this doesn’t work in this particular situation, where all the counter names are lost.

The answer is: “lodctr.exe /r“. The /r tells it to rebuild the sections of the registry that store this information, based on the list of what should be there (in the registry) and the backup set of .ini files. It takes a minute or so, and it doesn’t give you lots of useful information – but if you’re having this problem, try this and you’ll hopefully see the success that I had!