Corona-pandemin fortsätter och därför fortsätter vi i SQLUG med online-möten en tid framöver. Den 19 maj gästas vi av Markus Ehrenmüller-Jensen och Koen Verbeeck.
Tid: 19 maj, 18:00 – 20:30
Plats: Online, länken finns i bekräftelsen när du anmält dig på Eventbrite. Vi kommer att använda Teams den här gången.
Markus Ehrenmüller-Jensen presenterar ”A Game of Hierarchies: Introduction to Graph Processing with SQL Server 2019”
Hierarchies and graphs are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Bill of Material
Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 came with a different approach: Graph Database, which are further improved in SQL 2019.
Join this session for a journey through best practices to transform your hierarchies and graphs into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous ”Game of Thrones”.
Koen Verbeeck presenterar ”SQL Server Integration Services Best Practices and Tuning Tips”
Did you ever inherited a slow running un-maintainable mess of an SSIS package? Or do you want to knock up your SSIS developing skills to the next level? In this session we will guide you through common SSIS best practices and performance pitfalls. We will make packages easier to read, maintain and more efficient. You will learn some practical tips to make your life – and that of your successor – easier. Topics covered in this session: * How to quickly layout your SSIS packages and how to add documentation
* A few hidden tricks of SSIS
* Best practices for SSIS development
* A couple of quick performance boosters Join us to learn how to be a top notch SSIS developer.