Schedule

Online Microsoft Data Platform Lunch Sessions

You register to upcoming events on our Meetup page: https://www.meetup.com/SQL-Friday/.

SQL Friday Season 7

Session selection for SQL Friday season 7 is done and we are now awaiting confirmation from the selected speakers. Check out this page to see when the schedule goes live.

SQL Friday Season 6

#SESSIONDateSpekaer(s)Session title
992023-01-27Alexander ArvidssonNot My Problem(?) Azure Networking 101 for Azure SQL Server DBAs
1002023-02-03Heini IlmarinenLess Clicking, More Coding! Azure Data Platform Development Using Infrastructure as Code
1012023-02-10Olivier Van SteenlandtImproving Team Collaboration Using Database Projects and Azure DevOps
1022023-02-17Heidi HastingSensitivity labels – what do they look like?
1032023-02-24Armando LacerdaHybrid Disaster Recovery with SQL Server 2022
1042023-03-03Daniel HutmacherGetting your ducks in a row: Understanding ordered data flows
1052023-03-10Roni VeredImplementing SQL Server workloads on AWS cloud
1062023-03-17Edward PollackAll About SQL Injection
1072023-03-24Andy CutlerUp and Running: How to make your Synapse Analytics POC a success
1082023-03-31John MinerAudit and Prevent unwanted SQL Server tables changes
1092023-04-07Matt GordonReal Talk about Real Cloud Migration
1102023-04-14Erland SommarskogPackaging Permissions in Stored Procedures
1112023-04-21Erin DempsterData Protection Hors d’Oeuvres
1122023-04-28Dejan SarkaData Overview and Manipulation – T-SQL, R, Python
1132023-05-12Eitan BluminTroubleshooting Common SSDT Errors
1142023-05-19Andreas BergstedtData Access for Arc Enabled SQL 2022 with Purview Policies
1152023-05-26Deepthi GoguriPerformance and Tuning in Azure
1162023-06-02Taiob AliThe magnificent seven and beyond – Intelligent Query Processing in SQL Server
1172023-06-09Andrea Martorana TusaT-SQL Window Functions in SQL Server 2022

Sql Friday Season 5

#SESSIONDateSpekaer(s)Session title
912022-10-14Thomas Grohser42 T-SQL Functions
922022-10-21Ed PollackMy Favourite New T-SQL in SQL Server 2022
932022-10-28Mala MahadevanFinding and Fixing T-SQL Anti-Patterns with ScriptDOM (CHANGED START TIME!!!)
942022-11-04Milos RadivojevicParameter Sniffing in SQL Server 2022
952022-11-11Eitan BluminContained Availability Groups in SQL Server 2022
962022-11-25Erland SommarskogDon’t bite off more than you can chew – take it in chunks
972022-12-02Deborah MelkinDatabase Deployment Methods Demystified
982022-12-09Deepthi GoguriAzure SQL Security Concepts

SQL Friday Season 4

#SESSIONDateSpekaer(s)Session title
722022-02-11Mikey BronowskiArm your Bicep with D(i)SC – how to make your life easier while building new environments
732022-02-18Hugo KornelisHere’s the execution plan … now what?
742022-02-25Benjamin KettnerWorking with timeseries data in Azure
752022-03-04Gonzalo BissioAzure SQL Managed Instance HA/DR Options to Ensure Business Continuity
762022-03-11Eitan BluminSSDT Tools and Features for SQL Server DevOps
772022-03-18Jean JosephCleaning and Transforming Data with SQL
782022-03-25Jose Manuel Jurado Diaz, Roberto CavalcantiAzure SQL Journey: The Daily Routine of a Cloud DBA
792022-04-01Erland SommarskogDon’t Use Cursors or Why You Maybe Should Use a Cursor After All
802022-04-08Matt GordonI Broke It So You Don’t Have To – HA/DR Fails and Fun
812022-04-15Milos RadivojevicTransact-SQL Performance Tips
822022-04-22Reitse EskensMonitoring Azure SQL Database with Zabbix
832022-04-29Deepthi GoguriIntroduction to SQL Notebooks
842022-05-06Damir MatesicMS SQL New Functions, Syntaxes, Tips & Tricks
852022-05-13Torsten StraussResolve Locking and Blocking in Microsoft SQL Server
862022-05-20Guy GlantserHow to Use Parameters Like a Pro and Boost Performance
872022-05-27Zoran Barac, Erland Sommarskog, Edward Pollack, Taiob Ali, Reitse EskensLightning talks
882022-06-03Taiob AliWhat the Heck is a Checkpoint and Why Should I Care?
892022-06-10Andrea Mortorana TusaAPPLY operator in action
902022-06-17Edward PollackImproving Analytics Performance With Columnstore Indexes

SQL Friday Season 3

#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