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 at least two of the key people in your field. If you had to, would you spend your own money to buy tools or other materials that would improve the quality of your work? If you did not do this for work, would you still … 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, one of the greats. More information can be found at http://research.microsoft.com/news/featurestories/publish/Gray.aspx

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 against these things? I think her suggestion about making sure that you close unexpected windows using the ‘x’ in the corner is a good one. And making sure that you have firewalls and virus checkers is an absolute must. Using the ‘hosts file’ protection against … 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 whole set (rather than just in the page). @@rowcount doesn’t do it for them, because this will return the number of rows in that page. Something like this: select * from   (select *, row_number() over (order by employeeid) as rn from dbo.Employees) ewhere rn … 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 high quality course. And of course, it’s not as if I’m new to the material myself, having been involved in helping people learn about T-SQL for many years myself. I’m really pleased that this is the first course I’ll be teaching under the banner of … Continue reading My first Solid Quality course is scheduled