Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 35
Active/active operations deliver the greatest uptime and capacity. But technical challenges, data integrity concerns, and cost have limited deployment. Learn how to avoid the pitfalls and deploy most efficiently, with real-world case studies.

Get real-world advice on how to support active/active ops. You'll learn:
* pros and cons of building active/active into the app code
* how cloud infrastructure helps the cost model for active/active ops but can complicate your design
* reference architectures for successful customer implementations
* case studies of companies running active/active data centers 

Attendees attending the session will: 
•	Understand the application impact of building for active/active ops
•	Learn best practices for scaled out, distributed SQL Server clusters to limit the impact of database downtime on application availability
•	Get best practices from customers on enabling active/active operations across data centers
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: April 15

Time: 9:45 AM - 10:45 AM

Room: Gandalf

SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form of Availability Groups (AGs). This all sounds fantastic, but in reality there are issues and problems that are generally not discussed, or well known, that can impact your HA/DR story and cause major performance issues. In this session, I’ll give a brief overview on AGs in SQL Server 2012 and the enhancements that come in 2014 and 2016. Then we’ll get into some of the problems that exist, that I’ve seen in the real world of using AGs, and that you should be aware of before implementing it in your environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 15

Time: 11:00 AM - 12:00 PM

Room: Memphis

Either moving existing databases to Azure or designing a new SQL centric solution on Azure, availability and connectivity of Azure SQL Database is always a fundamental key requirement. We’ll share in the session best practices of designing highly available SQL Databases in the context of cross region deployment; how to make your application robust to handle transient connectivity issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 15

Time: 8:30 AM - 9:30 AM

Room: Utopia

Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries that really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an "intelligent datawarehouse".
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: April 15

Time: 2:45 PM - 3:45 PM

Room: Utopia

The updateable clustered columnstore in Microsoft SQL Server 2016 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional B-Tree based schemas.  This session assumes that you understand columnstore technology basics. We will do a deep dive into (a) strategies to load data leveraging minimal logging with concurrency (b) identifying/solving performance issues with queries (c) real-world best practices of keeping columnstore humming along.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 15

Time: 9:45 AM - 11:15 AM

Room: Denali

R Services brings the power of R and its 8000 packages to your data on SQL Server 2016, Hadoop and Teradata. This talk will explain Microsoft's R distributions, and will demo the packages in R Services that enable machine learning with big data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 15

Time: 11:00 AM - 12:00 PM

Room: Utopia

Anyone who has attempted to use the SQLPS module knows how lacking it is. Anyone who has attempted to use SMO to do things with SQL Server knows how frustrating and confusing it can be. There is a better way!
The open source DBATools.io project exists to provide a larger (and ever growing) set of commands for DBAs to use to manage, and gather data, from SQL Server.
Download the DBATools.io module and play along as we go through a few of the great commands on offer, and learn how you can contribute to a project working to change the way that you manage your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 15

Time: 11:00 AM - 12:00 PM

Room: Memphis

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: 

Asking the right questions to set yourself up for success
Making the case for stored procedures over ad hoc code and other objects
Pro tips for standardization and cross-version compliance
Reevaluating and expanding on your solution
Limiting inputs to reduce unexpected behaviors and errors
Choosing between alternate solutions
Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 15

Time: 1:30 PM - 2:30 PM

Room: Stinger

Do you want to make your SQL Server engine roar and make it one of the fastest in the planet? If so, then come to this session to learn about new enhancements and advanced tuning and diagnostic options available in SQL Server 2016 database engine. As hardware capabilities increase rapidly, knowing when to use these enhancements and configuration options is extremely important to scale SQL Server for the required application workload throughput rates. 
In the last couple of years, SQL Tiger Team has worked closely with many customers running Tier-1 mission critical workloads to scale their SQL Server with several configuration parameters and application patterns. In this session, you will hear directly from experienced members of the Microsoft SQL Server Tiger Team, about these specific enhancements, configurations, and approaches for scaling SQL Server on the largest hardware systems available in the planet.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 15

Time: 2:45 PM - 4:15 PM

Room: Denali

This session is an introduction to the spatial features in SQL Server. In this session, you will learn how to create, procure and leverage spatial data.  You will be made aware of tools you can use to integrate your own spatial data with a variety of public data sources such as the Census Bureau, National Weather Service, etc. Functions and T-SQL commands related to spatial data analysis will be demonstrated. We will end the session by using the geometry data type to actually mimic a bitmapped picture using SQL (that's the fun part!).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 15

Time: 11:00 AM - 12:00 PM

Room: Stinger

Power BI provides analytics solutions for your whole organization. Small Businesses can profit by exposing their data, and see the impact in their clients sites. I will introduce "Oil test Systems" a small business that tests oil in trucks. It's clients portal and the test data as other insights and recommendations, can be viewed by the clients using SharePoint 365. Performance dashboards are displayed using PowerBI, giving the business the opportunity for efficient decision making. The demo was built without code, every ITPro can do it!.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: April 15

Time: 8:30 AM - 9:30 AM

Room: Gandalf

In this session we’ll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We will cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 15

Time: 1:30 PM - 2:30 PM

Room: Denali

This session will cover High Availability and Disaster Recovery solutions for SQL Server on Linux. What technology options are available and how to build a highly available database solution on Linux? How will the various planned maintenance and unplanned downtime scenarios will work? We will discuss the design patterns and architecture blue prints for HA/DR for SQL Server on Linux, and will demo the solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 15

Time: 1:30 PM - 2:30 PM

Room: Memphis

Microsoft has announced graph capabilities in Azure SQL DB (currently in private preview as of Dec 2016). This session will cover the feature, typical use cases and learnings from early adopter customer engagements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 15

Time: 8:30 AM - 9:30 AM

Room: Stinger

Who has difficulty communicating the value of databases across their organization? Who wants to make more of a difference using database systems? Who is dissatisfied with their job and feels under-appreciated?

Welcome to my world. I've worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I've helped many organizations make millions of more dollars through my consulting efforts. I'd like to help you, too.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 15

Time: 1:30 PM - 2:30 PM

Room: Utopia

How many times has a lack of budget for hardware, training, or expert assistance caused problems for you in designing, implementing, and maintaining a great SQL Server environment?  Come to this session to learn effective ways to secure the budget you need instead of being consistently required to do more with less, or worse – nothing.  The good news is that there are several simple and practical things you can do to vastly improve your ability to get the budget you need when you need it.  You will hear how to think like an executive from someone who was one for many years so you can begin to influence decisions at the right level to get what both you and your SQL Server infrastructure need.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 15

Time: 2:45 PM - 3:45 PM

Room: Gandalf

With ever growing demand to store different types of data and provide intelligent analytics, it can be a challenging task for data professionals. Join this session to learn more about the on-demand scalable platform for big data analysis, Azure Data Lake, that allows you to use language that you are already familiar with. This session will show case an end-to-end demo using Azure Data Lake for image processing and text analysis.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 15

Time: 9:45 AM - 10:45 AM

Room: Utopia

JSON is a de-facto standard for machine-to-machine communication but also to store "liquid" data. Once a killer feature of NoSQL database, with SQL Server 2016 is now available also in a (post) relational environment.
But how it fits in the relational database space? How the usage of JSON can simplify DBAs and DEVs everyday work? What about performances? And what about flexibility? 
In this session we'll see how powerful JSON can be, when used correctly and not abused, providing solution to common problems 
(like in the well known "dynamic schema" case), simplifying development (for example to pass to Stored Procedure complex objects or variable numbers of parameters) with also very good performances, even if they maybe hidden in not-so-obvious places.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 15

Time: 9:45 AM - 10:45 AM

Room: Stinger

Powershell has become the defacto standard for scripting Microsoft products.  However, putting data in text files doesn’t scale.  Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections.  We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting.  This is a no holds barred session taught by an enterprise SQL Server scripting expert.  You can’t afford to miss this session if you do any level of scripting in your shop.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 15

Time: 2:45 PM - 3:45 PM

Room: Memphis

(full-day precon) 
In this Power BI hands-on Workshop, you will learning essentials and some advanced techniques to transform, model and analyze business information with this powerful platform.  Techniques and best practices presented are from several prior workshops and years of field experience.  Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis. Beginning and intermediate level users will learn to address data and reporting challenges with advanced design techniques.  At the conclusion of the workshop, you will have a complete solution built from real business data, shaped, cleansed & modeled; with a dashboard and interactive report visuals ready for analysis.
Topics & skills include: Power Query/M, modeling and calculations/DAX, standards & custom visuals, R visuals.  Data sources: CSV, JSON, SQL Server; query folding, scheduled refresh & DirectQuery.
Speaker:

Accompanying Materials:

No material found.

Session Type:
All Day Session (480 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 14

Time: 8:30 AM - 4:30 PM

Room: Paul

Sessions Found: 35
Back to Top