Sql-Server

In the last rotation of the Microsoft Certified Masters for SQL Server 2008, I had the pleasure of having Jimmy May in the class. One topic we covered was on disk partition alignment and as I knew Jimmy had been working on the whitepaper, I got him to talk to the class on that topic.

The whitepaper is finally out and I note that another SQL friend Denny Lee is the co-author. You can download it here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5b343389-f7c9-43d0-9892-ddcf55890529

2009-07-05

I’ve had a number of people tell me over the years that they aren’t surprised when I say “Recommended” at the end of any book review I write, as I never seem to say “Not Recommended”. I suppose that comes under the heading of “if you can’t say anything good about something, don’t say anything”. So, I’m going to temporarily change tack with this book.

For a long time, I’ve wished there were more books tackling the thorny topic of refactoring databases. Most people would consider Scott Ambler’s book to be a seminal work in this area but while I loved the fact that he wrote on the topic, I found the methods he used to be way too generic for SQL Server developers and DBAs. For example, where persisted calculated columns could be used, Scott would use triggers. I’d been eagerly awaiting any other books in this area.

2009-07-03

If you’re working with SQL Server, chances are pretty high that you already realise that your future involves SharePoint as well. 

Fellow Australian MVP Ishai Sagai recently sent me a copy of his new book SharePoint 2007 How-To.

I have to say I really enjoyed it. It does exactly what the title suggests. I haven’t read any other books in the “How-To” series before but I liked the format. Ishai spends a little time with SharePoint basics and then presents a series of chapters on the main aspects of the product. In each chapter, he presents a series of things you commonly might need to do when working with the product and shows you how to accomplish each, step by step. This makes it a very practical book for those who don’t spend their entire working hours with SharePoint. As a bonus, the writing style is easy to follow.

2009-07-03

One of the smaller events I try to get to each year is the Code Camp that happens in Adelaide (Code Camp SA). It might be smaller but I always enjoy it and I’m sure that Peter Griffiths and David Gardiner will be putting on a good show again this year.

I’d love to see as many of you there as possible. It’s July 18th and 19th in Adelaide. Details are at the site.

2009-07-01

I’m really looking forward to the upcoming PASS summit in Seattle. I know it’s a tough year for funds and training, etc. but (particularly for those that travel from a distance), this is likely to be the year offering the lowest cost travel options for a very, very long time. It’s a tough year in the airline business too.

One of my colleagues Pinal Dave has just described why he thinks you should attend.

2009-06-19

Speech recognition technology has intrigued me for years but never seemed to live up to its promise. It always seemed to me to have more potential where a very limited grammar was involved, rather than attempting complex work like writing freeform prose. For example, the number of commands you can give to a television set is quite limited and much more likely to be successful.

Writing code in programming languages also seems to fit this quite well as it has a constrained grammar. I’ve often wondered what on earth I’d do if I couldn’t type for some reason and figured that speech recognition might provide the answer (while hoping not to be in that situation in the first place).

2009-06-09

While we were at TechEd in LA, Mai and I got to catch up with an old friend:

2009-06-08

I had a query from an attendee of my full-text indexing session at TechEd US. He asked how he can find out which documents (or how many) still need to be processed. I did a little investigation on this and here’s my best guess:

<WARNING: Undocumented and potentially just a guess!>

1. Query for the objectid of your full-text index. You can do this by:

select * from sys.fulltext_indexes

2. Open an admin connection to your system ie: connect to admin:SERVER instead of SERVER.

2009-06-03

One of the members of our Asian regional development team for PASS is Jacob Sebastian. A week or so back he told me he’d written an eBook for the Red-Gate folk on XML Schemas in SQL Server. I downloaded it expecting it to be fifty to a hundred pages. It was 483 pages. What can I say: Jacob is a writing machine. You can download it from Jacob’s blog.

2009-05-26

The title pretty much says it all. The May 2009 version of SQL Server Books Online is now available for download from:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97

2009-05-24