Presented by Allan Hirt and Ben DeBow
Running Time: 388 minutes
Are you new to SQL Server? Looking to brush up your skills? Thrust into a SQL Server DBA role or been asked to administer some databases? Are you only familiar with another RDBMS or a Windows administrator? Is your company implementing a SQL Server-based application and you are familiar only with another vendor’s RDBMS? This two-day, six-part series is designed for you.
Each of the six sessions will provide you with the foundation you need to be successful with SQL Server. This basic knowledge is crucial to be able to hit the ground running. This eLearning series will cover aspects of various versions of SQL Server, whether you are a few versions behind or wanting to know more about the latest and greatest.
- Learn the core SQL Server concepts every DBA should know
- Learn how to increase the availability and performance of SQL Server instances and databases
- Learn how to properly approach administration of your instances and databases, whether you have one or 10,000
- Learn how to effectively implement the right backup and restore strategy based on your needs
- Learn how things outside of SQL Server affect and influence your daily tasks
Session 1: Hardware, Infrastructure, and Operating System Concepts for the DBA
When dinosaurs roamed the Earth, DBAs administering their respective RDBMSes had to also know about hardware as well as the operating system underneath. With changes in responsibilities over time, the modern DBA often times does not know as much as he or she should about core hardware and OS aspects to be able to successfully plan, deploy, administer, troubleshoot, and maintain their SQL Server solutions. Without this base knowledge, you could have deployments that are unreliable and perform poorly. This session’s goal is not to make you an expert, but to understand what you need to know and give you a solid foundation to be able to have the right conversations in the future.
Session 2: Virtualization and the Cloud for DBAs
We live in a world where deploying solutions on physical hardware is becoming more the exception than the rule. All DBAs need to understand about virtualization and what it means to their deployments of SQL Server in all aspects. DBAs also cannot bury their heads in the sand with regards to the cloud (public or private), either. This session will cover what SQL Server DBAs will have to consider as their jobs change to include physical, virtual, and hybrid solutions.
Session 3: SQL Server High Availability
Your management and end users expect the applications powered by SQL Server databases to be up and running when they want it. Between the features in SQL Server as well as third party solutions, there are quite a few ways to make your instances and databases available. However, technology is only part of the availability story – people and process is important, too. This session will paint the entire picture of how to approach making your instances and databases available, including demonstrating some of the more popular solutions.
Session 4: Indexing Fundamentals
Indexes are a key aspect to ensure that an application’s databases are performing optimally. The right index can ensure that data returns in milliseconds, whereas the wrong index and a poor indexing strategy can do more harm than good. This session will talk about what every DBA and developer needs to think about and know when it comes to indexes, including tips on how to devise the right indexing strategy.
Session 5: Administration Essentials
There are many things a DBA needs to do on a day-to-day basis to ensure that everything remains optimal. The key is doing the right task at the right time and having a long-term strategy. Success is tied to being proactive, not reactive. This session will discuss the most important tasks a DBA must perform (or automate) for their instances and databases to ensure key things like availability, performance, and security. Where possible, the different tasks, tools, and techniques will be demonstrated. Using maintenance plans vs. doing the tasks yourself will also be touched upon.
Session 6: Troubleshooting 101
Last, but not least, everyone runs into a bit of trouble from time to time with no map or starting point. While there are many variables as to what road one will ultimately take, you have to begin somewhere and learn the rudiments when it comes to approaching SQL Server problems. Often times the problem may not be SQL Server, but you can’t get to that conclusion without information. This session will teach you some of the fundamental troubleshooting techniques for SQL Server whether it is performance-related or something that may be causing you an outage. Hopefully you will gain insight into how to stop becoming the default blame acceptor.
Ben DeBow is a consultant who works with customers of all sizes on their mission-critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt.
Allan Hirt consults for and trains clients all over the world. He has written or co-authored numerous SQL Server publications; his latest book is Pro SQL Server 2005 High Availability (Apress).
If you have any questions regarding this event, the registration process or would like to register more than one attendee, please contact us directly.
Phone: 800-262-1954 or 913-967-1719