SQLBits 2024
2024-03-19..2024-03-23
Farnborough, United Kingdom
SQLBits ·
[SQLBits 2019, SQLBits 2020, SQLBits 2022, SQLBits 2023, SQLBits 2024]
| title | author | length |
|---|---|---|
| Roche's Maxim of Data Transformation - By Example | Alexander Arvidsson | 47m |
Roche’s Maxim says transform as far upstream as possible and as far downstream as necessary and the talk gives concrete rules: do simple joins and string… | ||
| Mastering Power BI Design with User-Centric Frameworks | Kerry Kolosko | 47m |
A consulting engagement runs user research with field workers and leadership, tests multiple dashboards, and finds adoption fails because reports are slow… | ||
| Data Mesh vs Data Fabric - in Microsoft Fabric | Marthe Moengen | 47m |
Microsoft Fabric claims to let organizations implement Data Mesh by centralizing storage in OneLake, grouping workspaces with the domains feature, and exposing… | ||
| Streamlining Power BI with PowerShell | SANDER STAD, LINDA TORRANG | 48m |
PowerShell module PSP PowerBI Tools and Microsoft’s management module get inventory (workspaces, reports, users), add counts, and run actions like renaming and… | ||
| One dataset and three use cases with Microsoft Fabric | Prathyusha(Prathy) Kamasani | 51m |
Imports World Bank Open Data into Microsoft Fabric using three concrete ingestion methods: Dataflow Gen2 to Lakehouse, Data Pipelines with copy assistant and… | ||
| Microsoft Fabric. Adoption, adoption, adoption: What gets measured, gets done | David Alzamendi | 52m |
Practical roadmap for Microsoft Fabric and Power BI adoption with 19 recommendations and concrete KPIs: active users, returning users, report views, data… | ||
| Soaring to New Heights with Accelerated Database Recovery | John Morehouse | 54m |
Accelerated Database Recovery (ADR) redesigns crash recovery with an in-memory slog, a persisted version store moved into the user database, and a logical… | ||
| Crafting Flight Simulations: The Art of Synthetic Data Generation | Dave Ruijter | 21m |
Argues synthetic data reproduces production characteristics while avoiding privacy risk, demonstrating two concrete tools: a MostlyAI generator reporting 91.4%… | ||
| Rapid Power BI Development with ChatGPT, Tips & Tricks | Pedro Reis | 20m |
Shows GPT‑4 (multimodal, ChatGPT Plus) generating usable SVG button DAX that produces red/green status cards and an HTML visual CSS animation that scales and… | ||
| Getting started with SparkML in Microsoft Fabric | Nico Jacobs | 20m |
Shows end-to-end SparkML work inside Microsoft Fabric notebooks: load a ~500,000-row flight dataset (day, departure time, estimated air time), assemble… | ||
| Let me show you why data types still matter | CLÁUDIO SILVA | 19m |
Shows concrete failures and fixes: float loses precision so casting and ceiling produced wrong truth values and ruined a cursor-to-set refactor; use float only… | ||
| You Can't Govern Data You Don't Understand | Joey D'Antoni | 21m |
Argues that data governance is a business function, not an IT project, and requires executive sponsorship, departmental stewards and change management; gives a… | ||
| Pagination made easy | Aaron Felton, Rae Ellingham | 20m |
Power BI Report Builder connects to a Power BI semantic model, copies DAX from a Power BI visual, and uses a single-cell list to turn row groups into pages… | ||
| Intro to Azure Data Studio | Heidi Hastling | 20m |
Azure Data Studio is a fast, cross‑platform SQL editor that ships with four installers (including a non‑admin user install), loads noticeably faster than SSMS… | ||
| Put your own mask on first - mental health and wellbeing for your business | Hollie Whittles | 19m |
Covers concrete employer actions: implement bike to work and tech timeout schemes, offer private healthcare and menopause support, run monthly one-to-ones and… | ||
| New ways to optimize shared datasets in the Power BI Service | Gregor Brunner | 49m |
A demo shows a concrete workflow that finds and removes unused columns and measures from a shared Power BI dataset, using Measure Killer locally (PBIX +… | ||
| Do Low Code projects need Change Management? Appsolutely! | Angeliki Patsiavou | 51m |
Claims that 75% of new apps will be low/no‑code by 2026 (Gartner) meets concrete failures: a Cisco audit finds ~90 vs 1,200 cloud services, and early copilot… | ||
| Here’s the execution plan … now what? | Hugo Kornelis | 51m |
Examines real plans to find the exact culprit: a dashboard paginated_sales_report uses a temp table and a full Sort that requests ~47 MB per execution… | ||
| Behind the Hype - Architecture Trends in Data | Simon Whiteley | 54m |
Argues that treating datasets as data products—publishing SLAs, refresh guarantees and measurable business KPIs—actually drives ownership and value… | ||
| Data Modelling Showdown: Unravelling the Mysteries of Different Data Modelling Approaches | UST OLDFIELD | 49m |
Compares concrete modelling tradeoffs and practical recipes: Data Vault: hubs links satellites loads concurrently and simplifies source integration but yields… | ||
| Using your existing knowledge, skills and experience to 'make it' in the Tech World. | Liz Hardy | 52m |
Five concrete career moves and examples: prioritise five transferable skills—ready to learn, communication and people skills, adaptability, problem‑solving and… | ||
| 20 Power BI tips in 20 minutes | Matt Lakin | 20m |
Twenty quick, actionable tips delivered as a rapid toolkit: use Ctrl+G goto column and the Power Query quick-access toolbar for navigation, prefer… | ||
| Celebrating Diversity and Inclusion: Black History, Workplace Challenges, and Change | Bim Adeniran | 21m |
Session runs a live black history trivia with 23 live players, names specific figures (Mary Seacole, Queen Charlotte, Diane Abbott), and cites the UK Slavery… | ||
| Value of DevOps Release Process in Data Teams | FALEK MIAH | 21m |
Argues that a simple CI/CD pipeline with clear Dev/Test/Staging/Prod environments and branching (feature → dev → main) cuts deployment time, reduces rollback… | ||
| How To Actually Make Decisions When Architecting a Data Platform | Ed Freeman | 19m |
Claims a repeatable decision process: version-controlled Non-functional requirements alongside functional specs, use Architectural Decision Records to record… | ||
| Fast and Efficent Text Analysis using Azure's Language Cognitive Service | Lewis Prince | 21m |
Uses Azure Language Studio APIs — Key Phrase Extraction, Sentiment Analysis and Opinion Mining — called from Python to send Trustpilot review rows, receive… | ||
| From Skopje to Seattle: My Journey in Tech | Elena Drakulevska | 18m |
Career pivot from telecommunications to data using Power BI and UX design leads to a reproducible path: learn ETL/data engineering and visualization, apply UX… | ||
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Compares relational versus non-relational with concrete examples: a URL redirection system built on Cosmos DB using the document model and userID as partition… | ||
| Power BI - Creating a M-agical Date Table | Kristyna Ferris (Hughes) | 23m |
A complete Power Query M calendar is built in a fast 20-minute demo using Power BI Desktop and Sublime Text, proving you can generate a self-contained date… | ||
| Aggregations in Power BI | Marco Russo | 51m |
Shows how Power BI rewrites slow DirectQuery SQL into smaller pre-aggregated tables and when that succeeds or fails, using DAX Studio performance traces and… | ||
| Exploratory vs explanatory, when do you build which dashboard and how? | Marjolein Opsteegh | 48m |
Designs use Power BI dashboards as either interactive investigator tools or static communicators. Exploratory dashboards are multi page, Power BI reports with… | ||
| Time Series with SQL Server 2022 | Gianluca Sartori | 50m |
Compares SQL Server 2022 to InfluxDB and shows concrete numbers and techniques: loads 15 days of performance counters (two instances, 82 million rows), finds… | ||
| Flight Plan for Data Security: Safeguarding your Dataset with Dynamic Object-Level Security | Diogo Martins, José Calheiros | 44m |
PowerShell scripts use the Fabric REST API (via the fabric ps pbip module) to export dataset model files, edit the model.bim JSON to add roles and… | ||
| How to be awesome at getting your next job | Robert French | 49m |
Claims over 100 interviews and roughly ten job moves in a decade underline the methods: use tooling like CV keyword scanners and bots, prefer simple sans‑serif… | ||
| Data Quality Revolution : The Fabric-OpenAI Approach | ALPA BUDDHABHATTI, NAGARAJ SENGODAN | 51m |
Demonstrates a working pipeline that pairs Fabric + Azure OpenAI to clean messy insurance data: notebooks call deployed models (DQ demo 1 = GPT‑4, DQ demo 2 =… | ||
| Automating Power BI Governance: How dynamic security groups can solve 95% of your sharing needs | Bernat Agulló | 41m |
Claims that dynamic security groups in Entra ID solve about 95% of sharing needs by auto-updating membership when HR changes department data, demonstrated… | ||
| Stand Fast - How Governance Can Save You a Fortune | Alexander Arvidsson | 47m |
Governance saves money by forcing concrete actions: inventory and monitor workloads, right‑size resources, and apply guard rails to stop runaway services… | ||
| The Fundamentals of DAX Contexts | JAMES MCGILLVRAY | 52m |
A concise, demo-first primer that uses a 12-photo dataset in Power BI to demonstrate why the same DAX measure returns different numbers: filter context picks… | ||
| What to look out for when migrating your data to the cloud; is it REALLY the right choice? | Emanuele Meazzo | 49m |
Describes a full on‑prem to Azure migration and the tradeoffs with numbers: 60–85% fail rate for big data/lake projects, enterprises waste roughly 30% of cloud… | ||
| Bring your contextual data to life with Microsoft Graph and Power Platform | Lewis Baybutt, Steph Martin | 51m |
Claim: using Microsoft Graph plus Power Platform surfaces subconsciously created data (emails, Teams presence, calendar, SharePoint files) to speed common… | ||
| A Step-by-Step Guide to Building a Data-Driven Culture in Your Business Using Power BI | Gethyn Ellis | 45m |
Chief Data Officer Berry Wand uses Power BI to unify siloed police systems, runs a CICD dashboard that shows deployments failing 25% of the time, and uses that… | ||
| Common Data Science Mistakes | TOMAŽ KAŠTRUN | 48m |
Checklist of concrete mistakes with reproducible fixes: code and data live in R demos on GitHub and the repo is named common data science mistakes; examples… | ||
| Desk Pilots: Navigating a Healthy Flight Plan for Your Posture and Well-being | Faisal Hussain | 17m |
Workplace claims: humans spend ~80,000 hours at desks and 85% get an occupational health complaint. Practical setup rules include 50–100 cm monitor distance… | ||
| Mastering Fabric: Workspace Governance and Organization | Just Blindbæk | 21m |
Provides concrete tooling and procedures: extract a full tenant workspace catalog with Azure Data Factory pipelines or Synapse to audit owners, access and… | ||
| Azure Infrastructure - What Not to Do | John Morehouse | 22m |
Countless teams leave anonymous blob access enabled or forget network planning and then hit overlapping IP spaces during migration; blob anonymous is off by… | ||
| How to handle Blanks and Nulls in Power BI | Renato Lira | 20m |
Power Query treats nulls as unknown so any arithmetic or concatenation with them returns null unless replaced early in the ETL (recommend handling in the… | ||
| Winging It: My Neurodivergent Non-Technical Journey into Data | ISI TURNER | 18m |
Claims that ADHD-friendly work relies on concrete hacks: uses the INCUP acronym (interest, novelty, challenge, urgency, passion) and shows specific practices… | ||
| Take off with Tabular Editor | Sue Bayes | 22m |
Attaches to Power BI Desktop and runs free as Tabular Editor 2, letting the model be edited externally: creates measures (example: CountRows and Distance sum)… | ||
| When a platform isn’t enough: Building an experimentation culture | Stephanie Pancoast | 21m |
Companies see only 4 of 20 tests succeed (roughly 10–33%), so the talk argues that a platform alone is insufficient: platforms cut engineer and analyst time… | ||
| Unraveling the Web of Relationships: Understanding Graph Data | Mala Mahadevan | 19m |
Claims that graph databases outperform relational systems for highly interconnected data and pattern matching, with concrete examples: social graphs… | ||
| Avoiding Turbulent Skies: Power BI Security Strategies for a Smooth Flight | Mark Hayes | 52m |
Covers concrete Power BI controls: tenant review finds about 120 tenant settings including that publish to web enabled by default (demo shows Google indexing… | ||
| Nose-Dive Narratives: Slide Karaoke 2024 | Simon Whiteley, Mark Pryce-Maher, Rob Sewell, Benni de Jagere, LINDA TORRANG, Mathias Halkaer, Marthe Moengen, Liping Huang | 52m |
Forty audience-suggested topics feed a QR form, six random decks filled with non-data slides auto-advance every minute, and each contestant improvises five… | ||
| Managing replication with dbatools | Jess Pomfret | 48m |
dbatools adds new replication commands to a ~700-command PowerShell module allowing enablement of a distributor, creation of snapshot, transactional, merge… | ||
| Lessons learned: Governance and Adoption for Power BI | Paulien Van Eijk | 50m |
Shows a practical Power BI governance roadmap with concrete failures and fixes: blueprinting often takes up to one year, dataset refreshes sometimes exceed… | ||
| A deep dive into Direct Lake | Mathias Halkjaer | 52m |
Direct Lake runs inside Microsoft Fabric and connects Power BI to a Lakehouse, but it does not truly query files live — it uses column-level caching that pulls… | ||
| How to get started with MLOps in Azure Databricks | Doug Leal | 51m |
Introduces a concrete Azure Databricks workflow: ingest Airbnb sample (90 features), use Delta Lake time travel for data versioning and audit, register… | ||
| Find your PII reports and make your data safer | Francisco Gutierrez Gonzalez | 50m |
Three methods to locate PII are described with concrete tradeoffs: Premium scan that adds 30% extra compute to every refresh and misses some fields… | ||
| Get a Load of this - Realistic Load Testing for Power BI, explained! | Matt Lakin | 39m |
Shows a concrete workflow using the open-source Realistic Load Test tool (forked PowerShell scripts) to spin up multiple browser windows, simulate bookmarks… | ||
| An Evolution of Data Architectures - Lambda, Kappa, Delta, Mesh & Fabric | Paul Andrew | 48m |
Claims that bringing ACID to data lakes solved scale and consistency problems by letting storage and compute cooperate, with Delta Lake open-sourced April 2019… | ||
| Zero to Lakehouse in Microsoft Fabric | Craig Porteous | 50m |
Claims that a complete Data Lakehouse is buildable inside Microsoft Fabric as a SaaS platform without touching Azure resources, using one Lake as the storage… | ||
| Disaster Recovery Strategies for SQL Server | Andrew Pruski | 47m |
Starts with backups as the non-negotiable baseline and defines RTO/RPO tradeoffs, shows how log shipping (transaction log backup, copy, restore) saves time for… | ||
| How to Conduct a Transact-SQL Code Review | Kevin Kline | 49m |
Practical checklist and runnable scripts that inspect plan cache, DMVs and Query Store (or capture with Extended Events) to flag defects: counts of cursors and… | ||
| The Hitchhiker's Guide to navigating Power BI | Just Blindbæk, Kristoffer West | 50m |
Shows concrete tricks: build a one‑page front portal that opens other reports in new tabs, use buttons + bookmarks and hover‑icon toggles to switch hierarchy… | ||
| Scanning the skies above SQLBits - Realtime streaming of flight data with Microsoft Fabric | JAMES DALES | 44m |
A working end-to-end demo streams ADS‑B transponder data from a Raspberry Pi + FlightAware software into Fabric’s Eventstream, writes into a KQL database… | ||
| ACID in SQL Server: what it is, how it works, and how to live more adventurously. | Daniel Hutmacher | 52m |
Covers ACID in SQL Server with hands-on demos: shows read uncommitted (NOLOCK) producing dirty reads, contrasts read committed, repeatable read and… | ||
| Data Leadership: Navigating Security, Governance, and Ethical Decision-Making in the Digitial Skies | Gethyn Ellis | 40m |
Roadmap for securing and governing data with concrete tools and three police-focused case studies: adoption of OneLake and Purview to build a data map and… | ||
| How to automate your data actions through Data Activator | Marthe Moengen | 19m |
Microsoft Fabric’s Data Activator is a no-code experience that monitors Power BI visuals or live event streams and triggers actions when thresholds hit (demo… | ||
| Power BI meets UX Design: The Design Process | Elena Drakulevska | 20m |
Argues that applying the UX design process to Power BI prevents wasted work by insisting on Empathize, Define, Ideate, Prototype, Test; recommends building… | ||
| Would your business pass pre-flight information security checks? | Hollie Whittles | 17m |
Explains concrete controls and costs: Cyber Essentials covers five controls (firewalls, secure configuration, user access, malware, patching) and starts ~£300… | ||
| How to reduce costs & build new analytics capabilities in Power BI with Power Automate | Roland Szirmai | 20m |
Shows concrete automations built with Power Automate and adjacent tools: a template flow that saves email attachments to SharePoint created in about 20… | ||
| How I Deal with Depression | Eugene Meidinger | 19m |
Describes a data-first regimen: daily mood logging with Daylio, weekly self-assessments using the Burns Depression Checklist (score fell from 19 to 10), and a… | ||
| Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit | Ben Weissman | 22m |
Azure Arc adds a central control plane for on‑prem and non‑Azure SQL Server instances by running a single PowerShell script or bash installer that deploys an… | ||
| Navigating the Skies of Data: A Flight Through Feature Stores | Dave Ruijter | 20m |
Explains what a feature store does, shows a live demo creating a wine feature table in Databricks Feature Store (create_table call, dataframe + primary key)… | ||
| Using ALLEXCEPT or ALL/VALUES? | Marco Russo | 22m |
Demonstrates that ALL/ALLEXCEPT vs VALUES+REMOVEFILTERS is a functional choice in DAX: ALL or REMOVEFILTERS clear filters, ALLEXCEPT removes every other column… | ||
| Mastering Rapid Power BI Development with ChatGPT: A Deep Dive | Pedro Reis, Ricardo Santos | 50m |
Hands-on demo of using GPT-4 and 3.5 to generate a semantic data model, CSV sample data, a Python data generator, Power Query M code, DAX measures (YTD… | ||
| Upgrade to First Class with Calculation Groups for Power BI | Jason Romans | 50m |
Calculation groups replace dozens of duplicate measures by using a SelectedMeasure placeholder so one time‑intelligence or statistic definition applies to many… | ||
| Power BI dataflows: building your own refresh orchestration | Ben Watt | 50m |
Shows a working orchestration that runs Power BI dataflows in ordered blocks by calling the Power BI REST APIs from Azure Functions and marshalling execution… | ||
| Navigating Data Governance in the Age of Generative AI | Scott Bell | 50m |
Argues that governance must track new artifacts (prompts, embeddings, model outputs) and shows concrete harms and fixes: demonstrations of Gemini 1.5 with 1M… | ||
| Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks | Prathyusha(Prathy) Kamasani | 52m |
Demonstrates that Microsoft Fabric Notebooks give zero setup access to Python/PySpark and built‑in tools so Power BI workflows run faster: uses pandas… | ||
| Gender 101 | Els van Vessem | 40m |
Provides interactive data and practical steps: a live Mentimeter word cloud proves engagement and Genderbread/Gender Unicorn diagrams map identity, expression… | ||
| The Swiss Cheese Security Pattern | John Martin | 46m |
Argues that layered defenses have inevitable holes so security follows a Swiss cheese security pattern rather than an impermeable onion, and recommends secure… | ||
| An introduction to Extended Events | Peter Kruis | 51m |
Shows how to set up Extended Events for on‑prem SQL Server: creating sessions in SSMS, choosing events, adding causality tracking, and writing to an .xel file… | ||
| Demystifying Power BI Variables: A Comprehensive Guide to Understanding DAX and M Variables | Renato Lira | 51m |
Walks through Power Query M showing let in as a record syntax, building a reusable column-rename function, buffering and adding an index to read “next row”… | ||
| End-to-end data validation strategies in Microsoft Fabric | Will Needham | 46m |
Outlines a practical end-to-end approach for medallion-style data validation in Microsoft Fabric: three concrete checkpoints—schema validation on ingest… | ||
| A Beginners guide to Query Store | Peter Kruis | 22m |
Query Store captures and retains execution plans and runtime telemetry per database so regressions are visible over time, storing estimated plans, runtime… | ||
| Level-Up Power BI Dashboard Storytelling with DataViz Tools | Ioannis Philippides | 20m |
Follows a concrete dashboard recipe: define metrics with a KPI mapping (uses a Figma template from cter do), create personas and sketch on paper or whiteboard… | ||
| Data Linkage Options: MDM vs Splink (PySpark) | Barney Lawrence, Ash Ward | 21m |
Direct comparison of Master Data Management vs Splink: MDM provides a non‑technical UI, integrated QA/distribution and predictable outcomes but typically costs… | ||
| Microsoft Copilot Demystified: A 20-Minute Introduction | ALPA BUDDHABHATTI | 19m |
Explains that GitHub Copilot is an LLM trained on millions of public repos and that it generates runnable code, comments, and unit tests but requires human… | ||
| Boosting Your Blog's Visibility: Strategies to Drive More Traffic and Engagement | Annabel Hemingbrough | 22m |
Explains actionable steps to move a tech blog onto Google page one: use related-search keywords and include keyword in title, meta description and slug; put… | ||
| Microsoft Fabric and Data Mesh - a perfect fit? | Barry Smart | 20m |
Argues that Microsoft Fabric already delivers the self‑service platform piece of data mesh but leaves a clear gap around Federated computational governance, so… | ||
| Treat your reports as communication tools | Hubert Kobierzewski | 21m |
Converts a wide Power BI table into a condensed matrix, trims numeric precision, and replaces it with a slope chart mimic built from line series and markers… | ||
| Fueling Your Future: Embracing the Rewards of Data Platform Community Involvement | Ben Weissman | 19m |
Argues that active community work—speaking, mentoring, volunteering, blogging, organizing—returns concrete professional and personal value: begins speaking… | ||
| Introducing your Databricks Flight Assistant | Liping Huang, Marius Panga | 19m |
Live demo shows Databricks Lakehouse Assistant reading Unity Catalog metadata and notebook history to convert SQL to PySpark, convert R and Python to SQL, and… | ||
| Burnout: A personal journey to the bottom and back up again | Steph Martin | 46m |
Burnout is a workplace syndrome (WHO) triggered here by role ambiguity, four managers in 12 months and lack of managerial support; symptoms include bone-deep… | ||
| Govern your data in Fabric | Hylke Peek | 49m |
Shows how Fabric’s governance features actually work: sensitivity labels classify artifacts (lakehouses, pipelines, datasets) but inheritance stops after a… | ||
| Understanding window functions in DAX | Marco Russo | 51m |
Covers practical DAX window functions with concrete demos showing when they simplify code or hurt performance: index picks absolute positions (positive from… | ||
| Prepare for Takeoff: Navigating Power BI Developer Mode - Is the Journey Worth the Flight? | Miguel Félix | 50m |
Developer Mode saves reports as pbip format with dataset and report folders, exposes model text via tmdl files (and older tmsl), and enables git integration so… | ||
| Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights | Anthony Nocentino | 50m |
Demonstrates dbatools doing real work: standing up two SQL Server containers in seconds, keeping a persistent SMO connection with Connect-DbaInstance… | ||
| Data Mesh - a hot air balloon? | Rune Ovlien Rakeie, Johan Ludvig Brattås | 47m |
Argument lays out concrete claims and tools: Data Mesh (coined 2019) reorganizes ownership into domain teams, defines four principles (domain ownership, data… | ||
| Infra as code, control it from the tower. | Reitse Eskens | 48m |
Deploys an Azure data solution with Infrastructure as Code, emphasizing security and maintainability, and publishes runnable code on GitHub. Uses Terraform and… | ||
| The future of accessibility - lessons from research | Ashley Graham-Brown | 44m |
Defines accessibility as beyond WCAG to include WCAG, RRI's six pillars and the AREA 4P framework and argues for participatory methods: co-design with disabled… | ||
| Saying no is OK | SANDER STAD | 43m |
Addresses why saying no prevents burnout and gives concrete tactics: use time blocking and Pomodoro sprints, put every task in the calendar, apply the… | ||
| Unlocking Azure OpenAI: A 20-Minute Introduction | ALPA BUDDHABHATTI | 20m |
A 20-minute introduction that shows setup, integration and working demos rather than high-level hype, deploying Azure OpenAI + Azure Data Factory with REST… | ||
| Be more responsible around AI - Less Bias, More Ethics | Ben Weissman | 21m |
Uploads a phone photo to facecheck.id reverse-search and immediately finds an Instagram profile, demonstrating how easy nonconsensual identification is. Shows… | ||
| Field Parameters or Personalize Visuals – Choosing the Right Aircraft for Your Self-Service Journey | Bruno Mairos, Maria Gabriel | 22m |
Field Parameters in Power BI (preview) create a built table of name/value/order that the report author customizes (the talk shows an increment-by-10 ordering… | ||
| Top 10 transactional database mistakes, and how to avoid them | Aaron Felton, Rae Ellingham | 17m |
A concise checklist of ten real failures and fixes: missing relational design and duplication (move tables to third normal form), absent surrogate keys (add… | ||
| Data Lakehouse Vs Data warehouse in Fabric, which is right for you | Michael Johnson | 22m |
Microsoft Fabric exposes two engines: a Spark-based data engineering / lakehouse that reads and writes Delta Lake parquet files and supports nested types… | ||
| When to stop tuning a query | Milos Radivojevic | 53m |
A single T‑SQL query against 100M/335M rows is tuned stepwise: forcing a nested loop join cuts elapsed time from ~11s to ~2s but exposes a 10 GB memory grant… | ||
| Let End Users Drive: Empowering User Control in Power BI Reports | Cristian Angyal | 50m |
Built a live “bom pile” Power BI report that tracks serial-level failures with non‑additive measures (last‑date quantity per period) and a daily snapshot… | ||
| From DevOps for data to DataOps | Vincent Goris, Niels Nagle | 51m |
Argues DataOps extends database DevOps by adding continuous data testing, monitoring and governance, not just CI/CD with Git and Azure DevOps; claims reuse… | ||
| Safe Landings: Self-care In A High Intensity Technological World | Matt Gordon | 50m |
Conference data shows 43% feel disengaged and 51% feel they're underperforming then connects those stats to concrete fixes: deploy relevant monitoring and… | ||
| Better ETL with Managed Airflow in ADF | Niall Langley | 52m |
Managed Airflow in ADF brings Apache Airflow as a PaaS inside Data Factory, with demos showing DAGs that run ADF pipelines asynchronously (async operator +… | ||
| Navigating the Skies of Open AI: Perfect Your Grounding for a Smooth Landing | Brynn Borton | 49m |
Explains how to ground LLMs with retrieval using vector embeddings and concrete tooling: uses Azure AI Search and Blob Storage to index brochures, creating 3… | ||
| Decide on the fly: Real-Time Analytics in Microsoft Fabric | Joana Barbosa, Sónia Cruz | 40m |
Live demo of Microsoft Fabric wires Event Hubs to OneLake or a KQL database and builds semantic models that power Power BI dashboards with seconds‑level… | ||
| Accessibility is for everyone, including you! | Kay Sauter | 42m |
Covers concrete wins: use of cochlear implants, PowerPoint and Teams live captions, and Power BI accessibility checkers; cites WHO at 16% worldwide… | ||
| From SSIS to Synapse to Fabric - A Data Architects Case Study | Bob Duffy | 50m |
A metadata-driven declarative framework migrates an EDW automation system from SSIS to Synapse/ADF and then Fabric, keeping the same metadata-driven… | ||
| The Next Frontier: Azure OpenAI Models and the Arrival of GPT-4 | Anupama Natarajan | 51m |
Azure OpenAI on Azure runs GPT‑4 via Azure OpenAI Studio with region and model constraints, content‑safety filtering, token billing or provisioned throughput… | ||
| Air Traffic Control (Data Governance) with Databricks Unity Catalog, tips, tricks and best practices | Vuong Nguyen, Liping Huang | 51m |
Unity Catalog centralizes access for tables, files, models and external catalogs, adds column-level masking and row-level filters rolling GA this quarter, and… | ||
| The data runway: Soaring to New Heights with Fabric Data Activator | Denis Selimovic | 45m |
Demonstrates Fabric Data Activator as a no-code midlayer that watches streaming sources and triggers actions; prototypes link Power BI visuals or an Azure… | ||
| Social Engineering: Hacking People | Mladen Prajdic | 51m |
People are the weakest link: historic scams include Frank Abagnale’s $10M con and a 2007 $21M diamond heist, modern tools include Metasploit and the social… | ||
| Power BI and Big Tables | Markus Ehrenmueller-Jensen | 51m |
Explains when to use import vs DirectQuery and how to combine them with DAX Studio, the XMLA endpoint and Tabular Editor to manage partitions and scripts… | ||
| Anyone can be an alphabet soup ally | Jess Pomfret, LINDA TORRANG | 52m |
Clear, actionable allyship steps: listen and learn, amplify voices and make room at the table, and take specific actions like confronting discrimination and… | ||
| Visualizing Data for Non-Data Experts: Making Reports Accessible to All | Valerie Junk | 46m |
Shows a real failure case: a 25‑page vessel‑tracking Power BI report managers and captains cannot use, then a redesign that removes noise and surfaces… | ||
| SQL Server 2022 Performance Enhancements | Ola Hallengren | 50m |
Covers concrete 2022 changes and outcomes: availability group redo uses a global redo thread pool (observed up to 17 threads on a 144‑core host), tempdb… | ||
| What does Microsoft Fabric mean for a Finance/Business Analyst? | Rishi Sapra | 48m |
Shows a concrete finance pipeline: files + SQL transactions land in a bronze/silver/gold Lakehouse, notebooks and pipelines ingest and convert messy Excel into… | ||
| Building a High Performing Impact Center of Excellence (COE) in Microsoft Fabric | Vishal Pawar, Ph.D. | 49m |
Covers a practical 12-step roadmap from Microsoft and a recommended 6–12 week phased rollout with a baseline 10-question assessment and measurable skilling… | ||
| Knee-Deep In Tech Live @ SQL Bits | Simon Binder, Alexander Arvidsson | 35m |
Argument: frameworks become a ritual unless teams set a clear long‑term goal, run 2–4 week sprints with daily standups, act on retrospectives and hold… | ||
| Power BI Quiz Extravaganza | Martine Pieck | 18m |
Thirty rapid-fire Power BI questions cover concrete facts and gotchas: 30 rapid-fire questions, voting cards and timer, and a QR code for feedback drive the… | ||
| Website Analytics in My Pocket Using Microsoft Fabric | Cathrine Wilhelmsen | 20m |
Builds a pocket-sized website analytics dashboard using Cloudflare GraphQL API to pull daily and hourly stats, stores raw JSON files in a OneLake lakehouse… | ||
| How to Run Code Clubs for Neurodiverse Children | Justin Bird, Anna-Maria Wykes | 21m |
Code club runs monthly on Saturdays at a familiar charity venue (Jigsaw) using donated Digilocal laptops and block coding with Scratch blocks. Sessions keep… | ||
| The Critical Role of Creativity in Technical Professions | Annabel Hemingbrough | 21m |
Argues that creativity in technical roles produces measurable improvements by focusing on three concrete areas: colors, fonts and alignment. Recommends… | ||
| Elevating SQL Server Performance with Query Store Hints | Rui Carvalho | 20m |
Demonstrates how SQL Server 2022 Query Store Hints let DBAs change plan behavior without touching application code by registering hints against captured query… | ||
| An Introduction to Calculation Groups in Power BI Desktop | Pedro Reis | 20m |
Calculation groups are now native in Power BI Desktop (preview) and replace the need for external tools by letting a model define reusable items like time… | ||
| Turbo charge your Data Science workflow with Microsoft Fabric | Barry Smart | 51m |
Claim: Microsoft Fabric supports an end‑to‑end data science workflow inside one SaaS. Builds two data products on the Titanic dataset: a diagnostic semantic… | ||
| Dealing with Very Large Tables in SQL Server | Milos Radivojevic | 51m |
Shows a real 20 billion–row / 4.6 TB table that takes 28 minutes and ~72 million logical reads to return 3 rows when missing an index, so adding indexes must… | ||
| Building Tomorrow's Warehouse Today: Modern Data Warehouse Modelling Insights | Maria Zakourdaev | 42m |
Modern warehouses combine multiple cloud services, use ELT not ETL pipelines to decouple extraction and transformations, and mix normalized and denormalized… | ||
| Best practices for developing Power BI reports | Gregor Brunner | 48m |
Seven practical Power Query rules: query folding whenever possible, load only needed columns/rows, set explicit data types, name queries and transformation… | ||
| Timespan Fact Tables | Tino Zishiri | 19m |
A single fact table stores time ranges by adding valid_from/valid_to/is_current and a concatenated date range key, then a date range bridge explodes those… | ||
| Let's define Entities and attributes for tabular models in 20 minutes. | Ana María Bisbé York | 20m |
Shows how to convert messy denormalized tables into useful tabular entities in 20 minutes by using Power Query steps: create a star schema via SQL joins or… | ||
| Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory | Cathrine Wilhelmsen | 20m |
Compares three offerings by concrete tradeoffs: Azure Data Factory is a standalone orchestration and ETL service good for cross-vendor architectures, but… | ||
| Snowflake concepts & architecture | Surbhi Pokharna | 20m |
Snowflake is a fully managed, cloud data platform that runs on Azure, AWS or GCP and can replicate across them via cloud-agnostic Snowgrid. Storage is… | ||
| Power BI Culture: Governance as a gateway to adoption, not a barrier. | Megan Livadas | 20m |
Organisation has thousands of ungoverned workspaces and duplicate reports; the session presents a roadmap: four governance principles and three culture pillars… | ||
| Do those numbers look right? How to ensure quality, and avoid inaccuracies in your data insights. | James Broome | 45m |
Public Health England underreports about 2,000 cases a day for eight days is a concrete failure mode that motivates building tests into data pipelines. The… | ||
| Power BI meets UX Design: Creating accessible, intuitive and visually appealing reports | Elena Drakulevska | 50m |
Practical, actionable guidance for making Power BI reports intuitive: apply Gestalt rules—similarity, proximity, common region—to group visuals; use the… | ||
| More than 'just' a Data Catalogue - Boarding the Tour through the Microsoft Purview Universe | Wolfgang Strasser | 54m |
Microsoft Purview is now a suite that combines a data catalog (built on Apache Atlas), M365 compliance tools and security features under per.microsoft.com… | ||
| Maximizing Database Performance With Isolation Levels | Bob Pusateri | 47m |
Shows isolation levels on SQL Server and Azure SQL DB using a 41,437-row ZIP code demo, Extended Events and dbcc user options to prove behavior. WITH (NOLOCK)… | ||
| Calculation Groups & C# - The Perfect Couple | Paulina Jędrzejewska | 38m |
Demonstrates how C# scripting in Tabular Editor generates measures from KPI columns, loops through 20–60 base measures and five calculation items, and writes… | ||
| Did you know that you should version control your solution – even the smallest ones? | Emilie Rønning | 50m |
Version control your solutions using Azure DevOps
Speaker: Emilie Rønning https://SQLBits.com/speakers/Emilie_R_nningSpeaker Blog… | ||
| From substitutions to public keys - an introduction to cryptography | Daniel Hutmacher | 46m |
Covers hands‑on specifics: demonstrates Caesar shift and frequency analysis, explains AES internals with AES uses 16‑byte blocks and S‑boxes and 9/11/13… | ||
| Power Query in 20 Minutes - How it Works | Eugene Meidinger | 19m |
Power Query appears as a clicky UI but actually generates M code, follows an 80/20 practical rule and behaves lazily: it drops or reorders steps it deems… | ||
| The Decentralized Data Access Revolution | Maria Zakourdaev | 21m |
Argues that shifting from a push/ingest to a serve and pull model cuts duplication and time-to-insight by letting domains own and publish consumable analytical… | ||
| The Future of Data Analytics: Adapting to the Shifting Technology Landscape | Marthe Moengen | 21m |
Microsoft Fabric launched May 23, 2023, consolidates storage, transformation, BI, governance and real‑time analytics into a SaaS one lake that claims to cut… | ||
| Unlocking Synergy: PowerBI and PowerApps Collaboration for Data-Driven Decision-Making | Sascha Götz | 21m |
Shows a concrete workflow: add a small table in mixed model with DirectQuery table to a Power BI semantic model, drag its fields into the Power Apps visual… | ||
| A Deep Dive into Analytics Delivery Behind one of the Largest North American Banking Acquisition.. | Rodrigo Lemmi | 20m |
Analytics delivery for a $6 billion North American bank acquisition tracks 2 million customers, $60B deposits and 500 branches using a six-module framework… | ||
| Navigating Tech Job Interviews: Asking the Right Questions About Work Culture | Mala Mahadevan | 17m |
Focuses on concrete questions to reveal real culture: whether work is evaluated individually or by team, how promotions actually happen and ask for a recent… | ||
| Sensitivity labels - what do they look like | Heidi Hasting | 48m |
Sensitivity labels act as metadata not automatic access control: they require Office 365 E5 to create and Power BI Pro/Premium PPU to apply, and service views… | ||
| Python in Fabric for Data Engineers: all you need to know | Arthur Graus | 01m |
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with… | ||
| Thriving with ADHD in Tech: Unleashing the Data Analyst Superpowers Within | Reid Havens | 55m |
Claims ADHD can be leveraged into productivity with concrete routines and tools: a consistent morning routine, 140 reminders in iPhone for timed/location… | ||
| Asking questions to get meaningful answers | Benni de Jagere | 21m |
Concrete rules: do quick research first, pick the right channel (email for multirecipients, Teams/Slack for quick pings), avoid blasting 7,000 people, and… | ||
| Git off my lawn: Mastering Power BI Deployments with Git Integration | David Mitchell | 48m |
Shows a working setup that automates Power BI deployments using the REST API and Azure DevOps YAML pipelines to create workspaces, assign capacities, and push… | ||
| Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes | Haider Raza, Manish Kumar | 22m |
Covers concrete IQP changes across SQL Server 2017/2019/2022 and Azure SQL: memory grant feedback persisted to Query Store (so learned grants survive cache… | ||
| Indexing Internals for Developers & DBAs | Bradley Ball | 53m |
Covers how heaps, clustered and non‑clustered indexes behave with concrete measurements and fixes: uses DBCC IND/DBCC PAGE, DMVs, Query Store, set statistics… | ||
| Setting yourself up for success when submitting to present | Benni de Jagere | 22m |
Focus on concrete choices: fill every optional field (bio, notes), submit two different proposals, and target platforms like call for data speakers and… | ||
| Star Schema ALL the things! But why? | Benni de Jagere | 50m |
A practical comparison uses NYC bike CSVs (≈212 million rows) loaded into Fabric, measuring refresh time, model size, CPU and query cost. A single flat table… | ||
| What we’ve learned running a YouTube channel (so far) | Josh Luedeman, Daniel Taylor, Bradley Ball | 21m |
Channel launches with 42 subscribers first month, 121 after six months, 702 down to ~1782 views and just 84 watch hours, then pivots to regular pure technical… | ||
| Prepare for Fabric with Power BI Governance, Auditing and DR | Alex Whittles | 48m |
Argues that governance must be planned, monitored and fixed with concrete controls rather than vague policies, showing a practical three-layer architecture… | ||
| Models in Flight: Elevating semantic modelling with Spaceparts Co and Tabular Editor 3 | Morten Lønskov, David L. Bojsen | 51m |
Tabular Editor 3 demo shows actionable features: live DAX workflow to define measures in query scope, edit and F7-deploy fixes without re-deploying whole… | ||
| Assessing and Optimize Enterprise SQL Server Environments | Angela Henry, Ben DeBow | 49m |
Enterprise assessment shows a few small targets deliver big wins: top 1% of code = >50% cost across servers, so tuning a single hot query that runs millions of… | ||
| What's new in Power Query in Power BI, Fabric and Excel? | Chris Webb | 54m |
Power Query online surfaces in Power BI Desktop and soon Excel delivering diagram view, schema/script view, query plans and step-folding indicators; Excel adds… | ||
| Analytics Architectures on Microsoft Fabric | Bradley Schacht, Freddie Santos | 48m |
Compares concrete architectures on Microsoft Fabric and shows measurable wins: a 10TB TPC‑H run matches Synapse DW3000 on an f64 at roughly 1/8 the cost… | ||
| Contextualizing timeseries data with graphs | Devang Shah, Henning Rauch | 44m |
Kusto (Azure Data Explorer) adds in-query graph semantics that build an in-memory property graph per query using make graph and traverse it with graph match… | ||
| Fabric security: everything you need to know! | Kasper de Jonge | 48m |
Fabric encrypts data at rest and enforces TLS 1.2 in transit and uses encrypted by default storage for OneLake, but customer‑managed keys are not yet… | ||
| Navigating Microsoft Fabric - Choosing the Right Workload for Your Needs | Patrick LeBlanc, Adam Saxton | 52m |
Microsoft Fabric walks through three concrete workloads and tradeoffs: a Spark-powered Lakehouse that you can create automatically and do a no-code Lakehouse… | ||
| Connect Excel to Power BI data with Live Connected Tables | Chris Webb | 20m |
Demonstrates how to export Power BI data into Excel as Live Connected Tables that stay linked to the Power BI semantic model, rerun the original DAX query on… | ||
| Workflows of Highly Functional App & Data Engineering Teams | Jerry Nixon | 50m |
Outlines a pragmatic medallion pipeline: raw bronze dumps (hourly/daily) into a shared lake, cleaned and joined into silver, then precomputed, business-aligned… | ||
| Optimising DAX fusion - Power BI | Philip Seamark | 51m |
Uses DAX Studio and server timings to show concrete steps that cut 337 storage-engine calls to one and drop server time from ~21s to about 1–2s on a heavy… | ||
| Analytics at the speed of Direct Lake | Patrick LeBlanc, Philip Seamark | 47m |
Direct Lake uses Parquet files plus V order compression to page columns into memory on demand, so models start empty and only queried columns load… | ||
| Scale your business in real-time using ML in Microsoft Fabric Real-time Analytics | Aviv Yaniv, Devang Shah | 53m |
Custo (Kusto) uses native time‑series functions like series_decompose and series_forecast to predict CPU demand from three weeks of history, combine ingestion… | ||
| Fabric Product Group - Ask us Anything | Mark Pryce-Maher | 48m |
Panel answers concrete timelines and workarounds: a self-hosted integration runtime for on‑prem copy arrives on the public roadmap as Q1 roadmap; a proper… | ||
| Stabilizing Performance with Query Store | Erin Stellato | 19m |
Demo uses Wide World Importers to show plan forcing (manual jobs and automatic correction) and Query Store hints to stabilize a statement that flips between an… | ||
| Fabric Power Hour | Mark Pryce-Maher, James McGillivray, Lars Andersen, Scott Stauffer, Devang Shah, Chris Webb | 51m |
A mock “no pilot” mind‑reading co‑pilot with a Mind Horn hardware demo fails to calibrate reliably, producing laughs but no usable output; a new Fabric file… | ||
| GitHub Copilot for SQL Development: Integrating the Power of AI into Database Development | Subhojit Basak | 47m |
Demo shows GitHub Copilot hooked into IDEs (notably Azure Data Studio) using a GitHub account and the Copilot extension with subscriptions from $10/month… | ||
| Augmenting Power BI Adoption with Center of Excellence team | Syangprova Sinha | 20m |
A Power BI Center of Excellence creates a measurable adoption engine: it implements data governance and tenant audits, runs standardized templates and… | ||
| Driving alerts and actions on your data | James Hutton, Lars Andersen | 47m |
Microsoft Fabric’s Data Activator is a no‑code detection-to-action layer (now public preview) that watches Power BI models and real‑time event streams, detects… | ||
| Fabric Direct Lake Deep Dive | Chris Webb | 50m |
Direct Lake mode lets Power BI query OneLake Delta/Parquet files by paging needed columns into memory on demand, converting on the fly to the VertiC in‑memory… | ||
| Azure SQL MI & Fabric Fusion: A speed-session | Niko Neugebauer | 25m |
Shows how Azure SQL Managed Instance queries external Parquet in OneLake via data virtualization and how CREATE EXTERNAL TABLE AS SELECT (CETAS) writes table… | ||
| Understanding Zero Trust security | Kasper de Jonge | 20m |
Zero Trust assumes breach and verifies every access rather than trusting a network perimeter, so Entra ID handles authentication for Microsoft Fabric and Power… | ||
| Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR | Djordje Jeremic, Dani Ljepava | 23m |
Demo shows Mi link online replication that sets up distributed AGs from SQL Server 2016+ to Azure SQL Managed Instance via an SSMS wizard that also emits the… | ||
| Introducing Explore - a new way to explore data right within Power BI. | Patryk Kowalski, Roseanne Levasseur | 42m |
Explore is a new in-product Power BI / Fabric canvas that opens from a report command bar, Data Hub, workspace list or a Data Mart SQL result and starts with a… | ||
| Copilot Studio: Guiding Your Chatbot Takeoff with AI Aviation! | Lewis Prince | 20m |
Built a live SQLBits chatbot using Copilot Studio that ingests the SQLBits website, Word docs and FAQs, answers low‑to‑medium complexity questions, and returns… | ||
| Welcome to the world of SQL Copilots | Bob Ward, Joe Sack | 45m |
Azure SQL Copilot demos show two portal experiences: an Azure Copilot sidecar with about 40 skills ready (55 total planned) and a natural language to SQL… | ||
| Flying High with Data Engineering in Microsoft Fabric | Aitor Murguzur, Luke Moloney | 44m |
Demonstrations show Microsoft Fabric using notebooks (PySpark/Scala/Spark SQL with magic commands) plus Lakehouse storage on ADLS Gen2 and a SQL analytics… | ||
| Fly at Mach-speed with Azure SQL Managed Instance | Niko Neugebauer, Nevena Nikolic, Uros Milanovic | 51m |
General purpose Managed Instance moves from premium page blobs to managed discs, cutting average latency to ~3–4 ms and raising max data IOPS to ~80k and max… | ||
| A Deep Dive into DevOps Practices with Azure SQL | Jerry Nixon, Carlos Robles | 50m |
Demo-heavy walkthrough of Azure SQL DevOps shows concrete recipes: pack app plus database into Dev containers (Codespaces/VS Code), scaffold schema with SQL… | ||
| Hidden Gems in SQL Server 2022 Database Engine | Ajay Jagannathan, Dimitri Furman | 49m |
Demo-heavy tour of small fixes that deliver big wins: handsfree tempdb removes PFS/GAM/system-table latch contention so a single tempdb file runs with no… | ||
| Discover what's new in Azure SQL Managed Instance through an exciting Demo Party! | Dani Ljepava, Nevena Nikolic, Uros Milanovic, Niko Neugebauer | 50m |
Demo shows how failover groups plus maintenance alerts enable plan failover with maintenance alerts: create peered VNETs, non‑overlapping subnets, open ports… | ||
| What You've Been Missing in SSMS | Anna Hoffman | 50m |
Release notes say SSMS 20 ships with updated Microsoft.Data.SqlClient, SMO and DacFx and a changed connection dialog that defaults encryption from optional to… | ||
| Come see your SQL Perfmon in the cloud | Dimitri Furman, Bob Ward | 49m |
A new managed service called Database Watcher collects diagnostic telemetry from Azure SQL databases, managed instances, elastic pools and replicas, stores it… | ||
| What's new on the Power BI Roadmap | Mohammad Ali, Rui Romano | 52m |
Power BI now ships a text-first developer mode that saves PBIX as a pbip folder with Git-friendly files, a new open report asset format to let tools copy pages… | ||
| Zero to Hero with SQL Server on Linux - DBA & Developers | Tejas Shah, Amit Khandelwal | 50m |
Same SQL Server binary runs on Ubuntu, RHEL and SLES and in containers; Microsoft provides Ansible system role (on Ansible Galaxy and built into RHEL 8.5) to… | ||
| Building AI ready applications | Muazma Zahid, Sanjay Mishra | 50m |
Shows a working pipeline that keeps data in Azure SQL DB and augments it with Azure OpenAI and Azure AI Search: precomputes embeddings for 8 million reviews… | ||
| Accelerate your Oracle & Mainframe Modernization journey to Azure SQL | Mukesh Kumar, Asad Khan, Des FitzGerald | 44m |
Azure SQL migration shows concrete IPs and measured results: a Databricks + Spark/Scala pipeline moves 50 million rows in ~14 minutes and can hit roughly 1 TB… | ||
| Harnessing Data Science and AI in Fabric | Aitor Murguzur, Luke Moloney | 45m |
Shows Fabric running an end-to-end data science flow: created workspace via Fabric API then used a notebook workflow to ingest churn CSV into a Lakehouse… | ||
| Operational insights in your hybrid-cloud multi-cloud SQL inventory outside azure using Arc SQL Serv | Dhananjay Mahajan | 49m |
Azure Arc discovers and inventories SQL Server instances by installing an Azure Arc agent and an Azure SQL extension, ships DMV and performance counters at… | ||
| What's new in SQL Tools | Drew Skwiers-Koballa | 50m |
Connections now default to encryption after the move from SQL Client 3→4 and the TDS8/TLS1.3 work in secure-by-default SQL Client can break old connection… | ||
| Your first flight with Data Factory in Microsoft Fabric | Krishnakumar Rukmangathan, Ulrich Christ | 49m |
Data Factory in Microsoft Fabric presents a unified SaaS data-integration stack with ~170 connectors and data flows Gen2 offering more than 400… | ||
| The Microsoft Data Leadership Panel | Bob Ward, Sanjay Mishra, Alicja Kucharczyk, Muazma Zahid, Asad Khan, Mohammad Ali | 03m |
A live leadership Q&A focuses on products and policy: panelists take unscripted questions about Azure SQL Database features and roadmap, Fabric team… | ||
| Data tiering using data Virtualization in SQL | Ajay Jagannathan | 51m |
SQL Server shows a working data-virtualization stack: PolyBase V3 runs natively in the engine with a REST/S3 object-storage connector, supports Parquet/CSV… | ||
| JSON - a first class citizen in Azure SQL DB | Abhiman Tiwari, Sanjay Mishra | 45m |
Azure SQL DB now stores JSON in a native JSON data type (binary storage, private preview, docs + signup) supporting update-in-place, efficient partial reads… | ||
| Navigating Modern Authentication in SQL | Pieter Vanhove, Jordan Hays | 51m |
Overview of concrete steps and outcomes for replacing passwords with Entra-based auth for Azure SQL and Arc‑enabled SQL Server: shows Defender for cloud… | ||
| Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi | Ajay Jagannathan | 50m |
Covers concrete engine features and demos: metadata versioning (Azure private preview) lets snapshot reads continue while ALTER TABLE runs by using… | ||
| More for less: Cost optimizing your Azure SQL databases | Aditya Badramraju, Arvind Shyamsundar | 52m |
Claims that hyperscale is usually the cheapest option for mid‑to‑large databases because it disaggregates compute and storage, supports up to 100 TB, offers 30… | ||
| Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance | Niko Neugebauer, Djordje Jeremic, Bogdan Gavrilovic, Dani Ljepava | 50m |
Maps on‑prem DBA tasks to Azure SQL Managed Instance and names exactly what stays with the DBA versus what Microsoft handles: automatic backups (full/diff/log)… | ||
| SQL Server and Windows Server Better together on Azure | Dilip Ramachandran, Bob Ward | 49m |
Demonstrations show hot patching without reboots (Xbox: 1,000 servers patched in 48 hours with zero downtime), a new Azure update manager that applies SQL… | ||
| Making the SQL Query Processor Work for you | Ajay Jagannathan, Joe Sack, Derek Wilson | 51m |
Upgrading a database’s compatibility level 160 (SQL 2022) often reduces CPU and duration versus 130 without code changes, because the engine applies persisted… | ||
| Modern models of managing database fleets in Azure PaaS. | Dani Ljepava, Uros Milanovic, Bogdan Gavrilovic | 40m |
Azure Database Fleet Manager automates tenant provisioning, placement, autoscaling and pool rebalancing for Azure SQL with a stable connection endpoint so… | ||
| Business continuity of on-prem SQL Servers using Azure services through Arc | Raj Pochiraju, Dhananjay Mahajan | 46m |
Arc-enabled SQL Servers bring cloud features to on-prem systems immediately: Azure Arc collects inventory for availability groups and FCIs, shows health and… | ||
| Azure SQL DB Data Portability : Mirroring, CDC, Export/Import and DataSync | Rajesh Setlem, Carlos Robles | 50m |
Quick practical rundown: Import/Export is fragile above 200 GB limit so use SQLPackage (wraps DACFx) instead — SQLPackage is in public preview for larger… | ||
| HADR on SQL Server on Azure VMs: Everything you Need to Know | David Pless | 52m |
Covers concrete choices and tradeoffs for HA/DR on SQL Server in Azure VMs: use SQL IaaS Agent extension to provision multi-VM Always On AGs (VMs, listener… | ||
| Confidential development with Always Encrypted using enclaves | Pieter Vanhove | 43m |
Always Encrypted with secure enclaves in Azure SQL enables in-place encryption and key rotation without exporting data, and unlocks rich confidential queries… | ||
| Deep {sky}diving into Data Factory in Microsoft Fabric | Jeroen Luitwieler | 50m |
Demo moves a 1 TB CSV from Azure Blob to Fabric Lakehouse as a binary copy in under 4 minutes using auto ITO and 128 threads, reporting 1 TB binary copy <4… | ||
| Perfecting business continuity for Azure SQL DB | Rajesh Setlem | 47m |
Covers concrete configs and demos: uses a 2 vCore Gen5 Hyperscale DB, simulates 28,000 requests/min with JMeter, and triggers a SQL database failover command… | ||
| Extendable by Design: Building Generative AI Apps with Postgres and Vector Storage and Azure AI | Adam Wolk | 47m |
Shows a working Rails app that loads ~30 years of mailing‑list emails (1998–Mar 2024), adds a generated ts_vector column for full‑text search, creates 1536‑dim… | ||
| SQL Server on Azure VM - Configuring for Price-Performance | David Pless | 49m |
Covers concrete configuration choices: choose ebds V5 (double‑sprinkles) for mission‑critical workloads and Azure Boost, use premium ssv2 for most… | ||
| The What and the Why of Microsoft Fabric Real-time Analytics | Devang Shah | 20m |
Microsoft Fabric ingests high‑frequency telemetry (supports Event Hub / AMQP / Kafka endpoints and sample sources), transforms JSON arrays with operations like… | ||
| SQL Server Containers & Kubernetes - Going to Production! | Amit Khandelwal, OJ Ngo, Tejas Shah | 57m |
Claim: customers run full SQL Server engine on Linux containers in production, with cross‑platform Always On failover between Windows VMs, Linux VMs and… | ||
| How to design and build AI applications with vector search using Azure OpenAI & Azure Cosmos DB | Theodorus Leonardus van Kraay | 50m |
Shows a working RAG pipeline using Azure OpenAI for embeddings and chat completions plus Cosmos DB VOR as the vector store, with a Java demo that loads three… | ||
| A Deep Dive into Microsoft Fabric Data Warehouse | Jerry Nixon, Mark Pryce-Maher | 51m |
Microsoft Fabric Data Warehouse stores tables as Delta tables (Parquet + Delta log) on OneLake, queryable via a SQL analytics endpoint from SSMS/Azure Data… | ||
| Best Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the Cloud | Dilip Ramachandran, Alicja Kucharczyk | 36m |
Cloud deployments show big, measurable effects: a cross‑region pgbench run yields ~3,000 transactions vs ~500,000 in same‑zone with avg latency ~1s vs ~23ms… | ||
| SQL Modernization Journey with Tools, Assets & Migration Best Practices | Ajith Krishnan, Neel Ball, Des FitzGerald | 50m |
Overview of tooling and hard numbers for moving SQL to Azure: Azure Migrate discovery finds metadata and produces a business case and a SQL assessment (example… | ||
| Flight of Insights: Navigating Data Turbulence with SQL Modelling and Visualisation | Corrinna Peters | 17m |
Uses pilot‑flown simulations and virtual‑reality recreations to show that when human reaction time is modelled, every alternate landing option fails and Hudson… | ||
| Get Rid of Your Data Quality Problems | Oliver Engels, Tillmann Eitelberg | 50m |
HEDDA.IO ships a management app plus notebook runners that push business rules into customer compute (Databricks/Fabric) and keeps everything in the Azure… | ||
| Managing the Challenge of Monitoring Growing, Multi-platform Database Estates | Laura Copeland, Grant Fritchey | 20m |
Survey shows ~80% cloud/hybrid adoption, 72% manage multiple platforms and 50% use PostgreSQL; Redgate Monitor is a multi‑database, multi‑platform monitoring… | ||
| Shift-Left: A DevOps and Database Story | Kevin Kline | 23m |
Code changes get performance-gated during CI so regressions fail before production. Uses Plan Explorer for query plans and index advice and SQL Sentry hooked… | ||
| Getting Started Quickly with DB DevOps | Huxley Kendell | 20m |
Demonstrates using Flyway and a free Fly Autopilot sandbox to go from zero to CI/CD in about 20–30 minutes, using GitHub Actions runners and a local DB to… | ||
| SQL Horror Stories | Kevin Kline | 21m |
A rapid set of real incidents: a preventative‑maintenance script rollout is blocked until a manager is reframed by reputation and then deployed, saving hours… | ||
| The New Database Landscape - Revealing Shifts and Charting the Next Horizon | Grant Fritchey, Danielle Summers | 49m |
Survey data says 21% single database while 30% use six or more platforms, and 70% report hybrid deployments (18% all cloud, 12% on prem); 44% cite… | ||
| Flying High with Highly Available SQL Server Deployments | Aaron West | 20m |
Defines high availability for SQL Server as recoverable failover and shows a working product that pairs Windows Failover Clustering with DataKeeper to mirror… | ||
| Data Testing with HEDDA.IO | Oliver Engels, Tillmann Eitelberg | 52m |
HEDDA.IO provides a management UI to define schema domains, compose rule books with conditional rule flows and dataset-level rules, and expose an API and… | ||
| Effortless Low-Code Data Testing | Tomas Tucek, Petr Pařík | 19m |
Claims a low-code test harness called cat that runs SQL/Power BI checks with three commands and plugs into CI/CD. Example tests: a date-dimension end-date… | ||
| Challenge to Triumph: Exploring Real-World High Availability in SQL Server Environments | Harry Aujla | 20m |
A large Canadian customer migrates ~3–400 SQL servers into AWS and builds ~300 two‑node EC2 clusters across two availability zones using SIOS DataKeeper to do… | ||
| Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 1st Leg | Scott Stauffer | 22m |
Shows a working pipeline that scrapes the International Guide Dog Federation website and maps affiliate offices into a Power BI report using Microsoft Fabric… | ||
| The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website) | Lewis Prince | 20m |
SQLBits gets a website chatbot built with Copilot Studio that indexes the conference site as a source, is created in about 5 minutes, and is published via an… | ||
| Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg | Scott Stauffer | 22m |
Demonstrates web scraping inside Microsoft Fabric using PySpark notebooks (Python with httpx and selectolax plus geopandas and geopy for geocoding) and Power… | ||
| Speeding Data Product Delivery from Model to Marketplace | Mike O Donnell | 17m |
Blueprint claims a model-first start that moves a data product from design to an internal Marketplace in seven repeatable steps, using a catalog to automate… | ||
| Mastering the Hybrid Environment: Essential Strategies for DBAs | Anat Dror | 17m |
95% of organizations already use cloud, investment is projected to triple by 2027 and a study says 63% of IT infrastructure moves to cloud within 18 months… | ||
| Effortless Low-Code Data Testing | Tomas Tucek, Petr Pařík | 20m |
Product called Cat is a PowerShell module that installs in seconds and runs data tests from YAML or Excel, comparing SQL Server, Postgres, Power BI (via DAX)… | ||
| How will AI transform your data platform? | Ben Jarvis, Manoj Matharu | 17m |
Live demos show concrete wins: deploy ADLS Gen2 + Databricks via Bicep generated by GitHub Copilot as a starting template (not production ready), CSV→JSON with… | ||
| Defending the Cloud: Securing Your Microsoft Data Workloads | William Rathbone, Chris Murray | 43m |
Shows a live honeypot VM exposed to the internet that immediately attracts automated scans (FTP, SSH, RDP, SQL, common username/passwords) proving… | ||
| Lessons Learned: Insights from 30 Years in Cloud and AI/ML Integration | James Smedley | 39m |
Claims that a functioning data marketplace plus continuous flow of trusted data turns trapped legacy data into reusable products, speeds self‑service, and… | ||
| DevOps Discovery: Navigating the Database Landscape | Huxley Kendell, David Ong | 48m |
Redgate demos a concrete DevOps stack: Test Data Manager creates masked clones, shrinking a 5 TB → 100 MB per dev image and provisioning it in about 30 seconds… | ||
| Empowering Women in Data: Navigating Challenges, Seizing Opportunities | Gloria Georgieva | 20m |
Current landscape: women occupy about 25% of STEM roles, rose to ~31% pre-pandemic, fell to ~20% then recovers; Harvard Business Review data shows… | ||
| Data Modelling is not a one man job! | Simon Meacher | 22m |
Argues that data modelling must be collaborative and automated, showing how WhereScape 3D plus GIT pipelines let multiple designers share models, enforce code… | ||
| Mastering TempDB | Monica Rathbun | 48m |
Explains which SQL Server features actually land in TempDB (AlwaysOn AGs, RCSI version store, spills, sorts, temp tables) and gives concrete remedies: add… | ||
| DAX Visual Calculations: What You Need to Know | Renato Lira | 50m |
Demo uses the AdventureWorks sample and the Power BI/Fabric preview visual calculations feature (enable via Options > Preview features, released Feb 2024)… | ||
| Generative AI: Concepts, Tools, and Applications for Data Professionals | Buck Woody | 49m |
A practical tour of how generative models get built and used: history to LLMs, RAG (retrieval-augmented generation) for making models use private docs, and… | ||
| Should I become a manager in IT | Buck Woody | 21m |
Chooses between staying an individual contributor who gets promotions for personal output or becoming a manager rewarded for team results, with concrete skills… | ||
| Should I become a manager in IT | Buck Woody | 19m |
Outlines concrete decision factors: becoming manager means trading individual recognition for responsibility for others, daily unpredictability, more admin in… | ||
| You're a Power BI Admin? Let's get your threads aligned for Fabric! | Benni de Jagere | 49m |
Fabric treats Power BI as a workload on a unified platform and requires paid capacity for any lakehouse, warehouse, KQL database or pipeline (trial capacities… | ||
| The Untruthful Art - Five Ways of Misrepresenting Data | Alexander Arvidsson | 49m |
Five concrete tricks are exposed: manipulated axes and missing labels that stretch trends, Power BI visuals reshaped to hide raw data, selective time windows… | ||
| Writing T-SQL code for the engine, not for you "more demos" by popular demand | CLÁUDIO SILVA | 52m |
Shows live demos on SQL Server 2022 in a Docker container with SSMS 19 and a 10GB StackOverflow DB, proving concrete fixes: an implicit conversion flips an… | ||
| Your Performance Tuning Check List | Monica Rathbun | 54m |
Checklist of concrete changes: set OS/VM to High Performance for an observed 30% CPU gain (verify with CPU‑Z), disable unused services (SSIS/SSRS), apply… | ||
| Relational or Non-Relational? Choosing the Best Database for the Task | Bob Pusateri | 19m |
Compares relational vs non-relational with concrete rules and examples: shows a working URL-redirect implemented in Azure Cosmos DB, explains partitioning on a… | ||
| A Data Engineer, Scientist and Analyst Walk Into a Bar | Bethany Hope Archer, Tori Tompkins | 45m |
Defines concrete handoffs: engineers build ingestion pipelines, deploy automated CI/CD and run cloud infra on Databricks or Azure/AWS; analysts clean data… | ||
| Load Testing Fabric - What is our hold capacity? | Reitse Eskens | 48m |
Loads are generated from the TPC-H toolchain into CSVs and copied into a Fabric Lakehouse via Pipelines and Notebooks, then transformed into Delta and joined… | ||
| We Are All in Sales | Nick Harshbarger | 20m |
Claims that every technologist must sell ideas to advance careers, summarizing a 20‑minute set of concrete tactics: cites Forbes (Oct 5, 2021) and highlights… | ||
| nothing matches | ||