Presentations about SARGability tomorrow

Tomorrow, via LiveMeeting, I’m giving two presentations about SARGability. That’s April 27th, for anyone reading this later. The first will be at the Adelaide SQL Server User Group. If you’re in Adelaide, you should definitely come along. Both meetings are being broadcast to the PASS AppDev Virtual Chapter. The second will be in the Adelaide … Continue reading Presentations about SARGability tomorrow

SQLBits VI – The sixth sets

My involvement stopped with the tagline, but SQLBits VI is on tomorrow. The theme of the event is Performance Tuning, which has nothing to do with Bruce Willis or dead people – unless Bruce Willis has just become a database expert and been shot for doing a dropping an index (some would say that’s a … Continue reading SQLBits VI – The sixth sets

Handling special characters with FOR XML PATH(”)

Because I hate seeing > or & in my results… Since SQL Server 2005, we’ve been able to use FOR XML PATH(”) to do string concatenation. I’ve blogged about it before several times. But I don’t think I’ve blogged about the fact that it all goes a bit wrong if you have special characters in … Continue reading Handling special characters with FOR XML PATH(”)

Exploding maps in Reporting Services 2008 R2 – T-SQL Tuesday #005

Kaboom! Well, that was the imagery that secretly appeared in my mind when I saw “USA By State Exploded” in the list of installed maps in Report Builder 3.0 – part of the spatial offering of SQL Server Reporting Server 2008 R2. Alas, it just means that the borders are bigger. Clicking on it showed … Continue reading Exploding maps in Reporting Services 2008 R2 – T-SQL Tuesday #005

My new laptop – with a really nice battery option

It was about time I got a new laptop, and so I made a phone-call to Dell to discuss my options. I decided not to get an SSD from them, because I’d rather choose one myself – the sales guy tells me that changing the HD doesn’t void my warranty, so that’s good (incidentally, I’d … Continue reading My new laptop – with a really nice battery option