Archives: April 2011
If you've been considering registering for the first ever SQLRally May 11-13 in Orlando it's coming down to crunch time. We're less than two weeks away and there are only 3 days left to sign up for the 2 day portion of the conference at $349 - starting May 1… Read more
Just a quick mention that I'm presenting Paging DR Availability, You're Wanted in the Recovery Room twice this week - today, April 27, at noon Eastern for the PASS DBA Virtual Chapter and Saturday, April 30, at SQLSaturday #74 in Jacksonville.
There's just a few more weeks to go until the inaugural PASS SQLRally (May 11-13) in Orlando and there are still seats available for the Pre-conference seminars. Attendance is capped at 100 people per room and we're just a few seats shy of selling out both the BI and DBA… Read more
I've been working a lot with the datetimeoffset data type recently so today's SQLServerCentral.com article The SQL Server 2008 Datetimeoffset Data Type caught my attention. It's a good read if you're unfamiliar with datetimeoffset, as is The Death of DateTime? from Bart Duncan's blog.
Both articles fall short of… Read more
Here's a tip for bloggers (or anyone else) who use third party tools to convert T-SQL code into a publishing friendly format…
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script to take filtered indexes into consideration in SQL 2008 and am sharing both the 2005 and 2008 versions. Also, a friendly reminder that the scripts run within the scope of… Read more
Replication: It's Not Really As Bad As SQLRockStar Says It Is
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and are wishing for something different - something less political, less structured, maybe a bit more people-focused, edgy, and fun. I've thought about how to channel that unhappiness in a way… Read more