Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type


Sessions Found: 23
Preparing and defining ETL for insights is significant challenge for businesses today—ingestion, cleansing, transformation, and enrichment are labor-intensive and time-consuming tasks, which require deep technical skills. Power BI now introduces advanced data prep with dataflows—a suite self-service low-code/no-code features and capabilities for business analysts to easily process and unify their data and store it in Azure-based data-lake storage. With these new capabilities, Power BI offers a solution for any business need—whether you want to prep your data with ease, using a familiar built-in Power Query experience, or to leverage the full Azure stack for more advanced use-cases. Join this session to learn how to easily prep your data, leverage Microsoft’s standardized schema, improve time-to-value, eliminate data silos, and create one source of truth for your organizational insights.   This session will also finish with a look at some of the AI features that will be coming soon!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science and Artificial Intelligence

Level: Beginner

Session Code:

Date: February 23

Time: 10:00 AM - 11:00 AM

Room: Room 1

Finance is crying, a random SQL server is running slow, and now it's your problem.
How do you now go about looking for what the likely cause of the bad behavior might be?
You are an accidental/junior/mid-level DBA and now the pressure is on.
In this session we will look at Triage – where is it hurting, and how much is it hurting. We will touch on some techniques, tools and quick fixes that will buy you some more time and maybe even resolve the problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Beginner

Session Code:

Date: February 23

Time: 1:45 PM - 2:45 PM

Room: Room 2

There is a possibility to do Machine Learning in Power BI Service. This feature has been added recently to Power BI service. In this session, first, some concepts regarding machine learning and AI will be provided. For instance, the audience will learn what is Classification, Regression, Clustering, and Forecasting will be presented. Next, how we able to get data in Data Flow in Power BI service from blob storage, how to use Data Flow to clean the data, then how to apply machine learning to cleaned data will be provided.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science and Artificial Intelligence

Level: Intermedia

Session Code:

Date: February 23

Time: 11:00 AM - 12:00 PM

Room: Room 1

When it comes to security, we assume we know everything and have covered every aspect. But a lot of security implementations and nuances are not known by many. Come into this session to know the tips and tricks that you will need to know working with SQL Server Security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Intermedia

Session Code:

Date: February 23

Time: 2:45 PM - 3:45 PM

Room: Room 3

Today’s database professionals must be engineers, not just administrators. We build things. We create things. As engineers practicing devops, we are all in this together, and nothing is someone else’s problem. As engineers, we apply repeatable processes, established knowledge, and expert judgment to design, build, and operate production data stores and the data structures within. As database reliability engineers, we must take the operational principles and the depth of database expertise that we possess one step further.

Guiding Principles of the DBRE
* Protect the Data
* Self-Service for Scale
* Elimination of Toil
* Databases Are Not Special Snowflakes
* Eliminate the Barriers Between Software and Operations
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Beginner

Session Code:

Date: February 23

Time: 2:45 PM - 3:45 PM

Room: Room 2

2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes.  But while the analysis is important, the real value in the refresh.  Can your model pull in another 22 text files and next year's budgets in less than a minute?  This model can.
Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 23

Time: 12:00 PM - 1:00 PM

Room: Room 3

Traditionally, SSRS is used for paginated reports which gives flexibility like drill through reports, subscriptions and print formatting. With Power BI the reports are now more interactive and dynamic. There are still few gaps between these two platforms which are built to purpose. This gap is getting smaller as features are ported between these two platforms. In this session I will be going through various features which are bridging these gaps and point out the differences. These are significant and can affect your decision in choosing the right platform which will fit your needs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Beginner

Session Code:

Date: February 23

Time: 1:45 PM - 2:45 PM

Room: Room 1

If you are hesitating between choosing a Business Intelligence Solution in the cloud or on-premises, this session will provide you with the different options on-premises as well in Azure to take into account regarding your Business Intelligence architecture.

During the past few years we have been experiencing vast changes in the Business Intelligence space, not only related to data analytics, data modelling or applications, but also the importance of infrastructure.

In this presentation, I will explain how to get the best from both worlds.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Architecture & Design

Level: Intermedia

Session Code:

Date: February 23

Time: 10:00 AM - 11:00 AM

Room: Room 4

Are you managing your "chaos" environment but still can't move forward to start improvements and automation successfully?

Do you really know how is your SQL instance, permissions and servers configured and why you are still missing strong and persistence naming structure and standards? 

This session will be focusing on the Naming convention and standards in the infrastructure environment and how to apply it correctly, which also includes SQL Database objects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Architecture & Design

Level: Intermedia

Session Code:

Date: February 23

Time: 1:45 PM - 2:45 PM

Room: Room 4

Did you know the DAX language is far more capable than merely running a SUM over a column, or counting rows in a table? DAX sits on top of one of the fastest databases around, and this session will explore some unusual and creative scenarios that you previously would have thought as not possible using just DAX.

The session will aim to reset your understanding of what is possible in DAX by walking through some interesting code highlights from a recent series of games built using DAX (Blackjack, Sudoku , Tic Tac Toe , Hangman & Minesweeper). Each game pushes and explores different boundaries in DAX and will attempt to show just where those lines are.

The session will hopefully inspire you to add some creative and exciting techniques to your own DAX based data models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 23

Time: 2:45 PM - 3:45 PM

Room: Room 1

Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools.  But did you know that these tools also have their own query language?   In traditional databases such as SQL server, it is possible to extract data into a new table.  The same is possible using DAX as a query language with a tabular data model.

In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model.  Once connected, DAX studio can be used to write queries over the tabular data model to start to interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report).  The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 23

Time: 11:00 AM - 12:00 PM

Room: Room 3

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR - dedicated ADF servers for lifting & shifting SSIS packages - and extend it with custom/3rd party components. You can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice built-in data transformations in your ETL/ELT workflows, provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 23

Time: 10:00 AM - 11:15 AM

Room: Room 3

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life. 
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control.
Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Beginner

Session Code:

Date: February 23

Time: 2:45 PM - 3:45 PM

Room: Room 4

Azure Cognitive Services are APIs available to develop Intelligent applications. In this session you will get to know about the catalog of Azure Cognitive Services and learn how Cognitive Services makes it easy for developers to get started infusing AI into their applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science and Artificial Intelligence

Level: Beginner

Session Code:

Date: February 23

Time: 1:45 PM - 2:45 PM

Room: Room 2

Do you know if your development, test and production environments created were equally? 

How many SQL instances are you responsible for? Do you know if they are installed and configured consistently? If a dog ate your SAN, could you rebuild them 'by lunchtime'?

In this presentation we'll walk through a live demo using reusable community resources to automatically install, configure and verify the installation of SQL Server(s) that implement best practices using Powershell Desired State Configuration, dbachecks.io and other community resources.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Intermedia

Session Code:

Date: February 23

Time: 11:00 AM - 12:00 PM

Room: Room 4

SQL Server 2017 came out with GraphDB functionality. Graph database is a really important technology, and SQL 2017 is Microsoft's attempt to get into the game. But there are other "Non-Microsoft" Graph Database implementations in market, and one of the popular one is Neo4j. So, in this session lets learn about Neo4j, how its implemented, whats provided in it, how to start with it and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Architecture & Design

Level: Beginner

Session Code:

Date: February 23

Time: 11:00 AM - 12:00 PM

Room: Room 4

Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Intermedia

Session Code:

Date: February 23

Time: 11:00 AM - 12:00 PM

Room: Room 2

Martin has seen life from a few different sides of the database environment. Often the world of TSQL and DBA are seen from vastly different viewpoints – but it doesn’t have to be this way. Join Martin to find out some ways that these two groups can enhance each other’s life and work as efficiently as possible. We’ll examine a range of tip during this presentation that most SQL professionals should get value from.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Intermedia

Session Code:

Date: February 23

Time: 12:00 PM - 1:00 PM

Room: Room 2

SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS? 
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development, Administration & DevOps

Level: Beginner

Session Code:

Date: February 23

Time: 10:00 AM - 11:00 AM

Room: Room 2

In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release, there have been many further developments, including the release of Power BI Report Server and subsequent SSRS versions. In this demo laden session, Craig will recap the changes that SSRS has undergone from SSRS 2016 onwards, as well as look at and discuss Power BI Report Server.This session will be valuable for anyone new to SSRS, or anyone who has not had an opportunity to work with the latest versions of SSRS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery, Analytics and Visualization

Level: Beginner

Session Code:

Date: February 23

Time: 1:45 PM - 2:45 PM

Room: Room 3

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