Training
Tim Radney is a Microsoft Certified Trainer providing live online and in-person training classes. He also presents a number of workshops at conferences.
Workshops:
Common SQL Server Mistakes and How to Correct Them
Making mistakes is natural but learning from them and avoiding them in the future takes effort. There’s no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid and how to correct them. In this full-day workshop, Tim will share with you a ton of what he’s learned over the years from working and consulting at multiple Fortune-level companies. You’ll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. We will cover key topics such as backups, recovering from disasters, database maintenance, consistency checks, security reviews, installation best practices, and monitoring and troubleshooting performance issues. By the end of the day you’ll be comfortable with your ability to support SQL Server because you will know what you need to do and have a checklist of items to take home to make sure your SQL Server is configured properly.
Azure for the SQL Server DBA
Microsoft Azure is an open, flexible, scalable, enterprise-grade cloud computing platform. This full day class will teach you why migrating to SQL Server running in Azure is secure, reliable, easy, as well as how to do it.
The Azure platform is vast with many services to choose from. You will get a high level overview of the various services with a focus on SQL Server running in Azure Infrastructure as a Service (Iaas) and Azure SQL Database and Managed Instance as a Platform as a Service (PaaS).
You will see how easy it is to build a virtual machine in Azure running SQL Server and how to migrate your data. You will gain insight into licensing, security, pricing, and networking for connecting to the Iaas platform. You will quickly see how beneficial Azure VMs are with the ability to scale workloads, integrate Active Directory, leverage built in HA/DR options and manage your environment. You will also learn why many companies are leveraging Azure VMs for disaster recovery.
In addition to Iaas, we will cover SQL Server as a Platform as a Service with using Azure SQL Database and Managed Instance. You will learn about the features that Platform as a Service offers as well as Azure SQL Database and Managed Instance features. We will cover the similarities and differences between on premises SQL Server. You will learn various ways to check compatibility of your on premises databases and well as migration methods when we run a compatibility check and migrate it to Azure. You will gain a deep understanding of how to use and manage Azure SQL Databases and Managed Instance.
Pluralsight
If you are in need of building out a DR location for your organization, looking for an Iaas platform that is secure, easily scalable, and affordable, or are wanting to learn the benefits of SQL Server in a Platform as a Service, then this workshop is for you.
SQL Server: Understanding Database Fundamentals (98-364)
SQL Server: Understanding and Using Azure SQL Database