July 2008 Blog Posts
I can't stress this enough:
Never ever call me on my work phone as a form of the first contact!
Unless I know you and have given you permission to call me, don't. Send me an email instead.
I don't have anything against recruiters, I think their jobs are very important in the greater scheme of things.
I also never give my work phone number away, and if I have to I give my mobile phone number to people.
So it's beyond me how do recruiters think it's actually OK to call me at work. It shows disrespect to me and to the company...
In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error. The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and it doesn't work for non stored procedure code. And that IS a pretty BIG con! As is customary in this blog there is a solution to this. :) SQL Server 2005 Event notifications Event notifications are a special kind of database object that send information...
Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching. What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when selecting only columns covered by a nonclustered index. I've been able to reproduce the error on different collations and servers. They were all SQL Server 2005 SP2+. SQL Server 2000 isn't affected by this. You can find the connect issue posted by my coworker here. Craig Freedman pointed me to this connect issue that is...