SQL Server 2008 Systems Views Poster

Another project that Ron Talmage and several other of my colleagues have been working on is a new system views poster for SQL Server 2008. I'm told that it's going to go out with the December issue of SQL Server Magazine.

I got a copy of this at the PASS summit and it's excellent. In fact, stocks ran out before the conference even really got started.

Congratulations to all involved.

SQL Server 2008 Upgrade Technical Reference

I've been working on the SQL Server 2008 Upgrade Technical Reference with a number of my colleagues (Ron Talmage, Aaron Johal, Steven Abraham, Allan Hirt, Herbert Albert, Antonio Soto, Joe Webb, Craig Utley, Dejan Sarka, Larry Barnes, Pablo Ahumada, Kathy Blomstrom) and a bunch of great folk from Microsoft (Arvind Rao, George Huey, Richard Waymire, Siva Harinath, Edward Melomed, Deepika Mistry, Fernando Caro, Goldie Chaudhuri, Max Verun, Vijay Tandra Sistla, Tom Michaels, Justin Erickson, Devendra Tiwari, Jingwei Lu, Fernando Azpeitia Lopez, Ketan Duvedi, Lukasz Pawlowski, David Noor, Matt Masson, Karandeep Anand, Jen Witsoe, Suzanne Bonney, Megan Bradley, Tresy Kilbourne, Bronwyn McNutt).

I am really pleased to see that it has become available and that you can get all 486 pages of goodness here: http://www.microsoft.com/downloads/details.aspx?familyid=66D3E6F5-6902-4FDD-AF75-9975AEA5BEA7&displaylang=en




Outstanding new book: T-SQL Fundamentals (Itzik Ben-Gan)

I'm so glad to see that my colleague Itzik Ben-Gan has his T-SQL Fundamentals book now available. This book has been needed for some time. It's been updated for SQL Server 2008 and I'm sure it'll fast become one of the standard SQL Server 2008 references.

Details are here: http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=sr_1_1?ie=UTF8&s=books&qid=1225597357&sr=8-1

The companion web site for the book is here: http://www.insidetsql.com/tsqlfund2008/



PASS Community Connection – New Zealand

I'm really pleased to see that Nathan Pitcher and the gang in New Zealand have organised a PASS Community Connection event. It will run in Porirua (same place as their last SQL Code Camp) on December 6th / 7th. I'll be there to deliver a few sessions and the keynote along with Adam Cogan. Peter Ward, Chris Auld, Daryl Burling, Dave Dustin, Duncan Murch, Myles Matheson and Bruce Cassidy are also all doing sessions. It should be a great weekend.

For more information, hit: http://www.dot.net.nz/Default.aspx?tabid=120

Great news on Datadude licensing

When I've been doing sessions around the world on DataDude (Visual Studio Team Edition for Database Professionals), the main feedback I've had is "great product but pity we'll never get to use it because of the licensing".

Sanity has finally prevailed. In today's PressPass announcement, while there's interesting news on product naming (Visual Studio 2010 and .NET Framework 4.0), there's great news that the developer and database professional editions will merge and in the meantime, people licensing the developer edition will now get DataDude as well. (and vice versa). This is a big step forward for the product.

SQL Server 2008 eBook from MSPress (and free)

Hi Folks,


I recently wrote a chapter in the new eBook "Introducing SQL Server 2008" at MSPress. Peter DeBetta was the main author and Mark Whitehorn also wrote. It’s now available: http://csna01.libredigital.com/?urss1q2we6




And it’s free !




(PS: I've had a few people ask how you read it. It downloads with a cfm file extension for some bizarre reason. It is a pdf. Just rename it to be one and you should be fine). 


TechEd Australia and New Zealand done and dusted

Well, TechEd in Australia and New Zealand have come and gone again already this year. Congrats to the content owners Andrew Coates and Darryl Burling for their efforts again this year and for organising good shows.

I had a really busy week as I was teaching a SQL 2k8 for developers precon on Monday and Tuesday, then had to travel to New Zealand on Tuesday night, just for the day. I got into the hotel about 1am, woke up and did my session at 10:45, another one at 2:20pm and then raced out of the venue into a cab and back to the airport to go back to Sydney. I did my session at TechEd Australia on Thursday.

The tight schedule meant that I didn't get as much time as normal to catch up with people at either event this year. I think the outcome was ok though. I was very excited to make Darryl's Kings of TechEd list, (particularly given my lack of sleep) but I'm always mindful of just how good the people further up that list are. It was great to see Scott Hanselman come down under to present this year and on anyone's measure, Steve Riley is always the King of TechEd locally.

I do want to make a particular shout out to Andrew Coates for organising the "Internal TechEd" this year where we got to do some dry runs of our presentations, in conjunction with Steve Herzberg from NRG Solutions. I have no doubt at all that the session I did at TechEd Australia was better for their efforts. I've commented before that I'm always amazed when speakers are offered such sessions and don't take advantage of them.

Next similar events I have coming up are TechEd Hong Kong and TechEd Developers in Barcelona. If you are at one of these events, please come and say hello.


2 Sessions at the PASS Summit: Hope to see you there

Hi Folks,

The summit program committee have confirmed I'll be doing two sessions at the PASS Summit in Seattle in November. I've got upgraded versions of both "Avoiding Stored Proc Recompiles" and "A SQL Server DBA's Guide To CLR Integration" to cover SQL 2k8 changes. The first session also has a little more time allocated as a spotlight session.

I'm really looking forward to the summit this year and hope to see you all there. Summit details are here: http://summit2008.sqlpass.org/