Monthly Archives: June 2010

PASS, Don’t Waste My Time

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

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

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

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

Posted in Blog | Tagged , | 1 Comment