Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 36
Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 24

Time: 9:40 AM - 10:40 AM

Room: 114

"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 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 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:
Double Session (120 minutes) (120 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 24

Time: 10:50 AM - 12:50 PM

Room: Auditorium

The debate regarding the relative merits of extract transform load (ETL) and extract load transform (ELT) data migration strategies isn’t new, but it remains relevant. Making the right choice is critical, because the wrong solution will slow development cycles and execution times, and increase the cost and complexity of code maintenance.  In this presentation, I’ll cover some best practices for implementing an ELT solution for a variety of data migration scenarios.  Data enthusiasts of any level will benefit from a detailed discussion of methodologies, strategic benefits, and code examples.  The discussion will focus on the SQL Server stack including Azure and code examples will use T-SQL and SSIS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Design & Architecture

Level: Beginner

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 112

The ""Cloud" is here.  With it, there are many options for storing and processing data.  What does it mean?  Why should you be interested in this conversation?  How can a cloud solution compare to an "on-prem" solution?  We will discuss these questions and more. The focus of this session will be on the options available in Azure from Azure SQL DB to Azure SQL Data Lake, but we will also touch on AWS and Google Cloud options to put the options in context.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 111

Is your SQL Server instance running at its peak performance level?  Probably not but the real question is do you know why? Is your disk subsystem too slow or are you lacking enough CPU’s or is it something else entirely? It is very easy to capture and analyze the file & wait stat information that is automatically collected by the SQL Server instance so why not utilize them. We will see how you can stop chasing your tail and focus on which area of SQL Server performance bottlenecks are doing you the most harm. This should be part of every DBA’s arsenal so come make it part of yours as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Internals & Performance

Level: Beginner

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: Auditorium

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 24

Time: 3:00 PM - 4:00 PM

Room: 111

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting.  This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 24

Time: 9:40 AM - 10:40 AM

Room: Auditorium

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Design & Architecture

Level: Intermedia

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 113

Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Advanced

Session Code:

Date: March 24

Time: 3:00 PM - 4:00 PM

Room: 144

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition.  Unfortunately the database is commonly considered a bottleneck.  Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver.  Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: Auditorium

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (SSAS, SSIS, SSRS, PowerBI)

Level: Intermedia

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 143

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 113

Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Internals & Performance

Level: Intermedia

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 113

Well-instrumented code not only helps others with troubleshooting our code but it also helps with performance analysis and provides a good audit of runs over time. In this session we will explore a small framework for TSQL Logging that is easy to use and generic enough to fit simple and advanced use-cases. We will see how we can track messages, errors & duration of runs by code type without intruding on the functionality of common/shared code and how this functionality may be shared across databases with a single code base. Tying DMV’s to business logic side of what is in-flight, is covered. All of the code will be available for use in your own projects. Let us see how you can get your code instrumented on
Day 1!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 111

This session is a very basic introduction to Integration Services (SSIS).  We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time.  We’ll talk about packages, connections and project parameters and their respective tasks/properties.  We’ll also cover some basic performance tuning to make your packages run faster.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes) (75 minutes)

Track:
Business Intelligence (SSAS, SSIS, SSRS, PowerBI)

Level: Beginner

Session Code:

Date: March 24

Time: 10:50 AM - 12:05 PM

Room: 144

Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a  flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AzureML experiment. Join me to see how AzureML might meet your advanced data analysis needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Intermedia

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 144

Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 114

Polybase is Microsoft's newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage.  In this talk, we will get an overview of the Polybase technology and then implement it to work with an on-premises Hadoop cluster as well as Azure Blob Storage.  We will then dive into the mechanics of how Polybase works, using packet captures to understand the cross-network communication.  Finally, we will look at ways of tuning common Polybase scenarios and look at a few less-common scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 143

Power Query is a great tool for extracting, transforming, and loading data.  It has an intuitive interface that allows you to create queries without having to worry about writing code. Under the covers Power Query is creating the M code that gets executed. In this session we will pull back the covers to reveal and understand the M code that is being created. This will give you greater insight into how to debug your queries. In addition, we will look at creating advance queries that go beyond what is available using the Power Query user interface.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence (SSAS, SSIS, SSRS, PowerBI)

Level: Intermedia

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 114

Relational databases have their strengths.  Ironically data relationships are not one of them.  Graph databases excel in this department using nodes and edges.  They are optimized to find and view relationships using graph theory.

One of the best new features of SQL Server 2017 is the Graph Database!  It brings us the best of both worlds in one easy platform!  Come learn about the history of graph databases, how they work and why you should be using it!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 24

Time: 3:00 PM - 4:00 PM

Room: 114

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