Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 54
"Just because something works doesn’t mean it can’t be improved." Shuri, T’Challa’s sister and a technological wizard, has this foundational quote in the movie that ties the cinematic marvel to the technology industry in a fun and challenging way. This session breaks down what we can take away and some ideas on how to apply these principles to lead our teams, products, and industry into the next chapter.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 11

Time: 2:15 PM - 3:15 PM

Room: 145

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

Level: Beginner

Session Code:

Date: August 11

Time: 3:30 PM - 4:30 PM

Room: 136

Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.
In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 140

In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.

The High-Altitude SQL Server Project, or HASSP, is one such project.

The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!

In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 9:30 AM

Room: 137

So you've done traditional BI for some time, but now you and your company know it's time to dig into advanced analytics. The big question is, with so many data science platform options available, which one is the right one for us?

In this session we dive into the available platforms listed below and provide a brief summary, strengths and weaknesses, scale capabilities, and last but not least, pricing/licensing.
•	Microsoft R Open
•	Microsoft R Server
•	R and Python Services for SQL Server 2017
•	Azure Machine Learning Workbench
•	HDInsight (with Spark)
•	Microsoft Data Science VM

If you're looking to maximize and optimize your data science platform of choice, be sure to attend.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 141

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

Session Code:

Date: August 11

Time: 1:00 PM - 2:00 PM

Room: 143

Sometimes a data professional will find themselves in need of a large demonstration data set.  However, non-proprietary options are few and usually lacking.  This session will educate attendees in how to get around these obstacles by creating their own data.  We'll talk about the process of using real-world variability, creating inconsistency that leads to insight using some basic statistical concepts, the process of putting everything together, and getting the data set into SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 11

Time: 1:00 PM - 2:00 PM

Room: 144

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 11

Time: 2:15 PM - 3:15 PM

Room: 143

Although they have been around since SQL Server 2005, Common Table Expressions (CTEs) have been a complete mystery to many.  As a result, there are many misunderstood myths and assumptions surrounding them. This session will explore deep into CTEs, what they are, what they are not, and how they work.  We'll look at situations where they can really help improve not only code clarity but also performance especially when compared side-by-side to usual methods.  We'll also identify situations where CTEs can be used incorrectly causing hidden performance problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 11

Time: 8:00 AM - 9:00 AM

Room: 143

Just like pilots who are prepared for disaster recovery through regular practice, we as Database Administrators need to actually spend time practicing recovering with those backups. Ransomware has made it critical to prepare to rebuild your datacenter at any moment. This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 11

Time: 8:00 AM - 9:00 AM

Room: 109

The 'recently' introduced PowerApps visual for Power BI allows us to greatly extend the capabilities of our reports. In this talk we will cover the basics of PowerApps, from pricing to capabilities. We’ll also cover some potential use cases for adding PowerApps to your Power BI reports, and see some of those use cases demonstrated. Finally, we’ll walk through the whole process of building and deploying a PowerApp to a Power BI report.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 11

Time: 3:30 PM - 4:30 PM

Room: 144

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience.  The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. 
We’ll learn:
1.    Linux history and concepts.
2.    Important differences between systems
3.    Crucial commands to get around 
a.    Navigating, searching and managing
b.    Monitoring, tracing and updating
c.     Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 136

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way. 

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 11

Time: 1:00 PM - 2:00 PM

Room: 145

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 11

Time: 8:00 AM - 9:00 AM

Room: 140

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group.  Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover.   We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 140

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: August 11

Time: 2:15 PM - 3:15 PM

Room: 136

Do you have large amounts of data which you want to leverage to predict the answers to difficult questions?  The seemingly new field of Machine Learning (ML) has been around for almost 60 years, with this exact goal in mind. 

In this session, you will be introduced to the fundamentals of ML, to get you started without requiring a mathematics background.  We will look at how to “frame” your data questions, as well as understanding the type of outputs ML can provide in responding with predictions.   Focus will be placed on the high-level overview of the ML process, and spend time on the simple steps of determining the “right” algorithm to use.  Tools used include Weka and Azure ML Studio, but the focus of the session is on fundamentals and the ML process, not specific toolsets.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 144

Starting in SQL 2016, two rivals entered the ring in a professional fight for format supremacy. XML seems too fat to compete with the newcomer JSON but a fight has begun.  JSON doesn't seem experienced enough to have real punching power but does it have the speed to win?  Who is the pound for pound format champion?  Come watch this action-packed bout between two titans of SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 11

Time: 3:30 PM - 4:30 PM

Room: 143

Hadoop seems to be in every conversation related to Modern Data Platforms and Initiatives, but it is amazing how many people say it like it is thing. This talk will introduce the various components that can make up a Hadoop environment and discuss the differences between the different distributions of this technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 11

Time: 8:00 AM - 9:00 AM

Room: 141

Microsoft says Azure Cosmos DB is a globally distributed, multi-model database.  Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”.  The fundamental purpose of this session is to answer those very questions.  After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB.  Upon completion of this session you will be better equipped to discuss the value of CosmosDB to your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 11

Time: 2:15 PM - 3:15 PM

Room: 140

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