Your SQL Residency
Our events include webcasts that you can attend as well as conferences and seminars that take place in the real world. We’ll try to post videos and lessons from physical events on our blog!
If you missed one of our previous events, check out our video archive.
Are you frustrated by third party applications that you can’t change, but you have to support? Tired of beating your head against the wall when your users complain about things you can’t fix? In this 30-minute session, Brent Ozar will show you his favorite tricks to get the most performance without losing support. He’ll show you how to interact with vendors and get what you want – without getting heartburn. Register here.
Occasionally you check out job listings and wonder, “Could I have a better job?” If you’ve been working as a database administrator for a few years, it’s time to learn how to tell a dream job from a potential nightmare. Join Kendra Little for a 30 minute guide on how to read hidden messages in job listings and find the right next step for your career. Register here.
Have you ever wished your SQL Server could have an identical twin, holding the same data, in case you ever needed it? SQL Server mirroring provides just that, and you can choose if you want it for high availability or disaster recovery. If you’ve ever been curious about what mirroring really is, and what the pros and cons are, this is the session for you. Register here.
Southampton SQL Server User Group (Remote Sessions)
“Which Queries Are Killing My Server?” – Brent Ozar – What’s slowing down production? It’s easy to find out in just a few minutes using ClearTrace, sp_WhoIsActive, and the plan cache. Whether you’re a junior DBA or a senior developer, you can use the three free tools covered in this session to find the culprit.
Sometimes our identical twin turns out to be evil – and sometimes our SQL Server does, too. When we encounter data corruption, hardware failure, and OS errors, we need to fail over from our principal to our better mirrored twin. Jes will show you how to handle database mirroring failovers in both high safety and high performance setups. Register here.
It’s incredibly easy to make big mistakes with indexes in SQL Server. In this free 30 minute session, Kendra Little will share the three most common mistakes she finds people make with their indexing. You’ll learn how these mistakes can have disastrous impacts and practical steps you can take right away to identify if these problems exist in your environment. Register here.
Ensuring unmatched availability and performance of your organization’s SQL Servers is attainable – even to an “accidental DBA.” If you started as a developer or Windows admin, and now you’re faced with a database server and are not entirely comfortable with it, you’re not alone! Brent Ozar, Microsoft Certified Master, travelled that exact same path and will share the knowledge he gained along the way in this insightful webcast. Register here.
They’re powerful, but they’re the opposite of the easy button. Before you deploy this slick SQL Server 2012 feature in production, join Brent Ozar to learn real-life lessons about setup, quorum planning, backups, and monitoring. No marketing mumbo-jumbo here, just straight talk about the challenges. Register here.
You know that you’ve got problems with indexes in your environment, but you aren’t sure what to do first. In this free 30 minute session, Kendra Little will share how you can prioritize which changes should be made first and select how many changes to deploy at one time. Most importantly, you’ll learn how to use free tools to prove when your changes improve performance. This session is suitable for DBAs with one to two years of experience administering SQL Server. Register here.
South Florida SQL Server User Group, Remotely
When you pass in a query, how does SQL Server build the results? We’ll role play: Brent Ozar will be an end user sending in queries, and you’ll be the SQL Server engine. Using simple spreadsheets as your tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability. Register here.