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/

SQL FRIDAY #47 – Thimantha Vidanagamage on ‘Power BI Utilize Large Scale Semantic Models in Service’

Date:2021-05-07
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 #47 – Thimantha Vidanagamage on ‘Power BI Utilize Large Scale Semantic Models in Service’

Are you an owner of a large scale Power BI Semantic Model that cannot be utilized in Power BI service? Its time to cut down the model size. Various techniques and best practices can be followed to cut down the size of a semantic model. In this session, I will walk you through the key techniques and best practices that you can follow to get this done. By the end of the session, you will be able to understand the approach in utilizing your large scale Power BI semantic models.

About Thimantha Vidanagamage

Thimantha Vidanagamage is a Microsoft Certified Data Analyst Associate with 2+ years of experience in Microsoft Business Intelligence. He is passionate about technologies such as Microsoft Power BI, Azure Analysis Services, Azure Data Factory and Azure Data Lake Gen2. Currently, he is an Associate Microsoft Business Intelligence Consultant for Fortude (Pvt) Ltd. which is the only Microsoft Gold Partner for Data Analytics and Data Platform in Sri Lanka.

Thimantha blogs at www.thimantha.wordpress.com.

https://twitter.com/ThimanthaV
https://www.linkedin.com/in/thimanthav

SQL FRIDAY #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’

Date:2021-04-30
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 #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’

T-SQL, the SQL dialect of SQL Server is one of the most important tools for working with data in tables throughout the data platform. However, since SQL has also found its way into other products such as Stream Analytics, we believe that a sound knowledge of SQL is a good basis for your work in the data platform. And while manipulating strings feels so 80ies, today many Web APIs consume or produce string-formats that need to be processed to be stored or delivered in the correct format. We introduce several functions that are available in T-SQL to master this task.

The T-SQL Ninja (www.tsql-ninja.com) is a project aimed at making T-SQL and the Microsoft Data Platform accessible for beginners and MVP Frank Geisler and Benjamin Kettner will present T-SQL language features at an entry level.

About Benjamin Kettner

Dr. Benjamin Kettner ist Mitgründer und CTO der ML!PA Consulting GmbH. Er promovierte im Jahr 2012 an der Freien Universität Berlin in angewandter Mathematik. Zur Zeit seiner Promotion war er Mitglied des DFG Forschungszentrums Matheon – Mathematik für Schlüsseltechnologien und Mitglied der Arbeitsgruppe Computational Nano Optics am Zuse Institut Berlin.

Während der Promotion und des Studiums beschäftigte er sich mit Software-Entwicklung und Programmierung sowie Datenbanken und Datenmodellen. Nach der Promotion arbeitete er als Berater bei einem Microsoft BI Partner, wo er technischer Projektleiter war und außerdem den Bereich Forschung und Entwicklung leitete und als Software-Architekt tätig war. Im Jahr 2015 gründete er die ML!PA Consulting GmbH, einen Microsoft-Partner mit Schwerpunkten im Bereich Advanced Analytics, Internet der Dinge und Cloud-Lösungen. Dort ist er als CTO und Software-Architekt tätig und konzipiert, entwickelt und gestaltet Kundenlösungen. Die ML!PA Consulting GmbH wurde im Jahr 2017 als einer von nur vier Partner des Jahres Finalisten der Firma Microsoft im Beriech Internet der Dinge ausgezeichnet. Dr. Benjamin Kettner ist in der Microsoft Data Plattform Community aktiv, leitet dort die Regionalgruppe Berlin des PASS Deutschland e.V. und tritt häufig als Autor von Blogbeiträgen und wissenschaftlichen Artikel und Sprecher auf technischen Veranstaltungen auf.

https://twitter.com/DataMonsterBen
https://www.linkedin.com/in/benjamin-kettner-0b5556128
https://www.tsql-ninja.com

SQL FRIDAY #45 – Lou Segers on ‘Turn Your Slow Steam Locomotive into a Streamlined Highspeed Train’

Date:2021-04-23
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 #45 – Lou Segers on ‘🚂 Turn your slow steam locomotive into a streamlined high-speed train 🚄’

>> 10 Performance tips to speed up your Power BI reports <<

Arriving at work and the first thing you do is opening your Power BI report and going for a coffee while waiting for the report to render. Seems familiar?
Well, it shouldn’t. Your reports should render instantly, especially if there is a large or C-level audience consulting them on a regular basis.
Luckily enough there are some tips and tricks to melt your frustrations like snow in the sun.

About Lou Segers

Lou Segers is a Data Analytics consultant at Belgium’s Lytix with a strong emphasis on the Microsoft BI stack.
He loves to interact with anyone breathing data.

Some say good health is true wealth. A sweaty run or a satisfying gym session are among Lou’s favorite energy drainers.

Come have a chat with me or simply connect via LinkedIn!

All aboard the data train, CHOO CHOO 🚂 🚂

https://www.linkedin.com/in/lou-segers-451baa80
https://www.thedatatrain.be

SQL FRIDAY #44 – Damir Matešić on ‘Historical Data with MS SQL System Versioned (temporal) Tables’

Date:2021-04-16
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 #44 – Damir Matešić on ‘Historical Data with MS SQL System Versioned (temporal) Tables’

Before the existence of system-versioned temporal tables, tracking changes in a database table forced us to implement some custom solutions based on triggers, stored procedures etc.

System-versioned temporal tables offer us the possibility to keep a full history of data changes and allowing us easy point in time analysis. Using this solution, we can easily time travel through the data and see what the exact state of the data in a point of time was.

In this session we will see what system-versioned temporal tables are, how we can create and use them and what are the limitations and benefits of such implementation.

Damir Matesic

About Damir Matešić 

For many years Damir is a passionate programmer and a Microsoft SQL Server developer (ver. 2000+).
He is a certificated Microsoft professional on various technologies. In 2020 Microsoft awarded him with Data Platform MVP.

Damir leads the Croatian SQL Server User Group (PASS) and he introduced and organizes SQL Saturday events in Croatia.

He is working as Senior Database Developer @Span.eu.
Damir speaks on various community events and conferences like SQLSaturday, Advanced technology days and user groups.
When free he blogs about SQL @ https://blog.matesic.info.

https://twitter.com/matesic_damir
https://www.linkedin.com/in/dmatesic