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 … 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 … 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 … Continue reading The Pope and sneezing

Time to try some exams? Second shot is back

I always tell people to do exams during Second Shot season. Reason being – it makes the first one a practice. Don’t bother studying, don’t bother stressing, just go and see how you do. Then you can sit it a second time for real. Feel like giving it a go? Register at http://www.microsoft.com/learning/mcp/offers/secondshot/default.mspx before booking. … Continue reading Time to try some exams? Second shot is back

Ctrl+1 in SSMS for sp_who, plus more

I did this by accident, but turns out it’s a really useful feature. I was just trying to zoom in on something using Zoomit, that really useful thing that I use whenever I’m presenting these days. But I didn’t have Zoomit running, and so SQL Server Management Studio ran sp_who. And it’s not even new. … Continue reading Ctrl+1 in SSMS for sp_who, plus more

Busy times recently

Time seems short at the moment. I’m putting the finishing touches on a presentation for TechEd Australia 2008. I’m not on the list of speakers at the moment, but I will be when they’re next updated (there are a few blanks still). I’m giving a talk about T-SQL techniques, which should be a lot of … Continue reading Busy times recently

Filtering results without losing the OUTER JOIN

This is a question I seem to answer for people quite often, so I thought I’d write a blog post about it. Suppose you’re joining between two tables (or more, but we’ll only consider two to keep things simple) in the AdventureWorks sample database on SQL Server 2005. SELECT *FROM Production.ProductSubcategory s  LEFT JOIN  Production.Product … Continue reading Filtering results without losing the OUTER JOIN

UNICEF Australia project at TechEd

It was unfortunate news when I heard that the UNICEF Australia site was hacked a little while ago. An old colleague of mine called me to let me know, and to ask if I knew anyone who could help them out. I used to work at a hosting company with this guy, and had seen … Continue reading UNICEF Australia project at TechEd