What we're about

SQL Friday is a weekly online lunch seminar about Microsoft Data Platform. It’s hosted by Magnus Ahlkvist (B (https://www.tsql.nu/) | T (https://twitter.com/transmokopter)) and financed by Transmokopter SQL AB.

Homepage of SQL Friday is https://sqlfriday.net

Every friday, at noon CEST, 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 on the homepage, the posts about upcoming speakers and their session will be updated with an embedded Youtube video.

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 post about upcoming sessions. We aim at announcing speakers weeks in advance, but will always keep the upcoming Friday session on top.

Sessions will be streamed with Microsoft Teams, as long as we don’t hit the 250 attendees limit. Should we hit that limit, we’ll move over to a platform that allow more attendees. As nice as it is to be able to watch the sessions on Youtube, we want interaction. Sessions are way more fun and interesting when we can interrupt the speaker with questions in the chat, right? ”Hey, can you show that again, what the heck kind of operator was that?”

Do you want to speak at SQL Friday? Poke us on Twitter: @SqlFriday (https://twitter.com/SqlFriday) or email us at friday@sqlfriday.net.

Code of conduct

If you participate in a SQL Friday session, you must follow this simple code of conduct.

Be nice to people. This includes the speaker, the host/moderator and of course all the other attendees. Respect other people’s right to their own space. Don’t get in peoples face.

Understand that irony doesn’t work as well in writing as it might do in an in-person meeting, where your body language helps you.

Understand that you can not and may not be the judge of anyone else’s feelings. If you do something that offends someone, even when that is not the purpose, don’t argue. Just back down. You may or may not understand what was going on, but SQL Friday is not meant for you to test limits.

See, that wasn’t so hard, was it? If you feel anyone is not respecting this very simple Code of Conduct, contact the moderator during the session or write an email to friday@sqlfriday.net – we want to keep SQL Friday clean from abuse.

Upcoming events (3)

SQL FRIDAY #48 - Martin Guth on 'Relaxed Releases with DB-Workload-Tests'

Are you responsible for database changes such as index management or configuration changes?
Have you experienced how a seemingly harmless change like changing an index went south completely after the release on production? Or do you even prefer not to make any changes at all due to the uncertainty of the outcome?

Then this session is for you! Get to know the power of DB-Workload-Tests: recording and replaying the complete activity of a database. Sounds complicated? It doesn't have to be that way. After the session you have the tools to perform workload testing as well. This gives you the chance to get to know possible problems related to changes directly through the workload test and to fix them before a release to production.

Good knowledge of schema adjustments (changing tables, indexes etc.) and querying using TSQL is required. Further knowledge in the field of performance tuning or database administration (especially backup / restore) is an advantage.

About Martin Guth
Martin Guth (37) has been a passionate BI developer for more than 11 years. He has also been fascinated by database administration for 5 years. He works at 3C Deutschland GmbH (part of Experian Ltd.) in Heilbronn. Highlights from his work as a BI developer are building a data warehouse from scratch and delivering analytic products.
As a database administrator, performance tuning is particularly important to him. Martin shares his experiences (deliberately irregular) on his blog at martinguth.de.


Erland Sommarskog on 'Error and Transaction Handling in SQL Server'

Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don't. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling ""fancy"", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.

About Erland Sommarskog
Erland Sommarskog is an independent consultant based in Stockholm. He has worked with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and he has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.


Markus Ehrenmüller-Jensen on 'Leverage Your T-SQL Knowledge to Learn R'

SQL FRIDAY #50 - Markus Ehrenmüller-Jensen on 'From SQL to R – Leverage Your T-SQL Knowledge to Learn R'

You are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.

About Markus Ehrenmüller-Jensen
Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, data engineer and BI architect since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform and MCSE Business Intelligence. Markus speaks regularly on international conferences (eg. SQL PASS Summit, SQLBits London, Power Platform Worldtour, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria and in 2016 Power Platform Usergroup Austria and organizes SQL Saturdays in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.


Photos (63)

Find us also at