| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Vijay Narayanan | Keynote | Fireside Chat Keynote - Deep Learning Concepts and Experiences |
| 10:30:00 | Armando Lacerda | Enterprise Database Administration Deployment | Unleashing Stretched Databases |
| 10:30:00 | Steve Jones | Strategy and Architecture | Bringing DevOps to the Database |
| 10:30:00 | Christian Wade | BI Platform Architecture, Development Administration | Modeling and Analytics Features Coming in Analysis Services vNext |
| 10:30:00 | J May | Strategy and Architecture | SQL Server 2016 Always On Availability Groups Perf Internals |
| 10:30:00 | Ike Ellis | Cloud Application Development Deployment | Survey of the Azure Data Landscape |
| 10:30:00 | Eric Bragas | Analytics and Visualization | R in Power BI |
| 10:30:00 | Mark Ginnebaugh | Other | Microsoft Data Management Hands-on Labs |
| 11:45:00 | Harriet Farmer | Professional Development | It Isn't Magic: Make It Happen. Resume Writing and Interviewing Tips |
| 11:45:00 | Bryan Walsh | Enterprise Database Administration Deployment | Using Dell EMC to Empower Microsoft SQL Server DBAs and Test/Dev Engineers |
| 11:45:00 | Trent Mera | Other | Spotlight on SQL Server |
| 13:15:00 | Steve Jones | Professional Development | Branding Yourself for a Dream Job |
| 13:15:00 | Jonathan Stewart | BI Platform Architecture, Development Administration | An introduction to the magical world of BIML! |
| 13:15:00 | Reeves Smith | BI Information Delivery | The New Revolution in Data Science, R integrated into SQL Server |
| 13:15:00 | Ami Levin | Application Database Development | Where did I put my (primary) keys? |
| 13:15:00 | Alisha Harold | BI Platform Architecture, Development Administration | Power BI SSRS On Premise |
| 13:15:00 | Jarek Kazmierczak | Strategy and Architecture | What’s new in SQL Server 2017 |
| 14:30:00 | Reeves Smith | BI Information Delivery | SQL Server Integration Services for Data Science |
| 14:30:00 | Phil Robinson | Analytics and Visualization | Data Wrangling for Reporting Analytics |
| 14:30:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization |
| 14:30:00 | Angel Abundez | Big Data | Intro to Azure Data Factory |
| 14:30:00 | Jarek Kazmierczak | Advanced Analysis Techniques | Scalable Deep Learning with Microsoft Cognitive Toolkit |
| 14:30:00 | Joshua Vickery | Analytics and Visualization | Power BI: Best Practices from the Field |
| 15:45:00 | Ami Levin | Application Database Development | Physical Join Operators |
| 15:45:00 | Randy Knight | Application Database Development | But it worked great in Dev! Perfomance for Devs |
| 15:45:00 | Prakash Heda | Enterprise Database Administration Deployment | Consolidated Essential Performance Health Check using PowerShell |
| 15:45:00 | Andy Parkerson | BI Information Delivery | Programming in Power Query: An Introduction to M |
| 15:45:00 | John McAllister | BI Platform Architecture, Development Administration | Master Data Management - Getting Started with SQL Server MDS |
| 15:45:00 | Rajya Bhaiya | Big Data | Big Data Analytics Apps |
| 15:45:00 | Greg Larsen | Application Database Development | Indexing Guidelines |
| 17:00:00 | Armando Lacerda | Enterprise Database Administration Deployment | Why are you still taking backups? |
| 17:00:00 | Lori Edwards | Enterprise Database Administration Deployment | DBA 101 – Let’s Get Started |
| 17:00:00 | Mike Lawell | Application Database Development | Execution Plans for Mere Mortals |
| 17:00:00 | Prakash Heda | Enterprise Database Administration Deployment | Smart Re-Indexing - The quest of ultimate automation |
| 17:00:00 | Milan Lee | Cloud Application Development Deployment | Hybrid Cloud and On-Premise Environment for Model Development and Deployment |
| 17:00:00 | Joshua Vickery | Analytics and Visualization | Power BI: The Streaming Story |
Event Date: 22-04-2017 - Session time: 09:00:00 - Track: Keynote
Data and Artificial Intelligence are the deeply woven into the fabric of our Microsoft Data products. Microsoft SQL Server 2016 is the simplest enterprise-grade scale-out deployment platform for data AI applications. It deeply integrates Advanced Analytics and ML through Microsoft R Services and Python. Applications can move AI into the database, making it 100x faster and get unprecedented insights to actions. We will lead you through manifold examples showcasing Artificial Intelligence in SQLServer 2016 on-premise and in Azure . One of the examples we are going to talk about how we now can combine high-volume transactions with Machine Learning Predictive intelligence to perform High Speed Fraud Detection. Another example is showcasing how lung cancer detection can be done inside SQLServer using Deep Neural Networks and Python.
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Strategy and Architecture
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Strategy and Architecture
Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Analytics and Visualization
Event Date: 22-04-2017 - Session time: 10:30:00 - Track: Other
Get hands-on and learn how you can simplify your data management approach with Microsoft SQL Server, a secure, scalable database platform that has everything built in. Experience firsthand, in a live environment, how SQL Server delivers break-through performance, advanced security, integrated analytics and extends your data management to the cloud with Azure Data Services.
Event Date: 22-04-2017 - Session time: 11:45:00 - Track: Professional Development
Bring your resume with you (thumb drive or hard copy) for review and edit.
We will … Take a look at your resume, revising content and format. Work on interviewing technique Chart your current Career Path.
Event Date: 22-04-2017 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 11:45:00 - Track: Other
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: Professional Development
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: BI Information Delivery
The R language is run as a desktop application and was not built with performance and scale required to accommodate Big Data. Revolution Analytics, a wholly owned subsidiary of Microsoft, has solved the performance and scaling issues of a desktop application by creating a more robust enterprise architecture. SQL Server 2016 brings the power of R and Revolution Analytics into the industry leading relational database.
This session will introduce R and demonstrate the functionality and power of using R within SQL Server.
This presentation is ideally suited for Business Intelligence professionals that are interested in understanding the new R Service that is being added to SQL Server.
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: Application Database Development
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-04-2017 - Session time: 13:15:00 - Track: Strategy and Architecture
New SQL Server 2017 Azure Data Estate capabilities provide better flexibility, consistency, and performance across all platforms Data landscape is changing challenging – Microsoft’s Modern Data Warehouse Solution can help you adjust to any language, any platform, any time Intro of SQL Server 2017 capabilities, including fast performance, mission critical HA, encryption, dynamic reporting, enhanced SSAS, etc. SQL Server available across all platforms and consistent across on-prem and the cloud SQL Server can be stretched to Azure, providing scale, performance, machine learning, etc.
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: BI Information Delivery
ETL developers play a key role in the success of a data science project. With your overall knowledge of the data integration architecture within your enterprise, you are in an excellent position to help with the next advanced analytics project at your company.
What are the additional skills needed to improve your role in the next data science project? In this presentation, we’ll discuss the data preparation and integration considerations that you will need.
Some of the topics that will be covered in this session include: • Data Cleansing • Data Normalization/Discretization • Missing Values • Noisy Data • Data Reduction • Model Integration
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Analytics and Visualization
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Big Data
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
The Microsoft Cognitive Toolkit—previously known as CNTK—empowers you to harness the intelligence within massive datasets through deep learning by providing uncompromised scaling, speed and accuracy with commercial-grade quality and compatibility with the programming languages and algorithms you already use.
Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Analytics and Visualization
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: BI Information Delivery
We then look at what to do when the information you get is incomplete and contradictory. Cleaning up data and handling errors and missing data will be our focus in an example of combining multiple data sources into a single data set. We consider this crucial step in the ETL cycle.
Our examination will conclude with a discussion of best practices, centering on coding style and deciding on when to solve a problem with M versus when to rely on DAX.
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Big Data
Ziosk case study – leverages big data from customers’ tablet interactions to run analytics apps and optimize the restaurant experience and resources A powerful toolkit is needed to build big data analytics apps – Microsoft has a great solution with 4 key attributes To actually build an app, you’ll need some certain functionalities – Microsoft offers a comprehensive platform
Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Application Database Development
Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Cloud Application Development Deployment
Event Date: 22-04-2017 - Session time: 17:00:00 - Track: Analytics and Visualization