Tag Archives: administration

Regression Testing before CUs and Service Packs

Posted on January 15, 2013 by way0utwest

Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Regression Testing before CUs and Service Packs

A Patch Disaster

Posted on January 10, 2013 by way0utwest

Can you imagine sending the wrong patch to the wrong machines? That’s what happened with an Australian bank. Am OS patch was sent to many more machines than it should have. The patch was designed for desktops, but managed to get … Continue reading →

Posted in Editorial | Tagged , | Comments Off on A Patch Disaster

sp_Blitz, v16, on SQLServerCentral

Posted on January 10, 2013 by way0utwest

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and give you a quick, comprehensive report of the state of the instnace. It’s a great script, and if you have … Continue reading →

Posted in Blog | Tagged , , | Comments Off on sp_Blitz, v16, on SQLServerCentral

The Default Fillfactor for an Index

Posted on January 7, 2013 by way0utwest

I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL Sentry blog on trimming the transaction log, then went to his video on log analysis. I also glanced at the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Default Fillfactor for an Index