Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 44
This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: February 08

Time: 1:50 PM - 2:50 PM

Room: World's Fair

Microsoft's modern data warehouse strategy is centered around their latest generation of Azure Data Lake - it is the hub for Azure Synapse Analytics and more. This session will dive into Azure Data Lake generation 2 (ADLSg2) and provide an introduction to the technology. We will discuss a number of topics including: what is new with gen 2, how is ADLSg2 different than standard Azure Storage, how is security applied and managed, what APIs and SDKs are available, how does it fit into the larger picture, and what is the current state and where is it going. The session will also provide tips and tricks to help you get started and be more successful.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehousing

Level: Beginner

Session Code:

Date: February 08

Time: 10:20 AM - 11:20 AM

Room: Wright

Is your data lake a bit more like a swamp? Are your business analysts nearly drowning when you throw them into the deep end of the lake? 
In this session, you'll see how to use Azure Data Explorer to create a more structured interface on the files in your data lake, so that your business analysts can consume it much more easily from tools like Power BI. 
Azure Data Explorer (ADX) is a service that adds a query engine to various types of data, including raw files in a data lake. We'll look at the two ways you can add some structure and visibility to your data lake files using ADX, to eliminate the need for your data consumers to know the location and type of files in the data lake, and to add context such as entity names and data types. With a very small amount of simple code, you can add this structure to your data lake files and let the business analysts focus on the data. 
This session uses Azure Data Explorer and Azure Data Lake Storage (ADLS gen2) as well as a bit of Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Delivery

Level: Beginner

Session Code:

Date: February 08

Time: 12:40 PM - 1:40 PM

Room: Gateway Arch II

You're going to learn how to design an Ingestion Framework capable of scaling multiple sources without additional pipelines to populate Azure Data Lake. We will walk through Ingestion Strategy, the Ingestion Model, and the Ingestion Pipelines that fully automate data lake ingestion.

Ingestion Strategy - First, we will lay the foundation for best practices when it comes to ingesting data and storing data within Azure Data Lake. 

Ingestion Model - Second, we will learn how to design a metadata model framework built using Data Vault techniques to capture and store data from across the business.

Ingestion Pipelines - Finally, we will build two Data Factory pipelines that read from the framework and does that actual data ingestion, these are built so that we only ever have to build these two pipelines when scaling to a new source type.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehousing

Level: Advanced

Session Code:

Date: February 08

Time: 4:10 PM - 5:10 PM

Room: Wright

Would you like to create Pivot Tables in SQL with ease? 

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: February 08

Time: 3:00 PM - 4:00 PM

Room: Gateway Arch I

Power BI DAX and checking performance and adjust for faster, more accurate results.

We will cover:

•                  Calculate and advanced Switch True 
•                  Variables
•                  Tools- the where, how to connect, and basics to look for 
•                  Modeling Considerations and DAX for relationships

As data and models become more advanced, there are performance pitfalls that are easy to fall into when weighing the ever important 'Can I' vs 'Should I'. I am happy to share the learning resources I used to overcome these and how I fixed the many mistakes that I made along the way.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: February 08

Time: 9:10 AM - 10:10 AM

Room: Gateway Arch II

In today’s environment, more and more companies are finding that they need to capture the activity on their SQL Server instances. SQL Server Audit is a tool built into SQL Server that is designed to fill that need. With this tool, a DBA can capture nearly any action taken on a SQL Server, even some that cannot be captured by any other method.

In this session, we’ll take a detailed look at the capabilities of SQL Server Audit, how to configure it, and how to use the data it produces. We’ll also look into the areas where SQL Server Audit falls short and how to supplement it with other SQL Server tools to provide a complete auditing solution.

This session is part of the Data Security Learning Pathway. For more information please visit our Learning Pathways page.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: February 08

Time: 12:40 PM - 1:40 PM

Room: Gateway Arch I

Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server.  Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.

Bad SQL coding practices are known in the SQL community as “code smells”.  Sign up for this hour-long workshop where you will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: February 08

Time: 4:10 PM - 5:10 PM

Room: Gateway Arch I

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over 100 times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: February 08

Time: 1:50 PM - 2:50 PM

Room: Gateway Arch I

Databricks Delta is the new standard for building a data lake as a part to your data warehouse. In this sessions we will learn how we can automate the development and ETL of a Data Hub\PSE in Databricks Delta that can process 1000's of tables with minimal code.

Agenda:
 - Data Lake Design and the Modern Data Warehouse
 - Databricks Delta 
 - Automating Databricks Delta
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehousing

Level: Intermedia

Session Code:

Date: February 08

Time: 12:40 PM - 1:40 PM

Room: Ead's Bridge

Leverage the power of Kubernetes, Docker, and Open Source all within your own Azure environment. With Cloudera Data Warehouse, data warehousing is made easy. You no longer need to worry about noisy neighbors and unreliable SLA's. Save cloud costs with auto-scaling both up and down all while owning your data in a secure and governed environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehousing

Level: Intermedia

Session Code:

Date: February 08

Time: 12:40 PM - 1:40 PM

Room: World's Fair

Database development often lags behind modern Agile application development Continuous Integration and Delivery practices because it's harder. Unlike application changes, delivering database changes requires not only apply schema changes but preserving data as well.

This session will discuss guiding principles, strategies, and explore practices and tooling to support database development in the world of CI/CD. Common Agile development scenarios will be covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Delivery

Level: Intermedia

Session Code:

Date: February 08

Time: 9:10 AM - 10:10 AM

Room: Wright

Data is all around us. From calculating projections to influencing meaningful decision-making, the impact data has on the way we live and work is increasing rapidly. But, what does this mean for data processes and the business world as a whole, when not everyone has a seat at the table? During this presentation, LaShana Lewis will outline the importance of diversity in business and how you can consider data through the lens of diversity and inclusion, using your skills as a data professional to raise awareness and make lasting change.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: February 08

Time: 11:30 AM - 12:30 PM

Room: Gateway Arch I

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 of the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then  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 free 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:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Advanced

Session Code:

Date: February 08

Time: 4:10 PM - 5:10 PM

Room: Gateway Arch II

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBAs continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then, it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more.  We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: February 08

Time: 9:10 AM - 10:10 AM

Room: Gateway Arch I

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: February 08

Time: 3:00 PM - 4:00 PM

Room: Ead's Bridge

Many DBA's have the same outlook on Powershell - we all know we should use it, but we don't think we have time to learn one more tool that isn't even really part of SQL Server anyway.  I was one of these DBA's for many years, but recently I have come to respect the *power* of Powershell.  Come learn the basics of Powershell, how Powershell and SQL Server interact with each other, and finally how to use Powershell to automate common SQL Server tasks such as maintenance and SQL Server installations.  If you need to interact with Windows or Active Directory, odds are Powershell is the right tool for the job - come learn how to use it!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: February 08

Time: 10:20 AM - 11:20 AM

Room: Busch Stadium

Some say database containers are the future of database virtualization. I largely agree with that, at least for some scenarios. 

This session will review fundamental container architecture and concepts, discuss database containers use cases, and demo image and container management with Docker.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: February 08

Time: 3:00 PM - 4:00 PM

Room: Busch Stadium

This sessions will provide an introduction to Power BI Desktop and the Power BI Service. 
With Power BI Desktop, we will import data from several sources, then perform some cleanup and transformation of the data. We will build a model from the data and then some visualizations of it. Then we will publish the model to the Power BI Service and build a dashboard from it, then look at how it can be used in collaboration scenarios and distribution in your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: February 08

Time: 8:00 AM - 9:00 AM

Room: Gateway Arch II

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them. 
They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. 
Attend this session to learn how T-SQL windowing functions apply to many real world examples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: February 08

Time: 4:10 PM - 5:10 PM

Room: Busch Stadium

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