Where in the world is Quacky?

Each year, Idera sponsors a variety of events worldwide to support education, training and networking opportunities for Microsoft IT professionals. Check out the list below to find events near you. We look forward to meeting you!

If you’d like Idera to sponsor an upcoming event, please contact us at
sponsorships@idera.com

Duck

Webcasts

DATE & TIME LOCATION DESCRIPTION REGISTER
08/13/2015
1:00 PM - 2:00 PM CDT
Online Digging into THREADPOOL Waits in SQL Server

Some wait types are worse than others: when the THREADPOOL wait strikes, it can feel like your SQL Server just isn’t responding. Join Kendra Little to learn about THREADPOOL waits: how to recognize the symptoms, what to do when it occurs, how to find the root cause of the problem, and why a simple settings change is usually not the best solution.

About Kendra:

Kendra Little teaches people to performance tune their SQL Servers and make them highly available. She is a Microsoft Certified Master in SQL Server, a Microsoft MVP, and one of the few artists in the world to draw both dinosaurs and databases.

Register
08/13/2015
3:00:00 PM EDT
Online SQL Server Performance Tuning: Controlling Parallelism

Parallelism seems like it should be one of those things that the query engine takes care of for us, but it does require some care and tending from time to time. The default server configurations are no longer adequate for controlling parallelism, and DBAs need to know how to tweak the settings to make it run optimally. When parallelism goes awry, it can cause severe performance problems. Sometimes only for a specific query, sometimes it can hurt performance server-wide. To add a little complexity to the mix, parallelism can also be controlled by query hints and Resource Governor. Understanding how these three options for setting the Max Degree of Parallelism interact and who wins when they conflict is critical in being able to understand how to control it.

This session will cover:

  • Best practices for setting Max Degree of Parallelism and Cost Threshold for Parallelism
  • Why we would want to adjust these numbers up or down
  • How to view the parallelism details of a query plan
  • What CXPacket waits are and what we should do about them
  • How to determine effective degree of parallelism
  • Methods for controlling parallelism

About Robert Davis:

Robert Davis is a SQL Server Certified Master, MVP, and experienced DBA, evangelist, speaker, writer, and trainer. He has worked with SQL Server for 15+ years. He recently worked for Outerwall, Idera Software, and Microsoft. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. He currently works as a principal database architect at DB Best Technologies. Robert is co-founder and co-leader of the PASS Security Virtual Chapter.

Register
09/24/2015
1:00 PM - 2:00 PM CDT
Online The Art of Stress-Free Database Administration

You're responsible for keeping SQL Server online and fast, and you're constantly burned out. You feel like you're always behind and you can never catch up. Forget becoming proactive - your company can't afford to hire enough people to get there. Brent Ozar has been there too, and he'll give you 4 steps to become at peace with your work. Make a list of your servers, make a list of what you're responsible for, prioritize what isn't under control, and share it with management so they know what you're working on. Do those four things, and your stress will start to melt away.

About Brent:

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and sp_AskBrent®, coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com. He's a Microsoft Certified Master of SQL Server and a Microsoft MVP.

Register