Whitepaper : How To Deal With an Inherited SQL Server

Whether you are a newly minted database administrator or a highly experienced one, the first week at a new job can stretch your patience to breaking as you try to get answers to a wide range of questions about how things work and why things are done (or not done) a certain way. It is perhaps the most dangerous week you’ll have as a database administrator, because you do not know exactly what you do not know. This whitepaper is meant to be a roadmap for that first week to help you make sure you are asking the right questions and prioritizing your efforts in a way to minimize risk. It is also to help you set expectations for yourself and those you work with. The whitepaper describes nine tasks including taking notes, setting up a workstation, getting access, finding documentation, identifying instances, checking on free space and file growth, learning the change management process and maintenance windows, and checking on service packs. The tasks outlined in the whitepaper are based on the experiences of the author during the first weeks as a database administrator new to an organization. The tasks form the basis for his own best practices during his first weeks. Follow these guidelines for a great start. They may well help identify follow up tasks that will take weeks to complete. Remember to prioritize the efforts so that one does the things that matter most first.

Author: Andy Warren

Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding member of SQLServerCentral.com, President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been a Microsoft Most Valuable Professional (MVP) since 2009 and has written and presented extensively on topics relevant to SQL Server professionals.

Register to read the full whitepaper.



Topics : Database Administration,Database Diagnostics,Database Monitoring,Database Performance,

Products : SQL Inventory Manager,

Register for Free Whitepaper

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.