Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 35
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:

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

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:

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:

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:

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

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

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

Level: Beginner

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 114

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:

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

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:

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:

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:

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: 3:00 PM - 4:00 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:

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:

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

Graphs are everywhere!  Microsoft has added a lot of new features to SQL Server 2017, and among them SQL Graph has been one - one that holds a lot of promises, though it's still in its early stages (at least with Microsoft products).  Microsoft recently added Graph DB to their DocumentDB (product) and released it as Cosmos DB.  In this session, we'll take a look at what this feature brings to the table, and how it compares with other Graph databases.
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: 113

When disaster strikes, everyone's immediate question becomes: How long until the system is back online?  Whether it's a single database or the whole SQL environment, time is essential... As everyone waits on the restore to complete. 

How long will the restoration process take?  
Can it run faster? 

In this session, we'll answer these questions by looking at how to establish and maintain a Restoration Baseline and the options available for performance tuning database restores.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 24

Time: 1:50 PM - 2:50 PM

Room: 111

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