Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 56
Power BI is great for modelling. Having the ability to edit and clean your data quick and easy is one of its greatest boons. It is however very easy to have your model bogged down with applied steps. This talk will open the window to best practices with modelling and how to utilise "M" to your advantage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: August 17

Time: 2:15 PM - 2:30 PM

Room: Room 145

New in SQL Server 2019, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process.  This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced.  ADR also prevents the transaction log from growing during a long-running transaction.  Join me for this session to learn about ADR architecture and to see demonstrations of what it can do.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 143

If you're planning on deploying Office 365 or Azure, whether you know it or not, you will be using Azure Active Directory (AAD). But, you've already got on-prem Active Directory. How do these two products work together? Are they the same thing? SHOULD they work together? In this session I'll answer these questions, compare and contrast AD and AAD usage in Azure and hybrid scenarios, discuss costs, and some best practices.
This is a beginner session, but there will be some networking involved, in addition to "legacy" AD functionality and settings.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 2:15 PM - 3:15 PM

Room: Room 109

Data is the new gold and companies are producing it in massive amounts. Historically it has been tough for companies to mine the data because of the amount of technical resources and human capital it takes to mine it. Fortunately, Microsoft has added tools and services in its data platform that addresses this problem. 
 
In this session we will take a tour of the Microsoft ecosystem and explore some of these tools and services. We will explore:
 
-  How AI models are easily productionized in the cloud using Azure Machine Learning Services and Azure Databricks
-  How Microsoft brought data science to the database via SQL Server Machine Learning Services
-  How AI can be used to enhance Power BI data models
-  How AI is used in Microsoft Excel to help analyst work more efficiently

Come to this information packed session, and you will walk away with ideas of how you can help your company leverage the gold mine of data it is sitting on to gain a competitive advantage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 136

A new version of SQL Server is right around the corner and it comes with all new features and improvements to make SQL Server a more compelling modern data platform.   SQL Server 2019 is slated to bring better integration with different OS platforms, improvements in performance and availability, and bring big data and AI on-prem.   In this session, we will look at the highlights of the new features coming to SQL Server 2019 and discuss why these improvements will justify another upgrade.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 141

Automation is now required. For DevOps, for Infrastructure-as-Code (IaC), for Platform-as-a-Service (PaaS), for user self-service, and for overworked staff, automation is the buzzword. Ansible provides that cross-platform functionality with minimal effort. In this session we'll install and configure MSSQL on a Windows host, install and configure a fail-over cluster on RHEL hosts using pacemaker and availability groups, and provision and deploy a new schema to an existing instance all utilizing playbooks. Also, we'll walk through getting started and example use-cases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 17

Time: 3:30 PM - 4:30 PM

Room: Room 141

Azure Data Factory has an impressive feature set, but where do you turn when you need something that isn’t supported? Need to run SQL commands in Snowflake? Connect to an unsupported API? No problem. In this session we'll look at how Custom Tasks and Azure Functions can be used to extend Data Factory to do just about anything.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: August 17

Time: 8:00 AM - 9:00 AM

Room: Room 141

Interested in learning text mining techniques but not sure where to start?  Want to learn more about SQL Saturday presentations but haven't dug into the details?  This is the presentation for you!  This is an introduction to text mining techniques that will use the SQL Saturday abstracts as examples.  We will look at how to analyze data to find the most commonly used words and patterns and how to do sentiment analysis.  Is "database" the most commonly used word in SQL Saturday abstracts?  Come and find out!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: Room 137

As the business need for data becomes more prominent, the platform that IT builds on becomes a crucial component to the success of any data analytics project.  Apache Spark centralizes the information management process by providing a unified platform.  Azure Databricks takes that concept one step further by providing a layer of abstraction from Apache Spark, which allows for easier adoption of a big data ecosystem.  This presentation and demonstration will dive into the core concepts of Azure Databricks by focusing on three main use cases: ETL/ELT, Structured Streaming, and Machine Learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: Room 109

PowerBI recently added support for AutoML (Supervised Automated machine Learning). This session demonstrates the new ML capabilities with an end to end example using Power BI Dataflows. In this session, we will use AutoML to create and apply a regression model. Regression is a machine learning technique used for understanding the relationship between input and output variables. Regression  techniques provide additional insight into data, making it easier to see relationships between dependent and independent variables.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: Room 137

Two major cloud data warehouse solutions exist on Azure - Azure Data Warehouse and Snowflake.  This session will discuss the features of each, and the associated use cases, strengths and weaknesses that result.  We'll also look at some benchmarks and costs.  If you think of it as a bakeoff, it's a pie vs. a cake.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 17

Time: 9:15 AM - 10:15 AM

Room: Room 140

Snowflake has been named a Gartner leader in the data platform and analytics space that leverages the computing power of the AZURE cloud platform that provides pay-for-what-you-use storage (at about $23/mo per TB) and elastic computing resources that is literally scale up and/or out on demand in which storage and compute are separated within Snowflake’s architecture.  The product and architecture of Snowflake has helped organizations in lowering their data platform TCO by up to 50%.    
This live demo will provide fundamental and technical understanding for roles like CDO, Data Architects, and Data Engineers,  The focus will be Snowflake and how the only cloud-build data warehouse offers instant elasticity, secure data sharing, per-second pricing and many other features to enable the data-driven enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 8:00 AM - 9:30 AM

Room: Room 140

Containers and Kubernetes are changing the way applications are deployed and managed, including databases. Red Hat and Microsoft have partnered to deliver SQL Server 2019 in Red Hat Enterprise Linux containers running on OpenShift Container Platform. In this session we'll deploy an always on availability group replica on OpenShift via a Kubernetes operator.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 109

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 11:45 AM - 12:45 PM

Room: Room 140

You may have heard of Business Intelligence Markup Language or even tried to learn it. But how can you take the time to learn it, while getting the rest of your work done. In this highly interactive presentation, I’ll guide you through the process of learning/using Biml, without sacrificing your daily productivity.

We’ll cover how to: 
Identify “easy” ETL patterns to BimlScript
Take incremental steps in automating these processes
Move to metadata driven BimlScript
Tie it all together into a full-fledged framework

As a bonus, you’ll leave the presentation with a completed framework which dynamically generates most types of flat files that you can use in your own environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: Room 140

Ever the one left out, Pluto's status as a key member of the solar system has been under scrutiny in recent years and the debate rages on.

In the age of AI, surely it's an easy problem to solve with computering. I'm sure Microsoft has a crack team of hackstars working on it right now. What toolset do you think they would use to do something like that? Probably some fancy cloud bricks or something.

Anyway, I'm sure this is possible. It has to be, we'd just need to learn about:

- A distributed analytics platfrom able to work with tons of raw planetary data
- An AI platform that is performant and allows a team of developers to collaborate and improve the product
- The ability to call the model billions and billions and billions and billions errr

I don't think this will take much longer than 75 mins. Might as well get to it.

(Psst: You're going to learn all about scalable data processing and web scale analytics using Azure Databricks, MLFlow, and Azure ML)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 144

We'll look at the new features that have rolled out in response to a major push at Microsoft to make Power BI reports more accessible. What some of the different areas of accessibility to think about, and some handy tools to help you make your reports more usable for everyone.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 17

Time: 1:00 PM - 2:00 PM

Room: Room 137

As a data professional, you know what data is, and hopefully know what a lake is too. But what's a Data Lake? This session covers the very basics of Azure Data Lake, and is geared towards those who are familiar with relational databases and also curious about other technologies. Topics covered will include Data Lake storage, security basics, and an introduction to U-SQL, Azure Data Lake's query language. We will finish up with architecture examples showing real-world use cases highlighting Azure Data Lake's strengths. Attend this session to see how Azure Data Lake can complement your existing relational database skills, and give you a great new tool in your data toolbox!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 10:30 AM - 11:30 AM

Room: Room 109

In the past five years there has been an explosive increase in Docker adoption.  However, uptake has been slow among data professionals.  DBAs are naturally wary of Docker's stateless and transient paradigm.  In this session we'll discuss what Docker is, how SQL Server uses it, Docker deployment strategies in Azure, and when using Docker does and doesn't make sense.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 17

Time: 3:30 PM - 4:30 PM

Room: Room 109

As Organizations are looking to transform into data driven organizations. Stream analytics has emerged as an integral part of Enterprise Data platform architectures along with batch ETL. Stream analytics help to gain maximum value from user-interaction events, applications and machine logs. Ingesting, processing, and analyzing these data streams quickly and efficiently is critical in fraud detection, click stream analysis, sentiment analytics, online recommendations and IOT Scenarios among many examples. In this session we will look at options available in azure for real-time analytics and deep dive into Azure Stream Analytics. Build streaming jobs that can blend and aggregate data as it arrives to drive live Power BI dashboards. Plus, we’ll explore how a complete lambda architecture can be created when combining stream and batch data together and finally how it integrates with Azure ML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 17

Time: 2:15 PM - 3:15 PM

Room: Room 140

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