Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.

I skipped last week because of some mysterious reason. Here is what I found interesting this past week in SQL Land:

The death of datetime?

Bart Duncan explains why you should almost always use DateTimeOffset instead of Datetime

Who is Active? v8.40 – Now With Delta Power!

Adam Machanic has updated his Who is Active with a huge number of changes, fixes, and enhancements

SQL Server DBA Interview: Kendal Van Dyke

Brent Ozar interviews Kendal Van Dyke about SQL, RAID, Blogging etc

SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters

SQLDumper utility is used by various components of the product to generate and save diagnostic information in the form of mini-dump and other log files. You will normally find the output files [with extension .mdmp, .txt and .log] created by sqldumper.exe in the LOG folder of the specific instance for the Database Engine.

If you have SQL Server 2008 failover cluster installations you might be having a problem that prevents these important files from getting created

SQL Server Technical Rollup – Lots of Useful Documents, News, Events and New KB articles

Tony Rogerson has compiled a nice list of useful documents, news, events and new KB articles

That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future

*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum