Sessions & Content

Search
Content Type
Conference
Tags
7 Things I wish I'd known before building a 60Tb DWH on a Dedicated Pool Steve Powell
Lots of ADF, lots of data, lots of automation and lots of lessons learned. Backups aren't as useful as they look, dedicated pools have several "interesting" features in the small print, ADF is not always your friend and how to mitigate the sometimes deadly embrace of throughput vs concurrency trade off.
The video is not available to view online.
A DBA's Guide to the Proper Handling of Corruption Brandon Leach
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to corruption when it strikes.
The video is not available to view online.
Advanced Power BI refresh with ADF/Synapse Mathias Halkjaer
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
The video is not available to view online.
Azure Arc in 50 Minutes Ben Weissman (he/him)
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.
Azure SQL MI End-to-end Demo Party for DBAs and Devs Dr. Dani Ljepava
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.
DataOps 101 – A Better Way to Develop and Deliver Data Analytics John Kerski
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.
Declarative ETL pipelines with Delta Live Tables Vuong Nguyen
Modern software engineering and management for ETL, so data analysts and engineers can spend less time on tooling and focus on getting value from data.
The video is not available to view online.
Extended Governance of Power BI with Microsoft Purview Oliver Engels
Extend your Power BI governance functionality with Microsoft Purview. This session will show you how, what's in it for your PBI Landscape in terms of data catalog, -map and -lineage, data loss prevention, life cycles management and information protection. You will see live demos, watch outs and implementation best practises.
The video is not available to view online.
How To Get the Auditors Off Your Butt with dbachecks Tracy Boggiano
Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.
The video is not available to view online.
Microsoft Defender for SQL: Advanced Threat Protection Rie Merritt
Microsoft Defender for SQL is part of the Azure Defender family and it protects SQL Server in two main ways. We'll cover the first way, Advanced Threat Protection. This is a feature with advanced security capabilities that detect anomalous activities that might access or exploit sql server, like SQL Injection.
The video is not available to view online.
No more data quality surprises in your Databricks, Synapse or Power BI solutions! Dave Ruijter
In this demo-rich session you will learn how you can implement a framework for data quality validation and monitoring, spanning your end-to-end data platform including Power BI!
The video is not available to view online.
Performance Tuning Azure SQL Database Monica Rathbun
Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.
The video is not available to view online.
Power BI Governance quick start Ásgeir Gunnarsson
For many the mention of governance gives them images of massive effort and inconvenience for themselves and end-users. It´s a hindrance and waste of time. But it doesn´t have to be that way. In this session we will talk about how we can start to tackle Power BI governance. We will look at few things you can get started with very quickly that will get you far in setting up your governance strategy. We will look at things such as documentation, roles and monitoring. The hope is that you go back to your organization with a clear picture of where to start and a better feeling on governance.
The video is not available to view online.
Query Store Best Practices Erin Stellato
Want to use Query Store and not sure how to make sure everything is "correct"? Tried Query Store and had issues? In this session we'll cover what you MUST know to successfully use Query Store in a production environment.
The video is not available to view online.
Synapse Link to SQL, bring your on-prem data alive José Barbosa
How to provision, use, and monitor Synapse Link to SQL in order to bring on-premises SQL instances data into Azure Synapse Analytics
The video is not available to view online.
Synapse Q&A with PG Mark Pryce-Maher
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.
The accidental administrator's guide Power BI Michael Johnson
If not properly planned and managed, your Power BI environment quickly becomes a mess., making it hard to use and improve. Join this session where we will look at 6 key areas that you as a Power BI administrator will need to look at.
The video is not available to view online.
There and back again: SQL Server 2022 <-> Managed Instance Dr. Dani Ljepava
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.
Top 10 Azure Data Factory Tips & Tricks Alpa Buddhabhatti
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.
Unity Catalogue and Purview: Data Governance Bedfellows Barny Self
In this demo filled session, learn how to view lineage data from Databricks Unity Catalog in Microsoft Purview.
The video is not available to view online.
<<1234567>>