SQL Friday is a weekly online lunch seminar about Microsoft Data Platform. It’s hosted by Magnus Ahlkvist (B | T) and financed by Transmokopter SQL AB.

Every friday, at noon Central European Time, a new speaker will present on a new topic (or by all means by the same topic as a previous speaker, with a different angle).

All the sessions are recorded and published on Youtube. You will be able to watch the sessions right on here, just follow the Past Sessions link.

You register to upcoming events on our Meetup page: The direct link to the Meetup meeting will be in the schedule.

Upcoming sessions, autumn season 2021

#552021-08-27Torsten StraussBatch Mode Adaptive Join in Microsoft Sql Server
#562021-09-03Jeff Moden“Black Arts” Index Maintenance – GUIDs v.s. Fragmentation – They’re not the problem… WE ARE!
#572021-09-10Alpa BuddhabhattiAzure Sql Server for everyone
#582021-09-17Andrew PruskiA Deep Dive into Docker
#592021-09-24Ameena LalaniSQL Server Resource Governor
#602021-10-01Taiob AliThink like the Cardinality Estimator
#612021-10-08Kathi KellenbergerT-SQL Window Functions
#622021-10-15Deepthi GoguriQuery Store in 60 minutes!
#632021-10-22Erland SommarskogDynamic Search Conditions
#642021-10-29Guy GlantserExtended Events to the Rescue
#652021-11-05Sam NasrArtificial Intelligence Programming with T-SQL
#662021-11-12Javier VillegasPerformance Features in SQL Server and Azure SQL
#672021-11-19Ananta BulusuConfront Challenges in Migrating Oracle to Sql Server Database
#692021-12-03Kevin FeaselWhere We’re Going, We Don’t Need Servers: Serverless SQL Pools in Azure Synapse Analytics
#702021-12-10Uwe RickenSecurity Techniques for Cross Database Access
#712021-12-17Jared PocheEvery Millisecond Counts

Past sessions spring season 2021

SESSIONDATERegister to attendSpeaker and title
2021-01-08 FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’
2021-01-15 FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’
2021-01-22 FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’
2021-01-29 FRIDAY #33 – Geovanny Hernandez on ‘First steps to go ahead with MS SQL Server on Linux’
2021-02-05 FRIDAY #34 – Kevin Chant and Sander Stad on ‘GitHub DevOps Duet – SQL Friday Edition’
2021-02-12 FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: red pill or blue pill?’
2021-02-19 FRIDAY #36 – Manish Kumar on ‘Secure your data with Azure SQL DB’
2021-02-26 FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’
2021-03-05 FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’
2021-03-12 FRIDAY #39 – Cédric Charlier on ‘Azure databricks: brick by brick for the data engineer’
2021-03-19 FRIDAY #40 – Gonzalo Bissio on ‘Azure SQL DB Serverless, a new autonomous database?’
2021-03-26 FRIDAY #41 – Dennes Torres on ‘Data Virtualization and Data Lake using SQL Big Data Cluster’
2021-04-02CancelledSQL FRIDAY #42 – SANDEEP PAWAR on ‘Power Up Power BI with Jupyter Notebook – Use Cases’
2021-04-09 FRIDAY #43 – Ronen Ariely on ‘SQL Internals – Physical Table Structure under the hood, and implementation on real case scenarios’
2021-04-16 FRIDAY #44 – Damir Matešić on ‘Historical data with MS SQL System-Versioned (Temporal) Tables’
2021-04-23 FRIDAY #45 – Lou Segers on ‘🚂 Turn your slow steam locomotive into a streamlined high-speed train 🚄’
2021-04-30 FRIDAY #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’
2021-05-07 FRIDAY #47 – Thimantha Vidanagamage on ‘Power BI: Utilizing Large Scale Semantic Models in Service’
2021-05-14 FRIDAY #48 – Martin Guth on ‘Relaxed Releases with DB-Workload-Tests’
2021-05-21 FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’
2021-05-28 FRIDAY #50 – Markus Ehrenmüller-Jensen on ‘From SQL to R – Leverage Your T-SQL Knowledge to Learn R’
2021-06-04SQL FRIDAY #51 – Mark Hayes on ‘Migrating a Data Capture solution with Event Hubs and Stream Analytics’
2021-06-11SQL FRIDAY #52 – Torsten Strauß on ‘Parallelism in Microsoft SQL Server’
2021-06-18SQL FRIDAY #53 – Jean-Pierre Voogt on ‘Data Migration to Azure SQL DB using Polybase’
2021-06-25SQL FRIDAY #54 – Manpreet Singh on ‘Let’s Develop Power Apps & Power Automate/Flows on Office 365 from scratch’

Past sessions, 2020

#SessionDateSpeakerSession title
#12020-05-29Damir MatesicAdvanced Data Types – JSON
#22020-06-05Kevin Chant and Sander StadAzure Devops duet
#32020-06-12Mark HayesRebooting your Data Strategy with the Power Platform
#42020-06-19Gethyn EllisTop 5 skills a DBA will need in 2020
#52020-07-03Markus Ehrenmüller-JensenIntroduction to Numeric Calculations in DAX
#62020-07-10Mike ByrdA Self-Tuning Fill Factor Technique for SQL Server
#72020-07-17Ben WeissmanData Analysis using GitHub, Azure Data Studio and Big Data Clusters
#82020-07-24Josef RichbergBuilding a complete API in Azure
#92020-07-31Menaka BaskarpillaiModern Data Platform Azure Cosmo Db with .Net core
#102020-08-07Tomaž KaštrunApplied data analytics with Azure Databricks
#112020-08-14Torsten StraussPerformance Tuning with Optimistic Concurrency (Level 300)
#122020-08-21Alex YatesZero Downtime Database Deployments
#132020-08-28Guy GlantserThe Most Important Performance Factor in SQL Server
#142020-09-04Neil HamblyAzure Notebooks – Data Science Fundamentals
#152020-09-11Nikola IlicMagnificent 7 – Simple tricks to boost your Power BI Development
#162020-09-18Eitan BluminHow to HADR Your SQL Jobs
#172020-09-25Jeff ModenThe “Secret” to High Performance Code – High Performance Test Data
#182020-10-02Gail ShawOn Transactions and Atomic Operations
#192020-10-09Gianluca SartoriBenchmarking in the cloud
#202020-10-16Data Weekender Organising team#DataWeekender Schedule
#212020-10-23Mikey BronowskiMulti-Server Agent Jobs Administration with Happy Faces and Pigeons
#222020-10-30Javier VillegasNew Features in SQL Server 2019
#232020-11-06Gonzalo BissioAzure SQL Database Managed Instance, a Different SQL Server?
#242020-11-13Ferenc CsonkaPower BI Paginated Reports – MORE than just SSRS vNext
#252020-11-20Kathi KellenbergerModern T-SQL
#262020-11-27Will VelidaMachine Learning in C#? Introduction to ML.NET
#272020-12-04Matt GordonDialogue with Your Data: Interactive AI with Cognitive Services
#282020-12-11Jayakumar BalasubramaniamImplement Data Security in Azure SQL with Azure KeyVaults and Always Encrypted
#292020-12-18Uwe RickenSimplify Data Management with Partitioning