| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | BI Platform Architecture, Development Administration | SQL Server 2016: A dive into Data Quality Services |
| 09:00:00 | David Patrick | BI Platform Architecture, Development Administration | Microsoft and Big Data - An Overview of the Power Tools and more! |
| 09:00:00 | Deji Akomolafe | Enterprise Database Administration Deployment | Successfully Virtualizing SQL Server on vSphere - Straight from the Source |
| 09:00:00 | Chris Seferlis | BI Platform Architecture, Development Administration | Digging Deeper: BI Methodologies and Best Practices |
| 09:00:00 | Ned Otter | Enterprise Database Administration Deployment | Real world In-Memory OLTP |
| 09:00:00 | Andrew Novick | Application Database Development | Natively Compiled T-SQL: The Fastest T-SQL Ever |
| 10:15:00 | George Walters | Enterprise Database Administration Deployment | SQL Server 2016 and 2014 New Features! |
| 10:15:00 | Edward Pollack | Enterprise Database Administration Deployment | Query Optimization Techniques |
| 10:15:00 | Thomas Grohser | Enterprise Database Administration Deployment | Optimizing the SQL Server and Databases for large Fact Tables |
| 10:15:00 | Thomas Lane | Enterprise Database Administration Deployment | Help! My Replication Has Fallen and We Can#39;t Get it Replicating again. |
| 10:15:00 | James Serra | Cloud Application Development Deployment | Should I move my database to the cloud? |
| 10:15:00 | Aaron Bertrand | Application Database Development | T-SQL : Bad Habits and Best Practices |
| 11:30:00 | George Walters | Enterprise Database Administration Deployment | Organizational Security Compliance with SQL 2012 through 2016 |
| 11:30:00 | Thomas Grohser | Enterprise Database Administration Deployment | Size Maters Not |
| 11:30:00 | James Serra | Enterprise Database Administration Deployment | Big data architectures and the data lake |
| 11:30:00 | Beth Wolfset | BI Platform Architecture, Development Administration | Take Me to your Data - why Data Stewardship is needed NOW! |
| 11:30:00 | Aaron Bertrand | Application Database Development | New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database |
| 11:30:00 | Andy Roberts | Enterprise Database Administration Deployment | SQL Server 2016: Security Features we have been asking for... |
| 13:30:00 | Edward Pollack | Application Database Development | Dynamic SQL: Writing Efficient Queries on the Fly |
| 13:30:00 | Kevin Feasel | Analytics and Visualization | R For the SQL Server Developer |
| 13:30:00 | Beth Wolfset | BI Platform Architecture, Development Administration | Data Modeling for Predictive Analytics |
| 13:30:00 | Brett Powell | BI Platform Architecture, Development Administration | SSAS Tabular 2016: Not the Little Brother Anymore! |
| 13:30:00 | Paresh Motiwala | BI Platform Architecture, Development Administration | Big Data 101 |
| 15:30:00 | Chris Lumnah | Enterprise Database Administration Deployment | Taking the pain out of database migrations |
| 15:30:00 | Kevin Feasel | Application Database Development | Peanut Butter amp; Chocolate: Integrating Hadoop with SQL Server |
| 15:30:00 | Mike Hillwig | Enterprise Database Administration Deployment | Leaving the Past Behind: Rewriting Your Checklist for SQL 2016 |
| 15:30:00 | John Miner | Application Database Development | Effective Data Warehouse Storage Patterns |
| 15:30:00 | Andy Mallon | Professional Development | Inside the Management Studio |
| 15:30:00 | Sunil Kadimdiwan | Analytics and Visualization | Learn On-premises BI: SSRS 2016 and Power BI |
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
How does Garbage Collection work, what types of memory-optimized objects does it work with, and how can I make sure it's operational? What are the pros/cons of different ways of handling hot/cold data with In-Memory OLTP? What causes ALTER TABLE to be fully logged and serially executed? All of these questions and more are answered as we discuss real-world usage of In-Memory OLTP.
Event Date: 10-12-2016 - Session time: 09:00:00 - Track: Application Database Development
• Review in-memory tables • Look at the T-SQL language that can be used in Natively Compiled code • Discuss how transaction handling is different due to the use of optimistic concurrency • Recompile query plans as needed • Take a look at DMVs and extended events • Compare natively compiled functions to the alternatives forms
How the speed improvements are achieved is a fascinating topic. We’ll take a look at the C code that SQL produces and uses as an intermediate step. Somewhere in the C is the query plan and we will hunt for them.
If you want your application to be more than just fast, consider using Natively Compiled T-SQL. It can make your database code run really, really fast.
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
The problem won#39;t always be a bad query, but when it is, knowing how to dive in, diagnose its performance, and resolve the situation efficiently will turn a potentially frustrating situation into a fun one! Using that knowledge in development to prevent future performance issues will improve script quality and application design, while making your future self less burdened by performance emergencies.
This is an opportunity to identify common query mistakes and learn a variety of ways in which we can solve them. This discussion will include query rewrites, indexing, statistics, database design, monitoring, execution plans, and more!
Demos of poor-performing queries will be provided to illustrate key optimization techniques, design considerations, and the tools you need to fix them. Fast.
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Event Date: 10-12-2016 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
He will cover topics including but not limited to: handling a lot of transactions per second, managing large databases and tables with a lot of rows , inserting a lot of new data and updating a lot from many places at once, and managing many SQL Server instances.
The goal of the session is to show that SQL Server can scale and that when used correctly has no problem doing so.
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 10-12-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-12-2016 - Session time: 13:30:00 - Track: Application Database Development
Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Event Date: 10-12-2016 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 10-12-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-12-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Come to this session to learn about the new features, walk through the essential design and administration tasks, and see how Tabular can be leveraged by different reporting and analysis tools including Power BI, Excel, and SSRS.
Event Date: 10-12-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
We will learn about foundations of big data and social physics, What is the importance of data quality and data privacy. We will have a quick look at personal sensors and human behavior This module will explore the various sources of data, how to leverage personal sensors to predict behavior, and introduce you to the key features of 'Funf'.
We will explore the basics of data dynamics and data interrogation, and the importance of interdisciplinary research and testing on yourself, to assist in analyzing a data set.
What are the fundamentals and structure of peer networks? I'll also introduce you to the concepts of network theory and graph clustering.
Time permitting, We will then conclude with introduction to data exploration and visualization techniques by using the 'Bandicoot' application and we will talk about how to use this data to effect behavior change through social influence an
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
These are questions you addressed long ago in your setup checklist. You've spent a lot of time with that checklist, and you're sure it's perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday's best practices to ensure they meet today's business needs.
Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Application Database Development
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Professional Development
The interviewees talk about their childhood, how they got started in the business, their early career, and behind-the-scenes trivia. The interview concludes with the Proust Questionnaire, made famous by Bernard Pivot (Apostrophes) and James Lipton (Inside the Actors Studio). After that, students can question the interviewee directly.
Event Date: 10-12-2016 - Session time: 15:30:00 - Track: Analytics and Visualization
In this session I will give you a tour of enhancements in SSRS 2016 including KPI, mobile paginated reports. Mobile reports can now be viewed on any device; tablet, smartphone and desktop. I will also show you the newly introduced integration of Power BI views into on-premises SSRS 2016.