Infrastructure as code three way shootout & Parallelism in Microsoft SQL Server

19.08.2021 - 19:00 - 22:00 Uhr

Ceteris AG
Linienstraße 214
Deutschland URL
Anmeldung über diesen Link


Termin: Outlook: iCal

Microsoft Data & AI Meetup Berlin

We are happy to announce our next meetup. On August 19th, Torsten Strauss will visit us to talk about Paralellism in SQL Server and we will have a three way shootout for infrastructure as code.

What makes us even happier is that we will get the chance to see Ceteris‘ new location as we are able to meet in person in their meeting space.

The presentations will be given in english language!

*** Torsten Strauss: Parallelism in Microsoft SQL Server ***
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 with BP as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. Torsten is the founder of 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.

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.

*** The great 3-way shootout for infrastructure as code ***
Creating your Azure infrastructure as code is often a requirement. Not only does it enable you to re-create infrastructure in different environments, it also makes your changes deployable and trackable. There are, however multiple tools available to create your infrastructure. Which is the best? We will have three experts available that will show the code for different solutions and discuss their pros and cons.