Author Archives: Jim Murphy

Denali AlwaysOn – Finally, A usable ‘mirror’!

I’ll be presenting at this months SQL Server User Group (UG) meeting of CACTUSS Central (www.cactuss.org) this upcoming Monday 9/19/2011. The location of the presentation is here. The abstract is below. Abstract In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not […]

POSSE Formed

We just had our formation board meeting for POSSE (sqlposse.com). Wes, Richard and Mike K. met in person since they arrived early to the monthly user group meeting, while I was conferenced in via phone. We did set the initial executive committee in this first meeting: President – Wes Brown Secretary – Richard Heim Treasurer […]

DBCC loginfo, VLFs and SQL2000 and earlier.

I was reading Paul Randal and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL […]