SQLBits 2023
2023-03-14..2023-03-18
Newport, United Kingdom
SQLBits ·
[SQLBits 2019, SQLBits 2020, SQLBits 2022, SQLBits 2023, SQLBits 2024]
who it's for
database administrators, data engineers, Power BI developers, cloud architects, data architects, data governance leads, analytics managers
topics
Azure SQL Database performance tuning; SQL Server 2022 features; Azure Data Explorer (Kusto); Azure Synapse Link; columnstore index compression; intelligent query processing; Query Store troubleshooting; Azure Data Studio notebooks; Power BI composite and hybrid models; Power Apps write-back; Debezium change data capture to Event Hub; Microsoft Purview data governance
| title | author | length |
|---|---|---|
| "I can't keep up!" - Turning Discomfort into Personal Growth in a Fast-Paced World | Cathrine Wilhelmsen | 21m |
Argues that steady, planned nudges beat frantic catch-up: choose one priority (example: Azure Synapse), split it into milestones, and block out your calendar… | ||
| +5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems | LINDA TORRANG, Alexander Arvidsson | 46m |
Claim: most failures start with the wrong question and a rush to technology. Concrete techniques: start with open-ended then closed-ended questions, listen for… | ||
| 20 mins to git comfortable | Rob Sewell | 19m |
Shows how to get a working local Git history in minutes by running git init, using git add . / git commit -m and inspecting changes with git log and file… | ||
| 5 Things You Can Do to build better looking reports | James McGillivray | 22m |
Five actionable moves for Power BI: adopt a strict 16x9 grid with defined gutters and margins so visuals snap to pixel-perfect boxes; maximize real estate by… | ||
| A Capgemini Solutions Architect discusses common customer challenges, program trends & initiatives. | Prashant Bhargava | 21m |
Argues that precise, versioned installation and runbook documentation turns a click‑next install into reproducible, auditable procedures used for handovers, DR… | ||
| A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar | Nicky van Vroenhoven | 19m |
Step‑by‑step build of a live pipeline: create a form, make a Flow from scratch to pull response details, push into a Power BI streaming dataset and pin visuals… | ||
| A Practical Starter Guide to SQL Notebooks | Deborah Melkin | 50m |
A practical how-to shows Azure Data Studio with the Jupyter extension enabling SQL notebooks, demonstrates export as notebook from a query window, and runs SQL… | ||
| A to Z Azure SQL Security Concepts | Deepthi Goguri | 45m |
Covers concrete Azure SQL controls: four network layers from allow Azure services to private endpoint (demonstrates client_net_address 10.0.0.7 matching VM)… | ||
| Accelerate Release Velocity and Quality with Modern DevOps Test Data Management Practices | Corey Brune | 43m |
Shows how Delphix ingests large production sources (15–20 TB), compresses and snapshotting them as immutable images, and delivers masked, consistent copies… | ||
| Analytics in SQL Server and Azure SQL Database | Ajay Jagannathan, chuck heinzelman | 49m |
Covers concrete features and demos: in-memory OLTP plus clustered/nonclustered columnstore enable mixed transactional/analytical workloads; a simulated IoT… | ||
| Azure Data Explorer - a Torch in the Dungeon of Observational Analytics | Guy Reginiano, Pawel Potasinski | 51m |
Azure Data Explorer (Kusto) is a managed columnar service for high‑frequency, semi‑structured and free‑text logs with built‑in compression, full‑text indexing… | ||
| Azure Data Factory, Azure Databricks, or Azure Synapse Analytics? When to use what. | Lisa Hoving | 40m |
Starts from a 6M‑row parquet on ADLS Gen2 and compares ingestion, transformation, cost and runtime across the three Azure options. Azure Data Factory is a GUI… | ||
| Azure Data Studio and the Surprises Inside | Erin Stellato | 51m |
Azure Data Studio proves to be a lightweight, cross‑platform alternative that actually adds tangible features: a built‑in terminal that runs the new sqlcmd, an… | ||
| Azure SQL Managed Instance Roadmap | Niko Neugebauer | 50m |
Azure SQL Managed Instance roadmap lists concrete rollouts: 16 TB business critical with four synchronous replicas, GA transactional replication, MS DTC… | ||
| Azure Stack HCI and Microsoft Hybrid Data Services | Kenny Lowe, Stephen McMaster, Dilip Ramachandran, Robert Sonders | 48m |
Dell Integrated System for Microsoft Azure Stack HCI with 3rd‑gen AMD Milan‑X processors runs SQL Server 2022 as a DBaaS using Azure Arc and AKS, deploying 20… | ||
| Azure Synapse Link for Dataverse Implementation | Aoife Turley | 21m |
Azure Synapse Link for Dataverse continuously exports Dataverse into ADLS Gen2 and can optionally create a lake database (external tables built by the Apache… | ||
| Banishing Slow Queries with Intelligent Query Processing | John Morehouse | 53m |
Overview of SQL Server 2019 and 2022 Intelligent Query Processing features that actually change plans with zero code edits: enabling table variable deferred… | ||
| Become a Power BI Data Modeling Wizard using Tabular Editor 3 | David L. Bojsen, Morten Lønskov | 43m |
Tabular Editor 3 connects to a Power BI PBIX with data and delivers IntelliSense and an interactive DAX debugger (claimed first of its kind) that steps through… | ||
| BI Power Hour | Chris Webb | 51m |
A rapid-fire set of spoof demos shows functioning prototypes and bold claims: a SQL Server–backed text adventure (a MUD) that reads and writes game state to… | ||
| Building an Open Data Lakehouse using Apache Spark, Apache Iceberg and Dremio | Mike Flower | 45m |
Shows how to build an open lakehouse end-to-end: create an Apache Iceberg table from Apache Spark, insert and merge rows, inspect table snapshots for time… | ||
| Building Distributed OLTP with Azure Cosmos DB for PostgreSQL | Charles Feddersen | 52m |
Demonstrates building OLTP on Azure Cosmos DB for PostgreSQL using the open‑source Citus extension and Postgres SQL: default 32 shards sharded by a… | ||
| Building SaaS solutions on Azure SQL Database | Denzil Ribeiro, Silvano Coriani | 48m |
Azure SQL Database supports two practical SaaS patterns: elastic pools (single database per tenant) and hyperscale serverless (true multi-tenant). Elastic… | ||
| Building Trust in Teams | Richard Campbell | 49m |
Argues that trust grows from repeatable practices not slogans: influence is the one skill individuals can control, and scheduling one-on-one lunches and… | ||
| Building trust in your data. Why data governance is the key to success. | Marthe Moengen, Johan Ludvig Brattås | 40m |
Explains why metadata, lineage and quality checks must be operationalized, not just theorized, and shows live demos of Azure Purview scanning Power BI and… | ||
| Business Benefits of Good Governance | Victoria Holt | 47m |
Argues that governance must be use-case driven, start with a maturity assessment and deliver quick wins rather than a two‑year program, and that automation… | ||
| Choosing the Right Data Store--An Overview of Azure Data Platform Choices | Joey D'Antoni | 20m |
Clear mapping of Azure options with limits and gotchas: choose VMs for legacy features and full control; Managed Instance supports cross-database queries, CLR… | ||
| Columnstore Index Compression in a Nutshell | Edward Pollack | 20m |
Describes how SQL Server stores analytic data in rowgroups (up to 2^20 ≈ 1M rows) with one column per segment compressed separately, using dictionary and value… | ||
| Combine Power BI with External Tools | Miguel Félix | 48m |
Shows how to automate measure creation and debugging with Tabular Editor (runs scripts to generate display folders, create measures, and surface BPA rule… | ||
| Create Your Own Epic Adventure with PowerApps and Power BI: Dungeon and Dragons Edition! | James Solan, Lee John, Matthew Bean | 39m |
A playable Dungeons & Dragons–style game is built in PowerApps with Power Automate, Azure SQL Database and Power BI, generating GPT-3 backstories and DALL·E… | ||
| Creating a Culture of Accountability, Diversity and Inclusion | David Suson | 49m |
Claims that a simple, actionable MVP model — MVP (Mindset, Value, Push) — shifts quiet quitting into commitment by modeling empathy, setting expectations… | ||
| Crossing The Streams: Adding PostgreSQL to Your SQL Server Skillset | Grant Fritchey | 20m |
Redgate adds PostgreSQL to its toolset and the migration is practical not theoretical: expect demos of spinning up Postgres on AWS RDS and Docker, using Azure… | ||
| Data Observability with HEDDA.IO | Oliver Engels, Tillmann Eitelberg | 21m |
HEDDA.IO deploys into an Azure subscription and runs validation from Synapse/Databricks notebooks, producing per-run overall scores (example: Yellow Taxi demo… | ||
| Designing Data Architectures that InfoSec will actually approve | Craig Porteous | 51m |
Reference architecture uses Azure Data Factory, Databricks, Azure Data Lake and Azure Synapse wired into a hub‑and‑spoke VNet with private endpoints and v‑net… | ||
| Designing for Accessibility | Serena Samra | 16m |
Power BI Desktop shows concrete accessibility moves: use Alt+Shift+F11 to expose a screen-reader-friendly data table, set tab order via Selection pane (or let… | ||
| Designing Presentations for a Diverse Human Audience | Meagan Longoria | 46m |
Argues that presentations become measurably more learnable by designing for viewers not ego: use Sans serif fonts, keep body text at 24–32 point minimum, limit… | ||
| Do You Speak English? Localized Reports with Power BI | Markus Ehrenmueller-Jensen | 50m |
Shows a working, data-driven method to switch report UI and dimensional content languages in Power BI using a 3DS filter trick in DAX, a bridge table with… | ||
| Don't be scared with Hybrid, they are only tables… | Maria Gabriel, Bruno Mairos | 48m |
Shows a working Power BI hybrid table pattern that keeps four years of historical data imported, refreshes the most recent seven days incrementally, and serves… | ||
| Efficiency up, failed releases down; compliant production data for your test and dev environments | Grant Fritchey, Chris Hawkins | 47m |
Explains how to get realistic, compliant non‑production databases by tagging sensitive fields with Data Catalog, generating rules to detect PII and formats… | ||
| Financial Statements with Power BI - Part 1 P&L/BS | Bob Duffy | 52m |
Shows a metadata-driven approach that turns a chart of accounts into formatted P&L and balance sheet layouts using a many-to-many bridge table (built in Power… | ||
| FinOps, how data engineers get their cloud cost under control | André Kamman | 41m |
A data warehouse of ~200 TB moves to Synapse and ends up in the top-cost list at €150,000/month, driven by a DW6000c compute tier and many expensive queries… | ||
| Focusing on the why - Power BI User Journeys | Mara Pereira | 19m |
Asks for why, not what and maps the exact steps users take from opening a Power BI report to the decision they make, using mind maps in Miro to capture first… | ||
| From the Classroom to the Boardroom – Azure SQL DB through Demos | Silvano Coriani, Sanjay Mishra | 49m |
Live demos show a local Azure SQL DB emulator, VS Code SQL projects (SDK style) and a CLI-first tool Data API Builder that turns tables into REST/GraphQL… | ||
| From Your Couch to the Cloud: When and Why to Choose the Azure Portal | Erin Stellato | 51m |
Focuses on when the Azure Portal is the right tool: provisioning logical servers, networking and firewall rules, configuring failover groups, creating and… | ||
| Get PaaS like benefits outside of Azure with Azure Arc enabled SQL Managed Instance | Dinakar Nethi | 50m |
Azure Arc enabled SQL Managed Instance runs as the same SQL engine in Linux containers on CNCF‑certified Kubernetes, delivering true PaaS features on your… | ||
| Gathering Requirements for your Star Schema | Terry McCann, Johnny Winter | 50m |
A requirements method called Sunbeam combines BEAM and some modeling to produce a conceptual star schema by workshop: discover events, run the 7Ws (who what… | ||
| Govern your self-service integration processes | Oliver Engels, Tillmann Eitelberg | 19m |
WOODY.IO is an Azure-native app that lets non-engineers upload, validate and persist data to targets like SQL Server, Databricks Delta Lake, Data Lake, SAP… | ||
| Ground to Cloud: Your Migration Success Checklist | Matt Gordon | 21m |
Nine practical checklist questions guide a migration: what is moving (data, apps, oddball mainframes), why (cost, exit datacenter, three years extended support… | ||
| How Do I Reduce My Cloud Bill? | Joey D'Antoni | 20m |
Focus is Azure cost levers: use the Azure pricing calculator and azureprice.net for region comparisons, enable budgets and auto shutdown on dev subscriptions… | ||
| How to Architect your Data Platform for Success | Ben Jarvis | 19m |
Ten practical rules and concrete tool choices for Azure data platforms: start with Cloud Adoption Framework and Enterprise Scale landing zones deployed via… | ||
| How to build brilliant managers (including yourself) | Lubna Thomas, Steph Locke | 50m |
Argument: promoting top engineers without training fails, so build management deliberately. Employer example: a 200,000-person company trains every manager… | ||
| How to Get Noticed for Power BI Job Interview? | Odeta Jankaitienė | 19m |
Uses an interactive Power BI CV built from a LinkedIn export and stored on GitHub, demonstrating a single concrete trick to get noticed: make your résumé a… | ||
| How to get started with Computer Vision AutoML in Azure | Gavita Regunath | 16m |
Azure Custom Vision on Cognitive Services shows actual steps: create resource with training and prediction, upload labeled images, and hit Train. A useful… | ||
| How to learn fast-changing tech in a post pandemic, Attention-starved world | Rishi Sapra | 19m |
Claim: focus on specific goals, practice fast, and teach to learn faster. Uses Power BI examples, Azure migration as a concrete goal, and a learning loop… | ||
| How to Slay Your Personal Dragons and Take the Next Step in Your Career | James Ward | 20m |
Career advice grounded in specific moves: use Power BI and prophecy at work, lean into community groups like Saturday Morning Learning, and book 5–10 minute… | ||
| Identifying and Preventing Unauthorized Power BI Gateways | Angela Henry | 20m |
By default any user with Power BI access can register a gateway, which creates uncontrolled personal and on‑prem installations. Use Settings > Manage… | ||
| Introduction to the wonders of Azure DevOps | Anna-Maria Wykes, FALEK MIAH | 50m |
Covers an end-to-end Azure DevOps workflow that actually builds a Python wheel with YAML pipelines, runs pytest unit tests, publishes an artifact to Azure… | ||
| Lessons learned from refactoring multi terabyte databases for the last 10 years | Sergey Olontsev | 54m |
Ten concrete refactoring tactics for multi‑TB databases: use SQL Server in Docker for repeatable dev/test, keep schema changes tiny and fast, put external… | ||
| Lift and Shift with dbatools - Azure SQL Managed Instance edition | CLÁUDIO SILVA | 46m |
dbatools (650+ commands) automates lift‑and‑shift from on‑prem SQL Server 2022 to Azure SQL Managed Instance using PowerShell: create managed identity for blob… | ||
| Making Dungeons and Dragons Accessible | Ash Graham-Brown, Laura Graham-Brown | 51m |
Claim: a low-code Power BI report can turn a six‑page D&D character sheet into a usable, accessible battlefield tool. Built components: large AC/passive… | ||
| Maximize the business value of data with Microsoft Purview Data Governance | Gaurav Malhotra, Blesson John | 51m |
Microsoft Purview claims a unified, serverless data map that scans hybrid estates (56 connectors), extracts column‑level lineage and semantic tags (200+… | ||
| Microsoft Purview Data Governance: Updates & Roadmap | Gaurav Malhotra | 48m |
Purview claims a real roadmap: 56 sources are public-preview or GA and four private-preview connectors (AWS Redshift, Tableau, datawverse and Databricks Unity… | ||
| MLOps and ML-Flops: going from dev to prod | Andrew Blance | 45m |
Shows how to move from messy local notebooks (hundreds of Untitled_final.ipynb files) to a repeatable dev/UAT/production pipeline using Azure services… | ||
| Model Creation in Azure AutoML and Ingestion Through Excel | Lewis Prince | 37m |
Creates a classification model in Azure Machine Learning Studio using AutoML (runs many preprocessing + algorithm trials automatically), finds a stack ensemble… | ||
| Never ETL again, thanks to Synapse Link. Really? | Ben Weissman | 19m |
Synapse Link claims to push OLTP rows to Azure Synapse in near‑real time but actually requires a self-hosted integration runtime, writes into an ADLS Gen2… | ||
| Next Level Availability on SQL Server 2022 | David Pless | 47m |
SQL Server 2022 introduces concrete availability changes: distributed availability groups add an opt‑in zero‑data‑loss failover (guaranteed but with a… | ||
| No more data quality surprises in your Databricks, Synapse or Power BI solutions! | Dave Ruijter | 50m |
Uses Great Expectations inside Databricks/Spark to run column and table checks on a 10 million‑row sample, generate and save JSON expectation suites, and build… | ||
| Performance Tuning Azure SQL Database | Monica Rathbun | 51m |
Covers concrete steps for Azure SQL Database tuning: enable Azure SQL Analytics (Log Analytics) to capture deadlocks, waits and timeouts; use Query Performance… | ||
| Power BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution | Pawel Potasinski | 52m |
Demo builds a lakehouse on Azure Synapse: ingesting NYC Yellow Taxi files into a bronze folder, running a parameterized pipeline that copies ~11 tables… | ||
| Power BI Composite and Hybrid Models | Alex Whittles | 51m |
Shows how to combine import and DirectQuery so a billion-row web‑hits fact stays in source while a pre‑aggregated import table serves most visuals, cutting a… | ||
| Power BI Incremental refresh made simple. | Robert French | 50m |
Step‑by‑step shows how to configure incremental refresh for Dataflows and Datasets using Power BI (Pro or Premium Per User), a sample SQL Server with two… | ||
| Power Up with the Power Platform | Heidi Hasting | 52m |
Live demos show a Power BI report that accepts Azure SQL write-back from a canvas Power Apps to update monthly targets with instantaneous refresh (avoiding… | ||
| Protecting the confidentiality and integrity of your high value data with Azure SQL and SQL Server 2 | Jakub Szymaszek | 48m |
Covers concrete controls: TDE with customer‑managed keys (stored in Azure Key Vault, auto‑rotation and per‑database CMKs, revoke access makes DB unavailable… | ||
| Query Store: A Retrospective | Conor Cunningham | 48m |
Query Store originates around 2008, faces three cancellations, and ships in SQL Server 2016; it records query text, semantic context, and stores show plans… | ||
| Should We Defragment Indexes? | Rob Mandeville | 19m |
Argues that external fragmentation can make defragmenting counterproductive: rebuilding or reordering pages often concentrates them onto a single capacity… | ||
| Soft Skills eat Technical Skills for Breakfast | Bradley Ball | 19m |
Three books provide the tactics: On Writing for concise, purposeful emails and when to leave details out versus precise documentation; Crucial Accountability… | ||
| Spark Execution Plans for Databricks | FALEK MIAH | 44m |
Shows how Databricks uses the Catalyst Optimizer and explain() to turn code into logical then physical plans, with examples: a range 1..1,000,000 DF… | ||
| Spell of Transmutation - Using Debezium to Transfer Realtime Data Changes to Event Hub | Alexander Arvidsson | 46m |
Sets up Debezium to stream SQL Server CDC into Azure Event Hub using an Azure Container Instance that posts via the Kafka endpoint; includes a local Azure… | ||
| SQL Migrations to Azure Made Easy | David Levy | 46m |
Walks through using Azure Migrate plus the Azure Data Studio SQL migration extension to discover and assess an entire VMware host, auto-discovering 196 servers… | ||
| SQL Server 2022 - the most Azure-enabled SQL Server yet | Ajay Jagannathan, chuck heinzelman | 48m |
Managed Instance Link creates a DR/migration path that seeds on‑prem SQL Server 2022 to Azure Managed Instance, supports read replicas and planned… | ||
| SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy | Stephen McMaster, Robert Sonders | 21m |
Showcases Transact-SQL snapshot backup on SQL Server 2022 that freezes writes, generates a readable BKM metadata file, and lets T‑log rollforward from a… | ||
| SQL Server 2022 and the Wheel of Power | Bob Ward | 51m |
SQL Server 2022 ships cloud connectivity and on‑prem tools: Azure Arc enabled SQL Server installs a connected machine agent, monitoring agent and SQL extension… | ||
| SQL Server 2022 migrations with dbatools | Jess Pomfret | 20m |
dbatools migrates databases and logins to SQL Server 2022 using concrete steps: copy DBA login transfers SIDs and hashed passwords so logins aren’t orphaned… | ||
| Stop Doing Stupid $%^--How Not to Secure Your Environment | Joey D'Antoni | 20m |
Lists concrete failures and fixes: shared credentials and credential stuffing, service accounts granted domain admin privileges, and VMs with 1433 open to the… | ||
| Take a self-taught journey into the world of Data | Rosie Djurovic | 14m |
Leaves a clear, repeatable path: starts in Excel, learns Power BI and Power Query, studies star schema and DAX on Microsoft Learn, then learns Python to… | ||
| The accidental administrator's guide Power BI | Michael Johnson | 51m |
Overview of the concrete actions an accidental Power BI admin must take: claim and lock down the tenant settings and admin roles, decide between shared… | ||
| The Microsoft Intelligent Data Platform | Buck Woody | 51m |
Microsoft shows a pragmatic stack that connects on‑prem and multi‑cloud data: Purview data map catalogs spreadsheets, blobs, SQL, Cosmos and tags sensitive… | ||
| The Most Important Performance Factor in SQL Server and Azure SQL | Guy Glantser | 53m |
Central claim: query performance hinges on accurate statistics, not indexes alone. Demo shows missing stats cause SQL Server to use a square‑root default… | ||
| The Power BI Engine in 20 minutes | Kasper de Jonge | 21m |
Power BI loads data via Power Query M (now ~150 data sources), pushes foldable steps back to the source when possible, and stores imports in the VertiPaq… | ||
| The SQL Leadership Panel | Bob Ward, Sanjay Mishra, Erin Stellato, Niko Neugebauer, Muazma Zahid, Asad Khan | 40m |
Leadership team lays out concrete road map: on‑premine SQL continues with SQL Server 2022 in on‑prem receiving cloud parity of features (Ledger, JSON… | ||
| The Top 5 Must-Cares for On-Boarding New Team Members | Wolfgang Strasser, Michaela Berndl | 21m |
Hiring process replaces grilling with a half-day assessment that focuses on personality and gives candidates access to real projects and colleagues, not… | ||
| The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance | Dani Ljepava | 44m |
A hybrid bridge called Mi link replicates user databases near real‑time from SQL Server 2016–2022 into Azure SQL Managed Instance using distributed… | ||
| The wonderful world of collations, encodings and text storage | Mladen Prajdic | 45m |
Explains characters, encodings, collations, sort orders, diacritics and code pages as they relate to text storage in databases, using SQL Server/Azure context… | ||
| Three things to know before going Independent | John Sterrett | 19m |
Starts independent work by ditching hourly buckets and charge for value not hours: early math was 1,000 billable hours × $200 = ~$200k but that model breaks… | ||
| Tidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers | Lior Asta | 44m |
Practical checklist for multi-cloud SQL estates: shows how a monitoring stack aggregates queries from Azure SQL, SQL Server, Oracle, MySQL, Postgres and… | ||
| Understanding Alert Fatigue | Owen Murphy | 16m |
Explains that unchecked monitoring floods teams (often 50–100 alerts per day), causing missed incidents, slower response, burnout and even failed IT projects… | ||
| Understanding and Managing Data Lineage in Power BI | Joe Billingham | 20m |
Explains that native Power BI gives only a 30-day retention limit and coarse workspace-level lineage, then shows Power BI Sentinel as a SaaS that extracts… | ||
| Unity Catalogue and Purview: Data Governance Bedfellows | Barny Self | 49m |
Live demo integrates Unity Catalog and Microsoft Purview by calling the Unity Catalog REST API and Databricks CLI from Python notebooks, using pyapacheatlas to… | ||
| Using Automated ML models in Azure Synapse Analytics | Anupama Natarajan | 48m |
Provisioned an Azure Synapse workspace and Spark pool, created an Azure Machine Learning workspace, loaded data into a Spark table from a notebook, and… | ||
| What the heck is a checkpoint, and why should I care? | Taiob Ali | 51m |
Explains what a checkpoint actually does: it flushes transaction log records to disk, writes dirty pages back, updates the database boot page with a checkpoint… | ||
| Why the Lakehouse? | Craig Porteous | 21m |
Argues that a Lakehouse replaces a separate warehouse by putting Delta-format files plus a transaction log into cheap scalable storage, giving ACID + time… | ||
| Write-back with Power Apps in Power BI | Nicky van Vroenhoven | 47m |
Shows a working write‑back pipeline: a Power Apps form embedded as the Power Apps visual in Power BI edits promotion rows and updates a SQL Server table (SQL… | ||
| To Bicep or to Terraform - That is the Question | Heini Ilmarinen | 49m |
Compares Bicep and Terraform for Azure with concrete differences: Bicep compiles to ARM, is Azure-native and uses no state file, defaulting to resource-group… | ||
| The Future of Version Control for Tabular Models | Gabi Münster, Mathias Thierbach | 50m |
Announces a new Tabular Model Definition Language (timdal) that serializes models into a folder-based file per artifact layout, with a VS Code extension and… | ||
| Merging Power BI into Azure Devops | Hylke Peek | 41m |
Shows how Azure DevOps stores PBIX and extracted model JSON so teams get extract model JSON for diffs instead of fighting binary files, uses Visual Studio for… | ||
| Time Intelligence in Power BI | Alberto Ferrari | 50m |
Shows how Power BI’s auto date/time creates multiple hidden calendars and why the fix is to disable Auto Date/Time and build a single date table (DAX, M, SQL… | ||
| Power BI Datamart - What, How and Why? | Marthe Moengen | 19m |
Power BI Datamarts creates a fully managed Azure SQL database inside Power BI Service (requires Premium), ingests multiple sources (Excel, SQL Server… | ||
| Behind the Hype - Architecture Trends in Data | Simon Whiteley | 50m |
Argues that modern lakehouses using Delta lakehouse (transaction log, time travel, updates/merges) actually fix old lake pains and enable warehousing on cheap… | ||
| Introduction to Dataverse | Rosie Djurovic | 36m |
Sets up sandbox and dev environments, creates a Dataverse database, uploads Excel via a dataflow using Power Query, and loads a new TryLife_Sales table with an… | ||
| DataOps 101 – A Better Way to Develop and Deliver Data Analytics | John Kerski | 50m |
Shows how to stop babysitting Power BI reports by adding concrete DataOps practices: put PBIX and model JSON into source control (git or OneDrive version… | ||
| Power BI - Call REST API | Iuliana Tuhasu | 11m |
Live demo shows calling a REST endpoint from Power BI Desktop using Python with pandas and requests and returns a JSON dataframe for Power Query. The flow… | ||
| Debugging SQL Server | Bob Ward | 50m |
Shows how the product team reproduces and diagnoses real crashes and hangs using concrete tools: loading mdmp files with the Windows Debugger, running dot ecxr… | ||
| Secure networking with Azure and Azure SQL Managed Instance | Niko Neugebauer, Zoran Rilak | 45m |
Azure SQL Managed Instance requires a dedicated subnet that can’t host other resources, and DNS changes in the VNet must be notified to the instance… | ||
| Declarative ETL pipelines with Delta Live Tables | Vuong Nguyen | 51m |
Declarative pipeline framework that turns SQL or Python notebooks into production ETL with cloud_files autoloader for incremental file ingest, exactly-once… | ||
| Why is Batch Mode Fast? | Conor Cunningham | 49m |
Batch mode runs columnstore data in cache‑sized batches, using vector and new CPU instructions so analytics run far fewer cycles and fewer mispredicted… | ||
| Power BI Governance quick start | Ásgeir Gunnarsson | 19m |
Governance starts with a short, practical plan: pick relevant bits from existing IT or data strategies, write best-practice processes for development… | ||
| Generate test data quick, easy and lots of it with the Databricks Labs Data Generator | André Kamman | 19m |
Databricks Labs Data Generator uses Spark to create synthetic data at cluster scale, generating 100 million rows in 11s on a 12‑node (104‑core) cluster and… | ||
| Managing access to data sources in your data estate with Microsoft Purview | Erwin de Kreuk | 22m |
Microsoft Purview Access Policies let you manage cross‑estate permissions without adding RBAC roles by publishing policies to Azure Storage, Azure SQL, Arc… | ||
| Let Me Sell You on Power BI Goals - The True Dashboard in Power BI | Tommy Puglia | 50m |
Power BI Metrics (scorecards/goals) claims to turn a metric into a collaborative, tracked dashboard: it connects to any report across workspaces, requires no… | ||
| Security techniques for cross database access | Uwe Ricken | 53m |
Compares four concrete ways to allow cross-database queries and shows demos that work or fail: naive approach grants users in every target DB (works but scales… | ||
| AI Driven Data Enrichment with Azure Cognitive Search | Matt How | 19m |
Shows how to turn raw PDFs and Office files into a searchable, enriched index using Azure Cognitive Search plus a bridge of indexers and skillsets, running… | ||
| Understanding Maintenance in Azure SQL | Rie Merritt | 20m |
Azure SQL does platform maintenance for OS, firmware and the SQL engine and enacts it by patching secondaries then failing the primary to a healthy replica so… | ||
| Securing Azure Cosmos DB | Leonard Lobel | 51m |
Shows how to lock down Cosmos DB with concrete configs: use the IP firewall, VNet, private endpoint options to prevent public access; replace master keys with… | ||
| "Beyond the barchart". Some top picks from "Get More Visuals" to enhance your reports | Mark Hayes | 19m |
Power BI ships about 40 built-in visuals but AppSource exposes 480 visuals of which ~223 rate four stars or above and ~50 publishers supply them; visuals… | ||
| Power BI governance, disaster recovery and auditing | Alex Whittles | 23m |
Recommends a three-tier Power BI estate: centralized datasets, departmental enhancements and personal overlays, using composite models (DirectQuery over… | ||
| Automated Machine Learning on Azure | Gavita Regunath | 49m |
Compares AutoML on Azure Machine Learning and Databricks with concrete results and tradeoffs: Databricks produces line‑by‑line notebooks, MLflow logging and… | ||
| Everything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask | Aditya Badramraju | 49m |
Survey of HA/DR for SQL Server on Azure VMs that names concrete choices and tradeoffs: backups go to Azure Blob and automated backups via SQL IaaS agent… | ||
| Supercharge Power BI with Azure Synapse Analytics | Mathias Halkjaer | 51m |
Argues that Azure Synapse is a configurable toolbox not a monolith and shows pipelines copying three tables into a Data Lake as Parquet, serverless SQL… | ||
| Make your data shine - Data storytelling with Power BI visual reports | Madzy Stikkelorum | 49m |
Power BI report uses three years of bird-shelter data to drive decisions: interactive visuals with custom image tooltips, drill-through pages, bookmarks and… | ||
| Azure IoT from the edge to ADX | Johan Ludvig Brattås | 15m |
Shows an end-to-end Azure IoT pipeline: route device messages from IoT Hub into Event Hub (use 4 to 8 partitions for throughput), push into Azure Digital Twins… | ||
| How to improve Q&A in Power BI | Laura Graham-Brown | 20m |
Demo uses Met Office weather station data to show Q&A producing charts and numbers (e.g., top 5 stations by average rainfall) after cleaning a model and naming… | ||
| Azure SQL MI End-to-end Demo Party for DBAs and Devs | Niko Neugebauer, Dr. Dani Ljepava | 19m |
Demo-only session shows concrete features and numbers: start/stop: stopping MI takes ~5 minutes and spinning up plus attaching storage takes ~20 minutes… | ||
| Build & scale applications with Azure SQL Hyperscale | Denzil Ribeiro | 49m |
Hyperscale separates compute and storage and scales storage automatically to 100 TB storage, exposes provisioned compute from 2–128 vCores, and offers a… | ||
| DAX in 20 Minutes - The Hard Parts | Eugene Meidinger | 19m |
Rapid tour of DAX focuses on why Excel/SQL habits break: DAX uses a columnar VertiPaq engine with value/dictionary/run‑length encoding and routinely delivers… | ||
| A DBA's Guide to the Proper Handling of Corruption | Brandon Leach | 53m |
Explains how to detect and respond to physical file corruption using only built‑in SQL Server tools: SQL Agent alerts, the suspect_pages table, DBCC CHECKDB… | ||
| Building a Lakehouse on the Microsoft Intelligent Data Platform | Craig Porteous, Simon Whiteley | 45m |
Shows how to build a working lakehouse on Synapse using Spark for ETL, Delta as the file protocol with a Delta transaction log enabling ACID, time travel and… | ||
| You can do this, dammit | Kurt Buhler | 46m |
A concrete, psychologist‑audited 5-step process teaches pause, notice, accept, identify values, then commit to tiny actions; surveys cited show… | ||
| Integrate Data Quality into your processes | Oliver Engels, Tillmann Eitelberg | 50m |
HEDDA.IO supplies a versioned knowledge base of domains, members and rulebooks (regex, lookups, fuzzy algorithms like Levenshtein and phonetics) and exposes… | ||
| How to pick the best Data transformation strategy | Ginger Grant | 47m |
Recommends choosing tools by concrete tradeoffs: Power BI works for fast delivery but loses source traceability, forces Premium for dev pipelines (~$5k/month)… | ||
| Analyzing Big Data in Azure cloud using Spark and Databricks | Maria Zakourdaev | 43m |
Azure Databricks is shown as a data engineering platform that combines Spark, Delta Lake ACID logs and MLflow on cheap cloud storage; demos create tables over… | ||
| Successfully collaborate with externals in Power BI | Odeta Jankaitienė, Marc Lelijveld | 44m |
Step‑by‑step setup for B2B collaboration in Power BI: invite via Azure AD B2B, decide view vs build, grant dataset build permissions or workspace roles, and… | ||
| The Path to Success with Power BI: Best Practices | Patrick LeBlanc, Adam Saxton | 50m |
Demonstrates concrete Power BI fixes: use Power Query Online indicators and query folding to push filters back to SQL, inspect the view query plan to find… | ||
| Regex in PowerShell: How to grasp it and why you should grasp it | Ned Stratton | 22m |
Deep dive into PowerShell regex with concrete outcomes: a single inline pattern captures UK postcodes across seven postcode rules and varied placements, a set… | ||
| Five Ways to Increase the Accessibility of Your Power BI Reports | Meagan Longoria | 20m |
A concrete checklist: replace vague labels with page title DAX or descriptive visual titles so each chart names metric, currency and years; set tab order via… | ||
| Breaking (in)visible walls - how helping others may help your personal growth! | Pragati Jain, Nikola Ilic | 47m |
A volunteer-run, 11-week free Power BI bootcamp aimed at people who cannot afford training recruits 82 applications for 15 planned spots and scales to 75… | ||
| Report Design & Psychology (Quick Tips) | Jon Lunn | 20m |
Uses dual‑process psychology to turn attentive tasks into fast reads by applying top-left real estate and Gestalt grouping, removes decorative clutter, and… | ||
| A low cost serveless synapse data platform | Eivind Halmøy Wolden | 21m |
A minimal data platform built on serverless SQL and a Parquet data lake uses an optional Azure SQL metadata table plus Synapse pipelines to generate layered… | ||
| Power BI and Web API's - not so low code ? | Erik Svensen | 51m |
Live demos show Power BI calling real REST APIs using Power Query code: using web.contents with a relativePath to send headers and JSON content, switching… | ||
| What is the right database for you? | Ajinkya Soitkar | 38m |
Guides selection by engine and use case: RDS for managed Postgres/MySQL, Aurora (Postgres/MySQL-compatible) decouples compute/storage, claims enterprise… | ||
| Tales from the Field - How to Avoid Burnout | John Morehouse, Monica Rathbun | 21m |
Ninety percent of the room reports burnout and the session gives concrete habits that reverse it: set firm start and stop times, dress and report to work even… | ||
| My story as a data viz freelancer - ups, downs and lessons learned | Mara Pereira | 23m |
Seven-year shift from mechanical engineering into analytics leads to a one-year run as a solo freelancer who sells Power BI mentoring and builds online courses… | ||
| Platform Innovations with SQL Server 2022 + Intel | Darren Freimuth, Bob Ward | 49m |
SQL Server 2022 adds native integration with Intel Quick Assist Technology so backups can offload compression to hardware or fall back to software; demo shows… | ||
| Extend Azure capabilities anywhere with Azure Arc enabled SQL Server | Dinakar Nethi | 43m |
Arc enabling projects each on‑prem or cross‑cloud SQL Server into Azure as an Azure resource using an agent, surfaces server and database metadata, and lets… | ||
| How to create a high performance data team: lessons learned from the field | Barry Smart | 18m |
Cloud-first teams choose small multidisciplinary groups (around seven to nine, think two pizzas) and aim for engineering maturity: automated CI/CD on Azure, a… | ||
| Pushing Your Power BI Potential: A Comprehensive Health Check for Improved Performance and Security | Matt Collins, Dan Jackson | 19m |
Covers a hands‑on health check that finds common causes of slow or insecure Power BI estates and shows concrete fixes: model refactoring toward a star schema… | ||
| Can an Introvert become an International Speaker? If so, How? | ALPA BUDDHABHATTI, Deepthi Goguri | 19m |
Asserts that introverts can become international speakers by starting small, using virtual events and mentor programs, and shipping lots of short sessions to… | ||
| I'm here, I'm queer ( Why Representation Matters) | Jess Pomfret | 19m |
Argues that visibility changes lives, citing a 2020 GLAAD and PNG finding of up to 45% increased acceptance when queer characters appear in media; shows a… | ||
| How to write a Session Abstract, to get chosen to speak | Benni de Jagere | 21m |
Practical checklist for getting chosen: state a one-line title (~10 words), use Sessionize for title/abstract/notes/bio, and put audience, prerequisites, and… | ||
| Next Level Scalability on SQL Server 2022 | Ajay Jagannathan, David Pless | 51m |
SQL Server 2022 removes major tempdb choke points by turning GAM/SGAM update latches into shared latches so high-concurrency workloads stop producing the giant… | ||
| Synapse Q&A with PG | Stijn Wynants, Luke Moloney, Filip Popović, Pawel Potasinski, Mark Pryce-Maher | 50m |
Serverless now reads Delta tables visible to serverless when Spark writes them, but pipelines cannot write Delta (only Spark engines can), and mapping data… | ||
| An in-depth review of the latest advancements in authentication for Azure SQL and SQL Server 2022 | Jakub Szymaszek | 48m |
Shows concrete steps and demos: enabling Azure AD for Azure SQL, granting the server a system-assigned managed identity, mapping an AAD group to a server… | ||
| Elicit and Collaborate Like a Pro! Top Tips from an Expert | Pamela Paterson | 48m |
Elicitation focuses on concrete tactics: use a mini stakeholder analysis to pick who to meet, show notes on-screen to cut review cycles, and prefer 80%… | ||
| Code repos and automated deployment | Jens Vestergaard | 50m |
Walkthrough of Azure DevOps showing a real project: create a free five-seat organization, push an Azure Function from Visual Studio into a git repo, build a… | ||
| The 10 things every developer must absolutely know about Azure SQL | Davide Mauri | 51m |
Azure SQL is SQL Server and demos show exact behaviors: the optimizer pushes predicates into nested queries, implicit conversions disable indexes, and SET… | ||
| Connecting the dots of Azure SQL DevOps | Muazma Zahid | 48m |
Shows a workable pipeline: VS Code/Azure Data Studio + go SQL command creates a local SQL container with one line, SQL Projects build into DACPAC artifacts… | ||
| No no storage limits, just reach for the sky, with data virtualization in SQL MI | Sasa Popovic | 50m |
Azure SQL Managed Instance queries data directly on Azure Blob/ADLS Gen2 (CSV, Parquet, JSON) via external tables or OPENROWSET, using managed identity auth… | ||
| What Playing Minecraft Taught Me About DevOps | Richie Lee | 20m |
Describes converting huge partitioned heap tables to clustered column store indexes without the downtime SSDT’s rebuild-copy-drop would cause, using stored… | ||
| Taking the "Public" out of Public Clouds: Getting Started with Private Endpoints | Grace O'Halloran | 48m |
Defines a checklist of seven steps required to make Azure private endpoints actually work: create a private endpoint resource, couple it to the Azure resource… | ||
| Arc, Arc and Arc: De-mystifying Azure Arc for Data | Buck Woody | 50m |
Demonstrates that Azure Arc installs an agent on Windows or Linux to deliver Arc-enabled SQL Server features (inventory, Defender alerts, log analytics) and… | ||
| Short On Time? Don't Worry, We'll Have Your Azure Data Factory Automated in Only 20 Minutes! | Peter Avenant | 12m |
Claims automated Azure Data Factory pipelines built in about 20 minutes using a metadata-first tool called BimlFlex that imports table schemas, lets you add… | ||
| How Leaders Can Support Their Employee’s Mental Health | Eugene Meidinger, Tracy Boggiano | 47m |
Claims managers cannot fix employees' mental health but can cut risk by changing the environment: train leaders, enforce anti‑harassment policies, and provide… | ||
| Championing women in Tech | Giulia Iannucci | 51m |
Interactive workshop that analyzes external and internal barriers and gives concrete actions: cites UK and global figures (about 26% women in UK tech, only 9%… | ||
| Switching Careers: From PT to IT | John Morehouse, Yuki Hata | 18m |
A career changer abandons a planned doctorate in physical therapy to become a DBA during the pandemic, starts as the company’s first intern with no IT… | ||
| Cognitive Services Extravaganza! | Gosia Borzęcka | 50m |
Quick tour of Microsoft Cognitive Services showing concrete tools and results: Language Studio for entity recognition, sentiment, multilingual QnA; Speech… | ||
| It keeps getting easier to move Oracle and Open Source workloads to Azure | David Levy | 49m |
Shows a concrete migration stack: Azure Migrate for discovery and TCO, Azure Database Migration Service for online sync and cutover, and Azure Data Studio… | ||
| To be resilient; banish the dragons in a world of ever increasing cyberthreats | Michael O'Donnell | 16m |
Claims Quest is a top Microsoft co‑sell partner offering an end‑to‑end stack for Zero Trust, M365 backup and fast ransomware recovery, identity and privilege… | ||
| 7 Things I wish I'd known before building a 60Tb DWH on a Dedicated Pool | Steve Powell | 41m |
Build uses Azure Data Factory with a dedicated SQL pool and lots of automation and hits real limits: pause/resume can stall for an hour when killed… | ||
| ADHD - Failing at normal (and dealing with a mind that needs stimulation to focus) | Valerie Junk | 50m |
Chronicles living with ADHD: diagnosis follows losing a job for an impulsive outburst, then six years of therapy, coaching and concrete routines. Uses a daily… | ||
| ADX and the last crusade | Frank Geisler | 50m |
Introductory demo shows how to spin up a free cluster at dataexplorer.azure.com, create databases and tables, and ingest zipped log files from Azure Blob to… | ||
| Ageing gracefully through tech | Mala Mahadevan | 17m |
Summarizes evidence that age-based harassment tripled recently and that less than 11% of developers are over 45, with research showing bias starts at 46… | ||
| AutomatedLab 101 in 1200 seconds or less | Mikey Bronowski | 19m |
AutomatedLab is a PowerShell module that creates repeatable Hyper‑V or Azure labs using three commands to define a lab, add machines and execute the build; it… | ||
| Azure Cosmos DB Serverless Unleashed | Mihail Mateev | 22m |
Cosmos DB Serverless launches in 2021, excludes the Postgres API, and charges $0.25 per million RUs while capping throughput at 5,000 RU/s and storage at 1 TB… | ||
| Blogging for the Tech Professional | Steve Jones | 21m |
Blogging improves practical skills, makes troubleshooting reproducible, and attracts employers: use Open Live Writer or WordPress, keep drafts in OneDrive, and… | ||
| Breaking out of the habit of bulk loading everything | Pálmi Símonarson | 21m |
A utilities data platform captures MQTT from on‑site RabbitMQ (shovel to Event Hubs), uses Event Hubs, Stream Analytics, Azure Functions to transform and route… | ||
| Building an Azure Data Analytics Platform End-to-End | Paul Andrew | 48m |
Builds a working end‑to‑end Azure analytics platform using Azure Data Factory with self‑hosted IR (up to four nodes), private networking/ExpressRoute, IoT… | ||
| Building and using Organizational data types | Lars Andersen | 20m |
Shows how to create an organizational data type as a Power BI featured table (must be 100% import) with a row label and unique key, publish it, and consume it… | ||
| Building Multi-language Reports in Power BI | Ted Pattison | 50m |
Power BI supports dataset-level internationalization so table/column/measure captions translate, but metadata translations require Premium and must be… | ||
| CALCULATE evaluation order | Renato Lira | 20m |
Shows exactly how CALCULATE evaluates filters: filters and modifiers are evaluated first (context transition happens on expanded tables), then the expression… | ||
| Communication across Cultures | Mala Mahadevan | 20m |
Compares the Lewis model and a low/high context framework to show how Western teams expect direct, task‑oriented answers while high‑context colleagues use… | ||
| Data modeling for experts with Power BI | Jeroen ter Heerdt, Marc Lelijveld | 51m |
Covers practical Power BI behavior: how table-level storage modes (Import, DirectQuery, Dual) create composite models and separate source groups, how… | ||
| Delta Live Tables: Building Reliable ETL Pipelines with Azure Databricks | Mohit Batra | 49m |
Shows how Delta Live Tables on Azure Databricks builds medallion ETL with concrete mechanics: bronze/silver/gold tables, Auto Loader streaming for incremental… | ||
| Demystifying Power BI Slicers and filters | Prathy Kamasani | 20m |
Claim: slicer is a visual and filter is a functionality — slicers render as categorical, date or hierarchical visuals with formatting, relative-date sliders… | ||
| Don’t Let Your Permissions Be Hijacked! | Erland Sommarskog | 49m |
Shows a practical attack where a database DDL trigger sneaks in during index or stats maintenance and uses EXECUTE AS to make a DB owner escalate into a server… | ||
| Extended Governance of Power BI with Microsoft Purview | Gabi Münster, Oliver Engels | 51m |
Shows how Microsoft Purview connects to Power BI as an Azure PaaS and performs a tenant-wide scan that indexes dashboards, reports, datasets, dataflows and… | ||
| From stone age to data-driven tech for ears: a time travel | Kay Sauter | 49m |
A concise timeline and practical checklist that moves from shells and horns through vacuum tubes and transistors to digital aids in the 1990s and cochlear… | ||
| Go With The (data)Flow | Maria Gabriel | 48m |
Overview of Power BI Dataflows as cloud staging in Power BI Service that use Power Query (M) to cleanse, merge and share entities; dataflows support scheduled… | ||
| How changes to Azure Synapse Analytics impact data architecture designs | Ginger Grant | 17m |
Many Synapse features now change architecture choices: use serverless first to avoid provisioning an Azure SQL DB and save about $1,200/month in simple… | ||
| How I Deal with Depression | Eugene Meidinger | 20m |
Describes a personal, data‑driven system: daily mood logging with the DailyO app, weekly validated depression inventories, and tracking automatic negative… | ||
| How To Get the Auditors Off Your Butt with dbachecks | Tracy Boggiano | 40m |
dbachecks is an open source PowerShell module that runs ~200 configuration tests (CIS included) using DBAtools and Pester, claiming to verify actual compliance… | ||
| Introduction to Databricks Delta Live Tables | Niall Langley | 50m |
Databricks Delta Live Tables combines Auto Loader with Spark Structured Streaming to track files, run incremental loads and surface data quality metrics; demo… | ||
| Know the game you are in - and you will not win | Brian Bønk | 17m |
Argues organizations are playing an infinite game not a finite contest and offers a six-point playbook: advance adjust course / just cause / build trusting… | ||
| Lessons learned from optimizing enterprise data models | Nikola Ilic | 51m |
Shows how to mimic hybrid tables on Pro by splitting a 200M-row fact into hot (import) and cold (DirectQuery) parts and using a DAX “tipping point” (filtered… | ||
| Multitasking for Mortals - How to Stop Multitasking and Start Getting Things Done | LINDA TORRANG | 20m |
Multitasking actually cuts effectiveness — claim: it drops your IQ by as much as a night of lost sleep — because every switch drains focus and adds stress… | ||
| Persuasive Communication: Them Before Me | Catherine Brown | 20m |
Research of hundreds of respondents (statistically significant) shows sales still reads as sleazy, so the actionable claim is clear: flip the script by leading… | ||
| Power Automate 101 | Alexander Klein | 48m |
Live demos show building no-code flows that actually run: a Twitter search sends tweet text to AI Builder sentiment analysis and inserts results into a Power… | ||
| Power BI Meets Programmability – TOM, XMLA, and C# | Kristyna Hughes | 47m |
Demonstrates programmatic edits to Power BI models using C# + XMLA endpoint and TOM (Tabular Object Model): creates data and calculated columns, updates DAX… | ||
| Power BI Model Development Best Practices in a Team | Mathias Thierbach | 52m |
Describes a source control based model workflow that enforces a Git branch per environment with main = production, a release branch like release/2.6 for UAT… | ||
| Query folding in Power Query | Chris Webb | 21m |
Explains that query folding pushes Power Query transforms into the source for much better refresh performance and shows how to verify it: Power BI Desktop +… | ||
| Securing Cosmos DB: Ready for Production! | Heini Ilmarinen | 48m |
Shows how to lock a Cosmos DB account down by creating a VNet + backend subnet, provisioning private endpoints (note: creation takes time and briefly disrupts… | ||
| SQL Server vs Azure Cosmos DB | Hasan Savran | 49m |
Compares Azure SQL and Cosmos DB with concrete tradeoffs: Cosmos DB physical partitions cap at 50 GB per physical partition and add partitions when traffic… | ||
| Me, Myself and UI: Applying UI style guides to Power BI reports | Matt Lakin | 21m |
Shows how to standardize Power BI reports by building a reusable template that includes a header/footer background embedded as a base64-encoded background in… | ||
| Stressed, Depressed, or Burned Out? The Warning Signs You Shouldn't Ignore | Cathrine Wilhelmsen | 52m |
Personal account of chronic stress, two burnouts and 15 years of clinical depression lists concrete warning signs—insomnia, migraines, memory lapses, weight… | ||
| Supercharge Power BI Tooltips | Reid Havens | 21m |
Shows how to offload heavy calculations to report page tooltips so main visuals render faster and the tooltip computes on hover (expect a small blur while it… | ||
| Take Control of your Azure SQL Managed Instance Migration using the Log Replay Service | Rob Carrol | 19m |
Log Replay Service migrates SQL Server to Azure SQL Managed Instance by restoring backups from Azure Blob Storage using AzCopy, running LRS in continuous or… | ||
| Being Brilliantly Bonkers: Neurodiversity, mental health, & inclusion | Sarah Francis | 55m |
Claims that 1 in 7 people are neurodivergent and up to 70% also have mental-health conditions, demonstrated with concrete behaviors: a “spiky” skills radar… | ||
| The Most Powerful Azure Service You’ve Never Heard Of | Patrick LeBlanc, Bradley Ball | 42m |
A demo of Azure Data Explorer (Kusto) shows columnar storage, heavy compression and a distributed SSD architecture that returns aggregates over 40 billion rows… | ||
| The Power BI secret sauce: Security and governance | Kasper de Jonge | 49m |
Power BI runs on Azure AD with MFA, B2B and conditional access so authentication ties into existing enterprise identity and device rules; the service reports… | ||
| Top 10 Azure Data Factory Tips & Tricks | ALPA BUDDHABHATTI | 21m |
Twenty concrete ADF practices: save then refresh before publish to avoid overwrites; check object dependencies before changing datasets or linked services… | ||
| Top Ten Terraform Trip-Ups | Ben Somerville Roberts | 21m |
Top ten concrete pitfalls when deploying Azure data platforms with Terraform: using remote state to stitch parent/child configs exposes and reverts… | ||
| Troubleshooting Power BI Reports | Benni de Jagere | 50m |
Shows concrete fixes: using the Performance Analyzer Pane and optimize ribbon to find slow visuals, replacing dozens of shapes with a single background and… | ||
| Working with data using Azure Functions | Liam Moat, Steph Locke | 47m |
Shows how to glue Azure SQL, Cosmos DB, Event Hubs and storage with Azure Functions using VS Code, Bicep and managed identities; builds a timer-triggered… | ||
| Built-in Intelligence with Azure SQL and SQL Server 2022 | David Pless | 50m |
Covers practical features in Azure SQL/SQL Server 2022: query store hints let DBAs persist plan hints without changing code and demo shows using… | ||
| SQL Server on Azure VM - Configuring for price-performance | Aditya Badramraju | 42m |
Recommends running SQL Server on Ebdsv5 + Premium SSDv2 VMs, showing disk and VM limits: P30 = 5,000 IOPS, Ebdsv5 VM uncached/local temp up to 38,000 IOPS and… | ||
| Women In Tech: Lifting as We Climb | Rie Merritt | 49m |
Actionable steps: set mentorship expectations (meeting cadence, goals, boundaries), distinguish mentor versus sponsor — sponsors assign stretch projects and… | ||
| SQL Server 2022 hidden gems | Bob Ward | 48m |
Live demos show new diagnostic and ops features: query_abort XEvent captures the aborted query text plus T‑SQL call stacks (using Arvin’s call‑stack tool) so… | ||
| My application is fully concurrent and async. What about the database? | Davide Mauri | 52m |
A .NET console demo opens concurrent connections and shows SQL Server and Azure SQL taking page and key locks, lock escalation at ~5,000 locks, and queries… | ||
| Power BI + Azure Synapse Analytics: Beginning your journey | Adam Saxton, Patrick LeBlanc | 50m |
Covers concrete setups: use serverless SQL querying parquet files from ADLS for on‑the‑fly reads, or spin up dedicated SQL pools with materialized views to cut… | ||
| Multi-tenant SaaS apps made simple on Azure Cosmos DB for PostgreSQL | Alicja Kucharczyk, Adam Wolk | 44m |
Explains how Azure Cosmos DB for PostgreSQL (Citus extension) actually distributes rows into shards, requiring a distribution key and giving concrete limits… | ||
| Dell and Azure Arc-enabled data services - SQL MI Business Critical | Stephen McMaster, Robert Sonders | 49m |
Demo shows Azure Arc–enabled SQL Managed Instance running on Kubernetes with Dell PowerStore and PowerEdge, deployed as a three-replica Business Critical… | ||
| What's New and Cool in Azure Synapse Analytics | Stijn Wynants, Pawel Potasinski | 45m |
Latest Synapse updates show concrete, usable changes: a TTL-managed integration runtime cuts copy-activity queuing by keeping compute alive for five minutes; a… | ||
| Keynote by The Community | Craig Porteous, Jess Pomfret, Grace O'Halloran, Marthe Moengen, Ben Weissman | 52m |
A community-first keynote shows concrete wins: a grassroots meet-up grows into Data:Scotland — seven years and 10× size, mentoring converts terrified… | ||
| Lightning Talks | Mark Pryce-Maher | 39m |
Five-minute bites cover specific takeaways: use question titles for visuals to draw users in and force a value check; Power BI apps can restrict report parts… | ||
| Knee-Deep In Tech Live @ SQL Bits | Heini Ilmarinen, Alexander Arvidsson | 38m |
Episode 218 is a live audience recording at SQLBits Newport (18 Mar 2023) that chronicles a five‑year, 200+ episode podcast with 48,000 listens and the messy… | ||
| Ready. Set. Automate! Have your Azure Databricks Lakehouse Up and Running in 20 Minutes! | Peter Avenant | 20m |
Claims a full Azure Databricks lakehouse deploy in ~20 minutes using BimlFlex, driven by imported metadata and templates written in BIML, producing… | ||
| Pushing Your Power BI Potential: A Comprehensive Health Check for Improved Performance and Security | Dan Jackson, Matt Collins | 18m |
Walks through concrete checks and tools: run VertiPaq Analyzer (via DAX Studio) to find oversized columns and cut model size, run Tabular Editor best practice… | ||
| nothing matches | ||