TechEd AU this week. I'm giving a talk on "T-SQL Tips n Techniques: Improving Your T-SQL Arsenal" on Friday morning. The slides are available from CommNet for people registered, but the scripts are here as well. Come along to the talk to see how I use the scripts, but do grab these if you want to be trying them out on your data while ...

A while back I was talking to Bronwen Zande, of Brisbane-based SoulSolutions and GeekGirlBlogs. Anyway, she and her partner John are big fans of Virtual Earth. As it's well publicised that SQL Server 2008 will have new spatial types, including fancy ways of integrating with Virtual Earth, I asked her if they were planning a tour of the ...

This weekend is getting better and better. With England winning in both the football and the rugby, my mood is pretty good anyway - despite having to give the first presentation of Sunday morning at the SQL Down Under Code Camp. The local TV channel sent cameras just after I finished, so I think I managed to avoid having my presentation on the ...

Two days of intensive SQL Server training, thanks to experts from around Australia and Kevin Kline from the US. All the Australian SQL Server MVPs are coming (five here so far, two more coming soon). The coffee is great (thanks Peter), the company is great, and there are so many more people here (than last year) because there is also a Security ...

...and I'm not even referring to the User Groups which run regularly. The ones I'm referring to are SQLBits and the SQL Down Under Code Camp. SQLBits was in the UK last weekend, and was a massive success. I would've loved to have been able to attend, but it's a bit far to travel (I guess about 12000 miles). They had over three ...

A few people have asked me what my favourite thing is in SQL Server 2008 ("Katmai"). But my favourite thing isn't actually a feature at all, it's a mindset that Microsoft are taking with it. This mindset is "We will only put features into the CTPs once they are basically complete - including the documentation." And ...

Mitch Wheat sent me this. According to http://www.microsoft.com/learning/mcp/certified.mspx, there are only 71 people in the world (well, at the end of June) who have achieved MCITP:BI. This means passing the two exams 70-445 and 70-446. You could be one if you use SSIS, SSAS, SSRS and do a bit of Data Mining. Doing some of the courses like the ...

We all know that Adelaide hosted Code Camp SA recently - it was a great success, and some people even wished I was there! TechEd is coming up of course, but now there are two code camps scheduled for October, on the same weekend (13-14) and at the same venue! Yes, that place is Wagga Wagga - one Wagga for each event. Firstly, and most ...

What a great week for Adelaide having Australian SQL MVPs presenting! Code Camp SA on the weekend of July 7th and 8th features the Gregs (Linwood and Low), and BI expert Darren Gosbell will be coming to speak to the Adelaide SQL Server User Group the following Thursday. He'll be presenting about MDX, which is a topic that a few people have ...

Jos Verbaken was a student of mine a few weeks ago. He lives in Ballarat, and is known around the Melbourne SQL Server User Group circles. He did the 5-day course 2780 - Maintaining a Microsoft SQL Server 2005 Database. During the course, I encouraged the students to sit the exam 70-431, which the exam I wrote simulation questions for, and the ...