SQL community events in Adelaide this week

Two events coming up in the next few days in Adelaide. On Monday 22nd, we see the start of the Australian Azure Launch, with David Lemphers coming over. David has a tour, hitting five Australian cities in four days, starting in Adelaide. It should be a good event, with the SharePoint, .Net and SQL Server … Continue reading SQL community events in Adelaide this week

Why move a blog?

A few people have asked why I moved to sqlblog.com (I’ve shifted my blog from msmvps.com recently). After all, I had used msmvps.com since 2006 and written a lot of stuff there (over 400 posts). Whilst I doubt that those posts will be lost, there’s a degree to which you only have as much content … Continue reading Why move a blog?

A moving time…

For those of you who read my blog using RSS, you probably won’t even see this post, but either way. I’ve decided to move my blog to sqlblog.com. I have reposted some of my recent posts, but will not be posting any further content here at msmvps.com. Both the feed from msmvps.com and sqlblog.com use … Continue reading A moving time…

Book Review – oldie but a goodie – Inside SQL 2005 Query Tuning and Optimization

I’ve moved my blog here (to sqlblog.com), and thought I’d start with a book review. This is a post that I’ve been meaning to write for some time, and it seems a worthy first post for this new site. I might go through some of my older posts from my blog at msmvps.com, and maybe … Continue reading Book Review – oldie but a goodie – Inside SQL 2005 Query Tuning and Optimization

T-SQL Tuesday #003 (Relationships): The round-up

Lots of blog posts for this month, for the first T-SQL Tuesday to leave the safe-haven of Adam Machanic’s blog. Some people obviously missed out, probably because they don’t read this blog, but I guess that’s the nature of the meme. I don’t know who is hosting next month yet, but I’ll be looking out … Continue reading T-SQL Tuesday #003 (Relationships): The round-up

The Query Optimizer’s handling of Relationships for T-SQL Tuesday #003

I’m feeling the pressure for this month’s T-SQL Tuesday, probably because I’m also the host. I’ll be posting a roll-up for it soon too, which I’m sure will be great fun researching. Given that the topic is on relationships, and the main SQL Server database is a relational engine, relationships are incredibly relevant to databases. … Continue reading The Query Optimizer’s handling of Relationships for T-SQL Tuesday #003

Invitation for T-SQL Tuesday #003: Relationships

It’s time for the third of Adam Machanic’s T-SQL Tuesdays, and this time, I’m the host. The first one, last December was on the topic of date/time, and the second was on Puzzling Situations. Check them both out, along with the round-ups that Adam wrote about them. Lots of great topics, which is starting to … Continue reading Invitation for T-SQL Tuesday #003: Relationships

A CASE study in SARGability

A recent discussion on Twitter about a query that Denny Cherry was looking at led to this post by Josef Richberg: http://josef-richberg.squarespace.com/journal/2010/1/28/is-a-case-statement-considered-sargable.html, and I thought it might be worth going through a few points on the topic of SARGability. Particularly given that I wrote a related post recently myself. If something is SARGable, it means … Continue reading A CASE study in SARGability