Accelerated SQL Server 2008 – Walters, Coles, Ferracchiati, Rae & Farmer

Apress asked me to review this book, so here goes… I was a little disappointed, but on the whole thought it was pretty good. I also posted this review to Amazon, where I figure more people will read it. I saw this book come out, and had high expectations. The authors are all great guys who really know their stuff. What’s more, Donald Farmer is _the_ guy for Data Mining, so I was hoping for a big section about the improvements in that area for SQL 2008. Looking through it though, it feels like a book that was written for … Continue reading Accelerated SQL Server 2008 – Walters, Coles, Ferracchiati, Rae & Farmer

Improving Your T-SQL Arsenal – slides

I’ve given this presentation a couple of times at user-groups now – last week in Adelaide, and this week in Melbourne. I posted the scripts to my blog recently, making them available to people who heard this talk at TechEd Australia at the start of the month, so now I’ve got around to uploading the slide deck as well. I actually plan to blog about many of the tips too, so watch for that over the next month or so. I’ll try to do at least one a week for a while, if not more. Obviously some will become longer … Continue reading Improving Your T-SQL Arsenal – slides


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 I present. They all work on SQL Server 2005, and they use the AdventureWorks database. I’ll also try to do a series of blog posts about some of the tips, but as well as that, many … Continue reading DAT283