november, 2021

thu18nov5:00 PM6:30 PMVirtual EventI will speak at Data TGIFApproximate count distinct in Microsoft SQL Server

data-tgif

Abstract

Microsoft has introduced the new feature APPROX_COUNT_DISTINCT in Microsoft SQL Server 2019 to speed up approximate count of unique values in a large dataset and save query resources. In this session, we will evaluate the performance improvements of this feature using different scenarios.

Time

(Thursday) 5:00 PM - 6:30 PM CET

Organizer

Data TGIFEvery 3rd Friday of a month at 17:00 CEST, this group organizes free Azure, SQL Server or Power BI data virtual Meet-Up to celebrate the start of the weekend by meeting people to a Microsoft Data Platform talk. It is for beginner to experts of Microsofts Data Platform. Enjoy a speakers talk and a networking event thereafter. From Wikipedia: TGIF = "Thank God It's Friday is a common expression in English speaking Western countries [and is not connotated to any religion, added comment by Data TGIFs lead organizer]. It expresses gratification that the working week is nearly over, and a weekend of leisure will soon be here." Our goal is to spread knowledge in Microsoft Data Platform and to give opportunities for national and international networking for the Swiss community. Focus is primarily on online meetings so that everyone can participate from their own place but we may organize in-person meetings as soon as possible as well. Meetings are held in English so that we may cover all Swiss language regions. The format is that the speaker generally has 30 mins for their presentation and there will be 30-45 mins for networking afterwards. That means, you may - if you want - engage your webcam and microphone to speak with others.

Virtual Event Details

Event has already taken place!

Speaker for this event

  • Torsten Strauß

    Torsten Strauß

    MVP | MCSE | MCT

    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 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.

    URL https://inside-sqlserver.com/

    MVP | MCSE | MCT