May 17, 2017
10 AM - 4 PM CST

IDERA Live is our first Virtual Conference designed to educate and inform users of any level in a fun, engaging atmosphere. Join some of the industry’s top speakers to guide you through compelling content and the biggest issues present in the IT world. You can expect top-notch training, industry tips and techniques, networking, and more! This one day event is 100% free and virtual so you can enjoy from your home or workspace. Registration is open to any and everyone, you do not have to be an IDERA customer to attend.


All times are Central Time Printable Schedule || Times, presenters and sessions are subject to change.

10:00 AM
11:00 AM


Performance in 60 Seconds - SQL Tricks Everybody MUST Know

Pinal  Dave
Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

11:00 AM
12:00 PM


Database Benchmarking: Miseries, Myths and Misconceptions

Bert  Scalzo
Database benchmarking is a task that many DBAs only perform on rare occasion - such as before adopting a new hardware and/or software platform. Yet the DBA is often asked to provide an expert opinion on the relative chance for success based upon performing database benchmarks. Yet most database benchmarking projects fail totally or provide less than accurate predictions often resulting in huge surprises. The basic or root cause is almost universally due to common myths and misconceptions. In this session, Oracle ACE Bert Scalzo will prepare you to perform both repeatable and reliable database benchmarks - and how to avoid the most common problems and their associated misery.

12:00 PM
1:00 PM


New Features of SQL PowerShell

Aaron  Nelson
A lot has changed in the SQL PowerShell world over the last 14 months, so much so, that it really is a whole new world from where we were just a year ago. SQL PowerShell isn’t just for DBAs; BI Developers and Database Developers can benefit from this solution as well. With the new features, including new cmdlets and the SQL Server PowerShell module now available to download in the PowerShell Gallery, even more possibilities with this tool are obtainable than just one month ago. Join PowerShell Virtual Group of PASS Leader, Aaron Nelson, to explore the new features in SQL PowerShell and learn how you can leverage this tool to make your life easier.

1:00 PM
2:00 PM


TSQL Coding Techniques - Are You Playing with Fire?

Mindy  Curnutt
The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Non-Parameterized SQL and Parameter Sniffing. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!

2:00 PM
3:00 PM


A Brave New World: SQL Server on Linux

Joseph  D'Antoni
With the brave new world of SQL Server on Linux, it is important for SQL Server professionals to have good understanding of the platform so they can best advise their employers. Even though it is early days for SQL Server on Linux. In this session you will learn about the Linux operating system, how to use it, and how to master it, and how to best deploy SQL Server on the Linux platform.

3:00 PM
4:00 PM


A Medical Data Warehouse Model

Michael  Blaha
This session will describe a large data warehouse that we built with the medical data for a large hospital. The warehouse has a Kimball architecture with 200+ dimensions and 100+ facts. The primary input source is from Epic Clarity. We'll describe the project and give a flavor of the data model. We'll discuss some of what went right and wrong about the project and take questions from the audience.


Michael Blaha

Michael Blaha is a consultant and trainer who specializes in conceiving, architecting, modeling, designing and tuning databases. He has worked with dozens of organizations around the world. Blaha has authored seven U.S. patents, seven books, many articles, and two video courses. His most recent publication is the Agile Data Warehouse Design video course from O’Reilly. He received his doctorate from Washington University in St. Louis, and is an alumnus of GE Global Research in Schenectady, New York. You can find more information with his LinkedIn profile or at superdataguy.com.

Mindy Curnutt

Mindy Curnutt is a SQL Server MVP and has been actively involved in the SQL Server Community since 2000. She has presented at her local North Texas SQL Server User Group (2002, 2003, 2015), SQLPASS Summits (2005, 2006, 2012, 2013), and numerous SQLSaturday events (2013-2015). She was a SME for both the SQL 2012 and 2014 Certification Exams and is an MSPress Books co-author. Mindy works for Trimble Navigation/TMW Systems as a distinguished engineer and the director of database architecture.

Joseph D'Antoni

Joseph D'Antoni is a consultant at Denny Cherry and Associates Consulting, and is a Microsoft SQL Server MVP and is well versed in SQL Server performance tuning and database infrastructure design. He has over a decade of experience working in both Fortune 500 and smaller firms, and is a frequent speaker at major tech events, and an active blogger about all topics technology. He believes that no single platform is the answer to all technology problems. His knowledge of IT systems includes Microsoft SQL Server, Oracle, VMware, Hyper-V, EMC, NetApp, Dell Compellent, Dell Equalogic, 3Par, and Pure Storage to name just a few. He holds a BS in Computer Information Systems from Louisiana Tech and an MBA from North Carolina State University.

Pinal Dave

Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).

Aaron Nelson

Microsoft MVP - Aaron is a senior SQL Server architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server. His SQL Server community activity includes running the APPDev virtual chapter of PASS, volunteering for the AtlantaMDF PASS chapter and helping organize the Atlanta SQLSaturday and the PowerShell user group.

Bert Scalzo

Bert Scalzo is an Oracle® ACE, author, speaker, consultant, and a Senior Product Manager for database tools at Idera. Bert also spent 15 years architecting DBA features for the popular Toad product line. He has three decades of Oracle® database experience and previously worked for both Oracle Education and Oracle Consulting. Bert holds several Oracle Masters certifications and his academic credentials include a BS, MS and Ph.D. in computer science, as well as an MBA. He has presented at numerous Oracle conferences and user groups, including OOW, ODTUG, IOUG, OAUG, RMOUG and many others. Bert’s areas of interest include data modeling, database benchmarking, database tuning and optimization, "star schema" data warehouses, Linux® and VMware®. He has written numerous papers and blogs for such well-respected publications as the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ and Toad World.