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.
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 Q3 and Q4 2021: Call for Speakers/Papers @ Sessionize.com
Call for Speakers is open until July 25.
| Date: | 2021-06-25 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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
| Date: | 2021-06-18 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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.
| Date: | 2021-06-11 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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/
| Date: | 2021-05-28 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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
| Date: | 2021-06-04 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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
| Date: | 2021-05-21 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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.
| Date: | 2021-05-14 |
| Time: | 12:00 Central European Time (10:00AM UTC) |
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.
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/