The Brent Ozar World Domination Tour continues with a bunch more free training events. I’ve updated my Upcoming Events page, and here’s the stuff in the next 30 days:
May 28 – Quest Pain of the Week Webcast
Getting Started with SQL Server Management Studio
Join SQL Server experts Brent Ozar and Michelle Ufford to learn basic but essential skills for managing your SQL Server.
They will show you how to get around SQL Server Management studio, how to use Activity Monitor and how to get a quick feel for what’s happening on your SQL Server.
Don’t miss this overview of tools that can help you as you take on more DBA responsibilities in lean times.
You can register for this free webcast online.
June 3 – How to Be a Backup & Recovery Hero in Natural Disasters
Hurricane season is here! Will your SQL Server data be safe in the event of a hurricane or other natural disaster? Quest can help you be a hero in SQL Server data recovery for your organization with valuable insight based on experience gained in the aftermath of disasters.
I’m doing two different seminars:
DBAs at small to midsize businesses – you probably can’t afford to maintain standby servers in a remote datacenter. However, you can still put cost-effective measures in place to protect your organization’s essential databases in the event of a disaster. In this webcast, you’ll learn how to build a bug-out bag, why virtualization can be a lifesaver, and why USB drives don’t always make sense for emergency offsite backups. Register for the small to midsize business webcast.
DBAs at large enterprises – to ensure your organization’s data is safe when disaster strikes, it’s not enough to throw servers in a remote datacenter. Being ready means testing, documentation and planning for the return to the production datacenter. I’ll share practices I learned from managing databases for a $7 billion company in South Florida during three hurricane seasons, including a two-week power outage after Hurricane Wilma. You will also learn the importance of a buddy system with a fellow employee in another state, and why hardware inventories are much more important than you think. Register for the enterprise webcast.
June 11 – Quest Pain of the Week Webcast
Time-Saving SQL Server Management Studio Tips & Tricks
Advance your skills in SQL Server Management Studio (SSMS) with SQL Server experts Brent Ozar and Michelle Ufford. They’ll show you ways do administration tasks faster than ever and which free add-ons actually add value, like Mladen Prajdic‘s SSMS Tools Pack and the Performance Dashboard Reports.
Plus, they’ll explain how Toad for SQL Server complements SSMS by allowing you to compare and synchronize schema and table data, execute scripts against multiple instances, roll back transactions and more.
You can register for this free webcast online.
June 19 – Quest Day with the Experts – Chevy Chase, MD
Come meet me in person! We’re doing a day of presentations on how to get more performance out of the hardware you’ve already got, and how to make your applications run faster. My presentations will be:
Perfmon and Profiler Basics: Find The Performance You’re Leaving on the Table
These two tools are the key to successful performance tuning. Brent will show how to get started with these tools, how to slice and dice the results, and how to interpret the data to find easy ways to get more performance fast out of your existing hardware. Attendees will learn:
- How to use Perfmon to find bottlenecks
- How to use Profiler to track down the cause of problem
- How to feed these results into Microsoft tools to get performance recommendations
SQL Server Disaster Recovery 101
Developers and accidental DBAs: if you know more about how SQL Server handles crashes and disasters, you’ll be able to make a better decision about how to prepare. In this session, Brent will cover all of SQL Server’s backup and high availability options at a high level, including clustering, log shipping, mirroring, replication and more. He’ll show the pros and cons of each, and teach you how to pick the right method for your application.
Attendees will learn:
- The difference between high availability and disaster recovery
- Real-world drawbacks of each solution
- Which methods complement each other for better protection
You can register for the in-person event, or register for the live webcast.
June 25 – Quest Pain of the Week Webcast
Conquering the Giant – How to Manage a Very Large Database
As your database continues to grow to a terabyte or more, you might feel like David facing Goliath. Your challenge seems insurmountable as it gets harder and harder to allocate space and speed up queries. Attend this webcast to learn how to quickly reclaim space, monitor and report on capacity growth trends, and improve the performance of your database. Conquer your giant database!
I’m now registered to most of the webcasts! Awesome topics w/ @SQLFool!