Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 69
This session will show a lot of things in the world of data that went very, very wrong... 
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"!
After a log day, come in and have some fun before the evening event starts
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 05

Time: 4:45 PM - 5:45 PM

Room: A

You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: H

This will be an introduction to the Always Encryption feature introduced in SQL Server 2016 . Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. There will be a survey overview of both the operations and development side of Always Encrypted. However, the main focuses will be  porting considerations, certificate management, integrating Always Encrypted into a Continuous Integration and Continuous Deployment (CI/CD chain) and using Azure Keyvault for increased certificate security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Double Session (120 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: Part 1

Date: October 05

Time: 2:15 PM - 4:15 PM

Room: G

Negotiating a downtime for a release can be difficult in this modern, 24x7 world.  When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly.  This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment.  We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking.  We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing.  If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: D

In this session we will compare the offerings of Azure SQL Databases, then dig in and show what separates SQL Managed Instances from the rest. We’ll take a look at challenges that previously prevented migrations to Azure, the current features available, some common architectures, and backup and restore options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and the Cloud

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: A

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? Are you facing pressure to have data in Azure as well? Help is here! This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database and Managed Instances, and how some or all of those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss frequently seen scenarios from the field covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration / Infrastructure

Level: Beginner

Session Code:

Date: October 05

Time: 4:45 PM - 5:45 PM

Room: E

This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS, such as 2008 or earlier versions, with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components. We will next show you how to enable the following scenarios: running SSIS packages stored in file shares as first-class activities in ADF pipelines, accessing Azure SQL DB/Managed Instance with OLEDB/ADO.NET connectors configured for Azure Active Directory authentication with ADF managed identity, configuring SSIS IR to access data on premises using Windows authentication and Virtual Network injection/Self-Hosted IR as a proxy, running/debugging SSIS packages in ADF from SSDT, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe command line utility, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes)

Track:
Data Ware House Development / ETL / SSIS

Level: Advanced

Session Code:

Date: October 05

Time: 4:45 PM - 6:00 PM

Room: F

Embarking on building a modern data warehouse in the cloud can be an overwhelming experience due to the sheer number of products that can be used, especially when the use cases for many products overlap others. In this talk I will cover the use cases of many of the Microsoft products that you can use when building a modern data warehouse, broken down into four areas: ingest, store, prep, and model & serve. It’s a complicated story that I will try to simplify, giving blunt opinions of when to use what products and the pros/cons of each.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Ware House Development / ETL / SSIS

Level: Beginner

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: L

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 4:45 PM - 5:45 PM

Room: H

Its easy to build a Centralized Dashboard for all your Server's Agent Alerts that can monitor all your Servers. In 60 minutes we will create a Dashboard using SQL Agent, Powershell and SSRS that is easy-to-maintain and deploy.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration / Infrastructure

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: H

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Machine Learning / AI

Level: Beginner

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: K

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including: 

1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Machine Learning / AI

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: K

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: I

SQL Server 2017: With the vast amounts of data in today’s business warehouses, there has been increased demand on the Business Intelligence solution developer to produce more complex and all inclusive reporting facilities. More complexity, coupled with being all inclusive tends to yield more points of failure.In this hands on presentation we shall be examining new and innovative ways of rendering the required data in some unusual ways.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Ware House Development / ETL / SSIS

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: C

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage.  As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances.  In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources.  We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down.  Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 2:15 PM - 3:15 PM

Room: D

Are your database releases time-consuming, complicated, and exception-driven?  Do you wish you could deploy just a few of the changes from database 1 to database 2?  Does your boss say “we should do more of this DevOps stuff”?  Time to think about automation.

Keeping your “desired state” database in version control is the first step toward easy, repeatable deployments.  When your database contains exactly what it’s supposed to, there’s no such thing as “but it worked in Dev.”  And that’s just the beginning.

Join Larry Blake and Shantan Kallu from Teach for America to learn how they created custom Jenkins pipelines to automate deployments, run unit tests, introduce code review approval steps, manage logins, and more.  No Jenkins knowledge is assumed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 4:45 PM - 5:45 PM

Room: G

The database is sometimes one of the last areas considered when planning DevOps for new and existing projects. If you are new to Azure Pipelines or Database Projects in Visual Studio this presentation will show you how to combine these technologies to create a consistent database deployment across all your development environments. If you are already using Azure Pipelines and Visual Studio for your applications, you will learn how to include your database. We will go over creating a database project and deploying a Dacpac manually to multiple environments. I will point out things to consider and how to add custom deployment scripts and build validation. Then we will setup an Azure DevOps account and step through creating a pipeline to automatically deploy a data project stored in a git repository. We'll also use Key Vault to store the deployment credentials to avoid sharing around that password everyone uses to deploy manually.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:45 PM

Room: E

Would you like to increase your AG functionality and make it work cross-domains? Would you like your AG to receive data from other AG? In this section lets dive into the basics of the Distributed AGs, what they can do for you and what kind of scenarios we can apply them to.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration / Infrastructure

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: F

An essential part of migrating your application workload to the cloud is how to transfer your data securely to its new home. If you in addition want to change the underlying database system, for instance Oracle to SQL Server, it can quickly escalate to an overwhelming task. What if your application have a very high uptime requirement and your database is so large that you don't have a downtime window long enough to do a traditional backup/restore operation?
In order to overcome these pain points we have now available, both in Azure and AWS, services and tools that alleviate these pains and brings your valuable data safely across with near-zero downtime.

In this talk we will:
- Guide you through how to set up a migration process with checks and balances
- Compare the schema analysis and conversion tools provided by AWS and Microsoft
- Compare the migration services provided by AWS and Azure
- Demonstrate near-zero-downtime migration for a live database on AWS and Azure
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data and the Cloud

Level: Intermedia

Session Code:

Date: October 05

Time: 2:15 PM - 3:15 PM

Room: K

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?  This presentation will review the following techniques to fix your woes.

Techniques:
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: J

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