Upcoming Geek Sync Webinars

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 | MySQL Performance Tuning via Query Tuning

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

No one wants the slow performance of their application. In this session, we will learn about three performance tuning tricks that DBAs must know to improve their MySQL performance. We will understand what those tricks are and how efficiently we can use them in just 60 minutes. We will explore various settings as well as SQL code that will kill MySQL performance. At the end of this session, every attendee will receive SQL scripts that will help them improve their server’s performance. The presentation is carefully crafted from the real-world experience for DBAs so they can learn tricks that can help them to improve their server’s performance.

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 | Becoming a Better Data Modeler: Part 2 (Faulty Design Patterns)

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

To improve your data model design skills, you can learn to apply many best practices for model structures and patterns. But how do you determine which are the best patterns to use for specific designs? In this Geek Sync webinar, Steve Hoberman will explore a series of faulty design patterns and share lots of examples of data models that exhibit these patterns. You will learn how to fix each model, with the goal of making you a better data modeler by the end of this session!

Speaker: Steve Hoberman has trained more than 10,000 people in data modeling since 1992. Steve is known for his entertaining and interactive teaching style (watch out for flying candy!), and organizations around the globe have brought Steve in to teach his Data Modeling Master Class, which is recognized as the most comprehensive data modeling course in the industry. Steve is the author of nine books on data modeling, including the bestseller Data Modeling Made Simple. One of Steve’s frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique. He is the founder of the Design Challenges group, Conference Chair of the Data Modeling Zone conferences, and recipient of the Data Administration Management Association (DAMA) International Professional Achievement Award.

Geek Sync | Faster Transactions: Query Tuning for Data Manipulation

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

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.

Speaker: Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and is a 2020 IDERA ACE.

Geek Sync | Data in the Cloud: Understanding Amazon Services with Visual Models

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

As a data professional, you understand that a data model is primarily used for designing databases. But as more databases move up to the cloud, data modeling can also serve as a visual approach to capture concepts and relationships for database services, such as Amazon RDS, Aurora, and Redshift. Data models can demystify the complexities perceived and associated with managing and modeling cloud databases. Henry Nirsberger will show you how conceptual data models for Amazon database services can clarify confusion and accelerate an understanding of these complex offerings.

Speaker: Henry Nirsberger (CDMP, CBIP) is the author of “A Conceptual Data Model for Amazon EC2” and CEO of HMN Consulting LLC, providing IT consulting services specializing in Data Management, Enterprise Architecture, Cloud, Facilitation, and IT Leadership. As a trained facilitator, he has facilitated over 600 IT design and planning sessions for data modeling, process modeling, database design, project planning, process improvement, requirements consensus, strategy planning, issues management, and team building. He continues to be an unremitting student of data modeling, cloud computing, enterprise architecture, and all aspects of data management. His certifications include CDMP (DAMA), CBIP (TDWI), CDP-DM (ICCP), CFPIM (APICS 1984–2003) and TOGAF 9.

Geek Sync | Neutralize Troublesome SQL Server Indexes

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

SQL Server indexes are not always as helpful as we like to think. Often they work against our overall server performance. In this session, we will see some troublemaking scenarios and their workarounds. Pinal Dave will share scripts for various difficult scenarios which you can apply to your server right away to easily improve performance.

Events for IT and Data Pros