| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Mohit Gupta | Other | Key Note |
| 09:45:00 | Konstantin Melamud | BI Platform Architecture, Development Administration | Optimizing your data warehouse for OLAP Processing |
| 09:45:00 | Scott Stauffer | BI Information Delivery | Visualization Reporting Options on Microsoft’s Data Platform |
| 11:00:00 | William Wolf | Application Database Development | Common Coding Mistakes and how to Mitigate them |
| 11:00:00 | Melody Zacharias | BI Platform Architecture, Development Administration | Getting Started with Azure Machine Learning (AML) |
| 11:00:00 | Craig Millang | Application Database Development | T-SQL from Basics to |
| 13:45:00 | mirza baig | Enterprise Database Administration Deployment | backup and restore features in SQL 2012 |
| 13:45:00 | Konstantin Melamud | Enterprise Database Administration Deployment | Performance Tuning - Analyzing Execution Plans |
| 15:00:00 | Randolph West | Information Delivery | SQL Server Performance Tuning Starter Kit |
| 15:00:00 | Ian Chamberland | Enterprise Database Administration Deployment | Migrating SQL Server Quickly and Effectively |
| 16:15:00 | Terry Bunio | Application Database Development | How do I create an automated ETL test suite ?? |
Event Date: 09-04-2016 - Session time: 08:30:00 - Track: Other
Event Date: 09-04-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-04-2016 - Session time: 09:45:00 - Track: BI Information Delivery
Event Date: 09-04-2016 - Session time: 11:00:00 - Track: Application Database Development
There are several programming design patterns that work great in object orientated code that do not scale well inside of SQL Server.
In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
After this session, you can go back to your office Monday morning and be the code tuning rock star!
Event Date: 09-04-2016 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-04-2016 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 09-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Will try to take the audience from a beginner level to intermediate to advanced by giving examples. That way, they can get an idea on different options and ways of backing up and restoring and can use the scripts shown to practice later.
Event Date: 09-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
Event Date: 09-04-2016 - Session time: 15:00:00 - Track: Information Delivery
I talk quickly, and cover a lot of ground, but don't let that scare you.
Event Date: 09-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
In this session we will look at some techniques that can be used to migrate your SQL instances from one server to another using tools included with SQL Server. We will discuss how these strategies can be used to keep your down time requirements to a minimum and measured in minutes rather than hours.
Event Date: 09-04-2016 - Session time: 16:15:00 - Track: Application Database Development
We will review how to create automated tests with a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target. The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the functionality of the tSQLt test framework and the stored procedure code we created that generates the tests. We will review the considerable functionality in tSQLt that makes ETL testing and database testing easy and efficient. We will execute hundreds of tests in the short time during the presentation.