PASS Austria SQL Server Community Meeting - FEBRUAR

The Data Community Austria is an independent, non-profit organization (NPO) dedicated to supporting, educating, and promoting the global Microsoft SQL Server and Azure community. The organization is run by and for the community, made up of database administrators and developers, application developers, Business Intelligence and IT professionals, executives, consultants, educators, instructors, students, vendors, and many others who work with or use Microsoft Azure, SQL Server and Business Intelligence technologies.

Data Community Austria

Index tuning for the developer
In this session, we will be showing you how to get the best performance out of your application by using a good indexing strategy. We will be looking at the differences between clustered/non-clustered indexes, and touch on the different kinds of indexes like Columnstore and options you have (filtered, fill factor,…). Next to this, we will show you some common best practices to make sure you are able to use your index, and how to reduce the overhead of your indexes. After this session you will be able to evaluate your current indexing strategies and have a view on what your options are to improve your performance. 
presented by Stijn Wynants, Premier Field Engineer @ Microsoft
 
Build your own partitioning using partitioned views
Partitioning can be quite a life changing experience – in a good but also a bad way. It has incredible advantages but is also quite limiting (and can cause headage...). During the presentation, I will use examples both in theory and demo to showcase the possibilities and limitations of partitioning while simultaneously using partitioned views to solve identical problems and more! What if you would like to have your hot data in-memory and your cold data in a clustered columnstore index? Even if both partitioning and partitioned views are not your hot topics, I also cover topics like CHECK constraints, updateable views, and a lot more… presented by Fabian Schenker, Senior Premier Field Engineer @ Microsoft

PASS Austria SQL Server Community Meeting - FEBRUAR

Weitere Events von Data Community Austria

Entdecke weitere Events von Data Community Austria, von Wissenschaft und Technik bis hin zu anderen Erlebnissen, die dir gefallen könnten.

Noch auf der Suche nach dem richtigen Event?

Entdecke alle Events in Wien und filtere nach Datum, Kategorie und mehr, um das perfekte Event zu finden.

PASS Austria SQL Server Community Meeting - FEBRUAR

Weitere Events von Data Community Austria

Entdecke weitere Events von Data Community Austria, von Wissenschaft und Technik bis hin zu anderen Erlebnissen, die dir gefallen könnten.

Das könnte dir auch gefallen...

Stöbere durch weitere Events mit verschiedenen Daten, Preisen und Formaten, um dein nächstes tolles Erlebnis zu finden.

Noch auf der Suche nach dem richtigen Event?

Entdecke alle Events in Wien und filtere nach Datum, Kategorie und mehr, um das perfekte Event zu finden.