Where in the world is Quacky?

Events for IT and Data Pros

Each year, IDERA sponsors a variety of online and live events to provide education, training, and networking opportunities for database professionals. Check out the list below to find information about upcoming events. We look forward to meeting you!

Check out the IDERA Resource Center to watch replays for previous webcasts and explore other product content.

If you’d like Idera to sponsor an upcoming event, please contact us at [email protected]

Geek Sync

Join us in a Geek Sync to discover new ways of thinking, build your repertoire of tips and tricks, and connect with industry experts.

Want to lead your own Geek Sync? Contact us and let us know what ideas you have.

 

Geek Sync | Performance Tune Like an MVP

04.08.2020 @ 11:00 AM CT - 12:00 PM CT

The life of a DBA is evolving and your tuning skills should always be sharp. Tuning is one of the key components of a great DBA and developer. In this demo rich session we'll deep dive into performance tuning for on-premises, PaaS (platform as a service), and IaaS (infrastructure as a service). We'll discuss tips and techniques for troubleshooting bottlenecks and how to remediate them for hardware, OS, and the database.

About Daniel: Daniel Janik has been supporting SQL Server for over 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.

Geek Sync | Adopting a Compliance & Auditing Mindset

AndyWarren
04.15.2020 @ 11:00 AM - 12:00 PM CT

It's easy and all too common to see the auditing team as adversaries. All the information they want takes time to gather, all the rules and procedures they want added just slow things down, and far too often it feels like we're trying to pass the test rather than really be secure. Sound familiar?

There isn't a magic answer that makes it all painless, but there are ways to make this process easier, less frustrating, and more effective. It starts with understanding that in general everyone wants the same thing - a documented and sound approach for conducting business in a way that guarantees we stay secure and available. There are a lot of options for getting there, but they require a higher level conversation than you might be used to or expect. The auditing team may not be experts in every bit of technology - sometimes they prescribe solutions because we demand it, sometimes because they think they are supposed to! We'll talk about all of this in the context of SQL Server including what we can do with the tools in the box and places where third party tools can really make a difference.

Speaker: Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Geek Sync | Avoid the Seven Mistakes Data Modelers Make in Aiding Data Governance

Karen Lopez
04.22.2020 @ 11:00 AM - 12:00 PM CT

Data privacy, protection, and compliance legislation is becoming ever more important. In that context, organizations have been looking towards their data governance teams to make sure that they understand their data, know how it is classified, and where it resides.

In this session, join Karen Lopez in discussing the mistakes that data modelers make in supporting data governance programs — and that you should avoid! These mistakes include collaboration errors, data model security fails, data stewarding missteps, data model integrity harms, and more.

Newer compliance regulations can make these mistakes costly and difficult to recover from. Karen wants you to love your data — and your data model!

Speaker: Karen Lopez has more than 20 years of database design experience. She specializes in the practical application of design approaches, balancing development time frames with the need to deliver solutions that will support business agility and data quality needs. She’s known for her fun and engaging speaking and teaching style. She tweets about data, space exploration and her travel experiences at @datachick. Karen blogs at www.datamodel.com.

Geek Sync | MySQL Indexing - The Secret Toolbox

Pinal Dave
05.06.2020 @ 11:00 AM - 12:00 PM CT

Slow running queries are the most common problem that database professionals face while working with MySQL. While it may be easy to blame MySQL for unsatisfactory performance, the issue often persists with the way queries have been written, and how Indexes have been set up.

Join IDERA and Pinal Dave as he walks you through how to identify problems that slow down MySQL, and the secret indexing tricks to fix them. Database professionals will walk out with scripts and knowledge that can be applied to their servers immediately after the session.

Speaker: Pinal Dave is a Developer Evangelist and SQL Server performance expert. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).

Geek Sync | Secrets of the Plan Cache

05.13.2020 @ 11:00 AM - 12:00 PM CT

You have heard of a query plan, right? Perhaps even looked at one somewhere along the way. Have you ever wondered what information might be buried in the plan cache, the courses of action having that additional information might lead you to? Perhaps you have wondered what plans in the cache would benefit from those missing indexes or contemplated your cost threshold of parallelism, among other questions. This session is designed to answer just that. We will look at query plans without the pretty node icons and from there we will interrogate the plan cache thus putting its secrets to work for us.

Speaker: Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.