The blog has been quiet over the Winter, so where have I been lately? Simply put: On the road with the SQL Server community! I’ve been doing a lot in the community lately, as well as having our busiest Winter ever with SQLWatchmen. So instead of making a bunch of blog posts about what I’ve […]
Is a DBA just a button clicker? Can a good DBA be replaced by anyone who knows the same technical skills? ‘Supporting the business’ can be a lot more involved. What Does a DBA (Database Administrator) Do Anyway? Some people think a DBA simply Tweets, Facebooks, YouTubes and occasionally checks SQL Server logs. Others think […]
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 […]
Wes Brown and I just had a very nice meeting with the folks at Experis about them sponsoring the CACTUSS User Group by offering a place to meet for the newly formed Central meeting, which I have the privilege to lead. I really like their style. Very nice people and very eager to help the […]
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 […]
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 […]