It is very common to need to compare the values in two nullable columns, without changing the ansi nulls setting. For example, it is common to have to write:WHERE (a.SomeColumn IS NULL AND b.SomeColumn IS NULL) OR (a.SomeColumn = b.SomeColumn)Given how common this is (particularly for some forms of optimistic concurrency checks that aren’t based on rowversions), there should be a simple way to express the intent. I also presume the optimizer could also potentially take advantage of knowing the real intent of the statement. A new operator is needed, to enable syntax like: WHERE a.SomeColumn MATCHES b.SomeColumn It could … Continue reading SQL Server – Nullable column comparisons needed?
Everyone seems to love knocking Windows Vista. However, I regularly find things about the operating system that just impress me. Today I changed my hard drive to a new one, and yes it made me reactivate the system *but* I was trying to think of what sort of utility I’d need to extend my 100G drive out to use all the 200G of space. To my surprise, I right-clicked the partition and it offered “Extend Volume” and even though it was a simple volume, it happily just extended it out for me. That was a pleasant surprise.
Clearly, a lot of people have been following my QANTAS postings lately. This week, I’ve had many that have asked me how the flights went this week. The daytime flight from Sydney to Canberra on Wednesday was fine. The flight home from Canberra to Melbourne on Wednesday night was basically fine. I still don’t understand the “priority” baggage handling as my bag was the last one off the whole plane but at least the flight was on time, was fairly pleasant and my bag was at the other end. So, did I have a good set of flights for the … Continue reading QANTAS: Last week’s score – Electrical staff needed?
Another bright colleague at Readify, Daniel Bartholomew has just published an Ajax control extender to enable CardSpace authentication. Daniel has been working with CardSpace for quite a while now and this should be a worthwhile addition to the Ajax Control Toolkit. It enables you to easily add CardSpace authentication to your web site. Daniel has just posted it up to CodePlex. You can find it here: http://www.codeplex.com/CardSpaceAjax
Readify colleague Paul Stovell has been working on an extension to LINQ for a while. He’s finally announced it. Paul describes it as “SyncLINQ is a set of extensions to LINQ that enable data binding over LINQ queries. SyncLINQ alters LINQ queries so that they return INotifyCollectionChanged collections, meaning that when the sources are updated, the result of the LINQ query is also updated.”. It’s interesting work and Paul has provided a 7 minute video to show it in action as well.
My Readify colleague Philip Beadle has been taking a great lead amongst our staff in promoting Movember. He put together a team last year and I didn’t get to take part. I wish I had been around to do so. I’m not going to miss it this year. I’ve joined “Readify Mo Madness”. Movember highlights men’s health during November. Participants grow a Mo and it’s a bunch of fun but there’s a very serious message. It’s a personal message for me as about 10 years ago, I had a period of serious depression. The loss of my father was a … Continue reading Movember, Readify Mo Madness and Men’s Health
Hi Folks, SQL Down Under show 24 with guest Paul Randal is now available for download from www.sqldownunder.com. In this show, Paul discusses DBCC CHECKDB in SQL Server 2005 and improvements in SQL Server 2008 for database mirroring and partitioned tables. Enjoy!
Another one for those that follow my travel postings: In a recent post, and a prior post, I noted some of the issues I’ve been having with QANTAS flights recently. In the latest one, I mentioned I was heading off to Singapore for the week last week and wasn’t looking forward to the QANTAS flights. Well, the photo below pretty much sums up the experience for the week. Yes, that’s the engine of our plane opened up on the tarmac at Changi Airport late at night, after we should have been half way to Melbourne. The flight over left … Continue reading QANTAS: The fun (not) continues
Since he has left the SQL Server group at Microsoft and joined his wife Kim Tripp at SQL Skills, Paul Randal has been becoming even more prolific with his blog posts. If you really want to learn a lot about how things like DBCC CHECKDB, DBCC IND, DBCC PAGE and SQL Server indexing, etc. really work, make sure you are subscribed to his blog. The content lately has been outstanding. Paul’s blog is here: http://www.sqlskills.com/blogs/paul/
Timothy Ferris’ new book The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich contains some pretty solid (and again challenging) thinking for most of us. Tim describes the DLP (delayed life plan) that most of us aspire to as ill-conceived. Rather than spending your whole life working to save for a retirement, which many never see or are no longer capable of enjoying, Tim argues that you should look to take mini-retirements constantly. Leaving it all for a later day is not sensible. I’ve often heard descriptions of life that say that it’s not the destination that’s … Continue reading Book: The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich