Monthly Archives: June 2010

PASS, Don’t Waste My Time

Posted on June 30, 2010 by

Update: Apparently I can’t write, or get a point across from the comments and a few emails, so I have edited this to hopefully make it clearer. The pre/post conference sessions came out today for the 2010 SQL PASS Summit. … Continue reading →

Posted in Blog | Tagged , | 16 Comments

Truncating the Log and Database Mirroring

Posted on June 30, 2010 by

I saw someone post recently that they wanted to run this code on their principal server in database mirroring to clean out a large transaction log and shrink it. alter database <mydb> set recovery simplegocheckpointgoalter database <mydb> set recovery fullgobackup … Continue reading →

Posted in Blog | Tagged , ,

‘Tis the Season for SQL Leaving

Posted on June 29, 2010 by

With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter) taking a new job far from the Novice Chef, Kathi Kellenberger getting a new job, and more, … Continue reading →

Posted in Blog | Tagged ,

ASK SQLServerCentral – The New Community Model

Posted on June 29, 2010 by

We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange (SE) to an alternative, OSQA.net, without informing any of the people that work on the site. Needless to say this … Continue reading →

Posted in Blog | Tagged , | 1 Comment