SQLBits 2020
2020-09-29..2020-10-04
-- online --
SQLBits ·
[SQLBits 2019, SQLBits 2020, SQLBits 2022, SQLBits 2023, SQLBits 2024]
who it's for
data engineers, database administrators, cloud architects, DevOps engineers, data scientists, BI developers, IT managers
topics
Azure Synapse Analytics; Azure Data Factory patterns; Azure SQL Database migration; Azure SQL Hyperscale architecture; Azure DevOps with containers; Databricks Delta Lake; Machine learning in Azure; Notebooks for data exploration; Power BI performance tuning; Azure cost management strategies; SQL Server encryption capabilities; UTF-8 string storage in SQL Server
| title | author | length |
|---|---|---|
| Azure: Maxmise your bang for Buck | Justin Langford | 20m |
Covers concrete purchase levers: Azure Hybrid Use Benefit lets active Software Assurance Windows/SQL cores move to Azure (enterprise core can convert to four… | ||
| Understanding Azure Active Directory for Data Professionals | Joey D'Antoni | 46m |
Explains how Azure Active Directory differs from on‑prem AD (LDAP/Kerberos vs SAML/OAuth), shows AD Connect syncing choices, and demos logging into Azure SQL… | ||
| Predictive Maintenance with Azure Synapse | James Broome | 41m |
A telecom use case processes 10 GB/day of set‑top box telemetry with about 140 event types to replace six‑week Excel reports. The pipeline uses Azure Synapse… | ||
| Database CI/CD with Docker Containers and Azure DevOps | Chris Taylor | 46m |
Demo shows a Visual Studio database project producing a dacpac built into image via Azure DevOps build pipeline, then a Linux Docker image (Ubuntu + SQL Server… | ||
| SQL Managed Instance: Fully managed SQL Server in Azure | Mladen Andzic | 44m |
Azure SQL Managed Instance positions itself between SQL on VM and single-db SQL Database and emphasizes compatibility and modernization. Recent additions… | ||
| Azure Data Factory patterns and best practices | Shirley Wang | 50m |
Azure Data Factory claims real-world throughput (for example 2 petabyte in 11 days at 2–3 GB/s and a customer doing 1 PB per month increments), exposes DIUs… | ||
| Practical Container Scenarios in Azure | Anthony Nocentino | 01h 00m |
Builds a .NET Core web app, authors a Dockerfile, and runs an az acr build so Azure Container Registry builds the image in ~41s rather than shipping the full… | ||
| Azure SQL Hyperscale Deep Dive | Paraic Nolan, Denzil Ribeiro | 51m |
Architecture explains that Azure SQL Hyperscale uses separation of compute and storage with stateless compute, an externalized log service (durable landing… | ||
| Storing strings in SQL Server and Azure SQL DB | Pedro Lopes | 20m |
Explains when to use UTF-8 versus UTF-16 in SQL Server and Azure SQL DB with concrete numbers and migration tactics: UTF-8 gives 50% storage savings for… | ||
| Azure AI, Power new possibilities for every organization | Lindsey Allen | 50m |
Demo shows Form Recognizer extracting invoice fields and image recognition flagging a windshield crack at 92% confidence, and Chevron automates hundreds of PDF… | ||
| An introduction to Azure Synapse Analytics! | Mahesh Balija | 54m |
Azure Synapse Analytics combines Data Lake storage and MPP data warehouse into one workspace with integrated Data Factory pipelines, Spark pools and T-SQL… | ||
| Building Modern Data Warehouse with Azure Synapse Analytics! | Mahesh Balija | 55m |
Live demo builds a retail modern data warehouse on Azure Synapse that ingests SAP/Oracle/Blob/Cosmos/ADLS data, runs transformations with Spark notebooks… | ||
| Fast Focus: Azure Notebooks for Artificial Intelligence | Jennifer Stirrup | 19m |
Shows how to create an Azure Machine Learning workspace, clone sample Jupyter notebooks from GitHub, and launch a VM-backed compute instance to run Python, R… | ||
| Make A Company Conversational using Azure Cognitive Services | Matt Gordon | 56m |
Shows concrete Azure Cognitive Services patterns: a live Q A Maker demo wired into a webchat iframe, a Twitter sentiment pipeline using Logic Apps → Text… | ||
| Azure Key Vault, Azure Dev Ops and Data Factory | Erwin de Kreuk | 46m |
Shows end-to-end wiring of Azure Key Vault, Azure DevOps and Data Factory: creates factories and ARM templates, links factory to a DevOps repo, and uses… | ||
| SQL Server to Azure SQL: Performance and Availability | Bob Ward, Anna Hoffman | 50m |
Covers concrete migration choices: backup cadence (full weekly, log every 5–10 min, diff every 12 h) and RAGRS geo-restore, service tiers (general purpose vs… | ||
| Using Azure DevOps for Azure Data Factory | Paul Andrew | 22m |
Four concrete deployment patterns for Azure Data Factory: single Data Factory (dev and prod same resource), ADF_publish branch which contains the ARM template… | ||
| Azure Synapse Analytics | James Serra | 49m |
Azure Synapse Analytics shows an integrated workspace tying data lake Gen2 files, provisioned SQL pools and Apache Spark so you can right‑click a Parquet file… | ||
| Taking Models to the Next Level with Azure Machine Learning | Amy Boyd | 51m |
Tailwind Traders moves from Azure Cognitive Services Text Analytics to a bespoke pipeline using Azure Machine Learning and the Azure ML SDK, running Automated… | ||
| Azure Synapse Analytics: Evolving Azure SQL Data Warehouse | Artur Vieira, Mark Pryce-Maher | 53m |
Live demo of Azure Synapse shows a unified platform built on a data lake with Azure Data Factory integration, a provisioned MPP engine (provisioned SQL pool)… | ||
| Implementing AI using Azure Machine Learning Services | Vitor Fava | 53m |
Live demo shows a classification pipeline built in Azure Machine Learning Studio that trains on a public diabetes CSV dataset, applies log z-score and min-max… | ||
| Advanced Azure DevOps With Containers and Pipeline As Code | Chris Adkin | 22m |
Shows how to run Azure DevOps YAML pipeline as code that builds a DACPAC, publishes it as an artifact, then spins up four parallel sidecar containers running… | ||
| Designing Azure Data Disaster Recovery Strategies | John Morehouse | 54m |
Explains concrete DR choices: PaaS (Azure SQL DB/Managed Instance) gives automatic backups (weekly full, two dailies, log backups ~5–7 minutes) with 7‑day… | ||
| Battle tested project planning with Azure Devops boards | SANDER STAD, Kevin Chant | 41m |
Shows how to use Azure Boards inside Azure DevOps to plan data platform work end-to-end: demoed product backlog items, sprint boards with capacity and sprint… | ||
| Combatting illegal fishing with Azure for less than £10/mth | Carmel Eve | 44m |
Claims a serverless pipeline that processes 1.5 billion messages per month for under £10/month of compute by using Azure Functions consumption plan, Azure Data… | ||
| Yes, You Should Monitor Azure SQL Database | Grant Fritchey | 50m |
Azure SQL Database still requires active monitoring because billing and performance are linked to DTU/vCore choices and geo‑replication adds cost. Use the… | ||
| Building a secure data solution using Azure Data Lake | Carmel Eve | 38m |
Azure Data Lake Gen2 is used as a secure, scalable file-system layer on top of Blob storage with hierarchical namespace and POSIX-style ACLs, enabling… | ||
| Navigating the Bewildering Array of Data Services in Azure | Ian Griffiths | 49m |
Creates an Azure storage account live, uploads a 5 MB video to blob storage and shows a SAS token URL that expires 5 Sep 14:35 UTC; explains LRS/ZRS/GRS/RA-GRS… | ||
| Data Exploration & Experimentation with Notebooks in Azure | Ian Griffiths | 46m |
Claim: notebooks put code, text and visuals together so non-experts can interrogate real data; example loads UK ONS Excel into a pandas DataFrame, inspects… | ||
| De-risk Your Azure SQL Migration: 5 Critical Considerations | Dustin Dorsey, Denis McDowell, Kevin Kline | 57m |
Research shows more than 80% repatriate at least one workload; migrations fail from misaligned goals, unexpected CPU/storage/IOPS costs and chatty apps… | ||
| Azure Cost Management | Denis McDowell, Dustin Dorsey | 53m |
Shows how to map Azure resource hierarchy into scopes and use cost analysis, budgets and action groups + automation runbooks to trigger steps (shut down VMs… | ||
| Getting Started with Learning Azure | John Morehouse, Joey D'Antoni, Monica Rathbun | 43m |
Starts with a practical path: spin up a small Azure VM or use managed instance as a near‑on‑prem bridge, or pick a single‑database Azure SQL DB for new… | ||
| Designing performant and scalable data lakes | Rukmani Gopalan | 55m |
Shows how an enterprise data lake on Azure uses Azure Data Lake Storage plus Azure Databricks/HDInsight and Azure Synapse to ingest raw data, apply schema on… | ||
| Optimizing your Azure SQL Database workloads | Sanjay Mishra, Dimitri Furman, Denzil Ribeiro | 53m |
Live demos show a memory‑optimized table with 3 million inserts/sec into a schema‑only durable staging table that later moves to a clustered columnstore for… | ||
| Troubleshooting Power BI Report Performance | Benni de Jagere | 51m |
Demonstrates using the Performance Analyzer to record interactions, exporting its logs, and pairing that with DAX Studio server timings to spot FE/SE splits… | ||
| SQL Notebooks in Azure Data Studio for the DBA | Rob Sewell | 46m |
Demonstrates using SQL Notebooks in Azure Data Studio to make on-call work reproducible by storing query results inline as JSON so a midnight investigation can… | ||
| Value-Driven Analytics Development | Simon Whiteley | 24m |
Argues that prioritizing business value shortens time to insight by prototyping on a lake before heavy modeling, showing examples: land raw clickstream in lake… | ||
| 500-Level Guide to Career Internals: Building a Brand | Brent Ozar | 45m |
Advocates picking three brand words that show exactly what problems get solved, using your real name plus those words across social profiles, and betting time… | ||
| Rebooting your SME Data Analysis Strategy | Mark Hayes | 45m |
Combines SQL ERP rows, weekly retail Excel files and budget spreadsheets into a single model using Power Query and Power BI, adds a master product mapping, and… | ||
| Migrating my favorite past project from On Premise to Azure | Mark Hayes | 18m |
Migrates an IaaS pipeline (VM web service + file drops + SSIS + SQL Server + SSRS) to a PaaS flow using Azure Event Hub -> Stream Analytics -> Azure SQL… | ||
| Faster SSIS | Andy Leonard | 59m |
Shows concrete SSIS fixes: moving blob temp storage path off C speeds a demo load from ~2,300 to ~2,800 rows/sec and omitting XML/blob columns jumps it to… | ||
| Machine Learning in Azure Databricks | Terry McCann | 48m |
Shows end to end use of Spark ML on Azure Databricks to build a regression pipeline: read and cache a CSV from ADLS, use VectorAssembler/VectorIndexer, train a… | ||
| When and how to migrate to Azure Synapse? | Kamil Nowinski | 50m |
Migrating an on‑prem data warehouse to Azure Synapse means rethinking architecture: Synapse uses 60 distributions and MPP compute, so table design… | ||
| To Azure SQL Database from SQL Server 2008 | Henrik Staun Poulsen | 16m |
Migrates SQL Server 2008 workloads into Azure SQL Database by listing concrete fixes: replaces GETDATE() with a long local-time expression to avoid UTC… | ||
| Ethics and Bias in data science | Robin Lester | 55m |
Claims that biased data breaks projects: Gartner predicts about 85% of AI projects underperform because of biased data, and automated voice cloning enables… | ||
| Azure DW and Power BI, reporting at the speed of light! | Rita Dias, Stijn Wynants | 45m |
Hands-on demo shows Azure Synapse SQL pools (up to 60 nodes) serving 120M-row tables and the real gains: mismatched distributions cause shuffles that turn a… | ||
| Advanced Plan Explorer Usage for Tuning Execution Plans | Andy Yun | 51m |
Plan Explorer (SentryOne) demos show concrete techniques: add parallelism operations and plan tree columns to spot 4‑thread distribution and unbalanced… | ||
| Simplify your ETL with Databricks Delta Lake | Piotr Mucha | 45m |
Explains how Databricks Delta Lake adds an ACID transaction log (JSON commits, min/max stats) so datasets gain time travel, schema enforcement/evolution and… | ||
| Stop waiting to explore your data: use Azure Data Explorer! | Jason Bonello | 57m |
Azure Data Explorer handles streaming raw data for quick analysis: demoed a taxi trips dataset of 1.5 billion rows and runs a monthly aggregation in 25.05… | ||
| Getting To Know SQL Server Encryption Capabilities | Mladen Prajdic | 48m |
TDE encrypts data at rest and does not protect data in transit, so use SSL/TLS (SQL Server supports TLS 1.2) for channel encryption. Symmetric keys are fast… | ||
| nothing matches | ||