http://facility9.com ruminations on sql, ruby, c# and other things Mon, 28 Jul 2008 20:05:33 +0000 http://backend.userland.com/rss092 en For my current project, we're making use of a large number of jQuery AJAX callbacks, as well as cookies, to deliver some rich functionality to the users of a web site. Unfortunately this created a little bit of an issue when trying get this to work in IE7. Here's what ... http://facility9.com/2008/07/28/missing-cookies-in-jquery-ajax-callbacks/ I spent most of yesterday and most of this morning battling with a IE7 display bug. Back story: we are using jQuery's superfish drop down menus (a jQuery based implement of suckerfish/son of suckerfish) for site navigation. Everything works great in Firefox 2/3 and Safari. I'm going to assume ... http://facility9.com/2008/07/17/ie7-dropdowns-and-z-index/ Team Foundation Server, apparently. Let's say that some careless developer (me) forgot to close an XML tag. The aforementioned developer then checked in his build file and attempted to build it. At this point, I got a bit worried because TFS came back with the following error: TF42046: ... http://facility9.com/2008/07/15/who-needs-valid-xml/ Eric Johnson has put up a fantastic post detailing the new SQL Server 2008 Installation Wizard or, as it is officially named, SQL Server Installation Center. Rather than summarize, I've just provided a link. It's short, sweet, to the point, and full of screen shots. http://facility9.com/2008/07/11/sql-server-2008-installation-features/ Rick, I'm stealing your post. Which is okay because you stole it first. How old were you when you started programming? I originally started learning BASIC when I was very young, probably 11 or so. I gave up on programming for more worldly pursuits, only to come back to ... http://facility9.com/2008/07/05/software-development-meme/ Many OR/Ms use an UpdatedAt column and some even use a DeletedAt column for soft deletes. This practice also carries over when using date ranges for controlling notification display (StartDate and EndDate). I've often heard many DBAs make the claim that doing a date comparison is faster than ... http://facility9.com/2008/07/05/evaluating-is-null-vs-with-t-sql-datetimes/ I wrote this today in response to Patrik Löwendahl's post: A default architecture – without stored Procedures . I figured that I might as well post it up here, too, so that people can comment on my rantings. You'd be hard pressed to get me to concede that a data ... http://facility9.com/2008/07/03/in-re-a-default-architecture-%e2%80%93-without-stored-procedures/ In my attempts to customize Visual Studio 2008, after 6 months of Rails development in e, I came across a couple of links. John Lam on Vibrant Ink and Dark Visual Studio almost forgot Scott Hanselman's slightly more manual instructions Now, either one of these will attempt to set your layout to the author's favorite settings ... http://facility9.com/2008/07/03/dark-visual-studio/ Dear PostgreSQL, Your documentation is awesome. You are awesome. Thanks, me But, seriously, PostgreSQL has the best documentation of any FOSS database I've used (I'm looking at you MySQL). Combined with its ability to handle just about anything I throw at it in a timely manner, PostgreSQL is impressing me ... http://facility9.com/2008/02/20/dear-postgresql/ Once upon a time, back in the 60s, some MIT nerds took it upon themselves to "waste" valuable research computer time to compute the ideal route to ride the entire New York subway system. This is a pretty interesting look at how to coordinate a project to achieve a ... http://facility9.com/2008/01/29/behold-the-power-of-science/