sqlsathistory

Nr: 982

Back to Main list

SQLSaturday #982 – Auckland – Virtual 2020

Start Time (24h) Speaker Track Title
08:00:00 Erland Sommarskog Application Database Development SQL Titbits for the Inexperienced
08:00:00 Markus Ehrenmueller-Jensen Power BI Introduction to Numeric Calculations in DAX
08:00:00 Asgeir Gunnarsson Power BI What's Going On in My Power BI Environment?
08:00:00 Rob Sewell Learning Path for Data professional Job Jupyter Notebooks for DBAs
08:00:00 Dejan Sarka Machine Learning Advanced Analytics Text Mining with T-SQL
08:55:00 Kevin Feasel Machine Learning Advanced Analytics Applying Forensic Accounting Techniques Using SQL And R
08:55:00 Hasan Savran Cloud Application Development Deployment How does Azure Cosmos DB work under the hood?
08:55:00 Matt Gordon Cloud Application Development Deployment Azure SQL Database A to Z: More Than Meets The Eye
08:55:00 Belinda Allen Power BI Step by Step – Building (a Real Use Case for the) Power Platform Solution
08:55:00 Dmitri Korotkevitch Application Database Development 5 Availability Groups Issues That May Ruin Your Day
09:50:00 Christian Cote Power BI Power BI Report Server for the enterprise
09:50:00 Ben Miller Learning Path for Data professional Job A Walk Around SQL PowerShell
09:50:00 Miloš Radivojević Application Database Development Intelligent Query Processing in SQL Server 2019
09:50:00 Gaston Cruz Cloud Application Development Deployment Processing Tabular Models
09:50:00 Daniel Glenn Cloud Application Development Deployment Using Your On-prem Data in a Cloud World
10:45:00 Angela Henry Application Database Development Intro to Azure Data Catalog
10:45:00 Javier Villegas Application Database Development New Features in SQL Server 2019
10:45:00 Vitor Fava Application Database Development Management of multiple instances using Data Collector and PBM
10:45:00 Denny Cherry Cloud Application Development Deployment Azure 101
10:45:00 William Assaf Learning Path for Data professional Job Certification Exams Inside Out
12:15:00 Asanka Padmakumara Machine Learning Advanced Analytics ETL2.0: Data Engineering with Azure Databricks
12:15:00 Hamish Watson Cloud Application Development Deployment Database Reliability Engineer - the new DBA?
12:15:00 Martin Cairney Cloud Application Development Deployment Exploring the World of Azure Data Explorer
12:15:00 Raju RH Machine Learning Advanced Analytics Learn how to digitalize your business using Azure Form Recognizer
12:15:00 David Alzamendi Application Database Development Starting with Azure Synapse Analytics (workspace experience)
13:10:00 Ondrej Aubrecht Learning Path for Data professional Job Can you trust the intelligence of Application tracking systems with your CV?
13:10:00 Greg Low Application Database Development The Lowdown on Character Data Types in SQL Server
13:10:00 Dave Dustin Application Database Development Scaling databases to Enterprise scale - Vertical vs Horizontal
13:10:00 Reza Rad Power BI Dataflow vs Dataset: the Building Blocks of Power BI Architecture
13:10:00 Anupama Natarajan Machine Learning Advanced Analytics MLOps using Azure Machine Learning
14:05:00 Zoran Barac Application Database Development Migration path from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS)
14:05:00 Gilbert Quevauvilliers Power BI How to store your Power BI Audit logs indefinitely
14:05:00 Tariq Younas Application Database Development Azure SQL: (IaaS) OR (PaaS) What to use When?
14:05:00 Patrick Flynn Application Database Development SQL Server on the Edge (Is it time for Pie?)
14:05:00 Rob Farley Application Database Development SARGability
15:00:00 Will Velida Cloud Application Development Deployment Introduction to Graph Databases in Azure Cosmos DB
15:00:00 Sandeep Arora Cloud Application Development Deployment The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure
15:00:00 Ali Sharifi Application Database Development Calculation Group in SSAS 2019
15:00:00 Indira Bandari Power BI Writeback and Refresh Power BI dataset using PowerApps
15:00:00 Darren Gosbell Power BI Getting the most out of DAX Studio
15:55:00 Martin Catherall Application Database Development Exploring Window Functions
15:55:00 Warwick Rudd Application Database Development Azure Data Studio - Next Gen 2
15:55:00 Manohar Punna Cloud Application Development Deployment Cloud IaC (Infrastructure as Code) with Terraform
15:55:00 Heidi Hasting Application Database Development Bringing Source Control to BI world!
15:55:00 Leila Etaati Machine Learning Advanced Analytics Anomaly Detection and Entity Extraction from Text in Power BI
16:50:00 Marco Russo Power BI My Power BI Report is Slow: What Should I Do?
16:50:00 Luis Beltran Machine Learning Advanced Analytics Extracting information from your unstructured data with Azure Cognitive Search
16:50:00 Amit R S Bansal Application Database Development Developer Best Practices in SQL Server
16:50:00 Mihail Mateev Power BI How to Design Modern IoT Solutions with CosmosDB and PowerBI
16:50:00 Rob Douglas Application Database Development Taking the first steps down the path to security

SessionID: 105246

SQL Titbits for the Inexperienced

Back to calendar

Event Date: 08-08-2020 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Erland Sommarskog

Title: SQL Titbits for the Inexperienced

Abstract:

This session is directed to you who have been using SQL left-handedly a year or so. You have learnt to write the basic queries, but there are still some gaps in your SQL knowledge, and overall SQL is a little confusing to you. This session aims at filling some of these gaps by covering a few titbits about SQL and give you some tips that will be useful to you. This includes really basic things as what GO really is and the traps you can run into with NULL values. You will also learn a little about data types and how you should use UNION. Finally, time permitting, I will talk about CTEs, temp tables and table variables and you will get some ideas what to use when.

SessionID: 105277

Introduction to Numeric Calculations in DAX

Back to calendar

Event Date: 08-08-2020 - Session time: 08:00:00 - Track: Power BI

Speaker: Markus Ehrenmueller-Jensen

Title: Introduction to Numeric Calculations in DAX

Abstract:

DAX (Dynamic Analysis Expressions) is a formula language to enrich imported data with calculated columns, calculated tables and measures. While the syntax of the language is derived from Excel’s formula language and easy to learn, some of the functions are hiding a real complex semantic. In this talk we will concentrate on numeric calculated columns and measures. You will learn about the differences and advantages of each. You will leave this talk with the knowledge, how to distinguish filter contexts and row contexts and in which cases to use calculated columns and in which cases to use measures.

SessionID: 105287

What's Going On in My Power BI Environment?

Back to calendar

Event Date: 08-08-2020 - Session time: 08:00:00 - Track: Power BI

Speaker: Asgeir Gunnarsson

Title: What's Going On in My Power BI Environment?

Abstract:

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it. There are compliance, governance, performance, and implementation questions to consider. Who is creating content, how is it being distributed, what data is being used, dataset refreshes, who has a trial license, and what report is the most used? These are just some of the questions you as an administrator of Power BI might want to get answers to.

In this session, we will look at how you can find those answers by monitoring Power BI. We will look at the Power BI Audit log for usage, license, and other audit information. We will look at what the Power BI API can show us about data sets, refresh history, Enterprise Gateway information, premium capacity, and artifact inventory.

Lastly we will show how you can automate the data collection via Azure and PowerShell and report on the results.

SessionID: 105290

Jupyter Notebooks for DBAs

Back to calendar

Event Date: 08-08-2020 - Session time: 08:00:00 - Track: Learning Path for Data professional Job

Speaker: Rob Sewell

Title: Jupyter Notebooks for DBAs

Abstract:

Jupyter Notebooks were once the realm of Data Scientists. New releases of Azure Data Studio, Visual Studio Code, and .NET interactive tooling have brought this tooling into the Operational team's area. The biggest benefit of using Jupyter Notebooks is that you have your documentation, your code and your results in the same source controllable document.

I will share with you all of the knowledge I have gained over the past 12 months implementing Jupyter Notebooks for Data Operation teams.

You will leave

Enabling collaboration with your team, simplifying common tasks, improving Incident Wash-Up meetings, creating run-books, easily creating code for others to use are some of the benefits that you will take away. We will have fun as well.

SessionID: 105432

Text Mining with T-SQL

Back to calendar

Event Date: 08-08-2020 - Session time: 08:00:00 - Track: Machine Learning Advanced Analytics

Speaker: Dejan Sarka

Title: Text Mining with T-SQL

Abstract:

Analyzing text is another modern hype. You have many tools, packages, and languages available. But did you know that you can do really a lot of text mining also in pure Transact-SQL? Yes, your SQL Server can also become a text mining engine. In this advanced session, you will learn how to analyze text in multiple languages with pure T-SQL, using also features from the full-text search (FTS).

SessionID: 105262

Applying Forensic Accounting Techniques Using SQL And R

Back to calendar

Event Date: 08-08-2020 - Session time: 08:55:00 - Track: Machine Learning Advanced Analytics

Speaker: Kevin Feasel

Title: Applying Forensic Accounting Techniques Using SQL And R

Abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

SessionID: 105302

How does Azure Cosmos DB work under the hood?

Back to calendar

Event Date: 08-08-2020 - Session time: 08:55:00 - Track: Cloud Application Development Deployment

Speaker: Hasan Savran

Title: How does Azure Cosmos DB work under the hood?

Abstract:

To master any technology, you need to understand the foundation of how it works on the back-end first. In this session; We will explore Azure Cosmos DB's infrastructure. I will explain you how Azure Cosmos DB works and handles data in the back-end. We will cover the basics and some of the most misunderstood features of Azure Cosmos DB.

Learning new technologies make you a better leader and collaborator. Join me to learn more about this new Cloud Database technology.

SessionID: 105304

Azure SQL Database A to Z: More Than Meets The Eye

Back to calendar

Event Date: 08-08-2020 - Session time: 08:55:00 - Track: Cloud Application Development Deployment

Speaker: Matt Gordon

Title: Azure SQL Database A to Z: More Than Meets The Eye

Abstract:

Azure SQL Database has been known to many as merely “cloud-based SQL Server” lacking the full features required to make it a production workload destination. Times have changed! Azure SQL Database, with the addition of deployment models like Managed Instance and storage technologies like Hyperscale, has matured into a formidable PaaS database competitor. I will walk through how these technologies work behind the scenes, what options are available as you and your company consider migration, and how the Azure SQL Database family gives companies a powerful platform to store and use their data while minimizing the management overhead and hassle.

SessionID: 105310

Step by Step – Building (a Real Use Case for the) Power Platform Solution

Back to calendar

Event Date: 08-08-2020 - Session time: 08:55:00 - Track: Power BI

Speaker: Belinda Allen

Title: Step by Step – Building (a Real Use Case for the) Power Platform Solution

Abstract:

In this session, Belinda will build a Power Automate flow. She’ll then build a Power App that uses that flow. Finally, she’ll add the Power App to a Power BI Report. This is a real use case. See the whole enchilada being built, in less than 1 hour.

Who should attend this session?
• If you have never built a Power Automate flow, this session is for you. • If you have never built a Power App, this session is for you. • If you are struggling with use cases for these cool products, this session is for you.

SessionID: 105426

5 Availability Groups Issues That May Ruin Your Day

Back to calendar

Event Date: 08-08-2020 - Session time: 08:55:00 - Track: Application Database Development

Speaker: Dmitri Korotkevitch

Title: 5 Availability Groups Issues That May Ruin Your Day

Abstract:

AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.

SessionID: 105251

Power BI Report Server for the enterprise

Back to calendar

Event Date: 08-08-2020 - Session time: 09:50:00 - Track: Power BI

Speaker: Christian Cote

Title: Power BI Report Server for the enterprise

Abstract:

Power BI Report server allows you to share Power BI vizualisations on-premises as well as paginated reports. In this session, weèll cover the various possibilities of Power BI Report Server as a portal for your enterprise reports and we'll compare it to its counterpart in the clouds.

SessionID: 105254

A Walk Around SQL PowerShell

Back to calendar

Event Date: 08-08-2020 - Session time: 09:50:00 - Track: Learning Path for Data professional Job

Speaker: Ben Miller

Title: A Walk Around SQL PowerShell

Abstract:

PowerShell has been out for a long time now, and it is certainly not new for the DBA with all the modules and code floating around, yet there are many that have decided not to adopt it. This session takes a casual walk around SQL and PowerShell together and shows how powerful it is and how easy it is to get started. But be warned, once you slip into the pool and get past the shock of the "colder than you like" water, you will be hooked. Don't take my word for it, join me for a session that takes you through a little SMO and last the SQLServer module and the provider it gives you access to. You will be glad you did.

SessionID: 105282

Intelligent Query Processing in SQL Server 2019

Back to calendar

Event Date: 08-08-2020 - Session time: 09:50:00 - Track: Application Database Development

Speaker: Miloš Radivojević

Title: Intelligent Query Processing in SQL Server 2019

Abstract:

SQL Server 2017 started with query processing improvements called Adaptive Query Processing. Now, in SQL Server 2019, there are additional improvements; all of them are packed in a feature with a very promising name - Intelligent Query Processing.

The intention of these improvements is to fix plans for poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with no code changes. This session will cover briefly all 2019 features: Batch Mode on Rowstore, Batch and Row Mode Memory Grant Feedback, Scalar UDF Inlining, Table Variable Deferred Compilation, and Approximate Query Processing. If time permits, you’ll see also Batch Mode Adaptive Join and Interleaved Execution. After the session, you’ll understand how much improvements you should expect in your workloads, but also which of these features, and under which circumstances, can cause significant performance regression and how to overcome those issues.

SessionID: 105334

Processing Tabular Models

Back to calendar

Event Date: 08-08-2020 - Session time: 09:50:00 - Track: Cloud Application Development Deployment

Speaker: Gaston Cruz

Title: Processing Tabular Models

Abstract:

SessionID: 105335

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 08-08-2020 - Session time: 09:50:00 - Track: Cloud Application Development Deployment

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Power Automate, and Power Apps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Microsoft 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Microsoft 365 and SharePoint Server.

SessionID: 103574

Intro to Azure Data Catalog

Back to calendar

Event Date: 08-08-2020 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Angela Henry

Title: Intro to Azure Data Catalog

Abstract:

Your company has amassed more data than it can possibly use, yet no one can find the data they need. This is more common than you think. With Azure Data Catalog, anyone can find the data they are looking for, no matter the data source. This session will introduce you to Azure Data Catalog, what it is, how you can use it and why everyone should be using it.

SessionID: 105248

New Features in SQL Server 2019

Back to calendar

Event Date: 08-08-2020 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Javier Villegas

Title: New Features in SQL Server 2019

Abstract:

SessionID: 105317

Management of multiple instances using Data Collector and PBM

Back to calendar

Event Date: 08-08-2020 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Vitor Fava

Title: Management of multiple instances using Data Collector and PBM

Abstract:

In this session, I will address the main techniques for the efficient management of multiple instances in a SQL Server environment using the Tools Data Collector and Policy-Based Management. In addition, it will be demonstrated in a practical way how to configure each of the tools, as well as how to extract and analyze the metrics collected.

SessionID: 105321

Azure 101

Back to calendar

Event Date: 08-08-2020 - Session time: 10:45:00 - Track: Cloud Application Development Deployment

Speaker: Denny Cherry

Title: Azure 101

Abstract:

Microsoft Azure is a daunting thing to look at and think about. In this session, we'll look at the basics of Azure, what the options are for setting up an Azure account; as well as look at how regions are broken down. We'll take a look at the differences between Infrastructure as a Service, Platform as a Service and Software as a Service as well as the High Availability and Disaster Recovery options that are available to do with these services. We'll finish the session off by looking at some options for Virtual Machines within Azure as well as the SQL Server offerings that are available in the platform.

SessionID: 105407

Certification Exams Inside Out

Back to calendar

Event Date: 08-08-2020 - Session time: 10:45:00 - Track: Learning Path for Data professional Job

Speaker: William Assaf

Title: Certification Exams Inside Out

Abstract:

Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint, what rules item writers must follow, and why questions sometimes have strange phrasing. For any technical skillset pursuing certification, we'll review non-technical sample questions and walk through the process of using information at your disposal. You'll better understand how to deconstruct the problem statement. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.

SessionID: 103535

ETL2.0: Data Engineering with Azure Databricks

Back to calendar

Event Date: 08-08-2020 - Session time: 12:15:00 - Track: Machine Learning Advanced Analytics

Speaker: Asanka Padmakumara

Title: ETL2.0: Data Engineering with Azure Databricks

Abstract:

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.

SessionID: 105222

Database Reliability Engineer - the new DBA?

Back to calendar

Event Date: 08-08-2020 - Session time: 12:15:00 - Track: Cloud Application Development Deployment

Speaker: Hamish Watson

Title: Database Reliability Engineer - the new DBA?

Abstract:

Database technology has been evolving for years now - rather than being just SQL Server we now talk about managing a data platform.

The skillset of the DBA needs to rapidly change/evolve and they need to be generalists who are familiar with different platforms and the ability to recommend the right fit for an application. Whilst still being specialised enough to support a database to meet business application requirements.

Database Reliability Engineering teams configure, manage and support database infrastructure, writing the automation that builds databases to scale to serve hundreds of thousands of queries per second.

They embrace automation, they understand and leverage cloud services and using DevOps is how they approach all aspects of database installation, configuration and management.

This session will introduce the Database Reliability Engineer which is the new DBA.

SessionID: 105359

Exploring the World of Azure Data Explorer

Back to calendar

Event Date: 08-08-2020 - Session time: 12:15:00 - Track: Cloud Application Development Deployment

Speaker: Martin Cairney

Title: Exploring the World of Azure Data Explorer

Abstract:

If you have large volumes of log or telemetry data, then Azure Data Explorer (ADX) may be the tool you need to perform ad-hoc queries to extract insights for diagnostics, monitoring, or reporting purposes.

This introductory session will give you a taste of the power and flexibility of ADX and the Kusto Query Language. A demonstration will show the ease of ingesting Azure Metrics into ADX and a number of ways to query this data, including Azure Data Studio and Power BI.

SessionID: 105477

Learn how to digitalize your business using Azure Form Recognizer

Back to calendar

Event Date: 08-08-2020 - Session time: 12:15:00 - Track: Machine Learning Advanced Analytics

Speaker: Raju RH

Title: Learn how to digitalize your business using Azure Form Recognizer

Abstract:

Much like automation, artificial intelligence applications make it possible for machines to complete real human tasks. We will look how Form Recognizer help developers to build intelligent applications without having direct AI or data science skills or knowledge.

SessionID: 105484

Starting with Azure Synapse Analytics (workspace experience)

Back to calendar

Event Date: 08-08-2020 - Session time: 12:15:00 - Track: Application Database Development

Speaker: David Alzamendi

Title: Starting with Azure Synapse Analytics (workspace experience)

Abstract:

Do you want to learn more about Azure Synapse Analytics? What is the new workspace experience? Trying to save time building data analytics solutions?

This session is for you and will provide the answers to each of these questions.

By using Azure Synapse Analytics, you will learn how to empower your business with actionable insights.

This session includes some demos using a selection of the available features.

SessionID: 103694

Can you trust the intelligence of Application tracking systems with your CV?

Back to calendar

Event Date: 08-08-2020 - Session time: 13:10:00 - Track: Learning Path for Data professional Job

Speaker: Ondrej Aubrecht

Title: Can you trust the intelligence of Application tracking systems with your CV?

Abstract:

An applicant tracking system (ATS) is a software application that enables to handle candidate profiles and could scan and analyse the Resumes (CV's).

This session will answer some of the unspoken questions:     - Can you trust ATS with your CV ?     - Can ATS analyse your Resume correctly (with Real examples) ?     - How ATS works?

Come along to this session and find out more about REAL DATA analysis and scanning mechanism by multiple ATS used in the NZ job market and to find out if you can trust AI with your own CV.

SessionID: 105259

The Lowdown on Character Data Types in SQL Server

Back to calendar

Event Date: 08-08-2020 - Session time: 13:10:00 - Track: Application Database Development

Speaker: Greg Low

Title: The Lowdown on Character Data Types in SQL Server

Abstract:

Character data types should be simple. But they're not. In this session Greg will show you how they really work, and challenge a number of common myths. As an example, if you think that varchar(20) means a string of up to 20 characters long, you should attend. If you don't get why there's an N in front of many string values, you should attend. And if you aren't really clear on Unicode, UTF-8, and supplementary characters, you should also attend.

SessionID: 105410

Scaling databases to Enterprise scale - Vertical vs Horizontal

Back to calendar

Event Date: 08-08-2020 - Session time: 13:10:00 - Track: Application Database Development

Speaker: Dave Dustin

Title: Scaling databases to Enterprise scale - Vertical vs Horizontal

Abstract:

Think back a year. Your current databases happily serve 10k customers.

Now you've got 100k. There are performance issues, but nothing you can't handle with some DBCC FREEPROCCACHE calls when a "bad" plan is created or some ad-hoc creation of new covering indexes as the dev teams release features... Oh crap. Executives have just announced we're targeting 1M customers in 18 months.

This session talks about how to scale your data platform. It's not just a case of throwing more CPU and memory at the problem. We'll talk about how you can scale horizontally (sharding) as well as working with product teams to revisit their calls...

SessionID: 105442

Dataflow vs Dataset: the Building Blocks of Power BI Architecture

Back to calendar

Event Date: 08-08-2020 - Session time: 13:10:00 - Track: Power BI

Speaker: Reza Rad

Title: Dataflow vs Dataset: the Building Blocks of Power BI Architecture

Abstract:

It is easy to use Power BI as a self-service tool. However, using it in a multi-developer environment comes with challenges. You can easily end up with silos of Power BI solutions, duplicates of Power Query, and DAX codes. Come to this session to learn how to avoid duplicate work using the right architecture for developing your Power BI solution.

SessionID: 105482

MLOps using Azure Machine Learning

Back to calendar

Event Date: 08-08-2020 - Session time: 13:10:00 - Track: Machine Learning Advanced Analytics

Speaker: Anupama Natarajan

Title: MLOps using Azure Machine Learning

Abstract:

MLOps or DevOps for Machine Learning uses the DevOps principles and practices which includes Continuous Integration, Delivery and Deployment to the Machine Learning process. MLOps provides quality assurance to your organisation Machine Learning solutions using Azure Machine Learning.

In this session, you will learn how to create a end-to-end ML lifecycle using Azure Machine Learning and automate Model management, deployment and monitoring using MLOps capabilities.

SessionID: 104360

Migration path from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS)

Back to calendar

Event Date: 08-08-2020 - Session time: 14:05:00 - Track: Application Database Development

Speaker: Zoran Barac

Title: Migration path from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS)

Abstract:

Database migration path from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS).

DMA (Assessment), DEA (Capture the trace / Replay the trace / Analyze), DMS (Migrate database)

Data Migration Assistant (DMA) Use DMA tool to detect potential compatibility issues which may impact database functionality after migration to Azure SQL managed Instance.

Database Experimentation Assistant (DEA) Evaluate targeted version of SQL Server instance for a specific workload, in this example Azure SQL Managed Instance. Create workload from the source SQL Server Instance using Extended Events XEL trace, replay that workload against the targeted Azure SQL Managed Instance, and then create report and analyze those two traces.

Azure Database Migration Service (DMS) Use Azure DMS as end-to-end solution for migrating source SQL Server databases to the cloud, in this example from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS).

SessionID: 105258

How to store your Power BI Audit logs indefinitely

Back to calendar

Event Date: 08-08-2020 - Session time: 14:05:00 - Track: Power BI

Speaker: Gilbert Quevauvilliers

Title: How to store your Power BI Audit logs indefinitely

Abstract:

By default your Power BI Audit logs are only available for 90 days

In this session I will show you how to use the Power BI REST API to extract your Power BI Audit Logs

I will then show you how to store the audit logs in Azure Storage. By storing the audit logs in Azure Storage not only can you keep the files there indefinitely but it also allows you to be able to bring this data quickly and easily into Power BI Desktop.

Finally I will give a quick overview of what a Power BI Audit Log usage report looks like, allowing me to understand my users usage on my reports and dashboards.

SessionID: 105362

Azure SQL: (IaaS) OR (PaaS) What to use When?

Back to calendar

Event Date: 08-08-2020 - Session time: 14:05:00 - Track: Application Database Development

Speaker: Tariq Younas

Title: Azure SQL: (IaaS) OR (PaaS) What to use When?

Abstract:

Learn about the latest capabilities in the Azure SQL family (VM, SQL Managed Instance, SQL Database) in the past year, along with migration updates.

SessionID: 105429

SQL Server on the Edge (Is it time for Pie?)

Back to calendar

Event Date: 08-08-2020 - Session time: 14:05:00 - Track: Application Database Development

Speaker: Patrick Flynn

Title: SQL Server on the Edge (Is it time for Pie?)

Abstract:

In May 2019 at the annual Build Conference Microsoft announced a new database offering, called Azure SQL Database Edge, which brings SQL capabilities to edge computing.

Running on ARM64 and x64 processors, it is an optimised relational database engine geared for IoT and IoT Edge deployments and provides capabilities such as data streaming, time series data, graph support and in-database machine learning.

In this session we will take a quick look at the features of this offering and then demonstrate how it can be deployed and run on an ARM64 Raspberry Pi device.

This session will be almost Demo's and will provide a clear guide on how to install and use SQL Server in small foot print devices.

SessionID: 105485

SARGability

Back to calendar

Event Date: 08-08-2020 - Session time: 14:05:00 - Track: Application Database Development

Speaker: Rob Farley

Title: SARGability

Abstract:

SARGability is such a significant thing in the database world, and goes far beyond "Keep your columns on the left and functions on the right". In this talk, you'll be able learn principles that will affect not only how easily your data can be located, but also the way that joins are performed and more. You can even learn ways to tune poorly performing queries without having to rewrite anything.

SessionID: 103536

Introduction to Graph Databases in Azure Cosmos DB

Back to calendar

Event Date: 08-08-2020 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Will Velida

Title: Introduction to Graph Databases in Azure Cosmos DB

Abstract:

Azure Cosmos DB provides a fully managed graph database through the Gremlin API offering. This allows us to build graph databases in the cloud that can elastically scale, are available in multiple regions across the globe and can provide fast query times on our data.

In this session, I'll cover the basics of what graph databases are and how these concepts apply in Cosmos DB. Then I'll discuss how we can model our graph data in Cosmos DB, how we can optimize the performance of our Graph databases in Cosmos DB and how we can build applications to interact with our Graph databases.

By the end of this session, you'll leave with an understanding of what Graph databases are, how we apply that knowledge to Cosmos DB and how we can build graph databases in Azure Cosmos DB

SessionID: 103549

The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure

Back to calendar

Event Date: 08-08-2020 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Sandeep Arora

Title: The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure

Abstract:

The public cloud is making a huge impact on the way enterprises host, manage, and scale their database operations. They can provision new infrastructure at the click of a button, without a lengthy hardware procurement process. Through a range of Database as a Service (DBaaS) options, public cloud vendors now make it easier than ever for organizations to migrate and maintain their databases. But while these solutions address many of the headaches involved in database management such as migration, provisioning, and administration, there are significant differences between the various DBaaS offerings on the market. In this session, we explore these DBaaS solutions provided by the leading cloud platforms, AWS, GCP, and Azure, and compare key features such as the types of the Database Engines on offer, Infrastructure Design Challenges, DR and HA capabilities, Performance Indicators, Pricing and Database Security.

SessionID: 105445

Calculation Group in SSAS 2019

Back to calendar

Event Date: 08-08-2020 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Ali Sharifi

Title: Calculation Group in SSAS 2019

Abstract:

Calculation group is a new DAX feature introduced in SSAS 2019 where it creates generic DAX formulas in the model and uses them for different measures in the reports. For example time series calculations such as MTD(month to date), YTD(year to date), same period in previous year are very popular and are usually required to be created for most of the measures. By creating these measures for any numeric metrics( such as sales, orders, refund,…) we will end up with too many measures which take a lot of development time and make the model pilled up with many measures. Instead of creating measures for each metric, the formula can be created once in a Calculation Group and then be used in the reports for multiple measures.

SessionID: 105448

Writeback and Refresh Power BI dataset using PowerApps

Back to calendar

Event Date: 08-08-2020 - Session time: 15:00:00 - Track: Power BI

Speaker: Indira Bandari

Title: Writeback and Refresh Power BI dataset using PowerApps

Abstract:

In this session I will show you how to use PowerApps visual to write back data to the source and refresh the Power BI report.

I will be doing the following:

Creating a New Power App in Power BI Use this to enter the data you want to write back to the source. The same data can be instantly shown in Power BI Report

SessionID: 105458

Getting the most out of DAX Studio

Back to calendar

Event Date: 08-08-2020 - Session time: 15:00:00 - Track: Power BI

Speaker: Darren Gosbell

Title: Getting the most out of DAX Studio

Abstract:

DAX Studio is a tool for executing, profiling and building DAX queries. Come and learn all about this free community tool from it's creator. In this session you will learn all about the different features in DAX Studio and how to use it to maximize your experience working with DAX. If you are building paginated reports with DAX queries or if you need to do performance tuning of measures or tabular models then DAX Studio has something for you.

SessionID: 105221

Exploring Window Functions

Back to calendar

Event Date: 08-08-2020 - Session time: 15:55:00 - Track: Application Database Development

Speaker: Martin Catherall

Title: Exploring Window Functions

Abstract:

Window Functions first emerged with the 2005 release – and were enhanced in 2012.

They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may - at first - seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.

SessionID: 105331

Azure Data Studio - Next Gen 2

Back to calendar

Event Date: 08-08-2020 - Session time: 15:55:00 - Track: Application Database Development

Speaker: Warwick Rudd

Title: Azure Data Studio - Next Gen 2

Abstract:

We all know that of the terrible 2’s, but do we know it means an explosion of new skills and abilities as our capabilities are increasing exponentially. 12 months on from Azure Data Studio – the New Frontier, We will look at the exponential improvements and expand your horizons on when, why and how you can be using Azure Data Studio as a data professional.

This demo heavy introductory session will take you on a journey from first time introductions, to what is new and how this tooling makes your life easier as a Data Professional.

SessionID: 105353

Cloud IaC (Infrastructure as Code) with Terraform

Back to calendar

Event Date: 08-08-2020 - Session time: 15:55:00 - Track: Cloud Application Development Deployment

Speaker: Manohar Punna

Title: Cloud IaC (Infrastructure as Code) with Terraform

Abstract:

In the recent years, cloud has been adopted by most companies. It offers greater flexibility in terms of infrastructure and resource management at a greater scale. Although, if not noticed the prices of maintaining this infrastructure and resources will blow through the roof. DevOps and redeployability of resources as needed has become even more critical with cloud.

Infrastructure as code is a necessity than luxury. Terraform offer great IaC solution across multiple cloud vendors. In this session I will explain the importance of DevOps process for cloud resources and introduce how Terraform can be used for building your multi cloud IaC solutions.

SessionID: 105480

Bringing Source Control to BI world!

Back to calendar

Event Date: 08-08-2020 - Session time: 15:55:00 - Track: Application Database Development

Speaker: Heidi Hasting

Title: Bringing Source Control to BI world!

Abstract:

Do you ever have trouble finding the latest version of a report?

Do you want to see the changes to a database/cube/report over time?

Do you need to identify where a field is used across your BI environment?

Do you have issues with parallel development?

Do you work in a Business Intelligence environment with no source control?

If you answered yes to any of these questions, then this session is for you! We will go through:

  1. Why source control is important
  2. The different Visual Studio project types (Databases, Analysis Services, Integration Services, and Reporting Services)
  3. How to bring an existing Business Intelligence environment into Source Control
  4. How to facilitate parallel development

Let's bring order to your chaos!!

SessionID: 105745

Anomaly Detection and Entity Extraction from Text in Power BI

Back to calendar

Event Date: 08-08-2020 - Session time: 15:55:00 - Track: Machine Learning Advanced Analytics

Speaker: Leila Etaati

Title: Anomaly Detection and Entity Extraction from Text in Power BI

Abstract:

Anomaly detection is one of the common scenarios for all organizations dealing with huge amounts of data through time. They want to find the anomaly in data for company sales amount, revenue, and so forth. Microsoft's cognitive service provides an API for time series anomaly detection. Moreover, the audience will learn how to change the existing code in Power Query for text analytics to extract the entity from a text. The audience will learn how to combine the Cognitive service Anomaly detection with Power BI desktop using Power Query and M languages to call the cognitive service API.

SessionID: 103545

My Power BI Report is Slow: What Should I Do?

Back to calendar

Event Date: 08-08-2020 - Session time: 16:50:00 - Track: Power BI

Speaker: Marco Russo

Title: My Power BI Report is Slow: What Should I Do?

Abstract:

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance?

This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.

At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

SessionID: 105285

Extracting information from your unstructured data with Azure Cognitive Search

Back to calendar

Event Date: 08-08-2020 - Session time: 16:50:00 - Track: Machine Learning Advanced Analytics

Speaker: Luis Beltran

Abstract:

AI enrichment is a capability of Azure Cognitive Search indexing that is used to extract latent information from images, blobs, and other unstructured, non-text data sources - enriching the content to make it more searchable in an index or knowledge store.

Both extraction and enrichment tasks are implemented through cognitive skills such as natural language processing and image processing skills with several possibilities: Entity recognition, language detection, sentiment detection, OCR, face detection...

In this session, the Azure Cognitive Search service will be explored and described. Then, an enrichment pipeline capable of extracting information from images and documents (PDF, Word) will be built in order to demonstrate a use case scenario, along with requirements, costs, related Azure services and a website/mobile app that allows users to look for information from the files.

SessionID: 105365

Developer Best Practices in SQL Server

Back to calendar

Event Date: 08-08-2020 - Session time: 16:50:00 - Track: Application Database Development

Speaker: Amit R S Bansal

Title: Developer Best Practices in SQL Server

Abstract:

SessionID: 105438

How to Design Modern IoT Solutions with CosmosDB and PowerBI

Back to calendar

Event Date: 08-08-2020 - Session time: 16:50:00 - Track: Power BI

Speaker: Mihail Mateev

Title: How to Design Modern IoT Solutions with CosmosDB and PowerBI

Abstract:

Sometimes design and implementation of modern IoT solutions can be easy. This talk is how to implement modern IoT server-less solutions in Azure, based on event driven design, and powered by Cosmos DB and Power BI.

During the presentation you will see:

SessionID: 105472

Taking the first steps down the path to security

Back to calendar

Event Date: 08-08-2020 - Session time: 16:50:00 - Track: Application Database Development

Speaker: Rob Douglas

Title: Taking the first steps down the path to security

Abstract:

Security is one of the primary jobs of a SQL Server DBA. In this session we'll talk about how security has changed as cloud and Hybrid environments rapidly evolve. We'll talk about what can and can't be controlled, and we'll run through a demo of 5 different forms of Encryption that you can implement in your environment immediately to dramatically decrease your risk exposure.

This site is open source. Improve this page.