-
Recent Posts
Recent Comments
- Jon Lewis on A Busy/Accidental DBA’s Guide to Managing VLFs
- Arnold Lieberman on A Busy/Accidental DBA’s Guide to Managing VLFs
- Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT” – ReplTalk on Stored Procedure to Sequentially Run SQL Agent Jobs
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
Archives
Categories
Meta
Monthly Archives: February 2010
Community Based Training
There is a real un-served niche in the market for DBA delivered community training materials. The idea would be to work together as a community to create common course materials and delivery scripts that would be presented by individual DBAs to the teams they support. Everyone would get roughly the same experience while having a trainer that can speak directly to their specific questions or even look at examples using their specific data. Continue reading
Why Do My SQL 2008 Compressed Backups Shrink?
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew. It turns out this behavior is intentional and beneficial. Continue reading
Why Do I Need All These Servers?
Working in a large corporate environment I am frequently getting requests for a new server to do this or that. Running through the usual questions to determine scope and scale, the price can get high pretty quickly. Inevitably, talk turns to ideas on how to cut the cost while still delivering a robust platform. Continue reading
Posted in General
Tagged Development, Disaster Recovery, DR, HA, High Availability, Production, QA, Release Management, SSC, Staging, Testing
2 Comments