Schedule

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: https://www.meetup.com/SQL-Friday/. The direct link to the Meetup meeting will be in the schedule.

Upcoming sessions, autumn season 2021

#SESSIONDATESPEAKERSESSION TITLE with Meetup-link
#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
#682021-11-26
#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-08https://www.meetup.com/SQL-Friday/events/275338413/SQL FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’
2021-01-15https://www.meetup.com/SQL-Friday/events/275338429/SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’
2021-01-22https://www.meetup.com/SQL-Friday/events/275338749/SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’
2021-01-29https://www.meetup.com/SQL-Friday/events/275338804/SQL FRIDAY #33 – Geovanny Hernandez on ‘First steps to go ahead with MS SQL Server on Linux’
2021-02-05https://www.meetup.com/SQL-Friday/events/275338837/SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘GitHub DevOps Duet – SQL Friday Edition’
2021-02-12https://www.meetup.com/SQL-Friday/events/275338850/SQL FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: red pill or blue pill?’
2021-02-19https://www.meetup.com/SQL-Friday/events/275338869/SQL FRIDAY #36 – Manish Kumar on ‘Secure your data with Azure SQL DB’
2021-02-26https://www.meetup.com/SQL-Friday/events/275338880/SQL FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’
2021-03-05https://www.meetup.com/SQL-Friday/events/275338894/SQL FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’
2021-03-12https://www.meetup.com/SQL-Friday/events/275338920/SQL FRIDAY #39 – Cédric Charlier on ‘Azure databricks: brick by brick for the data engineer’
2021-03-19https://www.meetup.com/SQL-Friday/events/275338937/SQL FRIDAY #40 – Gonzalo Bissio on ‘Azure SQL DB Serverless, a new autonomous database?’
2021-03-26https://www.meetup.com/SQL-Friday/events/275339143/SQL 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-09https://www.meetup.com/SQL-Friday/events/277276842/SQL FRIDAY #43 – Ronen Ariely on ‘SQL Internals – Physical Table Structure under the hood, and implementation on real case scenarios’
2021-04-16https://www.meetup.com/SQL-Friday/events/277277421/SQL FRIDAY #44 – Damir Matešić on ‘Historical data with MS SQL System-Versioned (Temporal) Tables’
2021-04-23https://www.meetup.com/SQL-Friday/events/277277444/SQL FRIDAY #45 – Lou Segers on ‘🚂 Turn your slow steam locomotive into a streamlined high-speed train 🚄’
2021-04-30https://www.meetup.com/SQL-Friday/events/277277460/SQL FRIDAY #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’
2021-05-07https://www.meetup.com/SQL-Friday/events/277277489/SQL FRIDAY #47 – Thimantha Vidanagamage on ‘Power BI: Utilizing Large Scale Semantic Models in Service’
2021-05-14https://www.meetup.com/SQL-Friday/events/277277550/SQL FRIDAY #48 – Martin Guth on ‘Relaxed Releases with DB-Workload-Tests’
2021-05-21https://www.meetup.com/SQL-Friday/events/277277677/SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’
2021-05-28https://www.meetup.com/SQL-Friday/events/277277786/SQL 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