Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2011

3 Days Remaining Before The Next SQLRally Price Increase

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

0 comments, 700 reads

Posted in Kendal Van Dyke on 28 April 2011

Presenting On DR & HA Twice This Week

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.

Register for the DBA Virtual Chapter presentation here,… Read more

1 comments, 175 reads

Posted in Kendal Van Dyke on 27 April 2011

Meet The SQLRally Precon Presenters

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

0 comments, 219 reads

Posted in Kendal Van Dyke on 18 April 2011

Datetimeoffset And Time Zone Awareness

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

0 comments, 2,335 reads

Posted in Kendal Van Dyke on 18 April 2011

Posting Code? Trust, But Verify

Here's a tip for bloggers (or anyone else) who use third party tools to convert T-SQL code into a publishing  friendly format…

Yesterday I posted scripts to identify overlapping statistics and I used a tool to convert the T-SQL into something that retained the formatting you'd see in Management Studio.… Read more

1 comments, 202 reads

Posted in Kendal Van Dyke on 6 April 2011

Updated Overlapping Statistics Scripts

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

6 comments, 709 reads

Posted in Kendal Van Dyke on 5 April 2011

Meme Monday

Replication: It's Not Really As Bad As SQLRockStar Says It Is

(Wondering what the heck this is supposed to be about? Check out Meme Monday, Thomas LaRock's (Blog | Twitter) challenge to the SQL blogosphere to find out!)

Read more

3 comments, 159 reads

Posted in Kendal Van Dyke on 4 April 2011

Announcing The Association For SQL Server

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

2 comments, 161 reads

Posted in Kendal Van Dyke on 1 April 2011