Event Date: 09-12-2017 - Session time: 09:00:00 - Track: DEV
From the 25th May 2018 organisations who fail to implement appropriate technical and organisational measures that ensure and demonstrate that they are compliant will be liable for a fine of €20M or 4% of annual global turnover – whichever is GREATER. Also, prison.
As a professional who works with data it is wise to ensure that you understand GDPR.
DISCLAIMER: I am not a lawyer.
Let me repeat: I AM NOT A LAWYER.
I am not qualified to give legal advice. However, I do know a thing or two about delivering software. In this talk I will bring your attention to the main aspects of GDPR and discuss some of the consequences this has on the use of production data and database lifecycle management (DLM).
I will focus on technical problems that we need to address. You can (and should) hire your own lawyers to provide legal advice.
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: BI/DEV
We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field! After this session things like segment elimination, auto adjust buffer size, Delta Store,... will no longer be a mysterious concept for you you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: DEV/DBA
In this session, we’ll look at: Why these features still need data modelsHow to prepare data models, logical and physical, for these target featuresHow these features change the data model/database design processHow tools support these new features (or don’t)How to approach tuning for these non-relational featuresFinally, we end with 10 tips for working with non-relational features while still maintaining data model-driven database design.
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: DBA
This session would be great for accidental as well as experienced DBA's to learn or get more ideas about SQL Server installations. The following topics will be covered:
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: BI
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: DEV
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: BI/DEV
These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: DBA
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: DEV/DBA
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!
Event Date: 09-12-2017 - Session time: 10:15:00 - Track: BI
In this session, Prathy will talk about what options are available for On-Premises report publishing. What is Power BI Report Server how is it different from existing SQL Server Reporting Services(SSRS), how licensing works, what are the benefits of Power BI report server and how quickly we can create and deploy Power BI reports to SQL Server Reporting Services Portal / Power BI Report Server portal
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: DEV
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: BI/DEV
After the definition of scalability-types, the SSIS scale-out architecture and the involved system-parts are introduced. The attendees will learn the basics, get checklists and best practices when building up their own SSIS scale-out cluster. In addition to the configuration using SSMS other configuration options (command line, T-SQL,..) are presented. Behind the scenes information like logging, the programmability interfaces and configuration options will be shared.
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: DEV/DBA
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: DBA
Event Date: 09-12-2017 - Session time: 11:30:00 - Track: BI
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: BI
We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#. Evaluation metrics for regression models will conclude first part of the session. In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: DEV/DBA
Let's back to the basis then in order to better understand transaction isolation levels available in SQL Server. On this session we will learn about a concurrency issue, (not)expected behaviours, lost modifications and consider how to cope with them. I will tell what the optimistic and pessimistic concurrency models are, when use it and what tempdb has in common with them. Also, we will see in practice how dangerous (NOLOCK) might be which has being used so passionately by developers.
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: BI/DEV
In this session, I will show you some of what I have learned and discovered that has made me say "Oh wow! Why did I not know this yesterday!?" - including features in SQL Server Management Studio (SSMS) and SQL Operations Studio (SOS), keyboard shortcuts, free tools and scripts, Biml for SQL Server Integration Services (SSIS), and even a couple of things I used to think were only useful for those scary DBAs.
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: DEV
Event Date: 09-12-2017 - Session time: 13:30:00 - Track: DBA
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: BI/DEV
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: DEV/DBA
This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: DBA
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: BI
Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…
Event Date: 09-12-2017 - Session time: 14:45:00 - Track: DEV
Event Date: 09-12-2017 - Session time: 16:00:00 - Track: BI/DEV
Remember that algorithm that named paint colors? That's nothing compared to what you are going to witness in this session. From analyzing demonic possession based on selfies, to analyzing how "metal" a song is. In this session, presented by mad data scientists Tomaž Kaštrun and Enrico van de Laar, we will explore all the crazy things that are possible with data science. And who knows? You might even learn a thing or two!
Event Date: 09-12-2017 - Session time: 16:00:00 - Track: DBA
SQL PAL (SQL Platform Abstraction Layer)
SQLOSv2
The (very small) host extension which is platform specific
Installation with demo,yes that fast!
Backups and Restores cross platform
Clustering on Linux
AlwaysOn Availability Groups cross platform
SQL Agent for Log Shipping
Compiling/Deploying CLR code for both platforms with demo
How the Linux layer is compiled
Debugging a combined Windows PE and Linux ELF execution including getting a stack dump
New DMVs for Linux and DMVs which are replaced as they are not cross platform
Active Directory Integration with demo
Performance goals
Limitations with the current implementation
Event Date: 09-12-2017 - Session time: 16:00:00 - Track: DEV/DBA
In this session, you will learn about the data that the query store captures to identify queries that have regressed. You will learn about patterns for upgrades that allow you to upgrade with minimal impact to user performance. You will see demos of how to identify when a query has regressed in either plan or performance, and you will get some hints for the future of the Query Store with Adaptive Plans in SQL Server 2017.
Event Date: 09-12-2017 - Session time: 16:00:00 - Track: DEV
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Event Date: 09-12-2017 - Session time: 16:00:00 - Track: BI
In this demo-packed talk, you’ll see how you can go from a model built in R to making predictions on the fly in SQL Server 2016.