Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 50
Whether designing moderate-scale reports for a few business users or large-scale solutions with loads of data for an entire corporation, this session provides best practice guidance for the essential components of Power BI projects. Power BI is a very flexible platform with an vast range of options and often overwhelming design choices. We will discuss recommended practices to manage datasets and reports for team collaboration, version control, query optimization for scale, data modeling design patterns, measure design, dataset certification and governance. We will conclude with a complete checklist of important items to ensure project success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Visualization and Reporting Strategies

Level: Intermedia

Session Code:

Date: April 04

Time: 8:30 AM - 9:30 AM

Room: Hall 2

Data Science is currently the hottest topic among data analysts and technologists, but getting started can sometimes be daunting or confusing to many data professionals.  We aim to change that with this full-day, hands-on course in which you will be introduced to data science and its basic methodologies using the Python programming language!

Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  We'll cover collecting and importing data, and introduce basic statistics around our data.  We'll then move on to create some simple visualizations of our data to help us identify trends and patterns.

Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Python installation.  Full details on this will be provided prior to the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
All Day Precon (420 minutes)

Track:
Advanced Analytics, Machine Learning and AI

Level: Beginner

Session Code:

Date: April 04

Time: 9:45 AM - 4:45 PM

Room: Room 5

Over a decade ago Microsoft added the capability to store and work with geometry and geography data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things. 

Come to this session to learn about: 

? The two elusive data types (geography and geometry) 
? T-SQL Spatial routines and functions 
? How to load spatial data 
? Where you can get lots and lots of free spatial data to supplement your existing systems 
? See an example of real-world Spatial data in use (aggregating truck positions for tax calcs) 
? Write a SQL query from a bitmap picture (pure amusement)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development and Advanced T-SQL

Level: Intermedia

Session Code:

Date: April 04

Time: 1:20 PM - 2:20 PM

Room: Hall 3

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in or currently using Power BI? Do you you have a need for Analysis  Services but don't want to have to deal with the hassle of buying and installing a server? Are you dreading having to upgrade your hardware for your current SSAS Tabular instance?  Is your organization using Office 365?  If you answered yes to any of these questions, you might need Azure Analysis Services.  The wait is over! Azure Analysis Services is the platform as a service version of the wildly popular Analysis Services Tabular product. 

This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Beginner Track - T-SQL, DBA, Cloud, ETL or BI

Level: Beginner

Session Code:

Date: April 04

Time: 1:20 PM - 2:20 PM

Room: Room 3

What is Data bricks and how will help your company? 

In this session we will answer these questions , we will set up a brand new Azure Data bricks work space, connect to azure data lake storage and azure sql dw storage.

Then we will go through setting up Azure key vault. 
We will show how to run multiple examples of quick setup notebooks.
Discussing how to implement and run your clusters.
We will take a look at the new Data bricks Delta Lake functionality and how it will improve your large ELT implementations. 

Lastly, we will orchestrate these notebooks via Azure Data Factory V2.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Beginner Track - T-SQL, DBA, Cloud, ETL or BI

Level: Beginner

Session Code:

Date: April 04

Time: 1:20 PM - 2:20 PM

Room: Room 2

In this session we will automate the creation and deployment of a Modern Data Platform environment using DevOps, Continuous Integration and Continuous Delivery.

We will:
* Use Infrastructure as Code to create Azure Databricks,  Azure Data Lake Storage and a SQL Data Mart contained in a virtual network.  
* Automate the configuration of the environment, including creating Databricks clusters, deploying notebooks, configuring jobs, managing users, workspaces, security etc.
* Create repeatable Continuous Integration/Continuous Deployment (CI/CD) pipelines using Azure DevOps
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Data Development & Deployment

Level: Intermedia

Session Code:

Date: April 04

Time: 1:20 PM - 2:20 PM

Room: Room 5

SSIS is a great product, but making changes to many packages at a time is both time-consuming and mundane. 

In this session I'll show you how I am using BIML and Excel to create a metadata-driven environment, eliminate repetitive SSIS development tasks and dramatically speed up the time it takes to create and change SSIS packages.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 04

Time: 8:30 AM - 9:30 AM

Room: Room 2

I don't want to train you, I want to teach you how to think about SQL Server performance. 

You've already searched the internet high and low to figure out why your queries are slow, and you've read the same advice over and over again. That's just not cutting it anymore, and you're ready for the next level. This is the class you need to get there. 

You'll learn new and different approaches to common performance problems, how to figure out what's going on in your query plans, and how indexes really work. This is cutting edge stuff you can't find in normal training.

If you're anything like I was, you've had it with stumbling through your work week, unsure if you're focusing on the right things. You'll walk out of the class knowing how to find and fix your worst performing queries.

Anyone can have a plan, it takes a pro to have a blueprint.
Speaker:

Accompanying Materials:

No material found.

Session Type:
All Day Precon (420 minutes)

Track:
Database Development and Advanced T-SQL

Level: Advanced

Session Code:

Date: April 04

Time: 1:20 PM - 8:20 PM

Room: Hall 3

Your query returns the correct results, but even with supporting indexes it seems slow. Can it go any faster? In this session, we focus on T-SQL query antipatterns – commonly used techniques that are unintentionally counter-productive. Through an interactive story of user requests, we identify several antipatterns, examine what makes them troublesome, and show alternative methods to improve performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Beginner Track - T-SQL, DBA, Cloud, ETL or BI

Level: Beginner

Session Code:

Date: April 04

Time: 2:35 PM - 3:35 PM

Room: Room 2

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, Databricks, and SQL Server.

This session will be an introduction to the Python language including: 
1) Installing and Configuring Python
2) Accessing and Manipulating Data
3) Installing and Managing Packages
4) Creating and Using Objects/Variables
5) Controlling Flows and Functions
6) Controlling Flows and Functions 6) Python in MS Power BI, Azure ML, MSSQL, and Databricks. 

Attend this session to learn how Python can 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 learn some basic data science fun
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics, Machine Learning and AI

Level: Beginner

Session Code:

Date: April 04

Time: 11:00 AM - 12:00 PM

Room: Room 5

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 04

Time: 12:00 PM - 1:00 PM

Room: Room 3

Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time in trying to fix them. 

In this presentation, I will share my tried and true best practices for tuning SQL statements and other issues by utilizing Wait Time Analysis, reviewing execution plans and using SQL diagramming techniques. In addition, several case studies will be used to demonstrate these best practices.

Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases.

Learning objectives:
•	Learn how to effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach
•	Quickly identify inefficient operations through review of query execution plans
•	Learn how
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Beginner

Session Code:

Date: April 04

Time: 2:35 PM - 3:35 PM

Room: Hall 3

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017/2019 and Azure SQL DB/DW with predicate based RLS and in Power BI, as well. This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations. 

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development and Advanced T-SQL

Level: Beginner

Session Code:

Date: April 04

Time: 8:30 AM - 9:30 AM

Room: Hall 1

We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement third-party tools like MelissaData and CozyRoc
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 04

Time: 11:00 AM - 12:00 PM

Room: Room 2

Not everyone has a full time Database Administrator on staff, and in many cases the responsibility of managing the database server falls on you, the Developers or System Admins.  But as long as the backups are running successfully you're good, right? Not exactly. Has your SQL Server been tuned to fit your workload, or are you still running with the less optimal default settings? When was the last time your databases were checked for corruption? Are your statistics out of date? Are your indexes fragmented? These are things that DBAs look for, and you should too!

Tailored to the "Non-DBA", this session will cover these topics and more to ensure that you can avoid some performance issues you may not even realize you're having.  Discussing server settings, database configurations, and recommended maintenance, you will leave this session with the knowledge (and scripts!) you need to help ensure that your SQL Server and databases are in top shape.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Intermedia

Session Code:

Date: April 04

Time: 8:30 AM - 9:30 AM

Room: Room 1

The Query Store houses valuable information on performance of your queries, as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what's new in the 2017 Query Store, the new adaptive query processing features, and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You'll learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits that caused them. Both DBAs and developers can increase their performance-tuning skills by attending this session.

You will learn:

How to quickly find plan changes and analyze performance issues
How to use the new wait classifications in order to get clues on how to tune your statements
About the new adaptive query processing features and SQL Operation Studio
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Beginner

Session Code:

Date: April 04

Time: 9:45 AM - 10:45 AM

Room: Room 1

Data Discovery and Classification introduces a new set of services that can be used by customers to discover and classify sensitive data. Data security is becoming more important. The classification tool scans your database and identifies potentially sensitive data. Once you have the data identified, you can label the columns. You will be able to audit and report on the classified data for auditing purposes. During this session, we will walk through the steps required to run discovery and eventually audit the sensitive data in your database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Intermedia

Session Code:

Date: April 04

Time: 11:00 AM - 12:00 PM

Room: Hall 3

This session will cover the following topics:
1) Walk through the steps SQL Server takes when executing a query
2) How to generate and read an execution plan
3) How to troubleshoot a query using the execution plan

Session content assumes an ability to do basic queries against a database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Beginner Track - T-SQL, DBA, Cloud, ETL or BI

Level: Beginner

Session Code:

Date: April 04

Time: 3:50 PM - 4:50 PM

Room: Hall 2

When you see those little green checkmarks, then you know your new SQL Server instance is ready to go, right? Not exactly. Your fresh installation has some questionable default settings that could cause headaches and heartburn in the future. In this session, we identify several instance and database defaults that could lead to disaster, and discuss how you can modify them to improve performance and avoid unnecessary problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Beginner

Session Code:

Date: April 04

Time: 3:50 PM - 4:50 PM

Room: Room 4

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support starting in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.

In this session we’ll discuss some basics of dealing with time in a database, how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server, and how to write “time travel queries” using the FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration & Tuning

Level: Intermedia

Session Code:

Date: April 04

Time: 2:35 PM - 3:35 PM

Room: Room 1

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