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.

Sessions


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

9:30 AM
-to-
10:00 AM


   
add_alert
Add to Calendar

Welcome


 

 

 


10:00 AM
-to-
11:00 AM


   
add_alert
Add to Calendar

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
-to-
12:00 PM


   
add_alert
Add to Calendar

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
-to-
1:00 PM


   
add_alert
Add to Calendar

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
-to-
2:00 PM


   
add_alert
Add to Calendar

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
-to-
3:00 PM


   
add_alert
Add to Calendar

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
-to-
4:00 PM


   
add_alert
Add to Calendar

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.