Session List
Full Schedule
Date/Time Session Room
5/17/2017 9:30 AM -to- 10:00 AM Welcome
Room 1
5/17/2017 10:00 AM -to- 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.
Room 1
5/17/2017 11:00 AM -to- 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.
Room 1
5/17/2017 12:00 PM -to- 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.
Room 1
5/17/2017 1:00 PM -to- 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!
Room 1
5/17/2017 2:00 PM -to- 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.
Room 1
5/17/2017 3:00 PM -to- 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.
Room 1