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:
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
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
