The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Removing the Risk from Important Maintenance Tasks

Wed, Apr 27 2016 16:00 UTC

Removing the Risk from Important Maintenance Tasks

As database professionals, we are often in very close proximity to important processes, data, and applications. While we adopt the mantra of “Do no harm”, many maintenance or reporting tasks that we create carry unseen risks associated with them. What happens when a drive fills up during daily differential backups? What if an index rebuild job runs abnormally long and interferes with morning processing. How about if a data load process causes extensive resource contention, bringing normal operations to their knees? There are many simple ways to safeguard our processes against situations that could easily bring down production systems. This is a chance to greatly improve our standard maintenance and avoid unnecessary wake-up-calls at 2am on a Sunday!


Ed Pollack

Ed is a DBA at CommerceHub, with a focus on performance optimization, both in production and development environments. He has over 15 years of experience in IT, both as a DBA and in systems administration. His passion is simplifying, automating, saving time, and making anything and everything run faster and more efficiently. Sharing this experience with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids