| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Timothy McAliley | Cloud Application Development Deployment | Azure Cosmos DB – Does this change the game? |
| 08:30:00 | Chris Bell | Enterprise Database Administration (DBA) Deployment | 5 Minute No Sweat SQL Security Audits |
| 08:30:00 | Hilary Cotter | Enterprise Database Administration (DBA) Deployment | Replication Technologies |
| 08:40:00 | James Serra | Strategy and Architecture | Relational databases vs Non-relational databases |
| 08:40:00 | Ned Otter | Enterprise Database Administration (DBA) Deployment | Real world SQL 2016 In-Memory OLTP |
| 08:40:00 | Rick Lowe | Application Database Development | Weird Stuff I Saw While ... Working With Heaps |
| 08:40:00 | Kevin Howell | Cloud Application Development Deployment | Movin’ On Up: Taking your Data to the Azure Cloud |
| 08:50:00 | Slava Murygin | Enterprise Database Administration (DBA) Deployment | SQL Server on Linux for SQL DBA. |
| 08:50:00 | Thomas Grohser | Professional Development | Why candidates fail the job interview in the first minute |
| 08:50:00 | Peter Shore | Cloud Application Development Deployment | SELECT Provider FROM Cloud |
| 10:00:00 | David Patrick | BI Information Delivery | Microsoft and Big Data - An Overview of the Power Tools and more! |
| 10:00:00 | Thomas Chan | Enterprise Database Administration (DBA) Deployment | Finding more space for your tight environment. |
| 10:00:00 | Stephanie Herr | Enterprise Database Administration (DBA) Deployment | DevOps: What it is and why you should care |
| 10:10:00 | Vladimir Oselsky | Application Database Development | Crash Course on Better SQL Development |
| 10:10:00 | Alex Grinberg | Strategy and Architecture | Take the changes under control |
| 10:10:00 | Vishal Pawar | BI Platform Architecture, Development Administration | Power BI-Create a Dashboard from Zero to Hero |
| 10:10:00 | Rick Wargo | BI Information Delivery | Dashboard Development in R |
| 10:20:00 | Ray Kim | Professional Development | Tech Writing for Techies: A Primer |
| 10:20:00 | Sebastian Meine | Professional Development | The Phenomenal IT Consultant |
| 10:20:00 | Ryan Booz | Application Database Development | Slay the Legacy Leviathan... Without Modifying Application Code |
| 11:30:00 | Scot Reagin | BI Platform Architecture, Development Administration | Agile Data Modeling with Data Vault |
| 11:30:00 | Paresh Motiwala | BI Platform Architecture, Development Administration | Setting up BI Infrastructure: Points to consider |
| 11:30:00 | Thomas Grohser | Enterprise Database Administration (DBA) Deployment | SQL Server Storage Engine under the hood |
| 11:40:00 | James Serra | Enterprise Database Administration (DBA) Deployment | HA/DR options with SQL Server in Azure and hybrid |
| 11:40:00 | Chris Bell | Application Database Development | Would You Just Load Already?! Maximizing Your SSIS Data Load |
| 11:40:00 | Dan Hartshorn | BI Platform Architecture, Development Administration | Introduction to R and SQL Server |
| 11:40:00 | Hilary Cotter | Enterprise Database Administration (DBA) Deployment | Monitoring SQL Server using Extended Events |
| 11:50:00 | Greg Moore | Strategy and Architecture | Who's flying the plane? What IT can learn from plane crashes |
| 11:50:00 | Lisa Margerum | Professional Development | Network your Way to Success! |
| 11:50:00 | Rick Lowe | Enterprise Database Administration (DBA) Deployment | Why should I care about ... the plan cache? |
| 14:10:00 | Alex Grinberg | Strategy and Architecture | Migrating a Disk-based Table to a Memory-optimized Table |
| 14:10:00 | Azhagappan Arunachalam | Cloud Application Development Deployment | Understanding U-SQL |
| 14:10:00 | Bob Blackburn | BI Information Delivery | Power BI Advanced Modeling |
| 14:15:00 | James Serra | Professional Development | Learning to present and becoming good at it |
| 14:15:00 | Brian Carrig | Cloud Application Development Deployment | Running SQL Server in AWS |
| 14:15:00 | Ray Kim | Strategy and Architecture | Disaster Documents: The role of documentation in disaster recovery |
| 14:15:00 | Sebastian Meine | Application Database Development | Introduction to Unit-Testing in SQL Server |
| 14:20:00 | Timothy McAliley | Cloud Application Development Deployment | Azure Analysis Services - An introduction |
| 14:20:00 | Ned Otter | Application Database Development | Indexing survival guide for SQL 2016 In-Memory OLTP |
| 14:20:00 | Vince Napoli | BI Platform Architecture, Development Administration | Securing and Managing access to your DW data |
| 15:30:00 | Paresh Motiwala | Strategy and Architecture | Big Data 101 |
| 15:30:00 | Chris Bell | Application Database Development | Statistics Cardinality – How They Work to Find Data Efficiently |
| 15:30:00 | Ryan Booz | Application Database Development | Service Broker - Async In the DB |
| 15:35:00 | Greg Moore | Enterprise Database Administration (DBA) Deployment | Tips that have saved my bacon |
| 15:35:00 | Ravi Gudlavalleti | Strategy and Architecture | Master Data Management with SQL Server MDS 2016 |
| 15:35:00 | Tracy Boggiano | Enterprise Database Administration (DBA) Deployment | Query Store Primer |
| 15:35:00 | Dominic Falso | Application Database Development | Parsing T-SQL using the TransactSql.ScriptDom library (C#) |
| 15:40:00 | Chris Voss | Professional Development | From Analyst BI Day to Developer BI Night |
Event Date: 03-06-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 08:40:00 - Track: Strategy and Architecture
Event Date: 03-06-2017 - Session time: 08:40:00 - Track: Enterprise Database Administration (DBA) 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 SQL 2016 In-Memory OLTP.
Event Date: 03-06-2017 - Session time: 08:40:00 - Track: Application Database Development
Event Date: 03-06-2017 - Session time: 08:40:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 08:50:00 - Track: Enterprise Database Administration (DBA) Deployment
For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.
Event Date: 03-06-2017 - Session time: 08:50:00 - Track: Professional Development
Thomas will share what he misses in resumes and how to respond to questions better.
Event Date: 03-06-2017 - Session time: 08:50:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 10:00:00 - Track: BI Information Delivery
Event Date: 03-06-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration (DBA) Deployment
I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defrag the indexes and update the statistics, since shrink datafile is not fragmentation aware task.
Event Date: 03-06-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 10:10:00 - Track: Application Database Development
Event Date: 03-06-2017 - Session time: 10:10:00 - Track: Strategy and Architecture
Event Date: 03-06-2017 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration
Learn how to create Power BI Dashboard from scratch.
Event Date: 03-06-2017 - Session time: 10:10:00 - Track: BI Information Delivery
In this session, we will discover and understand how to build dashboards in R using a few different patterns. We will also understand how to deliver this content to the consumer in multiple forms, including on-demand (web and bot), interactive (web), and batch (email).
You will leave this session with an understanding of how to start developing dashboards in R and how to deliver them to your user community. To get the most from this session, some general knowledge of R and programming languages is required.
Event Date: 03-06-2017 - Session time: 10:20:00 - Track: Professional Development
Event Date: 03-06-2017 - Session time: 10:20:00 - Track: Professional Development
In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…
Event Date: 03-06-2017 - Session time: 10:20:00 - Track: Application Database Development
In this session I'll give a brief history of our SQL Server journey that started way back with version 6.5 and then I'll size up our installed user base to set the stage. Then we'll jump right into demonstrating the process we've taken to re-tool the database in ways that have improved performance, maintenance, and user experience… all without changing application code! You'll learn how to rethink your indexing scheme, naming standards, tools like Service Broker and Temporal Tables, server setup practices, and how to log metrics that matter.
This session will give you hope and inspire you to start your own "modernizing" journey!
Event Date: 03-06-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
In this session we’ll compare modeling techniques in real world scenarios to understand how Data Vault can make your EDW more capable and agile.
Event Date: 03-06-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
We shall discuss selection of vendors and technology. We will learn about various components of BI infrastructure, their HA/DR scenarios. We shall also learn about the best practices involved therein. We will also discuss whether to outsource this project or rise above our DBA job and do it ourselves.
We will also briefly discuss how Copy Data Virtualization helps us to provide data/information quickly to the BI team to turn around reports quickly.
Evolution of the cloud has really changed the lay of the BI land. We will talk about On-Prem, cloud hosted or hybrid solutions. We will take a quick look at the Power BI where the Power of BI is back in the hands of the users.
At the end of the session you will have a complete information about an ideal BI Infrastructure.
Event Date: 03-06-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration (DBA) Deployment
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Event Date: 03-06-2017 - Session time: 11:40:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 11:40:00 - Track: Application Database Development
In this session you will learn a simple method to load data via SSIS and identify, remove, and record those bad records allowing you to maximize the amount of data loaded while ensuring data integrity.
Event Date: 03-06-2017 - Session time: 11:40:00 - Track: BI Platform Architecture, Development Administration
- Overview of Infrastructure – How does R work within an environment
- Data Wrangling - How do you get at data and structure it for your use.
- Statistical Analysis and Packages - How can you use the analytic features that are important to you.
- Introduction to Machine Learning - Machine Learning is currently a hot button topic.
- Visualization and Reporting in R - A key feature is the robust level of visualizations. We will do an overview
Event Date: 03-06-2017 - Session time: 11:40:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 11:50:00 - Track: Strategy and Architecture
Every company will eventually have a disaster. It's just a matter of size and scope. This talk is a general overview of how to respond to an incident and talks about the roles of management and IT.
This is not your typical discussion of disasters focusing on how to make a backup plan or enable high availability.
I'll touch upon what we can learn from plane crashes and how those lessons can be applied to the IT environment in general.
Event Date: 03-06-2017 - Session time: 11:50:00 - Track: Professional Development
Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers.
Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!
Event Date: 03-06-2017 - Session time: 11:50:00 - Track: Enterprise Database Administration (DBA) Deployment
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Event Date: 03-06-2017 - Session time: 14:10:00 - Track: Strategy and Architecture
Event Date: 03-06-2017 - Session time: 14:10:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 14:10:00 - Track: BI Information Delivery
Event Date: 03-06-2017 - Session time: 14:15:00 - Track: Professional Development
Event Date: 03-06-2017 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 14:15:00 - Track: Strategy and Architecture
While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.
Event Date: 03-06-2017 - Session time: 14:15:00 - Track: Application Database Development
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Event Date: 03-06-2017 - Session time: 14:20:00 - Track: Cloud Application Development Deployment
Event Date: 03-06-2017 - Session time: 14:20:00 - Track: Application Database Development
Available index types (Range, Hash, and Columnstore), and their usage Index maintenance and troubleshooting Statistics How indexes affect recovery Indexes and Temporal tables Indexing capacities for non-Enterprise editions in SQL 2016/SP1 Parallelism for indexes Support for ascending/descending indexes
Event Date: 03-06-2017 - Session time: 14:20:00 - Track: BI Platform Architecture, Development Administration
Event Date: 03-06-2017 - Session time: 15:30:00 - Track: Strategy and Architecture
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? We will also talk about HDInsight and take a look at Microsoft's items in play.
Event Date: 03-06-2017 - Session time: 15:30:00 - Track: Application Database Development
Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.
Event Date: 03-06-2017 - Session time: 15:30:00 - Track: Application Database Development
In this session I'll take a look at this "older" technology introduced with SQL 2005. I'll discuss what it is, how it can be used as a local database messaging queue, and how it can effectively allow you to do asynchronous trigger and stored procedure logic that wasn't previously possible.
You'll leave with ideas of how to refactor existing logic and setup your first SSB conversation. We'll also cover some of the initial pitfalls many people run into and considerations for using SSB in larger environments.
Event Date: 03-06-2017 - Session time: 15:35:00 - Track: Enterprise Database Administration (DBA) Deployment
There's saying, never perform small miracles, people to rely on them, but isn't it useful to have a few in your back-pocket.
Everyone knows log-shipping is great for DR recovery, but what about using it for minor issues, like a delete or update gone bad? Want to move a large table someplace else (like that "oh it'll just be a small audit table, it won't grow large because we'll write the functionality later to keep it small" and they never do? UNC backups... an often overlooked but useful option for making a backup AND getting it off your server. Run a small operation where too many fingers have access to the operational DB and you want to catch them? These are some of the tricks I've picked up over the years and used more than once to perform small miracles and have saved my bacon or the bacon of others
Event Date: 03-06-2017 - Session time: 15:35:00 - Track: Strategy and Architecture
The following topics will be covered (tentative list):
Event Date: 03-06-2017 - Session time: 15:35:00 - Track: Enterprise Database Administration (DBA) Deployment
Event Date: 03-06-2017 - Session time: 15:35:00 - Track: Application Database Development
Event Date: 03-06-2017 - Session time: 15:40:00 - Track: Professional Development
This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and what relational database concepts, to help you navigate this uncharted territory...coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!