Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 60
"As is commonly the case, all good things come to an end.  And now is as good a time as any for the use of SQL Trace and Profiler to come to an end.  Let’s face it, Trace was a good tool and had some wonderful uses.  Profiler for that matter was a good tool and was useful at times.
It is time to let those old tools retire gracefully and move into the world of XE.  This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE.  Take advantage
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 3:30 PM - 4:30 PM

Room: 6-102

This is a deep dive into the data compression features in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in your production systems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 25

Time: 10:00 AM - 11:00 AM

Room: 6-207

By leveraging advancements in statistical computing and the large volumes of data generated by businesses today, Advanced Analytics empowers business users to make more strategic decisions that can help to reduce costs or increase profit. By utilizing relationships in historical data, predictive analytics and other machine learning algorithms can model future predictions and enable the business user to more accurately prescribe solutions. In this session, Karla will demonstrate a step-by-step process needed to implement an Advanced Analytics solution into a current data strategy. This includes statistical modeling methodology and techniques, but will also take a deeper dive into a few use cases and the data surrounding these models.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 25

Time: 11:15 AM - 12:15 PM

Room: 6-206

As an unsupervised learning algorithm, market basket analysis/association rule mining has its advantages over other predictive analytics techniques. As a deeper dive into the algorithms, models, and tools used in machine learning tasks and how they change today’s business world, in this session, Ying will explore several business scenarios where market basket analysis can make a huge impact and present demos built with R, Azure ML, Tableau, and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: March 25

Time: 2:15 PM - 3:15 PM

Room: 6-302

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 25

Time: 10:00 AM - 11:00 AM

Room: 6-206

Massively Parallel Processing (MPP) architectures allow the use of large numbers of processors (or computers) to perform a set of coordinated computations simultaneously.  MPP architectures can help with the processing and aggregation of large volumes of data with varying shapes, but can be complicated and costly to deploy and maintain.  We'll explore using the Microsoft Azure cloud as a platform for quickly creating cost-effective MPP solutions.  We will use Microsoft Azure to deploy and process data with a Hadoop based MMP architecture (using HDInsight).  The pros and cons of Hadoop based MPP, as well as when a company might choose a Platform-as-a-Service (PaaS) offering over an Infrastructure-as-a-Service (IaaS) solution.  This talk will be packed full of demos and real-world learnings.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 10:00 AM - 11:00 AM

Room: 6-302

Massively Parallel Processing (MPP) architectures allow the use of large numbers of processors (or computers) to perform a set of coordinated computations simultaneously.  MPP architectures can help with the processing and aggregation of large volumes of data with varying shapes, but can be complicated and costly to deploy and maintain.  We'll explore using the Microsoft Azure cloud as a platform for quickly creating cost-effective MPP solutions.  We will use Microsoft Azure to deploy and process data with a SQL based MMP architecture (Azure SQL Data Warehouse).  The pros and cons of SQL based MPP will be discussed, as well as when a company might choose a Platform-as-a-Service (PaaS) offering over an Infrastructure-as-a-Service (IaaS) solution.  This talk will be packed full of demos and real-world learnings.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 11:15 AM - 12:15 PM

Room: 6-302

Join me in a presentation on how to create your Azure environment for Data and Analytics.
- creating Azure resources
- population of data for POC
- creating a template to make POC a possibility (how to recreate on demand)  
- real world situations and lessons learned in Azure situations 
- consumption of that data through Power BI Embedded

This presentation will include creation of an Hybrid solution for Operational Analytics in Azure using Azure SQL DB, an historical Azure SQL DW and using Azure Analysis Services to create the ultimate Data and Analytics experience in the cloud.
Make the move from on prem BI solutions to an Azure Data and Analytics solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 4:15 PM - 5:15 PM

Room: 6-203

Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. We'll cover topics from monitoring, to high availability to disaster recovery, all within Azure SQL Database. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when, or if, you should use it within your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 1:00 PM - 2:00 PM

Room: 6-105

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 25

Time: 2:15 PM - 3:15 PM

Room: 6-303

Over the last few years Big data technologies like Hadoop  gained increasing popularity for processing and storing both structured, unstructured and semi structured data in the order of Peta Bytes or Zeta Bytes. A big data use case can help you solve a specific business challenge by using patterns or examples of big data technology solutions. Cloudera is an open-source Apache Hadoop distribution, CDH (Cloudera Distribution Including Apache Hadoop), targets enterprise-class deployments of that technology leveraging Big Data Applications. In this session Surya will explain the a few Big Data use cases and implementation using Cloudera.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: March 25

Time: 2:15 PM - 3:15 PM

Room: 6-105

Change Data Capture (CDC) was released with SQL Server 2008 and has been enhanced in several subsequent releases of SQL Server. Sever Stored Procedures were first provided to aid in using CDC with ETL and/or other CDC related processes. SQL Server 2012 included the release of the CDC Source and several other SSIS Task that greatly simplified the process of using CDC in your ETL. In this session, I want to share some of the creative uses I have seen involving CDC and hear about some of the things you have seen and or done with it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 25

Time: 3:30 PM - 4:30 PM

Room: 6-107

Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the data – only that which is new or changed since the last load. For that to work properly, there must be a reliable system for detecting delta data touched since the most recent load. 

In this session, we will review the tools and design patterns available in SQL Server for performing change detection. From source detection methods including change tracking and change data capture, to in-flight comparisons using hashed values, and even brute-force methods as a last resort, we’ll cover the spectrum of change detection tools in SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: March 25

Time: 3:30 PM - 4:30 PM

Room: 6-202

This session will use RevoScaleR  packages in Microsoft R to showcase the common linear and classification for machine learning, such as linear regression, logistic regression, etc. The presentation will also include the parameters or methods to create a good model as well as data visualization using PowerBI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 25

Time: 2:15 PM - 3:15 PM

Room: 6-206

This session introduces attendees to U-SQL, the new language created to combine the strengths of both SQL and C#. This powerful language can be used to query data which is stored in many different formats, including tab delimited , comma delimited files and JSON format.  Demonstrations will show how to write code using Visual Studio and query information stored in an Azure Data Lake.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 2:15 PM - 3:15 PM

Room: 6-202

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 25

Time: 10:00 AM - 11:00 AM

Room: 6-303

We've all installed SQL Server and, most of the times, the default settings work just fine.  This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server.  We'll also go through unattended installs, both with and without a config file.  This can really help to standardize your SQL Server installations and save you some precious keystrokes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 25

Time: 3:30 PM - 4:30 PM

Room: 6-207

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 10:00 AM - 11:00 AM

Room: 6-107

The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly.

In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 25

Time: 11:15 AM - 12:15 PM

Room: 6-207

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 25

Time: 1:00 PM - 2:00 PM

Room: 6-302

Sessions Found: 60
SQLSaturday