Event Date: 26-09-2020 - Session time: 09:30:00 - Track: Data Platform
In this demo heavy session we will show how Containers along with Azure DevOps can work for your CI/CD pipeline.
You will leave this session with the knowledge and ability to start creating your own bespoke SQL Server on Linux development / testing environments with automated image builds and releasing to Azure Kubernetes Service (AKS) along with some of the issues / pitfalls of doing so.
Pre-Requisite: To get the most out of this session a basic understanding of what Docker/Containers are, is recommended.
Event Date: 26-09-2020 - Session time: 09:30:00 - Track: Azure BI
In this session, we have a good look at CDS and find his strengths and weaknesses. We'll see how to build, ingest and extract data from CDS using demos. When you're using the Power Platform and/or curious about CDS but haven't used it yet, join me at this session.
Event Date: 26-09-2020 - Session time: 09:30:00 - Track: Power BI
It's good to have some form of interactivity in your presentation. Whether it's by (live) polling your audience, telling a story, asking questions during your presentation or any other way to make your presentation more interactive, doesn't really matter. The way I started doing this was by firing some questions at the audience after I introduced myself. Although that worked pretty well, I was asking closed questions with a show of hands. But as I work with the Power Platform suite of products I thought it was a good idea to use some of that Power! In this session I will show you:
Event Date: 26-09-2020 - Session time: 09:30:00 - Track: Cloud Development
In this talk we will:
Event Date: 26-09-2020 - Session time: 09:30:00 - Track: Azure DB
Learning new technologies make you a better leader and collaborator. Join me to learn more about this new Cloud Database technology.
Event Date: 26-09-2020 - Session time: 10:45:00 - Track: Azure BI
Event Date: 26-09-2020 - Session time: 10:45:00 - Track: Cloud Development
This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.
We will discuss
After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.
Event Date: 26-09-2020 - Session time: 10:45:00 - Track: Data Platform
Event Date: 26-09-2020 - Session time: 10:45:00 - Track: Azure DB
We will learn how to monitor the performance of our workload, how to improve it and how to secure it using the tools and features at our disposal on the Azure portal without having to install 3rd party tools. We will also see some ways to lower the costs or increase performance without having to also increase costs.
Event Date: 26-09-2020 - Session time: 10:45:00 - Track: Power BI
Event Date: 26-09-2020 - Session time: 12:00:00 - Track: Azure DB
In this session I will explain the differences between SQL Database, Managed Instance, and Serverless as well as the Hyperscale options. Together we will look at the use casses where these will fit best and when you should not use them in order to deliver the best results for your data driven applications.
Event Date: 26-09-2020 - Session time: 12:00:00 - Track: Azure BI
Event Date: 26-09-2020 - Session time: 12:00:00 - Track: Power BI
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. The audience leave the session ready to start their own monitoring of all or some of the topic
Event Date: 26-09-2020 - Session time: 12:00:00 - Track: Data Platform
Event Date: 26-09-2020 - Session time: 13:15:00 - Track: Cloud Development
Together we will work through the what, why, and how of infrastructure automation with Terraform for building solutions. We will build a data platform solution and look at how we can transition through environments with VSTS and integrate this into development and operations processes that will let you concentrate on delivering more value to your users.
Event Date: 26-09-2020 - Session time: 13:15:00 - Track: Power BI
I will demo how you can build reports based on a Power BI dataset and how to parameterize the report.
I will also show how you can use paginated reports without having a Power BI premium capacity by using Power BI Embedded SKU's to create datadriven subscriptions.
Event Date: 26-09-2020 - Session time: 13:15:00 - Track: Azure BI
Especially in BI development, the usage of database projects, unit testing, version control, continuous integration and deployment is an underrepresented area. Join me in this demo-heavy session where I will guide you through the not-so-frightful jungle of continuous integration using SQL Server database projects, SSIS, T-SQLt and Azure DevOps etc. After this 60 minutes you'll have the guidelines and some ideas how easy it is to change your manual BI development and deployment into a powerful and automated no-brainer that - just works!
Event Date: 26-09-2020 - Session time: 13:15:00 - Track: Azure DB
Event Date: 26-09-2020 - Session time: 13:15:00 - Track: Data Platform
This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Event Date: 26-09-2020 - Session time: 14:30:00 - Track: Cloud Development
With the release of ML.NET, this is no longer the case!
In this session, I'll cover what ML.NET is and how you can use it to add machine learning capabilities to your .NET applications. I'll cover the capabilities that the API offers in terms of preparing our data and evaluating our models. I'll also talk about the capabilities that the ML.NET Model builder and how that can simplify how we choose what type of model we want to build. I'll also talk about how we can deploy our models into production.
By the end of the session, you'll know how you can leverage your existing C# skills to use ML.NET to build machine learning applications!
Event Date: 26-09-2020 - Session time: 14:30:00 - Track: Azure BI
Event Date: 26-09-2020 - Session time: 14:30:00 - Track: Azure DB
We will cover installing Azure Data Studio. What a SQL Notebooks is. Using PowerShell in Notebooks in Azure Data Studio Numerous use cases for you to use SQL Notebooks in your daily workload such as creating a Notebook for Glenn Berry's Diagnostic queries.
and some gifs ;-) Prerequisites: Not having pogonophobia
Event Date: 26-09-2020 - Session time: 14:30:00 - Track: Data Platform
But how can we achieve this in ADF? And finally how do we deploy our DataFactories in Azure Dev Ops to Test, Acceptance and Production environments with these Secrets ? Can this be setup dynamically? During this session I will give answers on all of these questions. You will learn how to setup your Azure Key Vault, connect these secrets in ADF and finally deploy these secrets dynamically in Azure Dev Ops. As you can see a lot to talk about during this session.
Event Date: 26-09-2020 - Session time: 14:30:00 - Track: Power BI
This session introduces the syntax of calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.
Event Date: 26-09-2020 - Session time: 15:45:00 - Track: Azure DB
In this session we will look at what skills you would expect a DBA to have in 2010 and compare it to what they will need in 2020. No doubt we will be covering: • New versions of SQL Server • Automation and PowerShell • Continuous integration • Cloud technology • Maybe some non-technical skills too If you want to get my take on what skills a DBA needs to have in the Roaring 20s then this session is for you.
Event Date: 26-09-2020 - Session time: 15:45:00 - Track: Azure BI
This session is that next stop. We'll start by taking a deeper look inside the spark engine, understanding what makes it tick and how it talks to data. We'll then break down some of the key features that come together to build the kind of data processing task that's changing how we think about ETL.
We'll be looking at:
Each of these features comes together to build a single, generic notebook that can validate the rows within a dataset that meet a specific structure, and it's all driven by metadata!
We'll be doing everything in python, so a light familiarity will help but is not mandatory
Event Date: 26-09-2020 - Session time: 15:45:00 - Track: Data Platform
Snowflake is a vendor offering a native cloud data warehouse, hosted on Azure. In this session, we'll introduce you to this new technology and explain the important concepts to get you started. Walking out of this session, you'll have all the knowledge you need to embark a project with Snowflake.
Event Date: 26-09-2020 - Session time: 15:45:00 - Track: Power BI
In this session I will show you how I build my model documentation external tool and how you can start doing this yourself!
Event Date: 26-09-2020 - Session time: 15:45:00 - Track: Cloud Development
plays a pivotal role in the modern data architecture.
We also demonstrate the public preview features and some of the coming capability at GA.