Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type




Sessions Found: 36
Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Saturn / 81

How to bring big data analytics to your teams through smart apps that revolutionize the way they work 
?	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
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Galileo / 270

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Exec Conf Room / 30

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Session Type:
Keynote (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:45 AM

Room: Nebula / 40

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Exec Conf Room / 30

Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

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
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Nebula / 40

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Exec Conf Room / 30

Administering SQL Server environments can seem like a daunting task for any DBA.  In this session, we’ll provide some guidelines and tips to help new DBAs get started on the right foot.  Backups/restores, integrity checks, index maintenance, documentation, security and alerting will be some of the topics covered in this session.  We’ll also be covering some of the online resources that are available.  Bring your questions!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 22

Time: 5:00 PM - 6:00 PM

Room: Jupiter / 81

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. 

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 22

Time: 5:00 PM - 6:00 PM

Room: Nebula / 40

This special keynote and Fireside Chat featuring Vijay Narayanan and Ross Mistry will be held in the Galileo Auditorium, from 9:00 to 10:15.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Keynote (75 minutes)

Track:
Keynote

Level: Beginner

Session Code:

Date: April 22

Time: 9:00 AM - 10:15 AM

Room: Galileo / 270

This session will introduce the model development and deployment capabilities that are integrated between SQL Server and the Microsoft Cloud Platform. We will demonstrate the model development process using Microsoft R Server on the Cloud, discuss some of the key differences between open source R and Microsoft R Server, and finally deploy the finished model into an on-premise instance of SQL Server for scoring and operationalization. No prior background in data science or model development is necessary.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 22

Time: 5:00 PM - 6:00 PM

Room: Mercury / 81

This session will discuss the indexes development lifecycle and some guidelines on how to make good indexing decisions.   By understanding the development lifecycle, you will better understand how to build and optimize your indexes over time.  We will also be discussing how to decide what columns to consider when building indexes, and how to ensure those indexes are providing value as your application matures.  Column selectivity will also be discussed.  This session will show how selectivity information can help you determine the best column order when building multi-column indexes.  During this session there will be numerous demos to highlight the concepts being discussed. Additionally, an indexing toolkit (a set of scripts) will be provided to help attendees better manage their indexes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Exec Conf Room / 30

Azure Data Factory is a managed cloud service for building and operating data pipelines for NoSQL and Relational data stores. It can ingest structured and unstructured data sources with ease. Operationalize ADF pipelines with its built-in scheduling and monitoring systems. When combined with Azure Data Lake, it can become a key part of your data processing core. Its never been easier to start with ADF. Come and learn how you can get started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Saturn / 81

Your career is like a game of chess. It requires using multiple skills, simultaneously, while continually improving in all areas. All with one goal — to ‘win’ the current challenge and move on to the next milestone. This Session will look at where you are in your Career Path and focus on three key areas that keep you moving toward the next milestone.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 22

Time: 11:45 AM - 12:45 PM

Room: Nebula / 40

This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Saturn / 81

The Hands-on Labs will be available all day, following the Keynote.  They are located in the MTC Executive Briefing Suite 2036.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Hands-On Labs (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: MTC Exec Briefing Ste 2036 / 20

Microsoft SQL Server Analysis Services & Azure Analysis Services help you build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Join this session for a look forward to what's coming in SQL Server Analysis Services vNext & Azure Analysis Services. The demos will cover new features familiar to Power BI Desktop modelers such as Power Query integration. Various modeling enhancements will be included such as Detail Rows allowing users to easily see transactional records, and improved support for ragged hierarchies.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: Mercury / 81

SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Jupiter / 81

Walkthrough creating SSRS hosted Power BI with On-Premise Servers. 
-  Basic Setup of SSRS and Power BI preview on a development environment
-  Creating a Simple Dashboard
-  Publishing Report to SSRS
-  Highlight of currently available features and key capabilities not available
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Mercury / 81

The rapid surge in popularity of the Power BI product has empowered everybody to do more with their data. Come join this session to understand some Power BI best practices to ensure your reports and reporting architecture continue to perform and scale with demand!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Galileo / 270

Sessions Found: 36
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids