Another new SSMS 2008 goodie – moving files into a project

So many times I’m writing a query, and I think “I want to put this into that project…”, but because I didn’t add it when I first made the query it’s a pain (and I end up copying the text into a new query). But in SSMS 2008, I’ve just noticed the File menu has a “Move <file> into project” entry down near the bottom. So now I can just choose that and my query magically appears in the project. Terrific! There seems to be so many nice little things in SSMS 2008 – try right-clicking on some data in … Continue reading Another new SSMS 2008 goodie – moving files into a project

Map of the world in the Spatial Results tab (and converting from Geometry to Geography)

One of the things on my list of stuff to check out in the RTM version of SQL Server Management Studio in 2008 is the Spatial Results tab that Isaac Kunen talked about a while back. He called it Eye Candy, and it really is. I started by grabbing a set of data from Virtual Earth expert (and good friend) John O’Brien, containing geometry figures for the world. Geometry for things that are on the world isn’t exactly the best, but it was better than nothing. So then there was the matter of converting it to the Geography type. Geometry … Continue reading Map of the world in the Spatial Results tab (and converting from Geometry to Geography)

The Pope and sneezing

I flew into Sydney recently, around the time the Pope was leaving after World Youth Day. I figured if I saw him, I could go and stand near him and sneeze. (Don’t ask me how I’d make myself sneeze – I hadn’t worked out that part of the plan.) Hopefully, he’d reply in the standard way, and I’d have a great story about getting a blessing from the Pope. But then I thought – hang on, the current bloke is German. He’d probably say “Gesundheit” instead, which doesn’t have the same ring to it. I’d be stood there, complaining at … Continue reading The Pope and sneezing