So you've heard that automating deployments to your databases are all the rage, not least because you don't have to wake up at 2am to perform them. But how do you get from having a database with no automation to having your DB in code, and deploying changes automatically using Azure DevOps?
The video is not available to view online.
We all know that version control for Power BI datasets leaves something to be desired. This is where Tabular Editor saves the day. In this session, you will learn from our mistakes on our journey to CI/CD success see that you can merge the utility of CI/CD with the joy of Power BI datasets.
The video is not available to view online.
Introductory session to Azure Data Explorer that shows some examples how to set up ADX and how to use it.
The video is not available to view online.
How can you everage SSDT in order to deploy DB changes as part of your CI/CD pipeline
The video is not available to view online.
Misconfigurations and default settings in your virtual machine base SQL Server environment can be causing you the performance issues you are having. Learn what you need to build to design and build a high performance virtual machine environment for your SQL Server.
The video is not available to view online.
The session introduces the concept of automated testing and explains how it applies to Power BI solutions, both datasets and reports. Learn about existing tools and approaches and how you can introduce testing scripts to your own CI/CD pipelines.
The video is not available to view online.
Introduction to AutomatedLab PowerShell module that enables you to set up test and lab environments on Hyper-v or Azure in seconds.
The video is not available to view online.
Join me on a journey to understand what Azure Arc is and how it allows you to manage your hybrid and multi-cloud estates.
The video is not available to view online.
Cosmos DB Serverless in a Nutshell
The video is not available to view online.
Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.
The video is not available to view online.
The aim of this session is to highlight the process of implementing Azure Synapse Link for Dataverse and to discuss the reality of working with the data as it is incrementally updated in Azure.
The video is not available to view online.
Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.
The video is not available to view online.
With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.
The video is not available to view online.
Join this session if you want to get a guided tour into an example of how you could implement Azure DevOps in your organisation or team. We will be complete the journey from idea to running code
The video is not available to view online.
In this session we will take a look into some external tools and how can they help us take the our development skills to another level. From the creation of metrics to the deployment of models the usage of Power BI can be optimize using external tools. This session is for intermediate users that already know their way into Power BI but want to increase their development skills and speed.
The video is not available to view online.
Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.
The video is not available to view online.
In this session I'll guide you from through a secure reference architecture with Data Factory, Databricks, Data Lake, and Azure Synapse, working together as a secure, fully productionised platform. Each has their own idiosyncrasies, but this session will teach you the options available and the pitfalls to avoid.
The video is not available to view online.
Cloud migration projects are often massive projects with sprawling scopes. Don't you want some help sorting through this enormous pile of work? Join an experienced cloud migration consultant for a targeted walkthrough of their cloud migration success checklist so you can make sure your project gets off to a good start and reaches a successful completion.
The video is not available to view online.
Azure DevOps is the leading deployment tool for build and release solutions end to end. It helps you plan your Agile project, manages Git code, and deploys solutions using Continuous Integration (CI) and Continuous Deployment (CD) pipelines. In this session we will cover some of the core components of Azure DevOps and show you how to implement a secure deployment pipeline, using unit tests and gating with your CI builds and CD releases.
The video is not available to view online.
Implementing the Power BI Metrics feature in your organization.
The video is not available to view online.
We cloud solutions architects from Microsoft, will be demonstrating all the use cases with demos of the newly available (currently in public preview) Azure SQL Managed Instance Link. We will talk about all the available migration tools like DMA, DMS, Azure Migrate, ADS and why you may want to use MI Link to migrate on-prem SQL Server to Azure SQL Managed Instance as compared to other available migration tools.
The video is not available to view online.
Ever come across a Power BI report that looks like it was built by 20 different people? Avoid report noise and learn how to build your very own Power BI UI templates by creating standardised visuals, slicers, colour palettes and more!
The video is not available to view online.
From a development perspective Power BI gives you some challenges you can't overcome easily. When you and your team are continuously working on Power BI files, you need a central location, to keep track of changes, find differences between versions, check out files and deploy in an easy way. In this sessions we will see how Azure DevOps helps you with versioning, CI/CD-pipelines and tracking changes in datamodels.
The video is not available to view online.
So you’re the data person in your company and you need to look to the sky. Maybe you've been wanting to do it for a while, maybe it's a mandate coming from the top. What are the steps you need to think about? Where do you even start? What are the risks? How can you begin to wrap your head around all the different things you have to coordinate? Companies don't just need the IDEA that they should move to cloud, but a guide on how-to-do it. This session will not only give you that guide to get you going, but a foundation to take to your bosses to show just how awesome you really are.
The video is not available to view online.
Going from an machine learning model trained on your laptop in a notebook called “trainmodelV1Final_FINAL (1).ipynb” to a system ready to deploy is difficult. However, MLOps (a set of principles to prepare your model for prime time) is here to help! This talk is an introduction to all the elements you need to get your code production-ready - CI/CD, dev/UAT/prod, pipelines, and more! We'll walk through system diagrams, with a focus on Azure, but the takeaways will all be platform agnostic. Make sure your model deployment isn’t an ML-Flop!
The video is not available to view online.
We will go through a brief introduction to what Machine Learning is and some of its applications. we will then explore why AutoML should be used by all; as a great starting point for anyone new to Machine Learning, as well as a time saving tool for those more experienced. Finally, we will expose a model as an endpoint and understand how we can use it. Specifically in this case how to use it in excel via VBA. Technologies I will demonstrate are: - Azure Machine Learning Studio - VS code (with Azure Machine Learning Studio extension) - Python - VBA
The video is not available to view online.
Come and learn how to leverage C# to programmatically create and manage columns, measures, hierarchies, and translations within existing data models in Power BI using the XMLA endpoint. Happy coding!
The video is not available to view online.
The session presents and explains the components required to establish a highly effective team developing Power BI models: Processes, Tools, Deployment Automation, and Documentation. Attendees will be able to take away plenty of proven ideas and patterns, including a source control based development model, a change management system using release pipelines, and a CI/CD setup providing automation at all possible stages. The key focus will be on the right processes to implement within the team.
The video is not available to view online.
Moving from traditional SQL Server to Azure SQL Database can be a challenge! There's already lots to think about before you make the move, but this session can help you with one of those considerations: What do I do with my old SQL Agent Jobs?
The video is not available to view online.
Getting changes from SQL Server to Event Hub can be tedious. I'll show you how to set up Debezium to automate SQL Server change data capture into Event Hub and explain why this matters for your serverless architecture!
The video is not available to view online.
Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.
The video is not available to view online.
SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.
The video is not available to view online.
Join Patrick Leblanc from the Power BI CAT team, Josh Luedeman, and Bradley Ball from the Azure FastTrack PG as we talk about the most powerful Azure Service you’ve never heard of. If only you knew the name of the service. Come to this session, and you’ll never forget it!
The video is not available to view online.
In just 20 minutes you will see a demo of bidirectional database failover between SQL Server 2022 and Managed Instance, using the link feature. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.
The video is not available to view online.
If you're getting started with an implementation using Infrastructure as Code, one of the first things to figure out is which tool to use. In this session will dive into the details of the differences of Bicep and Terraform to help you choose the best option for your scenario. We will begin the session by going through the similarities of Bicep and Terraform, but will then jump straight into the differences of these two tools. We will cover how state is handled, how configuration is scoped and how making changes is evaluated. Then we will go through how existing resources are handled and using preview features. At the end of this session you will be able to choose which tool is the best option for your implementation!
The video is not available to view online.
ADF Tips and Tricks which help you to speed up your Azure Data Integration solution,save operational cost and improve performance.
The video is not available to view online.
Avoid common pitfalls when deploying Data Platforms with Terraform. Lessons learned from using Terraform in real-world corporate environments.
The video is not available to view online.
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
The video is not available to view online.
In this session, we'll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work.
The video is not available to view online.
In this session I'll cover what the Data Lakehouse architecture is, where it fits against existing architectures like a data warehouse, and why you should build one. We'll also cover the underlying technology options to arm you with all of the information you need to plan your next data platform.
The video is not available to view online.
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
Are you planning a migrating of your data platform to Azure Synapse Analytics? Is it currently based on Azure Databricks, Azure Data Factory, and Azure Data Lake Storage? Make sure to grab these 10 tips! We'll talk about Spark compatibilities, orchestration pitfalls and solution deployment differences.
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
The video is not available to view online.
Using open source apache nifi to integrate and ingest data at scale
Introduction into Terraform, Databricks provider and steps required to build an automated solution to provision Databricks workspace and resources into Azure cloud platform using Terraform.
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
In this session we will introduce Azure Container Apps and understand how it can be used as a simple and cost-effective way to host applications in Azure
I will show a few challenges while deploying Azure Data Factory and solution for them.
How to deploy SQL databases, data factories, and tabular data models to Azure using Azure DevOps release pipelines.
<<123>>