Tag Archives: sql server

Preparation for Disaster Talk

Posted on June 6, 2011 by way0utwest

This talk looks at the reasons and ways that you might prepare for disaster. I cover a number of areas, some of which might seem obvious, but are often overlooked: What is a disaster? Why Prepare for Disaster? RTO/RPO Overview … Continue reading →

Posted in Presentations | Tagged , , | 1 Comment

The Ad Hoc Change

Posted on May 31, 2011 by way0utwest

How many times have you been asked to change data in a production system? If your career has been like mine, it’s probably too many times to count. It seems that there are always data issues in production, and the … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Ad Hoc Change

No Shrink-y Tempdb

Posted on May 26, 2011 by way0utwest

I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues. I’ve never thought about … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Collation Conflicts in a SQL Server Join

Posted on May 23, 2011 by way0utwest

I went to run this query recently: select TOP 10 * from users a inner join Banned b on a.username = b.username and got this lovely message. I’d seen that message before, so I knew what was wrong. The collations … Continue reading →

Posted in Blog | Tagged , , | 1 Comment