Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 23
Power BI Dataflow is a new feature in Power BI and gives you self-service data prep in Power BI. Dataflows give extensibility to other services Azure, Dynamics, Azure Databricks, Azure ML etc. and uses common data model that PowerApps leverages.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: August 31

Time: 9:50 AM - 10:50 AM

Room: 22BR-01

The amount of data we collect, store and process is rapidly growing and goes hand in hand with growing amount of work related to managing it. Automation is a key if we want to stay in control and AIOps represents its next major level with potential to revolutionise IT operations. This session explains what predictive maintenance is, provides common use cases and gives practical examples that help to avoid costly Sql Server disruptions and eliminate firefighting. Presented real-world examples address limitations of Query Store and automate the identification and resolution of common performance issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 31

Time: 10:55 AM - 11:55 AM

Room: 21MPR-01

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2019 takes that power a few steps further. Have you ever:

•    Had a query suddenly slow down at 2 AM when you were on call?
•    Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt?
•    Had the optimizer choose the wrong type of join and send your query off to never finish?

Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 31

Time: 9:50 AM - 10:50 AM

Room: 21MPR-02

When you build a business intelligence system for the current times, such as a modern data warehouse, the mantra for getting data onboard is ELT, and not ETL. Building an ELT solution is not as simple as switching two letter; it is a paradigm shift in thinking. In this session, I will brief you on the concept of a modern data warehouse, then move to why its data integration needs are different, how a solution for such a need is designed, and finally how you would build it using Azure Data Factory, and related technologies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 31

Time: 9:50 AM - 10:50 AM

Room: 22CF-12

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 31

Time: 4:15 PM - 5:15 PM

Room: 21MPR-02

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:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: 21MPR-02

Making data available for data science was considered as very expensive and it was rare to see data scientist works directly with a database for creating experiments. Main reason could be, widely-used languages for data science were not available within DBMSs and DBMSs were not rich enough for experiments.

Good news is, SQL Server Machine Learning Service is now equipped for data science. Let’s have a look on it and see how we can work on training experiments and predictive experiments. Let me show you;
•	What is Data Science and its processes?
•	What is SQL Server Machine Learning Service?
•	Configuring SQL Server for data science
•	Make a training experiment and predictive experiment using Python within SQL Server
•	Consumed a trained model using TSQL

Join with me and see how useful this with both operational and business intelligence areas.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 31

Time: 9:50 AM - 10:50 AM

Room: 21MPR-01

Azure Data Lake Storage Gen2 is a highly scalable and cost-effective data lake solution for big data analytics. Data Lake Storage Gen2 makes Azure Storage the foundation for building enterprise data lakes on Azure. Data Lake Storage Gen2 allows you to easily manage massive amounts of data. 
In this session you will learn
•	How to ingest structured and unstructured data into Azure Data Lake Storage Gen2?
•	How to access Azure Data Lake Storage Gen2 data with Azure Data Bricks using Spark?
•	How to secure data in Azure Data Lake Storage Gen2?
At the end of the session you will learn how to implement end to end Analytics for a modern Data Warehouse using Azure Data Lake Storage Gen2.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 31

Time: 3:15 PM - 4:15 PM

Room: 22CF-12

Spark and Azure Databricks have become game changing features in data world and processing large volume of data has never been faster. In this session , I will give a introduction to Azure Databricks, Apache Spark and will walk though step by step on how to use Azure Databricks.Additionally I will showcase how to perform ETL operations using Azure Databricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 31

Time: 4:15 PM - 5:15 PM

Room: 22CF-12

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. 

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: 22CF-12

Even as many of the traditional DBA activities become automated or managed by Cloud providers, the ability to tune and optimize database query performance remains a desirable and marketable skill.

Central to ability to tune queries is an ability to use information provided from Execution plans, DMVs, Query Store and Extended Events.

In this demo based session we will look into:
- What information is available 
- How it can be used.
- Techniques to improve performance. 

Attendees will leave with an understanding of possibilities of turning queries and a roadmap for further learning.

This session will assume a basic knowledge of T-SQL and execution plans.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 31

Time: 12:55 PM - 1:55 PM

Room: 22BR-01

The CEO just tasked you with moving all the SQL Server instances to Azure, or maybe you are deploying a brand new application and want to leverage Azure IaaS to host SQL Server. Beyond security and performance, your most pressing concern might be ensuring SQL Server running in Azure is highly available.
 
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me? 

HA and DR professional Jason Aw with 20 years of experience explains all this and more in
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 31

Time: 12:55 PM - 1:55 PM

Room: 22CF-12

Block chain is very fast growing technology.It is going to transform industry , lot of R&D and initiatives going on in this area. In this session, We are going  to cover patterns and server-less tools for sending data to the ledger network with Azure Blockchain Service and understand data flow in Blockchain Consortium Network.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 31

Time: 4:15 PM - 5:15 PM

Room: 22BR-01

This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows. You will first learn to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI and extend it with custom components. You will also learn to configure SSIS IR to access data on premises using Windows authentication and Virtual Network injection. You can then use the familiar SSDT/SSMS tools to manage your SSIS packages in the cloud just like you do on premises. You will next learn to modernize your ETL workflows by invoking SSIS package executions as first-class activities in ADF pipelines, allowing you to chain them with other activities, automatically (de)provision SSIS IR just in time, store secrets in Azure Key Vault, and splice advanced transformations, such as Power Query Source, Data Quality Tasks, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: August 31

Time: 12:55 PM - 2:25 PM

Room: 21MPR-01

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change.  When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more.  I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 31

Time: 12:55 PM - 1:55 PM

Room: 21MPR-02

The Aggregations is one of the biggest feature introduced in Power BI in terms of scalability. In this session, will introduce the aggregation feature first. Then move to discuss use cases where you can implement aggs and finally demonstrate how to implement aggregations in your data models.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 31

Time: 10:55 AM - 11:55 AM

Room: 22BR-01

In this session, you will learn about the layers of data protection, important security features, potential scenarios in which these features can be applied to limit exposure to security threats and best practices for securing business applications and data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 31

Time: 10:55 AM - 11:55 AM

Room: 22CF-12

Use SharePoint Online site and custom List as a data source for number of applications. SharePoint Custom list can behave like a data table with Relationship to enforce data integrity. Use Custom list as a development platform for custom apps. Microsoft Power platform can be used to integrate with custom list to fetch and act on data. Microsoft Flow can be a business process engine.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 31

Time: 3:15 PM - 4:15 PM

Room: 21MPR-01

With SQL Server 2019, Microsoft is introducing a new couple of features for data virtualization, data mart scale out and big data analysis. They all together form the SQL Server Big Data Clusters.

Let's take a look at what that means and how you can make use of the extended PolyBase capabilities, built-in Spark queries and more!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: 22BR-01

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it?  I've got some of the answers here in this session for you.  During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 31

Time: 2:00 PM - 3:00 PM

Room: 21MPR-01

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