The Bit Bucket

Book: Inside Microsoft SQL Server 2005 Query Tuning and Optimization

I haven’t posted up any book reviews recently so it’s time to catch up a bit. For some reason, it had taken me ages to get to read Kalen’s latest book in the Inside SQL Server series: Inside Microsoft SQL Server 2005 - Query Tuning and Optimization.

As expected, it’s a great piece of work. I very much enjoyed the chapters written by other authors as well, particulary those from Adam Machanic and Craig Freedman. Ron Talmage, Sunil Agarwal and Lubor Kollar have also made strong contributions to this work.

2008-06-07

Book: Screw it, Let's do it - Lessons in Life

This is another one of those books I picked up in an airport when I ran out of reading material while travelling. One of the key criteria I applied when choosing the book was whether or not I’d finish reading it by the time we landed. We had a bit of a delay boarding so I’d definitely finished it by the time we’d landed. It’s in the “quick reads” series and it is just that.

2008-06-07

SQL Down Under Show 36 - Lubor Kollar

Hi Folks,

I’ve posted show 36 for SQL Down Under with guest SQL CAT team leader Lubor Kollar up at the site ( www.sqldownunder.com ). In the show, Lubor discusses the SQL CAT team and some SQL Server 2008 features such as the resource governor and compression.

Enjoy!

2008-06-07

Finally - a good VB to VB.NET converter

It was great to see an announcement from Francesco Ballena today that his VB to VB.net conversion tool has finally hit the market. It’s at www.vbmigration.com and looks like the sort of tool that was needed when VB.NET was first released. It sure would have avoided a lot of angst in the community. I was particularly impressed by the quote at http://www.vbmigration.com/Blog/default.aspx . I’d have to say I could definitely relate to the sentiment expressed in it. Congratulations Francesco!

2008-05-28

New Geek Toy and Upcoming SQL Down Under Podcasts

Hi Folks,

I was so pleased today to finally get my new geek “toy” installed. I bought a Rode Podcaster mike a while back but didn’t get a chance to install it till today. I love the balanced arm that lets me get it positioned so well while still able to type. And then I can just push it out of the way. It’s a broadcast quality mike and is in a shock mount. I’ve already noticed a major difference in the sound quality, including vastly reduced background noise. I’ve got a pop-filter for it which I might end up using too.

2008-05-19

Impact of Software as a Service on ISVs

I love seeing people start to undertake research work in computing areas. There aren’t nearly enough. Oscar Trimboli told me today that he’s undertaking predoctoral work at present and his topic is the “Impact of Software as a Service on Australian Independent Software Vendors”. Oscar is keen to recruit ISVs who are either traditional ISVs or SaaS (Software as a Service) ISVs (or a combination) that have their management and marketing decision making based in Australia. If that sounds like you, I’d encourage you to get in touch with Oscar (Oscar_trimboli @ hotmail.com) and answer his survey questions. Alternately, if you have strong opinions about this space, I’m sure he’d love to hear them.

2008-04-21

OT: Internet Connection Sharing on Vista - Problem Resolution - IPv6

I’ve been travelling a lot lately and one of the problems that always comes up is how to share a single Internet connection in a hotel room with my wife Mai who’s usually travelling with me. (She does remote SQL Server DBA work).

My colleague Fernando Guerrero suggested I try his USB-to-Ethernet adapter (a SiteCom one) and use Internet Connection Sharing. I installed the drivers for the SiteCom device (which is a good small size too) and configured ICS and it just worked. I thought this was excellent until Tuesday last week when the latest update for Vista came down from Microsoft.com. (I’m pretty sure that’s what did it). Along with rebooting my machine in the middle of the day (I’d so love to discuss that with the windows update author), my ICS no longer worked.

2008-04-13

Australia's First Groove MVP

It was great to see a friend (and former colleague) of mine, Aaron Saikovski being appointed as the first Groove MVP for Australia.

Congratulations Aaron!

2008-04-03

Global Reach Awards - Congratulations to All

Each year the Microsoft Regional Director program issues Global Reach Impact Awards. It was great to see seven from our company receiving awards:

Gold Awards - Fernando Guerrero, Richard Hundhausen, Greg Low, Mauro Sant’Anna

Silver Awards - John Alexander, Shervin Shakibi

Bronze Award - Ken Spencer

The Impact Award represents Microsoft’s respect for the work these Regional Directors do in evangelizing Microsoft technologies and products worldwide. That’s an oustanding result for our company. Congratulations also to all other Regional Directors receiving awards this year.

2008-04-02

SQL Server Interest Continues To Grow

If there’s any doubt that interest in all things SQL Server related just continues to grow, the latest download statistics from my SQL Down Under show show just how fast.

I’m really excited that last month was the first time we broke the 30,000 downloads per month barrier. Onwards and upwards!

2008-04-01