Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
A guide to available services and solutions for timeseries data
After understanding the basics, lets take the next step in data modeling in Power BI!
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
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.
A short intro to Lambda Architectures - what they mean, what they are, and how you can use them in your solutions
The video is not available to view online.
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Understand how to get started with any machine learning project using Databricks AutoML
Overview to some of the more popular Azure Data Engineering services used to analyze data
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
Learn how to unlock massive datasets for interactive analysis, accelerating time to insight, and reducing TCO.
In this session, you will tag along the journey of working towards a solution to this problem. We will touch upon topics like automated workflows with Power Automate, Active Directory Security Groups, Decoupled Datasets and Security Tables, all combined with Row-Level Security to bring them all together.
The video is not available to view online.
"Don't force me to *think*!" - how to help people find insights in information more easily by making well-informed design decisions.
The video is not available to view online.
DW Automation and Design Best Practices
In this session we will take the relational data model for a simple e-commerce application and migrate it to a horizontally partitioned, NoSQL database. Along the way you will learn the concepts, techniques and technologies needed to model for a horizontally partitioned NoSQL database that will allow your application to achieve millisecond response times with near unlimited size and scalability.
The video is not available to view online.
Hybrid Transactional Analytical Processing solve the age old problem of integrating operational processes with analytical capabilities within a single system. Find out what they're and how they deliver value
In this session you will learn how to keep you data up to date i Power BI.
What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?
Understanding how the parquet format works helps with understanding why it can help you retreive your data fast, or perhaps why you struggle to get the desired performance out of your design.
SQL Server is a complete Machine Learning platform - learn a complete process to use it from data ingestion to model deployment.
<<12>>