13 On-Demand Sessions Start on June 26th, 2012 and Ends After July 24th, 2012

Course Overview

Have you found yourself in a situation where you’re managing SQL Server systems, but need some help determining what’s important and what you need to know?

In SSWUG.ORG’s virtual class, conducted by Microsoft SQL Server MVP Stephen Wynkoop, you will be able to receive the information need in the real world for working with SQL Server. For the non-formally trained “Accidental DBA”, Stephen will center on learning experiences, how-to information and specific demonstrations and labs that will let you explore the topics covered. By the end of the course, you will be ready to support and manage production databases when they are working well and when they are misbehaving.

This is the perfect workshop for many types of IT professionals, including SharePoint administrators, departmental database managers or simply those who have been asked to watch over systems while performing other duties.

Session Descriptions

• Performance – Stephen will focus on management, tuning and optimization for your servers. Learn about counters to monitor, common pitfalls and native tools you can use to manage and monitor your performance, as well as view what’s happening on your server.

• Management – Find out more about ongoing management of your systems and how to determine what you to be monitoring, what types of things you can do to troubleshoot and what are best practices for your systems.

• Best Practices – Get answers to questions like, “What are your native options for monitoring and auditing your SQL Server?”, “What options best fit in your own implementations?” and “What is the impact or overhead of the various approaches?”

• Security – Stephen will help you with planning and implementing an access control model as well as better understanding the threats to your system, all while providing insightful tips for managing your footprint and installation vulnerabilities.

• Disaster Recovery – Learn about the key fundamental planning points for building a disaster recovery plan by finding out how disaster recovery works, seeing what options are available and exploring the steps to properly handle backups and restores.

• T-SQL – Get started with understanding T-SQL by moving beyond the graphical tools to create queries, views, stored procedures. Stephen will provide information on how tools work, what you need to know about SELECT statements, DELETE, UPDATE and much more.

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).