SQL Server
Why I prefer surrogate keys instead of natural keys in database design Mladen Prajdic put together a great article about using surrogate keys in database design. The best part is that a lot of bright people sounded off in the comments.
Donald Farmer Discusses the Benefits of Managed Self-Service BI I spoke with Donald Farmer [...]
SQL Server
Missing Index Information and Query Stats Grant Fritchey put together a nice little query to pull XML query plans out of the DMVs. Thankfully, these plans can also tell use which indexes are missing
Scalar Functions vs. Table Valued Functions vs. Inline Code Aaron Alton does some testing on these three to determine which is [...]
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 that IE6 looks great as [...]
