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
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?
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…
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
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
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
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 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