January 2011 - Posts

Scary day for me last Thursday. I had gone up to Brisbane, and was due to speak at the Queensland SQL User Group on Thursday night . Unfortunately, disaster struck about an hour beforehand. Nothing to do with the recent floods (although we were meeting Read More...

I have a new appreciation for Tom LaRock ( @sqlrockstar ), who is doing a tremendous job leading the organising committee for the 24 Hours of PASS event (Twitter: #24hop ). We’ve just been going through the list of speakers and their preferences for time Read More...

In honour of the regular T-SQL Tuesday blogging, the UnSQL theme started, looking at topics that were not directly SQL related, but nevertheless quite interesting. This is the brainchild of Jen McCown, who posted the second of these recently. I’m actually Read More...

This month’s T-SQL Tuesday is hosted by Jen McCown, and she’s picked the topic of Resolutions . It’s a new year, and she’s thinking about what people have resolved to do this year. Unfortunately, I’ve never really done resolutions like that. I see too Read More...

One of the things about PivotViewer is that it runs in the Silverlight platform and can be extended recently. One of my guys at LobsterPot , Roger Noble , has used this to incorporate a Bing Maps layer , showing items which have Latitude and Longitude Read More...

SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer handles LIKE to keep it SARGable, the Execution Plans that result, Collations, and PowerShell to come up with the Swedish alphabet. SARGability Read More...