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/.

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
1182023-06-16Various speakersLightning Talk Friday
Season finale

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