Links for the Week of 2009.10.16

SQL Server

Less Than Dot – Blog – How to Monitor Database Mirroring – Monitoring database mirroring is more than just running scripts to email you ever X minutes. Paul Theriault shows how to monitor mirroring (and other aspects of performance) using alerts. How to get the whole group of duplicate rows – CTEs are great for more than just replacing views. Mladen Prajdic shows how they can be used to find duplicate data quickly and efficiently. Bad habits to kick: making assumptions about IDENTITY – A great discussion from Aaron Bertrand about how IDENTITY actually works as well as solutions to make it work the way people want it to work. Introduction to SQL Server 2008 Extended Events

Stuff & Things

A Softer World: 490 – I don’t know what it is, but I like it. SCOUTING NY – » New York, You’ve Changed: Taxi Driver – Part III – It’s interesting to note how the world changes over time and how tiny pockets of it still stay the same. This is a look at the NYC of Taxi Driver then and now. 2001: A Space Odyssey Program – During the original theatrical premier of 2001: A Space Odyssey a program was handed out. This is a beautiful example of design that conveys the mood of the film and serves to prepare the audience as well as amplify their experience. Flickr Photo Download: 50 Years of Space Exploration In pictures: Graffiti artists transform Scottish ghost town Polphaill – The Scotsman – Transforming the rural crapscape into a work of art. The Pomodoro Technique – an interesting approach to solving problems and managing your time effectively. The Gentlemen’s Guide to Dressing – Some people are born with an innate sense of style. The rest of us all need to a little bit of help. @font-face and performance – There are some new techniques coming out for better font rendering on the web. Steve Souders goes over some of the pitfalls of these techniques to users can be aware of the downside while they’re making their choice.