Topics for coffee meetings

Nick Randolph made an interesting point. But first let me say that it’s great that the Perth .Net group are doing this at all. It’s a great move to develop a stronger community, and one that I would love to see happen in Adelaide some time. My problem with organising something like this is that … Continue reading Topics for coffee meetings

Paul Turner

Paul Turner is an Adelaide guy I know well. He’s been a trainer at Kaz for quite a while, is on the local ACS executive committee with me and has been involved in the local .Net user-group too. He’s had a couple of major lifestyle changes in the last couple of weeks. Most significantly, he’s … Continue reading Paul Turner

Scripting database objects a different way

Sometimes you want to make changes to your SQL Server objects (like tables, indexes, whatever), and you figure that it will be worth recreating them with a different set of options. One way of doing this is to generate a script, and then use a text manipulator to change the script in a way that … Continue reading Scripting database objects a different way

Coffee and Community

It’s amazing how coffee can be conducive to community. Community is about sharing, it’s about developing passion and enthusiasm, it’s about friendship. And coffee is too. The age-old invite – “Let’s do coffee” – is a great way to sit down with someone. It’s cheaper and less formal than lunch, and it doesn’t stop you … Continue reading Coffee and Community

Get SQL2005 SP2 today!

Here’s the link: http://www.microsoft.com/sql/sp2.mspx There are so many cool things about SP2. It’s not just about bug-fixes, there are new add-ins for Office and SharePoint, and a few Feature Pack of goodies! Definitely worth checking out. 

4 questions to evaluate people’s passion

I’m going to find this topic very interesting when I’m training people more and more. Kathy Sierra gives us four questions to judge someone’s passion for their work: When was the last time you read a trade/professional journal or book related to your work? (can substitute “attended an industry conference or took a course”) Name … Continue reading 4 questions to evaluate people’s passion

Jim Gray search abandoned

Many of us have been searching though images for Jim Gray since he went missing three weeks ago. But now his family and friends have suspended the search. It’s very sad, and I’m sure we will all maintain a bit of hope that he’s still alive somehow. He was a legend in the database world, … Continue reading Jim Gray search abandoned

Malware distributed by MSN Messenger banner ads

I’m sure this won’t be the case for long, Microsoft tend to be good about addressing things like this. Fellow MVP Sandi Hardmeier has put out a very detailed post about the problem, I suggest you read about it there. It does raise some interesting questions. Not least, how are we supposed to protect ourselves … Continue reading Malware distributed by MSN Messenger banner ads

Querying the total number of records, but only returning a page of them

A lot of people seem to have been asking about this recently. They have a T-SQL query which uses a call to row_number() within a CTE or derived table, and uses this row_number() field to filter the results to a single page – but they also want to know how many rows were in the … Continue reading Querying the total number of records, but only returning a page of them

My first Solid Quality course is scheduled

If you’re in Melbourne during the last week of March and want to learn about how to effectively write queries for SQL Server, then this course is for you. The course was written by Itzik Ben-Gan, who is one of the legends in the SQL Server world (and now my colleague!), so it’s a very … Continue reading My first Solid Quality course is scheduled