Whether you are considering a new career as a DBA or have been reluctantly thrust into the DBA role within your organization, becoming a successful DBA requires significant skill, effort, and determination. To succeed as a DBA, you must competently juggle an attention to detail, solid technical prowess, a strong sense of organization, and a real knack for interacting with people. Learning the ins and outs of these requirements takes time. But when guided by experts who’ve succeeded as professional DBAs, you can more quickly gain insights into how to successfully address these issues more efficiently.
Therefore, if you’re drawn to the challenges of being a DBA – or just need to learn where to start when it comes to managing mission-critical data and all the dependencies that have been thrust upon you, you’ll want to join independent SQL Server expert (and former DBA), Michael K. Campbell for an informative, insightful, three-part eLearning seminar that covers essential Skills that every SQL Server DBA should know.
Sessions (each session runs approximately 75 minutes):
Session 1: Core Tasks and Responsibilities for DBAs
Being a DBA can be a daunting task. Businesses, employees, and peers trust you with the safety and up-keep of the very data that ensures their continued success and livelihood. To be a successful DBA, you must have an understanding of your core responsibilities, roles, and expectations. You also need to know where to focus your time, energy, and talents – because DBAs are constantly inundated with competing demands and expectations.By attending this session, you’ll learn about:
- Roles, responsibilities, and requirements for being a successful DBA.
- Tips and insights into how to effectively interact with co-workers as a DBA.
- Conceptual underpinnings of SQL Server that every DBA must know.
- How to correctly manage SQL Server Security.
- How to correctly manage your SQL Server Environment and hardware.
- How to effectively prioritize demands for your skills and expertise.
- Tips and tricks for addressing SQL Server management tasks.
Session 2: Disaster Recovery and Data Availability
As a DBA, everything rests on you to make sure that data is accessible and that it can be recovered in the case of a disaster. And when it comes to data and disasters, the question is never IF, but WHEN – and how much it will cost to recover when a disaster occurs. Consequently, the more you know about core SQL Server disaster recovery concepts the more you can the decrease costs (and potential horror) associated with disaster recovery and down-time.By attending this session, you’ll learn:
- Core concepts for understanding, managing, and creating backups and restoring and recovering SQL Server databases.
- How to set up a disaster recovery plan that you can bet your career on.
- How to become fearless when it comes to recovering mission critical SQL Server databases and data.
- Core concepts and insights for setting up high-availability solutions – along with potential pitfalls to watch out for and test against.
Session 3: Managing SQL Server Performance
Apart from managing user and application access to data along with protecting data from disasters, DBAs need to constantly address issues with server, database, and query performance. Tackling performance issues can be a daunting task – but equipped with a solid understanding of the basic tools, options, and techniques available to SQL Server DBAs will help put you on the path to success.In this session, you’ll learn about:
- Core SQL Server performance considerations and concepts.
- Top-down approaches to locating poorly performing code and other performance problems.
- Bottom-up approaches, techniques, and instrumentation for determining where bottlenecks are impacting the underlying hardware.
- An overview of available tools, techniques, and solutions that successful DBAs use when troubleshooting performance challenges and problems.
Instructors
Michael K. Campbell is a contributing editor for SQL Server Pro and a consultant with years of SQL Server DBA and developer experience. He enjoys consulting, development, and creating free videos for www.sqlservervideos.com.
Customer Service
If you have any questions regarding this event, the registration process or would like to register more than one attendee, please contact us directly.
Email: service@sqlmag.com
Phone: 800-793-5697 or 913-967-1719