SQLSaturday #668 - Tallinn 2017
Event Date: 11/18/2017 00:00:00
Event Location:
- Microsoft
- Rävala pst. 5, Tallinn
- Tallinn, Harjumaa, Estonia
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server 2017 New Features (Not Linux support!)
Abstract: This session covers the new features in SQL Server 2017 - apart from Linux support
-
Using Query Store for automatic tuning of querys which have bad plans (multiple plans with regressions)
-
Additional information stored in actual execution plans
-
New DMVs e.g. log information, statistics histograms
-
Interleaved Execution for multi-statement T-SQL TVFs
-
Adapative joins for queries
-
Resumable online index rebuild
-
Faster non-cluster index builds on memory optimized tables.
-
Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES
-
Parallel Redo for memory optimized tables, increases throughput for Always On Availability Groups
-
DTC support for Always On Availability Groups
-
Cluster-less Availability Groups
-
Minimum Replica Commit Availability Groups
-
New CLR strict security
-
Graph database queries
-
Running Python scripts in SQL Server
-
BULK INSERT directly fro
Speaker(s):
- David Williams
Track and Room: ITPRO - Excel
Title: A Game of Hierarchies: Introduction to Graph Processing with SQL
Abstract: Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
- Product Categories
- Sales Territories
- Bill of Material
- Calendar and Time 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 comes now with a different approach: Graph Database. Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Developers - Word
Title: Biml for Beginners: Speed Up Your SSIS Development
Abstract: Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: Developers - Word
Title: Don’t cross the streams, a closer look at Azure Stream Analytics
Abstract: Azure is ready to recieve all your event- and devicedata for storage and analysis. But which options in the Azure IoT portfolio should you use to recieve and manage your data?
In this session I will explain the different options in the Azure IoT portfolio, take a closer look at how they work and what this means for you. Furthermore, I will take a closer look at the Azure Stream Analytics (ASA) language. You will learn how to develop both simple and complex ASA queries, and how to debug. We will look at the possibilities, limitations and pitfalls in the Azure Stream Analytics language. And finally look at the different input and output choices and when to use which one. This includes a look at how to build a live stream dashboard with Stream Analytics data in PowerBI.
The session is based on real world project experiences and will use real world data in the demos.
Speaker(s):
- Johan Ludvig Brattås
Track and Room: Developers - Excel
Title: Deadlocks. Everything you ever wanted to ask but were too shy.
Abstract: It’s not a secret that a deadlock - it’s not very good. Definition of deadlock is very simple and quite clear: This is an exceptional situation when two concurrent queries request same resources but in a different order.
Classic deadlock can occur when two concurrent transactions are modifying data from the two tables in a different order. Unfortunately, in real life deadlocks often are more complex and unobvious. One of the rules, which I always keep in mind, sounds: “You can not design a database, in which the occurrence of deadlock is impossible”. And we should deal with them. The algorithm is simple:
- Catch the deadlock
- Find the root cause
- Design and implement a solution. In practice, these steps can be tricky and may require different types of analysis.
In this session, we will look at ten various deadlocks scenarios and find the root cause of the deadlocks. Then, you will see how it will be easy to get the solutions for the deadlock issue if we did the second step.
Speaker(s):
- Denis Reznik
Track and Room: Developers - Word
Title: Hidden gems of SQL Server 2016
Abstract: SQL Server 2016 is full of new features and improvements. Some of them are “Killer” features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight.
In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Speaker(s):
- Denis Reznik
Track and Room: ITPRO - Word
Title: SQL Graph Database
Abstract: Graph database object in SQL server, Graph Querys.
How to play with graphs and how the actually implemented internally
Speaker(s):
- Henn Sarv
Track and Room: Developers - Word
Title: Create Stunning Visualizations with The Help of R
Abstract: R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand, and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Developers - Excel
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Markus Ehrenmueller-Jensen
Twitter: - MEhrenmueller
LinkedIn: Markus Ehrenmueller-Jensen
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
Markus Ehrenmueller-Jensen
Twitter: - MEhrenmueller
LinkedIn: Markus Ehrenmueller-Jensen
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Denis Reznik
Twitter: - https://twitter.com/DenisReznik
LinkedIn: Denis Reznik
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
Denis Reznik
Twitter: - https://twitter.com/DenisReznik
LinkedIn: Denis Reznik
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
Johan Ludvig Brattås
Twitter: - intoleranse
LinkedIn: Johan Ludvig Brattås
Contact: http://brattas.org/sqlmusings
Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.
Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.
Henn Sarv
.
David Williams
Twitter: - @smooth1x1
LinkedIn: David Williams
Contact: http://justdave.info
David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQLSaturdays as well as local usergroups and is a regular volunteer at events including SQLBits.
Sponsors
The following is a list of sponsors that helped fund the event: