SQL Friday Season 4 recordings

Here you will find all the recordings from Sql Friday season 4 once the recordings are published. You can also subscribe to the Youtube channel https://youtube.com/c/transmokopter to get notifications when new videos are uploaded.

Sql Friday episode 72 with Mikey Bronowski. https://youtu.be/pWmQYhWeEqk. Recorded on 11 February 2022.
Sql Friday episode 73 with Hugo Kornelis. https://youtu.be/e-ueyK_so9w. Recorded on 18 February 2022.
SQL Friday 74 with Benjamin Kettner. https://youtu.be/N3iGTjbTfqA. Recorded on 25 February 2022.
Sql Friday 75 with Gonzalo Bissio. https://youtu.be/S70ymZBzWkU. Recorded on 4 March 2022.
Sql Friday 76 with Eitan Blumin. https://youtu.be/nTh1xAOfitA. Recorded on 11 March 2022.
Sql Friday 77 with Jean Joseph. https://youtu.be/TX1xYgPt7l4. Recorded on 18 March 2022.
Sql Friday 78 with Jose Manel Jurado. https://youtu.be/NH46vG_L5tA. Recorded on March 25 2022.
Sql Friday 79 with Erland Sommarskog. https://youtu.be/aMYzx3LUI5E. Recorded on April 1 2022.
Sql Friday 80 with Matt Gordon. https://youtu.be/k4ais07DCf0. Recorded on April 8 2022.
SQL Friday 81 with Milos Radivojevic. https://youtu.be/HP3PssS2l00. Recorded on April 15 2022.

SQL Friday Season 3 recordings

Here you find recordings from the full season 3 of SQL Friday.

https://youtube.com/c/transmokopter to get notifications when new videos are uploaded.

SQL Friday episode 55, Torsten Strauss on Batch Mode Adaptive Join in Microsoft SQL Server. https://youtu.be/AM6lalrZ2P0. Recorded on August 27 2021.
SQL Friday episode 56, Jeff Moden on “Black Arts” Index Maintenance – GUIDs vs Fragmentation. https://youtu.be/nc4CMo7VSPo. Recorded on September 3 2021.
Download accompanying material (zip-file)
SQL Friday episode 57, Alpa Buddhabhatti on Azure SQL Server for Everyone. https://youtu.be/MwesFEIHq6Q. Recorded on September 10 2021.
SQL Friday 58, Andrew Pruski on A Deep Dive into Docker. https://youtu.be/TF8WEOYFmng. Recorded on September 17 2021.
SQL Friday 59, Ameena Lalani on SQL Server Resource Governor. https://youtu.be/w8ANdkeZ64Q. Recorded on September 24 2021.
SQL Friday 60, Taiob Ali on Think Like the Cardinality Estimator. https://youtu.be/2er6BlVNs40. Recorded on October 1 2021.
SQL Friday 61. Kathi Kellenberger on T-SQL Window Functions. https://youtu.be/vHG67yKLXYk. Recorded on October 8 2021.
SQL Friday 62. Deepthi Goguri, Query Store in 60 Minutes. https://youtu.be/fJg9aXg1_54. Recorded on October 15 2021.
SQL Friday 63. Erland Sommarskog, Dynamic Search Conditions. https://youtu.be/4H9eE1-28yg. Recorded on October 22 2021.
Sql Friday 64, Guy Glantser, Extended Events to the Rescue. https://youtu.be/dh6WiFX9_zI. Recorded on October 29 2021
Sql Friday 65, Magnus Ahlkvist, Solve T-SQL Problems with Tally Tables. https://youtu.be/9xLyYJEdGQ8. Recorded on November 5 2021
SQL Friday 66, Javier Villegas, Performance Features in SQL Server and Azure SQL. https://youtu.be/agPBx_TZx84. Recorded on November 12 2021.
SQL Friday 67, Ananta Bulusu, Confront Challenges in Migrating Oracle to SQL Server Database. https://youtu.be/TddFsdtVdN0 Recorded on November 19, 2021.
SQL Friday 69, Kevin Feasel, Where We’re Going We Don’t Need Servers: Servless SQL Pools in Azure Synapse Analytics. https://youtu.be/y9hQKXUiJhA Recorded on December 3 2021.
SQL Friday 70, Uwe Ricken, Security Techniques for Cross Database Queries. https://youtu.be/CSCv1rnKcc8 Recorded on December 10 2021.
SQL Friday 71, Jared Poche, Every Millisecond Counts. https://youtu.be/71zEg8BlHYk. Recorded on December 17 2021.

SQL FRIDAY #54 – Manpreet Singh on Let’s Develop Power Apps & Power Automate on O365 from scratch

Date:2021-06-25
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #54 – Manpreet Singh on Let’s Develop Power Apps & Power Automate on O365 from scratch

In this session I will introduce Power Apps & Flows on Office 365. We will develop a complete functional app on Office 365 and learn how the collaboration of Power Apps, Flows & Office 365 will work on real time scenarios. We will take a look on the capabilities of Power Apps and Flow and demonstrate how to develop the same process on this collaborative platform which is currently being done by other 3rd part tools in today’s businesses.

About Manpreet Singh

I am SharePoint Consultant, currently working in Philadelphia.I am a MVP on Office Servers and Services and a MVP of c# corner forum. I have written numerous articles and blogs on tech sites with a read count of more than 3 million readers. I am ranked 10th among million of developers on the C#Corner forum. My expertise is on SharePoint Hybrid and on Microsoft Online Services and Office 365.

https://twitter.com/manpreethere
https://www.linkedin.com/in/manpreetspconsultant/
https://www.c-sharpcorner.com/members/manpreet-singh12

SQL FRIDAY #53 – Jean-Pierre Voogt on ‘Data Migration to Azure SQL DB using Polybase’

Date:2021-06-18
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #53 – Jean-Pierre Voogt on ‘Data Migration to Azure SQL DB using Polybase’

The recommended way to migrating or moving our on-premises data is to use Azure Data Factory, but what if you want more control or even have a very tight budget? Well I will show you how we move/migrate data from and to our on-premises SQL Servers using Polybase and Azure Storage.

About Jean-Pierre Voogt

Jean-Pierre is an SQL Developer and Data Analysis Team Lead from South Africa. He is MCSA (Microsoft Certified Solutions Associate) and owner of a bachelor’ degree in Software Engineering with good experience with Database design, Data warehousing and development. He has a great passion for SQL server and he enjoys solving complex business problems.

Jean-Pierre speaks at the Johannesburg SQL User Group, trying to give back to the SQL community as much as possible. He loves to tinker with SQL Server and see how he can approach a problem with a different angle.

https://twitter.com/JPVoogt
https://blog.voogie.com

SQL FRIDAY #52 – Torsten Strauß on ‘Parallelism in Microsoft SQL Server’

Date:2021-06-11
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #52 – Torsten Strauß on ‘Parallelism in Microsoft SQL Server’

SQL Server can execute queries in parallel which can sometimes improve the performance of your queries. However, parallelism has its own challenges; therefore, we will look at the concept of parallel executions to understand when it makes sense to run a query on more than one thread. We deal with topics such as CXPacket, threads, workers, execution context, branches, MAXDOP, Cost threshold for parallelism, NUMA nodes and the iterators that SQL Server can implement in the execution plan to enable parallelism.

About Torsten Strauß

Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments.
He has been a Database Engineer at BP for over two decades and has also been working for SARPEDON Quality Lab as a Principal Microsoft SQL Server Consultant for many years.
Torsten is the founder of inside-sqlserver.com and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.
Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

https://twitter.com/TorstenStrauss
https://www.linkedin.com/in/torsten-strauss
https://inside-sqlserver.com/

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

Date:2021-05-28
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

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.

http://twitter.com/MEhrenmueller
http://at.linkedin.com/pub/markus-ehrenmueller/40/382/5b9
http://SavoryData.wordpress.com

SQL FRIDAY #51 – Mark Hayes on ‘Migrating a Data Capture solution with Event Hubs and Stream Analytics’

Date:2021-06-04
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #51 – Mark Hayes on ‘Migrating a Data Capture solution with Event Hubs and Stream Analytics’

In this session, I review an old data capture solution that I had built using SSIS, SQL DB and Reporting Services to a streaming technology solution using Azure Event Hubs and Stream Analytics.

We will look into Event Hubs and Stream Analytics to see how you configure them and how you can use SQL Tumbling windows to capture data.

Session will be mostly demo based with some slides.

About Mark Hayes

Mark (Certified Business Intelligence Professional (CBIP), MPP – Data Science, MPP – Big Data) is a Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000. He has worked on hundreds of projects working with the MS SQL DB Engine, Analysis Services, SSIS, SSRS, PowerBI. Tabular, Flow and more. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group, Cork PowerBI User Group, the Cork SQL Saturday and Data Céilí 2020.

https://twitter.com/MarkDataGuy
https://www.linkedin.com/in/markhayes/
https://www.datasmart.ie/blog

SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’

Date:2021-05-21
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #49 – 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.

http://www.sommarskog.se

SQL FRIDAY #48 – Martin Guth on ‘Relaxed Releases with DB-Workload-Tests’

Date:2021-05-14
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

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.

https://twitter.com/sqlnewrow
https://www.linkedin.com/in/martin-guth-7714ab114/