Session Submissions SQLGrillen 2018

  • "Self-Healing" Query Execution in SQL 2017

    In this session we’ll look at two of the big performance improvements introduced with SQL 2017: Adaptive Query Processing and Automatic Tuning. We will discuss the mechanics of each feature, highlight any implementation considerations, and, of course, have a look at the features in action. Scripts will be made available for your own experimentation.

    • Regular Session
    • DEV
    • 300
    • English
  • • EventSourcing: Time to rethink Data

    EventSourcing is around for quite some time now and over the years the interest in it has been growing. Often, though, the question comes up why to switch to EventSourcing. Although the benefits of an EventSourced-system are well known, it still is hard to change the way we used to work with data, especially because EventSourcing is so much different from relation-data-models. But these days with more and more applications being converted to use a Microservices-Pattern over a Monolithic-Pattern and more applications running in cloud environments, it’s time to look and EventSourcing again. EventSourcing works perfectly with a scaling system, which needs to be reliable and flexible. This session shows the benefits of an EventSourced-system and why it’s time to change the way to work with data.

    • Regular Session
    • OTHER
    • 200
    • English
  • 10 Alerts that you should have it running in your SQL Server

    Did you not get budget for that cool monitoring tool, but you still want to monitor your SQL Server? In this session I am going to show you 10 alerts that you should have setup in your SQL Server instance. Going from CPU, IO, Corruption and Backups. By the end of this session, your life as a DBA will be much easier with those alerts in place!

    • Regular Session
    • DBA
    • 100
    • English
  • 3 Lessons Learned in Successful Consulting

    I would like to share the 3 lessons I learned that helped me become a much better consultant. These lessons helped me go from being a regular "9 to 5 DBA" to diving into the world of consulting.

    • Regular Session
    • NEWCOMER
    • 100
    • English
  • 50 ways to show your data

    „Ein Bild sagt mehr als tausend Worte“ - wie wahr, auch und gerade bei der Datenanalyse. Visualisierung ist der schnelle, einfache Weg, das Gesamtbild in Deinen Daten zu erkennen, und gerade das R-Ökosystem hat in dieser Hinsicht einiges zu bieten. Es mögen nicht genau 50 sein, aber in dieser Session zeige ich viele ansprechende Visualisierungen, die das ggplot2-Package und seine Freunde ermöglichen. Wir starten jenseits der üblichen Balken-, Linien- und Streudiagramme. Stattdessen kommen Diagramme auf den Bildschirm, von denen Du schon immer wissen wolltest „Wie macht man das?“. Wir werden Wasserfalldiagramme, Violinen, Joyplots, Randhistogramme, Karten und mehr sehen… und Ihr bekommt den Code, um alles nachzubauen.

    • Regular Session
    • BI
    • 200
    • German
  • A real DBA don’t need a GUI-A Tour of SQL Server Management Studio

    A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive. This presentation will take look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there including some new features in SSMS 2017. At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.

    • Regular Session
    • DBA
    • 100
    • English
  • ADFv2 - Data Integration in Azure Just Got a lot Better

    Azure Data Factory version 2 (ADFv2) arrived in Sept17 with a bunch of new concepts and features to support our Azure data integration pipelines. In this session, we’ll update your ADFv1 knowledge and start to understand the true nature of scale out control flows. What’s the integration runtime? Can we easily lift and shift our beloved SSIS packages into the cloud? How do we embed expressions to achieve dynamic activity executions? Do we still need SSIS with the ADF platform as a service? The answers to all these questions and more in this demo packed session. An awareness of Azure Data Factory v1 is recommended before attending this session.

    • Regular Session
    • BI
    • 300
    • English
  • Administrating SSRS without boring web based clicks

    Do you manage one or many SQL Server Reporting Services instances? Do any of them have multiple folders, dozens of reports or hundreds of subscriptions? Historically, managing these subscriptions, reports and folders has been incredibly time-consuming. But, what if you could leverage open source PowerShell module from Microsoft to simplify these and other SSRS management tasks? The module counts with more than 40 commands and the community is the main responsible for it. We (community) have been contributing to it. Join this session and you'll see all of this action using real-world scenarios! We will see cases where we could improve the task 500 times when using the PowerShell module instead of the web-based GUI.

    • Regular Session
    • DBA
    • 200
    • English
  • Advanced analytics in the cloud: AzureML

    Everyone is talking about advanced analytics or data science these days and many companies are interested in taking their first steps in these new fields of data analytics. But how do you get started with new techniques like machine learning? What kind of new hardware or software do you need to buy to get started and how do you get your IT department to implement and support those choices? Before you decide on designing an advanced analytics solution on-premises, why not give it a go on a platform that only charges money for the time you are actually using it? Azure Machine learning is a cloud service that enables you to easily build, deploy and share analytics solutions with all the flexibility of the cloud. The perfect platform to start with advanced analytics without having to invest a lot of money! In this session we are going to take a close look at AzureML, from how you can build your first machine learning model, to connecting AzureML directly to your on-premises SQL Server databases. Don’t worry if you are not a data scientist. This session will be free of heavy statistics and math and will focus on helping you take those first steps in advanced analytics!

    • Regular Session
    • OTHER
    • 200
    • English
  • Agile BI from the cloud with Team Foundation Services

    gile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have? With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more. In my session you will get the directions to a quick start with Visual Studio Online. You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.

    • Regular Session
    • BI
    • 200
    • English
  • An R primer for SQL folks

    Du hast von dieser neuen Sprache "R" gehört, und ihrer wachsenden Popularität für Datenanalysen? Jetzt brauchst Du einen Überblick, was R in Sachen Analyse möglich macht? Diese Session ist für Dich: Es gibt eine kurze Einführung, wie R entstanden ist, und wie das R-Ökosystem heute aussieht. Dann geht es auch schon los: wir extrahieren Verkaufszahlen aus mehreren Mandanten einer Navision ERP Datenbank auf einem SQL Server. Unsere Daten werden in der RStudio-Umgebung gesäubert, aggregiert und ergänzt. Wir generieren verschiedene Diagramme, die uns erste Einblicke in unsere "Echt"-Daten erlauben. Mit dem Shiny-Framework stellen wir die Daten auf einer Deutschlandkarte dar, ändern hierbei interaktiv unsere Kriterien, und sehen so, wo die weissen Flecken wirklich sind.

    • Regular Session
    • BI
    • 100
    • German
  • Analysing your corporate online presence using Power BI

    In this session, we will look at how you can use Power BI to analyse your company’s online presence. We will look at how you can source data from Facebook, Twitter, LinkedIn and finally from web pages. We will discuss different ways to get the data and what the difficulties/hindrances are when working with API's in Power BI. We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence? This is a demo rich session where we will go through getting the data in and looking through how we can extend the model before visualizing the results. The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analysing their company's online presence.

    • Regular Session
    • BI
    • 200
    • English
  • Analysis Services DNA

    Have you ever wanted an overview of your cubes and their dimensions, attributes and measures? This session will show you how you can use Analysis Services DMVs to extract information about your cubes and collect it for later use. We will then see how you can report on top of it thus documenting your SSAS cubes. We will then hear about different scenarios where this data might be useful. By attending this session, you will learn how to extract, transform and load the data into a database using SSIS. You will learn how you can create reports that show you the relevant information for different scenarios and how my company is making use of these information for different purposes. Some of the use cases for this data can be aligning dimensions across cubes or creating a bus matrix for documentation purposes. At the end of the session the attendees leave with all the code needed to start on their own as well as the knowledge on how to extend and further the solution for their own company or clients.

    • Regular Session
    • BI
    • 200
    • English
  • Analyzing Execution Plans Like a Pro

    The most powerful tool when tuning a query is the execution plan. In most cases, by analyzing the execution plan of a query, you can learn all you need to know about how the query processor has chosen to execute the query, what is causing the execution to take so long, and what you can do in order to make it run faster. But there are common pitfalls that you should be aware of when analyzing an execution plan, such as the fact that the operator cost values are always estimated, or the true meaning of the cardinality numbers within some of the plan operators. These pitfalls can be very misleading, and they might lead you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort. You’ll become a performance tuning hero by getting the slow queries to run faster – faster…

    • Regular Session
    • DBA
    • 200
    • English
  • APPLY Yourself

    Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

    • Regular Session
    • DEV
    • 100
    • English
  • Auf auf in die Cloud, ihr Datenbanken

    Immer mehr Firmen möchten die Microsoft Public Cloud Azure nutzen, wissen aber nicht so recht wie man die Datenbanken dorthin bekommt. Neben dem virtuellen Server gibt es auch die Azure SQL Databases, welche in zahlreichen Solution völlig ausreichend sind und sich flexibel an die Bedürfnisse anpassen lassen. Dieser Vortrag zeigt die verschiedenen Möglichkeiten des Deployments ebenso der Migration und gibt Hinweise, worauf bei der Migration zu achten ist bzw welche Features eventuell (noch) fehlen.

    • Regular Session
    • DBA
    • 200
    • German
  • Automate your on-premises DWH and Tabular model in less than an hour

    As part of this session i will go through the steps necessary for you to automate your DWH build and release to ensures less time spend on deployment and releasing new features to your business even faster. In this session I will automate the following workloads related to build and release: * Database * SSIS * SSAS Tabular Finally i will briefly go through drift reports and test automation. During the session PowerPoint slides will held at a minimum and instead i will spend most time in automating thing in VSTS.

    • Regular Session
    • BI
    • 200
    • English
  • Automating Machine Learning in Azure

    Depending who you ask, machine learning will be seen as a data science process that a data scientist has under his control from data to delivery to the end user. This may really seem so in Azure ML where everyone can easily deploy web services. However, for some organizations this doesn’t suffice and they prefer a more mature and independent deployment pipeline. Through demo’s we’ll showcase how you can achieve this goal. Expect PowerShell, Azure ML Studio and some good old VSTS!

    • Regular Session
    • OTHER
    • 300
    • English
  • Azure Analysis Services vs. On-premises

    This session is intended to answer your questions, ensure your gain insights into and create an overview if you are • planning on migrating your SSAS Tabular models to a newer version of SQL • Moving your Analysis Services models into the cloud • Considering utilizing Azure Analysis Services As part of the session we will focus on comparison of the features and differences in • Azure Analysis Services • On-premises Analysis Services Tabular • Azure hosted machine with Analysis Services Tabular Furthermore, we will dive into, compare, and discuss • Functionality • Pricing in real case scenarios • Security • Strengths/weaknesses

    • Regular Session
    • BI
    • 300
    • English
  • Azure Cosmos DB - Planet-scale, globally distributed, multi-model? Ja nee, is klar...

    Azure Cosmos DB? Planet-scale, Globally distributed, Multi-model - Was zum Teufel? In dieser Session möchte ich dem genauer auf dem Grund gehen und die Architektur und die Einsatzmöglichkeiten der Cosmos DB näher beleuchten. Ist der neue Cloud-Service nur eine weitere No-SQL Datenbank, oder kann der Service tatsächlich was er verspricht.

    • Regular Session
    • OTHER
    • 200
    • German
  • Azure Data Factory - the second stage

    Couple months ago, along with the launch of SQL Server 2017, well-known Integration Services has appeared as a cloud service. Now we've got a bit better options for building cloud-based data warehouse and we've got wider data transformation arsenal. But are those well-known, on-premises functionalities transferable to Azure? During the session we will go through several scenarios of implementation and migration of data integration projects in the way to expose all major differentiations in cloud solution approach.

    • Regular Session
    • BI
    • 300
    • English
  • Azure Data Lake - The Services. The U-SQL. The CSharp.

    How do we implement Azure Data Lake? How does a lake fit into our data platform architecture? Is Data Lake going to run in isolation or be part of a larger pipeline? How do we use and work with USQL? Does size matter?! The answers to all these questions and more in this session as we immerse ourselves in the lake, that’s in a cloud. We'll take an end to end look at the components and understand why the compute and storage are separate services. For the developers, what tools should we be using and where should we deploy our USQL scripts. Also, what options are available for handling our C# code behind and supporting assemblies. We’ll cover everything you need to know to get started developing data solutions with Azure Data Lake. Finally, let’s extend the U-SQL capabilities with the Microsoft Cognitive Services!

    • Regular Session
    • BI
    • 200
    • English
  • Azure Data Lake – USQL Job Execution in Depth

    The love child of T-SQL and C# is here, it’s highly scalable with Azure Data Lake Analytics (ADL) and HDFS storage. This means the temptation to give our jobs huge amounts of compute with the usual Azure sliding bar is great. But do those USQL jobs really need it and is all that compute being utilised? In this session, we’ll understand the low-level cost of an ADL Analytics Unit and how that maps to a USQL job execution vertex. Query tuning in the cloud shouldn’t be ignored just because these big data services allow us to submit and forget about cost. We’ll also cover tips and tricks like predicate push down and using partition elimination in the ADL database objects.

    • Regular Session
    • BI
    • 400
    • English
  • Azure Data Warehouse: Why, What and How

    If your regular SQL Server becomes too slow for running your data warehouse queries, or uploading the new data takes too long, you might benefit from the Azure Data Warehouse. Via its “divide and conquer” approach it provides significant performance improvements, yet most client applications can connect to it as if it is a regular SQL Server. But to benefit from these performance improvements we need to implement our Azure Data Warehouse in the right way. In this session - through a lot of demos - you will learn how to setup your Azure Data Warehouse (ADW), review indexing in the context of ADW and see that monitoring is done slightly different from what you’re used to.

    • Regular Session
    • OTHER
    • 200
    • English
  • Biml for Beginners: Speed Up Your SSIS Development

    Are you tired of creating and updating the same SSIS packages over and over and over 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!

    • Regular Session
    • BI
    • 200
    • English
  • Biml for SSIS – the code is alive!

    You have heard about Biml? Maybe even seen a session about it before but still have doubts, how easy you can make something useful out of it? In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos! Everything is happening live! Starting with a blank staging database, we’re going to end up with a complete solution over the course of this session, to prove that it is not just easy to adapt existing Biml code but also to start from scratch and still be successful very quick! Let’s see, how that goes… 

    • Regular Session
    • BI
    • 200
    • English
  • Biml Tips and Tricks: Not just for SSIS packages!

    "Wait, what? Biml is not just for generating SSIS packages?" Absolutely not! Come and see how you can use Biml (Business Intelligence Markup Language) to save time and speed up other Data Warehouse development tasks. You can generate complex T-SQL statements with Biml instead of using dynamic SQL, create test data and populate static dimensions, and even compare tables and views across multiple servers and databases. Don't Repeat Yourself, start automating those boring, manual tasks today!

    • Regular Session
    • BI
    • 200
    • English
  • Biml: Your 3D Printer for SSIS

    In this demo-heavy session, you will learn about the basic concepts of increasing productivity by creating your SSIS packages using Biml. We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables. Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!

    • Regular Session
    • BI
    • 200
    • English
  • Boost your SSAS Tabular productivity

    Tabular Editor is an open source alternative that relies only on the Model.bim JSON metadata and the Tabular Object Model (TOM), thus providing an offline developer experience for Azure and on-premises tabular models. Making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a "what-you-see-is-what-you-get" model tree allowing you to maintain Display Folders, Perspectives and Translations. The perfect tool for your tabular models. Combined with scripting functionality, a Best Practice Analyzer, command-line build and deployment, and much more, Tabular Editor is a must for every SSAS Tabular developer. The tool is completely free. Demoing the capabilities of the tool is what is in focus for this session and therefore do not expect many slides. Attendees are assumed to be familiar with Tabular Model development.

    • Regular Session
    • BI
    • 300
    • English
  • Boring is stable, stable is good – best practices in practice

    Have you ever wondered why there are so many, sometimes contradictory, best practices for SQL Server on the internet? Have you considered creating your own but didn't know where to begin? Then this is the session for you. Everybody is talking about best practices, and like standards, most everybody has them. But why do they look like they do, and why would you use a specific set of "best practices" that someone has put together? This session goes through my set of best practices that I've accumulated over 20 years of DBA work, disassembles each and every one of them to see how they came about and discuss why I still use them - or don't. There are no such things as the "ultimate" best practices, but I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward. The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.

    • Regular Session
    • DBA
    • 200
    • English
  • Bots and AI with Azure

    Are Bots a real thing, or are they just a hype? Why are Bots being talked about so much? This session will take a look at bot technologies and how Microsoft is forging into the bot and AI space with the Bot Framework and practical uses in the real world.

    • Regular Session
    • DEV
    • 300
    • English
  • Build your next BI solution in azure

    Azure bietet eine Vielzahl von Diensten und Services an, die man zu einer BI Solution in der Cloud zusammenstellen kann. Welche Möglichkeiten bietet aktuell Azure um eine zeitgemäße BI Architektur zu erstellen? Die Komponenten, die derzeit angeboten werden reichen von Azure SQL DB und SQL DWH über Data Factory, Stream Analytics, Logic App bis hin zu Analysis Services und Power BI um nur ein paar zu nennen. Das ist eine sehr gute Toolbox, mit der man sehr schnell die ersten Erfolge erreichen kann. Schritt für Schritt wird hier erklärt wie man das klassische ETL in der Cloud erstellt und die Ergebnisse in Power BI analysieren kann.

    • Regular Session
    • BI
    • 100
    • German
  • Cardinality Estimates in Microsoft SQL Server

    SQL Server 2014 introduced a new cardinality estimator. This feature allows for statistics to be calculated differently than previous versions of SQL Server, often (but not always) resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance. You will learn: The differences between old and new cardinality estimator How to know if the new version is causing performance issues How to revert back to the old version if needed

    • Regular Session
    • DBA
    • 300
    • English
  • Continuous Integration With Docker, SQL Server and SSDT

    In this session you will learn how via the most popular continuous integration engine in the open source community how to take a simple build pipeline. This simple example will be expanded upon to include multi-branch build pipelines, scaling the build pipeline out adding tSQLt unit testing and much much more.

    • Regular Session
    • DEV
    • 300
    • English
  • CosmosDB - Überblick und erste Schritte

    In dieser Session möchte ich euch zeigen, was die CosmosDB ist, wofür man sie einsetzen kann und was die Besonderheiten sind. Ihr erhaltet einen Überblick in das Featureset und deren Nutzung in einer Vielzahl von Lösungen.

    • Regular Session
    • DBA
    • 200
    • German
  • Crazy Data Science

    Data is the most valuable asset to any company right now and you can gain a corporate advantage through the insights your data can provide. However, implementing Advanced Analytics can also lead to very....interesting....results. 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!

    • Regular Session
    • OTHER
    • 200
    • English
  • Customizing SQL Server 2016 Mobile Report Publisher

    In Reporting Services 2016 Microsoft introduced support for mobile reports. They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015. Mobile Report Publisher is really easy and quick to learn. Developers can create dashboards and KPI and publish them on Reporting Services in a very straightforward way. The downside is that Mobile Report Publisher offers simple features and settings for data visualization and parameterization, compared to Report Publisher for standard paginated reports in Reporting Services. Nevertheless there are some poor-documented customizations users can apply to have a more flexible products and to determine objects visibility. Want to add parameters to a mobile report? Want to add drillthrough and navigation from one report to another? Want to design and import a custom map, for your visualizations? Want to implement security and filter visibility based on the user's grants? Want to apply a custom layout to your portal? In this session you'll find the solutions that best fit your needs based on real implementation in a large company.

    • Regular Session
    • BI
    • 300
    • English
  • Cutting through the clutter - Indexing Nightmares and avoiding them

    What's a good index? Can you have too many indexes? What won't SQL Server use your preferred index? In this session we'll explore all the above and more as we look at - best practices for for creating indexes - the performance pros and cons - how to work out which indexes are actively hurting your performance

    • Regular Session
    • DBA
    • 200
    • English
  • Data Analysis - The The Whats and Hows of USQL

    U-SQL. You keep hearing about this new language, that it is supposed to be the next great analytical language to take over the world. What is it, how does it work and what can you do with it? This demo-heavy session will take detailed tour through the insides of U-SQL and its rich analysis capabilities. This session will look at its language structure, its extensibility, and its ability to query both structured (Azure SQL DB and SQL Data Warehouse) and unstructured (Azure Data Lake) data through a distributed and scalable model. This session will also look at the benefits of Azure Data Lake as an analytical data store for data of all types.

    • Regular Session
    • DEV
    • 300
    • English
  • Data Cleansing with SQL and R

    On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

    • Regular Session
    • OTHER
    • 200
    • English
  • Data Science, easy until it's not

    Data Science, it's easier than you think. In this session we'll go through a data science project using Microsoft's team data science process. You'll see the parallels between technologies such as Azure Workbench, Azure ML Studio and SQL Server 2017 Machine Learning Services. To top it all off, you'll experience why data science can actually be very hard, even with tools that aim to make it very easy. This all will help you get started easily on that idea or project that's been laying on the shelve!

    • Regular Session
    • BI
    • 200
    • English
  • Data Shaping in Power BI

    Data, which we usually use in our “quick’n’dirty” mode of analysis, very often requires a little bit of polishing in order to use it i.e. to join with additional datasets. Another, quite frequent case is serious drop in performance while working with larger number of rows. Those and similar situations are often caused by bad quality of data that we load to our reporting models. This full-of-demos session will be an overview of Power Query transformations and functions which may help you in getting your data in better shape.

    • Regular Session
    • BI
    • 300
    • English
  • Data Visualization: How to truly tell a great story!

    We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

    • Regular Session
    • BI
    • 100
    • English
  • Data Warehouse load performance with SSIS and SQL Server (and Zombies)!

    When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible? In this session, you will learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is happening behind the scene of minimal logged inserts, why they are so important when doing bulk load, and what is required to achieve a minimal footprint on the transaction log. And yes, there will be zombies!

    • Regular Session
    • BI
    • 300
    • English
  • Database in the Cloud for Early Adopters

    This session will be a little about architecture, a little about opportunities and a little about future of DBA. If you never touch Azure Services (Azure Portal, SQL Azure, Cloud Security) come to my session. In demo-focused fifty-five minutes story, I will show you why this way to work with data in 2017 and future years. We will discuss how set-up our environment in right way, how applied security helping us from the very beginnings, how we can save out a budget and get more from the cloud. We look for processing and storing data, for backup, restore and automation and for the tools which can make our (professional) life better.

    • Regular Session
    • DBA
    • 200
    • English
  • Database Source Control - The 1st step to Database DevOps

    Why database changes are handled differently from code changes? Does database really need to be a bottleneck in the agile delivery process? This session is about the first step to bring DevOps practices to databases: source control. So, during this session I intend to explore the following topics: • Database source control approaches: migrations-based and stated based; • Strategies and tools for implementing database source control: open-source and closed-source • Best practices and guidelines to manage database scripts • Database source control challenges In the end of this session you will have the power of starting database automation and as bonus you will unlock the next steps: continuous integration and continuous delivery.

    • Regular Session
    • DBA
    • 100
    • English
  • Databases and Data Lakes - Bridging the Gap

    Relational database management systems (RDBMSes) and data lakes are very different technologies, from different eras. But so what? They both store data that needs to be analyzed, often using the same tools. Moreover, the data stored in these different types of repositories may well need to be correlated and blended – or perhaps data in one can be enriched with data in the other. What can be done to match and merge data from RDBMS and data lake platforms (like Hadoop and Spark), especially when several vendors out there offer both? This demo heavy session will show how to get the RDBMS and data lake worlds in sync, and how bringing data from both repositories together pays off in analysis, insights, and digital transformation.

    • Regular Session
    • DBA
    • 300
    • English
  • Datawarehouse Lightning Performance with Columnstore!

    During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore. 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.

    • Regular Session
    • BI
    • 200
    • English
  • DBA 101, the "stuff" that keeps your databases going

    With the large increase in shiny offerings these days sometimes it can be a distraction from the things you need to think about to keep your databases going. In this session I'm going to go back to basics on some of the things you have to consider if you're a DBA responsible for looking after SQL databases; making your live easier so you can spend more time with your friends and family or looking into Data Science.

    • Regular Session
    • DBA
    • 200
    • English
  • dbachecks - a new module from the dbatools team

    dbachecks is a framework created by and for SQL Server pros who need to validate their environments. It is a free, open source module that allows data pros to crowdsource our checklists using PowerShell's open source testing framework, Pester. Basically, we all share similar checklists and mostly just the server names and RPO/RTO/etc change. We offer over 50 built-in checks. Imagine being able to easily ensure that: - Backups are being performed within your policy - Identity columns are not about to max out - Servers have access to backup paths - Database integrity checks are being performed and corruption does not exist - Disk space is not about to run out - All enabled jobs have succeeded - The build you are running is still supported - Dedicated Administrator Connection is setup - Your instances haven't generated any SQL Memory Dumps - SQL Servers are compliant with DISA, CIS, and more Do you already have some Pester checks in place? No problem, we can run your tests too. And to top it off, we make it easy to email yourself or view the results of your tests in a gorgeous Power BI Dashboard. Join us to see how easy (and beautiful) it can be validate all of your SQL Server environments!

    • Regular Session
    • DBA
    • 200
    • English
  • dbatools-PowerShell and SQL Server Working Together

    The dbatools module now has over 300 commands and anyone who wants to start is overloaded with amount of functionality in this module. There are not enough hours in the day to get everything done as a DBA. We need to automate our repetitive tasks to free up time for the important and more fun tasks. In this session I'll show you a set of commands which will help you start automating your tasks.

    • Regular Session
    • DBA
    • 100
    • English
  • Deploying an Azure BI solution automagically

    In is already a standard in the ‘regular’ developer world, but in the Business Intelligence world it is usually a challenge: having a CD/CI pipeline that fully automates building and releasing your Azure BI solution. In this session I will show you how to create an CD/CI pipeline that will build and release a solution containing: Azure Data Factories, Azure SQL Databases, Azure Analysis Service and Power BI reports fully automated and triggered by a single commit.

    • Regular Session
    • BI
    • 300
    • English
  • Deploying Power BI in the Enterprise - lessons learned

    Power BI has gained massive popularity as a self service BI solution, and is increasingly adopted as the go-to reporting tool for small and larger businesses. And this is when the fun starts - as Microsoft didn't offer Power BI as an enterprise ready tool. Join me to learn how Norway's largest production released Power BI implementation got implemented, the pitfalls we discovered and what we did to handle them. We will also look at how to monitor usage, and why Power BI Premium might be a good option.

    • Regular Session
    • BI
    • 300
    • English
  • Deployment pipeline for databases

    In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tend to be a different and separated process of the application delivery process, or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process. In this session, I will explore the challenges of each stage of the deployment pipeline: source control, continuous integration, continuous delivery. The database can be a Azure Database or a database hosted in SQL Server, the same concepts are applied to both. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that pipeline will allow to reduce the fear of making database changes. I will explore the different/possible configurations of the deployment pipeline while articulating databases and applications.

    • Regular Session
    • DBA
    • 200
    • English
  • Developers Guide to Power BI, part 2

    There are three different ways to combine coding and Power BI: Custom Visuals, Power BI REST API and the Embedding API. In this session I will talk about the REST API and the Embedding API. Both methods have here specific things that are needed before you can start and to make it a success. Where to start? How about security? Licenses? All typical questions that will be covert in this session and supported with a lot of demos.

    • Regular Session
    • BI
    • 300
    • English
  • DevOps for the DBA

    Far too many people responsible for production data management systems are reluctant to embrace DevOps. The concepts behind DevOps can appear to be contrary to many of the established best practices for securing, maintaining and operating a reliable database. However, there is nothing inherent to a well-designed DevOps process that would preclude ensuring that the information stored within your data management system is completely protected. This session will examine the various methods and approaches available to the data professional to both embrace a DevOps approach to building, deploying, maintaining and managing their databases and protect those databases just as well as they ever have been. We will explore practices and plans that can be pursued using a variety of tooling and processes to provide DevOps methodologies to the systems under your control. You can embrace DevOps and protect your data.

    • Regular Session
    • DBA
    • 200
    • English
  • Discover the new graph features of SQL Server 2017

    In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.

    • Regular Session
    • DEV
    • 200
    • English
  • Don’t forget your database when doing Continuous Delivery

    Organizations are beginning to deploy their applications in an automated way using DevOps. However, deploying the database seems to be an issue. Automating schema changes, migrating data between different versions and making sure that your application stays working while these deployments are happening is challenging. In this session you'll learn both architectural approaches and tooling support like SQL Server Data Tools and the RedGate Data Tools for different approaches to automatically deploying your database. We'll also test these changes and make sure you can deploy your application and your database with confidence.

    • Regular Session
    • DEV
    • 300
    • English
  • Don't cross the streams! A closer look at Stream Analytics

    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.

    • Regular Session
    • OTHER
    • 200
    • English
  • Einstieg in Azure SQL Databases und Powershell Automation

    Einstieg in das Thema SQL Datenbanken in der Microsoft Cloud, von A wie Allgemeines, nach B wie Backup, dann über P wie Powershell nach R wie Restore. Ich gebe einen Überblick, welche Möglichkeiten es gibt eine Azure SQL Database zur Verfügung zu stellen, wie höhere Anforderungen realisiert werden können, ebenso gehe ich auf das Thema Kostenersparnis ein. Wir werden uns verschiedene Deployments anschauen, auf das Thema Backup und auf die unterschiedlichen betrieblichen Leistungsanforderungen eingehen.

    • Regular Session
    • DBA
    • 200
    • German
  • Enterprise Power BI – Development Lifecycle

    When your development team is up to a certain size and often no matter what size it is you want to start following best development practises. These include things like source control, multiple environments, deployment processes and governance. As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are these things can get tricky. In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, dev, test and production and deployment of Power BI content. We will then look at the different options when it comes to distribution of content to the end user. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.

    • Regular Session
    • BI
    • 200
    • English
  • ETL and DWH Design with Metadata

    This session is all about getting away from manual SSIS packages. Instead of reinventing the wheel every time you need to change or extend a package, let’s talk about meta data models and how we can use them to design and describe our data warehouses and packages. We will discuss all areas from initial design, maintenance and support as well as documentation and compliance. In addition to that, we’ll take a look how Biml can help us translate our metadata into a ready to use SSIS solution!

    • Regular Session
    • BI
    • 200
    • English
  • Extending Power BI With Your Own Custom Visuals

    Microsoft Power BI is rich with its default visualizations and can also be extended by adding custom visuals from the Office Store (store.office.com). But besides those visuals, there is another option: you can also create your own visual to be used in your reports. How is this done? Where to start? These were also questions I had before I started creating my own visuals. Now with hands-on experience in creating and submitting custom visuals I will explain and demonstrate in this session how to start creating your own visual, what are the best practices and what are the extra next steps needed before submitting the visual to the Office Store.

    • Regular Session
    • BI
    • 300
    • English
  • Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

    When done right, data visualization informs users quickly and efficiently with a minimum of distraction. When done wrong, we end up with spinning 3D pie charts. In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience. We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image. When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards. Finally, we will take a couple of awful dashboards and turn them into something which end users will appreciate.

    • Regular Session
    • BI
    • 100
    • English
  • Faster transactions & Analytics with the SQL Server 2016 In-Memory enhancements

    Enhancements to the core SQL Engine In-Memory have made it drastically simpler to implement incredible performance benefits for your OLTP, Analytic & Data warehouse query workloads! In this session you will learn how these powerful features work; like the in-memory optimized tables and Clustered Columnstore indexes. Expect at least 30X improvement! And -as always- all shown in live demo’s!

    • Regular Session
    • DEV
    • 200
    • English
  • FILETABLEs: What They Are and How to Use Them

    Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d

    • Regular Session
    • DEV
    • 300
    • English
  • Football Feelings Quantified – Ranking Clubs by Supporter Sentiment

    Regardless of what football league you follow, some years the title chase can be quite boring. A football podcast in the US (Men in Blazers) came up with an interesting idea - what if we ranked the Premier League by the Twitter sentiment of the supporters at the end of the match? That discussion was the genesis of the Premier League Mood Table that I created for them to discuss during each episode. While the premise of a mood table might be quite silly, the underlying concepts and technology are relevant to any company with a social media sales presence. Join me as I walk us through using Azure Logic Apps, Cognitive Services, and Azure SQL Database to store and analyze Twitter sentiment that can impact your company's bottom line - and potentially yours as well!

    • Regular Session
    • OTHER
    • 200
    • English
  • Free Power BI for everyone!

    Reducing costs is always a mission for every IT department. We want to do more and more, so in this session I want to present the power of the Free Power BI offering. You can have all types of dashboard, refreshing them and provide significant insights. I want to show you, how to leverage that important dashboard without expending an euro with a BI tool.

    • Regular Session
    • BI
    • 100
    • English
  • From problem to Power BI: A journey in data visualization

    Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

    • Regular Session
    • BI
    • 100
    • English
  • From relational to Multimodel : Azure Cosmos DB

    We are more and more living in a polyglot database world. From having one database model to choose from for all our project, we now can choose between relational, document, key-value, graph and column oriented stores. But that means we need to use different tools for different projects. Azure CosmosDB aims to provides all models into one database, in the cloud. In this session, we will see what those data models are, for what kind of project they can be useful, and what are the strengh of Cosmos DB for your database needs.

    • Regular Session
    • DBA
    • 200
    • English
  • Fun with Legal Information in SQL Server: Correlating Offers and Counter-offers

    In this session you will learn about a typical challenge in legal information management: how to determine whether two (or more) offers to sell, or purchase, products (or services) represent the basis of a legally binding contract. You will learn which techniques are used to correlate the data in terms of the range of objects, their quantities, their qualitative properties, while also taking into account the temporal properties of the offers. You will also learn how clustered columnstore indexes can be used to improve the efficiency of the queries needed to solve this important legal problem.

    • Regular Session
    • DEV
    • 300
    • English
  • Fun with Legal Information in SQL Server: Determining the Law to Be Used

    Learn about typical challenges in legal information retrieval, the techniques used in querying data by determining its legal relevance, and how SQL Server 2016 can be used to simplify some of these techniques. For instance, a very important element of legal proceedings is determining which law should be used. Legal rules change over time, resulting in multiple versions of the same law. Laws do not last forever, and can be replaced by other laws (one old law can be replaced by one or more new laws). The timeline of events that are relevant to a particular court case provide one set of criteria to be used to determine the correct law and the correct version of the law.

    • Regular Session
    • DEV
    • 300
    • English
  • Get on the Azure Service Bus

    You have a carefully looked after on premises production application, but you need to transfer data to and from it from an Azure hosted application as well. Or you now have to ingest data from a 3rd party. How can you do that without compromising security or having to provision VPNs? Your new application MUST be up for customers 24/7, is it possible to decouple this from your application to allow for patching and maintenance windows? Azure Service Bus may be the solution you're looking for. On-Premise Service Bus architectures have been around for a while, but setting one up, maintaining it, and scaling it have been a full time job in themselves. Now with Azure Service Bus, setting up requires just a few clicks, scaling takes a few more and maintenance is done for you. We'll cover common design patterns, what Azure Service Bus can offer you, setting it up, configuring for performance and availability, and showing how your clients can interact with it.

    • Regular Session
    • OTHER
    • 100
    • English
  • Graph databases in SQL Server 2017

    Social media and IoT are just two of the many domains where we can represent things as directed graphs. But creating database queries on such a graph, especially if many nodes and edge-types exist, can be difficult. In this session, you will see that these types of queries can run a lot easier by using the new SQL Server 2017 graph functionality: special tables and queries to easily and performantly query graph structures.

    • Regular Session
    • DEV
    • 200
    • English
  • Handling JSONs in SQL Server 2016

    Consuming data from JSON is now much easier with the new built-in support introduced in SQL Server 2016. During this session will talk about JSON representation and will explore the new functions used for handling the content from a JSON file and based on some examples we'll transform a JSON text to relational table and then will export some data from SQL Server as JSON.

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Hash and stream aggregation

    Microsoft SQL Server has two physical operators to aggregate data - a hash and a stream aggregation. In the session, you will see the differences in terms of the internal algorithm, performance, scalability, hardware consumption and understand the limitations. In the end of the session you also understand how to implement the right index strategy to boost the query execution for aggregations.

    • Regular Session
    • DEV
    • 200
    • English
  • Heck freezes over - SQL Server for the Oracle admin

    Have you found yourself suddenly caring for a SQL Server database after a career of administering Oracle? If so, this is the session for you! This session will walk you through the key differences between Oracle and SQL Server and give you the confidence to manage a SQL Server database without inadvertently breaking it. It follows with key tips for getting to know your new database and how to avoid mistakes due to incorrectly assuming that SQL Server behaves in the same way as Oracle does. Join a fast-paced session filled with lessons from the field, all led by a 20-year veteran of Oracle and SQL Server. If you need to quickly get up to speed on SQL Server, gain a basic knowledge for administering SQL Server and develop a plan for continued learning, then this session will provide the tools you need to put you on the right track to become a SQL Server DBA.

    • Regular Session
    • DBA
    • 200
    • English
  • Hinter den Kulissen von Statistiken

    Sie kennen die Situation, dass eine Abfrage gestern noch schnell und zufriedenstellend gearbeitet hat und heute will sie nicht mehr so richtig? Was machen Sie in einer solchen Situation: • Ich starte den Server neu (hat ja sonst auch immer geklappt) • Ich lösche den Prozedur-Cache (hat mir mein DBA erzählt) • Ich hole mir erst einmal einen Kaffee und überlege, was ich in dieser Session gelernt habe Microsoft SQL Server benötigt Statistiken für ideale Ausführungspläne. Wenn Statistiken nicht aktuell sind, kann Microsoft SQL Server unter Umständen Ausführungspläne erstellen, die eine Abfrage um ein Vielfaches langsamer laufen lassen. Neben dem grundlegenden Verständnis für Statistiken werden in dieser Session Besonderheiten gezeigt, die nur einem kleinen Kreis von Experten bekannt sind.

    • Regular Session
    • DEV
    • 300
    • German
  • Hints, tips and shortcuts

    A practial session in which I would like to pass on some hints, tips, and time savers. Based around SQL Server Management studio, and developing / writing TSQL. A combination of keyboard shortcuts, features of SSMS, free scripts, tools and websites. These are all the things that I wish someone had told me when I started my career with SQL server.

    • Regular Session
    • NEWCOMER
    • 100
    • English
  • Hot potato – Administering SQL Server for the experienced sysadmin

    Have you suddenly been tasked with administering a database after a career as a systems administrator, or did the DBA just quit? Do you find yourself in the unenviable position of trying to keep a database afloat with no previous experience? If so, this session is your lifeline. This session begins by an overview of what a database is and what makes it different from anything else a sysadmin has seen before. It follows with do's and don'ts for keeping the database running and what is absolutely necessary to ensure that it continues to do so. We will cover among other things why the database is not just another file, why the different parts are strung together the way they are and how the backup works. Administering a database is surprisingly different from administering a server, despite what management sometimes think. This session will give you insight into what a database is and what makes it tick, describe key differences between systems- and database management and provide you the knowledge to ensure continued database availability even in the absence of a dedicated DBA.

    • Regular Session
    • DBA
    • 200
    • English
  • How to downgrade a database

    You can't simply restore a backup of the database to the SQL server with lower build number. I'll show you three possible ways to overcome this problem. Quick demo, no deep dive, 10 minutes tops... alright 15 minutes if the demo gods are in a bad mood.

    • Regular Session
    • DBA
    • 100
    • English
  • How to Use Parameters Like a Pro and Boost Performance

    Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren’t aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. Does your query sometimes run fast and sometimes slow – even when nothing’s changed? Did it happen to you that a stored procedure, which had always been running for less than a second, suddenly started to run for more than 5 seconds consistently – even when nothing had changed? In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing (don’t worry if you don’t know what that means) as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.

    • Regular Session
    • DEV
    • 300
    • English
  • I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!

    Challenged with this problem, let me show you how I used PowerShell Desired State Configuration to deploy and configure 80 SQL Servers for a client, fast! For this task, I needed to go from DSC Zero to DSC Hero. In this “notes from the field” session, I’ll share with you how I was able to achieve my client’s goals.

    • Regular Session
    • DBA
    • 300
    • English
  • Impact of weather on English Premier League matches – Power BI Desktop analysis

    Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data. How you can then manipulate and extend it and finally report on it. We will look into how you can use open weather data and combine it with data from web pages to create the dataset you need. When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report. In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report so they will see both the limitation of Power BI Desktop and open data as well as its strength. In the end the Power BI Desktop file will be available to download for the audience.

    • Regular Session
    • BI
    • 100
    • English
  • Implementing a hybrid datawarehouse

    The last couple of years have seen the emergency of "Big Data", "Cloud" and "Internet of Things". Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. Which of course is silly. Sensible companies don't just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW. This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.

    • Regular Session
    • BI
    • 200
    • English
  • Index Fragmentation

    In the session you will learn the difference between the internal and external index and heap fragmentation and how to detect it. You will get a deeper understanding of the reasons of fragmentation like + page splits + index fill factor + ghost records + forwarding records + heap PFS insert algorithm + batch insertions + database shrink / auto growth Additionally you get familiar with topics like + page dump + PFS, GAM, SGAM page + sys.dm_db_index_physical_stats + sys.dm_db_database_page_allocations + sys.fn_PhysLocCracker

    • Regular Session
    • DBA
    • 400
    • English
  • Index Tuning for the developer

    During our time I will be explaining the impact of indexes and why you should use them. After the session Clustered/Nonclustered/Columnstore/Filtered will no longer be a mystery for you. You will also know what the impact of indexes are on your system thus allowing you to develop a good indexing strategy in your own environment!

    • Regular Session
    • DEV
    • 200
    • English
  • Introduction to Azure Data Lake Store & Analytics

    An introduction to Azure Data Lake Store & Analytics.

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Introduction to Ensemble Modelling

    Ever heard of modelling techniques like DataVault? Many of those approaches are based on so called ensemble modelling, where the ensemble forms the backbone of the whole architecture. But... What does that mean?! We'll take a look at what an ensemble is, how to model it, what to avoid and, maybe most importantly, how it can help in designing and running an enterprise Datawarehouse.

    • Regular Session
    • BI
    • 300
    • English
  • Introduction to Machine Learning

    Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms. If you want help choosing between a 'neural net' or a 'two class boosted decision tree', this session will reveal all!

    • Regular Session
    • OTHER
    • 200
    • English
  • Introduction to Pester - TDD for PowerShell

    Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function, making sure that all of the code works as expected, is written according to PowerShell best practices and has a complete help system. You will leave this session with a good understanding of what Pester can do and a methodology to develop your own PowerShell functions

    • Regular Session
    • DEV
    • 300
    • English
  • IoT Circus – deathmatch oops, datematch 😊 Power Bi vs Time Series Insights

    Or how to visualize your data and find insights for beginner IoT developer If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data 😊 trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.

    • Regular Session
    • DEV
    • 300
    • English
  • IT Pro Security with The Beard

    Technology. Programming Languages. Databases. Application. Subjects of daily work. But how about us? How about people? How about IT Pro Security, or maybe in the right order - Securing It Pro. Let's discuss our daily work, about our tools and tasks in the context of securing IT Pro. Secure Yourself First.

    • Regular Session
    • OTHER
    • 100
    • English
  • Let the Cognitive Services to help you to find your favourite cocktail

    Who does not know the problem, you sit in the bar and just don't know which cocktail to order? The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?

    • Regular Session
    • OTHER
    • 300
    • German
  • Let’s start using Cognitive Services in our business apps!

    Our business application started to be more and more intelligent. And we can use a lot of data that we never had a chance to use in our application. To do that we can easily use API provided by Microsoft Cognitive Services. There are 30-ish API’s that are really clever and can provide object recognition, face detection and identification, emotion recognition, computer vision, video services, speech and speaker recognition, language understanding, text analytics, sentiment analysis, knowledge exploration, search services, and more. If you want to add to your application more intelligent futures, come to this session to more understand what Cognitive Services are and get some ideas how you can use in your business today.

    • Regular Session
    • DEV
    • 100
    • English
  • Level Up Your Biml: Best Practices and Coding Techniques

    Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

    • Regular Session
    • BI
    • 300
    • English
  • Locking and Blocking

    You Query is running infinitely? In many cases this is not caused by a bad execution plan but by locking and blocking. In this session, you will learn why a database management system like Microsoft SQL Server has to implement locking and blocking. We will monitor and analyse locking and blocking with extended events and database management views and understand how we can reduce the probability of blocking. We will deep into the different transaction isolation levels and distinguish between an optimistic and pessimistic concurrency model. Furthermore, the session demonstrates the transaction isolation dependencies (dirty, non-repeatable, phantom reads and lost updates) and the work of the lock manager.

    • Regular Session
    • DBA
    • 300
    • English
  • Making maps in Power BI

    How many ways do you know for making maps in Power BI? Maybe two? Anything else but bubble maps and choropleth? Are you aware of the new Shape maps visual embedded in Power BI? And what about the wonderful custom visuals available for every user? 3D GlobeMap and Synoptic Panel an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. How not to mention the new ArcGIS Maps for Power BI feature announced recently? It offers enhanced mapping capability, demographic data, and even more compelling map visualizations. And that's not all. Support for R open doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can. Amazing visualizations, interactive charts and deep data analysis: with Power BI custom tools everything is possible!

    • Regular Session
    • BI
    • 200
    • English
  • Making Row Level Security and Dynamic Data Masking work for you!

    Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it? These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong. In this session we will look at how you can get the most out of these features and retain the performance of your system.

    • Regular Session
    • DEV
    • 200
    • English
  • Managing Always On Availability Groups with Powershell

    Availability Groups is changing the way of leveraging High Availability and Disaster Recovery in SQL Server. PowerShell is helping Database Administrators to automate most of their work. In this session I want to share with you how I do manage my Always On AG environment with PowerShell. How combining them can make your life easier? This is the right session if you want to get your work easier.

    • Regular Session
    • DBA
    • 200
    • English
  • Managing Power BI with PowerShell

    Power BI user? DBA? BI developer? Get full visibility of your Power BI license usage, all workspaces in your tenant, your datasets, their refresh history and more. All without being an Azure or Power BI Admin. This can all be achieved through PowerShell. Implement improved alerting on dataset failures

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Microsoft Azure for the SQL Server DBA

    Although Microsoft Azure and the concept of Cloud Computing has been around for a number of years it is still a mystery to many. This talk takes offers an introduction to Microsoft Azure and the many services it has to offer. We will then go onto look in depth at SQL Azure Database; creating, configuring, scaling, connecting, using, securing, monitoring, uploading, scheduling, high availability and DR.

    • Regular Session
    • DBA
    • 200
    • English
  • Migrating your Database to Azure SQL DB as you never seen it

    Azure SQL DB Managed Instances brings a lot of benefits for migrating databases to the cloud and taking advantage of a scalable and reliable Database platform. In this session I am going to walk you through the various aspects of Managed Instances and how to migrate it, but also I am going to show you how it was done in the past. Afterwards you can compare and find your way to Azure SQL Database

    • Regular Session
    • OTHER
    • 200
    • English
  • Migrating your On Premise database to Azure SQL DW

    Have you ever tried to migrate your On Premise DataWareHouse solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution. What are the best practices to Migrate your solution with as little impact to users as possible? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience. I will take you in this session through all the steps you have to take care off. The following points will be discussed Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.

    • Regular Session
    • BI
    • 300
    • English
  • Mind the Gap: Can we generate a complete datawarehouse ?

    BIML is well known for generating the ETL part of a datawarehouse. But did you know that with T4 templates in Visual Studio tables, views and stored procedures and functions can be generated. To close the gap, with the new Tabular Object Model (TOM) generating a Tabular model is as easy as using BIML for the ETL. Now we can focus on transform the data into information instead of spending time on repeatable jobs which can be automated easily.

    • Regular Session
    • BI
    • 300
    • English
  • Mit Verfahren der künstlichen Intelligenz den Vergleich zwischen Äpfel und Birnen verhindern

    In der Session werden Verfahren aus des Machine Learnings in einen realen Anwendungsfall übertragen - wie vergleiche ich unterschiedliche Standorte/Stores objektiv miteinander? Mit einem griffigen Beispiel und Einblicken in Power BI und Azure ML soll den Zuhörern ein "Managementfähiges" Szenario an die Hand gegeben werden.

    • Regular Session
    • BI
    • 100
    • German
  • Modern Data Warehousing - A template for Lambda BI in Azure

    Technology changes quickly - patterns and approaches less so. As we move towards distributed cloud architectures we will employ a range of disparate tools, the patterns that were designed for single box solutions may not be appropriate any more. This session will take you through the patterns and processes that underpin the Lambda architecture, providing advice and guidance on the tool sets and integration points between them. We will follow the movement of data through batch and speed layers via Azure Data Lake Store & Analytics, Data Factory, SQL Datawarehouse and Streamining Analytics, before looking briefly at Azure Analysis Services with PowerBI. This is a largely theory-based session to prime you for the future

    • Regular Session
    • BI
    • 300
    • English
  • Monitoring Linux Performance for the SQL Server Admin

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, and Memory and monitoring techniques for each and look some of the new tools available!

    • Regular Session
    • DBA
    • 400
    • English
  • Monitoring Page Splits in SQL Server

    Monitoring page splits in SQL Server is useful. It can be very useful, for example, in order to choose the appropriate fill factor for an index. By monitoring the number of page splits for a particular index over a period of time, we can determine whether the fill factor for that index should be adjusted in order to reduce the number of page splits and improve the overall performance. In this session we are going to demonstrate all the possible options to monitor page splits in SQL Server, and we are going to show that all of these options are wrong. SQL Server is lying, and we're going to prove it. We will then demonstrate the only (documented) method to correctly monitor page splits in SQL Server as of today.

    • Regular Session
    • DBA
    • 300
    • English
  • Monitoring the Database Estate

    Remember when you only had three or four production servers to keep an eye on? Yeah, me neither. The modern database estate has an ever-growing set of servers on hardware, in virtual machines locally, virtual machines in the cloud and in an ever growing set of platforms. How do you monitor it all? This session will walk you through methods you can employ to get your database estate in hand in order to have better knowledge of what is online and performing well and what is not. Being surprise when one server went down was embarrassing. Being surprised when one hundred go down is career ending. Let me help you protect your career and ensure better estate monitoring.

    • Regular Session
    • DBA
    • 200
    • English
  • Monitoring to Quickly Diagnose SQL Server Performance Problems

    If you work with SQL Server long enough, whether as an official DBA or as the local de facto DBA, you're going to be faced with performance problems. Rather than simply poke and prod the server or your database in an attempt to get things running right, you need a method to rapidly identify the problems. This session walks you through the important metrics that you need to start capturing to outline the behavior of your SQL Server instances. Then, we'll use these metrics to quickly diagnose the root cause of performance issues. Gathering metrics, generating knowledge, is the fastest and safest way to improve the performance of your SQL Server instances.

    • Regular Session
    • DBA
    • 200
    • English
  • Moving advanced analytics to your SQL Server databases

    Traditionally advanced analytical solutions, like machine learning, require you to bring your relational data to the machine learning model. Your model would then perform a prediction and return the results. While the process described above is reliable, it involves moving your data between the database where it is stored and the location where your model resides. This also means an increase in the complexity of your analytical solutions. For instance, how do you trigger the scoring of new data as soon as it enters the database? Or, how can you design this process for real-time scoring? With the release of SQL Server 2016 Microsoft integrated a solution to the questions above, in-database analytics, allowing you to bring the analytics to your data instead of the other way around. Through in-database analytics we can design, train and score models directly from SQL Server without moving data out and back into the database. This creates a huge advantage, especially when working with real-time predictions, but how do you implement in-database analytics in your environment? In this session we are going to explore the various methods available inside SQL Server 2016 & 2017 to perform in-database analytics. From building and storing our models directly inside SQL Server, to performing real-time scoring on data as soon as the data is stored inside a table. After this session you will be able to understand the advantages and disadvantages of the various in-database analytics methods and you will be ready to start building your first in-database models!

    • Regular Session
    • OTHER
    • 300
    • English
  • Much Ado About Hadoop

    If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform. We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more. We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.

    • Regular Session
    • OTHER
    • 100
    • English
  • New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

    Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.

    • Regular Session
    • DBA
    • 200
    • English
  • Office 365 Group Reporting with PowerShell

    I will demonstrate how you easily you can build a Groups report for Office 365 in PowerShell. Will show common pitfalls and how to interpret the data. What can you do with the data afterwards? Integrate with PowerBI?

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Open Source Analytics in the cloud with Azure HDinsight

    You would like to get started with big data and analytics, but the landscape can be quite confusing and you are not sure where to begin. In this session, you will learn about Microsoft's managed big data offering: HDinsight. You will get an introduction to what the different cluster types (Hadoop, HBase, Storm, Spark, R Server, Kafka, and Interactive Query) can be used for, how you get it up and running, and how you can get started with open source analytics in the cloud.

    • Regular Session
    • BI
    • 200
    • English
  • Partitioning Deep Dive

    Partitioning has been available in SQL Server since 2005 but there can be a lot of misconceptions around it. This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos. Topics covered will be: - Paritioning definition Potential benefits and pitfalls Overview of partitioning functions and schemes Table design considerations Splitting and merging partitions Switching data Implementing sliding windows

    • Regular Session
    • DBA
    • 300
    • English
  • PBIRS - Power BI Reports Server On Prem - A real life story

    Erfahrungen über die Integrations eines Power BI Berichtsservers in die Unternehmenssystemlandschaft • Anforderungen • Voraussetzungen • Ziele • Installation und Konfiguration • Securtiy, Datenschutz • Lizenzierung • Tools, Autoren, Versionsverwaltung

    • Regular Session
    • NEWCOMER
    • 300
    • German
  • Performance Tuning for the BI Professional

    Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.

    • Regular Session
    • BI
    • 200
    • English
  • Plan Cache

    In this session you will learn how and why SQL Server caches execution plans. You will understand what kind of queries will cause plan pollution and how you can avoid this. Additionally you will see the benefits and drawbacks of parameter sniffing for procedures and functions and the difference of native compiled and interpreted stored procudures. Furthermore we will analyze how the setings ‘optimize for adhoc workloads’ and ‘forced parameterization’ influence query execution and the re-use of cached plans.

    • Regular Session
    • DBA
    • 300
    • English
  • Policy Based Management

    Die richtlinienbasierte Verwaltung, die mit SQL Server 2008 eingeführt wurde, kann viele Probleme beheben und bereits beim Aktivieren verhindern. In dieser Session wird an Hand mehrerer „Real World“-Beispiele gezeigt, wie der Einsatz von richtlinienbasiertem Management die Evaluierungszeit für Serverfarmen von 60 – 250 SQL Server Instanzen von 2 – 3 Tagen auf insgesamt 15 Minuten reine Arbeitszeit reduzieren kann.

    • Regular Session
    • DBA
    • 200
    • German
  • Power BI behind the scene: security and user management

    Power BI is a great suite of tools for business analytics and reporting. You use it to create reports and dashboard to deliver insights throughout your company. But, what about the new licensing model recently introduced for Power BI? How it can fits to your needs? Every organization is a complex system with rules and limitations. Users belong to groups each with visibility profile. So you need to know how security in Power BI works: how to configure and restrict access, how to filter data based on the logged user, how to implement static and dynamic Row-level security (RLS), how to control usage of specific features. Furthermore you deal with a large number of users you can’t leverage by hand. Power BI provides an admin portal that allows you to manage users and groups in the Office 365 admin center. Come to this session to discover what’s behind the scenes in Power BI and how to implement a solution compliant to your security and governance model.

    • Regular Session
    • BI
    • 300
    • English
  • Power BI in Concert featuring PowerApps & Flow

    "Write-back" in Power BI? In dieser Session integrieren wir Power BI mit PowerApps und Flow, um eine interaktive "App" zu bauen. Am Beispiel eines Cash-Forecasting-Tools nehmen wir die Möglichkeiten (und Fallstricke) des aktuellen Office 365-Baukastens auseinander und bauen ein praktisches Analysetool mit Eingabemöglichkeiten: In Power BI werten wir Daten aus und leiten daraus erwartete Ein- und Auszahlungen ab. Wir richten PowerApps ein, um grundlegende Parameter und Plandaten direkt aus dem Bericht heraus in den SQL Server erfassen zu können. Schlussendlich automatisieren wir Abläufe mit Flow.

    • Regular Session
    • NEWCOMER
    • 200
    • German
  • Power BI Report Server. Leveraging Power BI in your organization

    Do you love Power BI, but you need an on-premises solution? In this session, I am going to walk you through Power BI Report Server, a self-service analytics and enterprise reporting, all in one on-premises solution. In this session we are going to cover the following areas. - Power BI Report Server Installation - Using Power BI Desktop for Report Server - Create/Deploy Power BI Reports - Schedule refreshes - Web and Mobile App View - Sharing and Collaboration - Permissions. In the end of this session, you will have an overview of the solution and make this same presentation to your boss.

    • Regular Session
    • BI
    • 100
    • English
  • Power BI Server - On Premises

    In dieser Session zeigt Frank Geisler was mit dem Power BI Report Server, den man inzwischen auch lokal installieren kann möglich ist. Neben der Installation erklärt er die Unterschiede zur Cloud-Variante, erläutern die Bereitstellung des Servers mit und ohne SQL Server 2017. Außerdem zeigt er, wie man den Power BI Server in andere Umgebungen wie beispielsweise SharePoint oder eigene Applikationen integrieren kann.

    • Regular Session
    • BI
    • 200
    • German
  • PowerShell-Grow Your Script From Simple to Module

    With todays features within PowerShell developers are able to create the most advanced functions imaginable. We're talking about multiple functions interacting with each other, parameter validation, pipelines, use of the -WhatIf, modules, classes etc. If you're someone who wants to learn more to upgrade your current scripts to advanced functions, come to my session. I'll show you in a couple of easy steps how a simple script can be turned into something beautiful. Have you written a couple of scripts but want to get them to the next level. Than you'll want to attend this session and we'll see how far the rabbit hole goes.

    • Regular Session
    • DEV
    • 300
    • English
  • Practical SQL Server Machine Learning Services

    Admit to yourself that you’ve seen enough basic “R is coming to SQL Server” sessions with the same old examples! Enough of that, in this session we'll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring & maintenance. Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.

    • Regular Session
    • OTHER
    • 200
    • English
  • Projekt Migration SQL Server von physikal auf virtuell

    Projekt Beschreibung zur Ablösung von mehreren physikalischen SQL Servern durch Migration auf eine VMware Umgebung mit Details zur Anpassung der VM Konfiguration

    • Regular Session
    • DBA
    • 100
    • German
  • Push data to Power BI trough PowerShell

    How can we use PowerShell to interact with Power BI? What are the possibilities. What to think about? I will demonstrate how to get started using PowerShell/PowerBI and show some simple reports created in PowerBi and updated by PowerShell. If time permits, i will also show how to setup this in Azure Automation.

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Query Optimizer

    Despite of the fact the Query Optimizer represents one of the core features of SQL Server there is only little know about the internals. In this session, we will deal with the different tasks, methods and phases of this important feature. The knowledge will leverage your knowledge about the tuning of query plans but will also emphasize the limits of the query engine. The session assumes that you are familiar with the fundamentals of the query plan.

    • Regular Session
    • DBA
    • 300
    • English
  • Query Store

    Microsoft introduced Query Store in SQL Server 2016 as a new feature which makes certain database management views (sys.dm_exec_query_stats and sys.dm_exec_cached_plans) obsolete. In this session you will learn how Query Store works comparing to the “old” way to detect long running queries and even plan regression. Furthermore you will understand how to configure Query Store for your needs, avoid common pitfalls, interpret the available reports, new database management views and stored procedures to get the best out of the new feature.

    • Regular Session
    • DBA
    • 200
    • English
  • Real-Time Analytics: OLAP & OLTP in the mix!

    In this session we will talk about the Operational analytics possibilities using ColumnStore indexes with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot & warm data, and how to make this fit for your environment.

    • Regular Session
    • DEV
    • 200
    • English
  • Relationship Goals: The SQL Server Graph Database

    Relational databases have their strengths. Ironically data relationships are not one of them. Graph databases excel in this department using nodes and edges. They are optimized to find and view relationships using graph theory. One of the best new features of SQL Server 2017 is the Graph Database! It brings us the best of both worlds in one easy platform! Come learn about the history of graph databases, how they work and why you should be using it!

    • Regular Session
    • DBA
    • 100
    • English
  • Reverse engineering the business rules making use of Power BI & R analytics.

    Abstract In this session a reverse approach to the business rule definition process will be explained by highlighting the difference between fully tangible and rather intangible metrics. Business and implementation risks for dealing with fuzzy metrics are high compared with metrics which could be defined in just one way. Therefore, the business rule definition process should acquire more attention for those metrics and it should become an integrated part of the BI process, from the beginning on. This session uses a simplified part of the customer journey (churn & activation) in order for mimicking an intagible metric need. Microsoft Power BI and R analytics will be used for building a business rule definition facilitator. The focus is on providing a modern low-cost toolset which should guide key data stakeholders towards a data driven rule definition process. Target audience - Anyone interested in the process of making raw data speak to a business person - Microsoft BI enthusiasts - BI analysts / developers - Marketing people praying for relevant data insights Objectives - Indicating the danger of starting the BI process without having relevant business definitions - Making raw data speak in order to discover the business data-wise - Integrating R visuals in Microsoft Power BI - Simple predictive analysis using R on SQL Server on-premise - Building a flexible report with parameterized business rules (easy play and learn) Takeaway - Integrated low-cost Power BI / R / SQL Server solution - Better approach for guiding complex metric definitions Duration 1h Agenda Tangible vs. intangible metrics - Business relevance - Examples - Risks - Reverse rule definition approach Churn/Activation - What is it? - Business relevance - Various definitions possible - Pitfalls - Real-life considerations Demo - Generating raw business subscription / contract data on SQL Server on-premise - Exploring raw data to first understand the business making use of Power BI Desktop and R visuals - Implementing a parameterized churn definition for measuring actual churn (parameterized SQL Server functions) within Power BI Desktop - Implementing a parameterized churn prediction (Parameterized SQL Server stored procedure) within Power BI Desktop Power BI Cloud Service support for R visuals

    • Regular Session
    • BI
    • 100
    • English
  • Rub DevOps on all the things!

    What is DevOps and why should you rub it on anything? In this session we'll explore, through demo's, how a DevOps mindset changed my personal way of working and development of database and BI solutions. In the demos we'll automate the deployment of databases, SSIS, SSRS and SSAS and you'll experience the simple patterns to start automating the deployment of just about anything.

    • Regular Session
    • BI
    • 200
    • English
  • Scaling Out SQL Server Workloads With Containers

    This session will look at the pressure points of the legacy database engine and how containers can be used in such away to get around the usual suspect bottlenecks that the legacy database engine encounters, which are mainly around the internals and spinlocks associated with the log writer. Insights will be provided into how workloads scale which use SQL Server and containers for IoT use cases that involve ingesting data at scale and micro services style software architectures.

    • Regular Session
    • DEV
    • 300
    • English
  • Secure your data at rest - on demand, now!

    The new releases of Microsoft SQL Server: SQL Server 2016 & 2017 brings new functionality for Data Security Professionals. Newest release – SQL Server 2017 made those features even more mature. Now you can protect your data in your database anywhere (on-premise, in the cloud, in transit, in the hybrid environment) even more simply than before. Transparent Data Encryption with better algorithms and better support for backup, Row-Level Security, Dynamic Data Masking and Always Encrypted for your application are now simple features. Azure Security Center brings us a new way of looking and adopting security best practices in an easy way. We focus on theory and of course, on demos. We look a little closer for few specific files that exist in our environment. We work on all three different environments, but our goal is only one: protect your data.

    • Regular Session
    • DBA
    • 300
    • English
  • Security für Anfänger

    „In welcher Zeitung kann man lesen, dass eine Frau ihren Mann aus der Wohnung wirft? In "Schöner Wohnen!". Was dieser Satz mit Sicherheit im Microsoft SQL Server zu tun hat, erfährt man in dieser rasanten Session über die Sicherheitselemente von Microsoft SQL Server. • Was passiert mit einem Mietshaus, wenn Donald Duck und Daisy Duck einziehen? • Welche Rechte haben die beiden als Mieter oder als Eigentümer einer Wohnung? • Wie müssen die beiden die Wohnung einrichten, dass nicht jeder in das Schlafzimmer gelangt? • Wie können die beiden verhindern, dass die Neffen Tick, Trick und Track am Herd spielen? • … Alle Fragen werden anhand von konkreten Beispielen auf einfache Art und Weise erklärt.

    • Regular Session
    • DBA
    • 100
    • German
  • Simplifying Log Shipping using dbatools

    Have you ever tried to setup log shipping for one or more databases? You probably noticed the wide array of settings that have to be made for just one database. In most cases the settings only differentiate by the name of the database and some locations. Did you know you need about 40 clicks to setup log shipping for a single database? When it's finally setup, how do you check if the databases are in-sync? Have you setup log shipping as a warm stand-by? How do you recover the databases to get them online? We'll talk about the log shipping in general, applications for log shipping, third party solutions and possible competitors of log shipping. I'll show you how to use dbatools to setup a database for log shipping within minutes. How to test the status and how to recover to a functional database. Interested to know more about log shipping and/or make your life easier, come to my session and I'll show you.

    • Regular Session
    • DBA
    • 100
    • English
  • Simplifying XEvents Management with dbatools

    Extended Events are much more powerful than any other monitoring technology available in SQL Server. Despite this potential, many DBAs have yet to abandon Traces and Profiler. Partially because of habit, but mostly because the tooling around Extended Events was less intuitive until recently. Now, it's easier than ever to set up, control and inspect Extended Events sessions with dbatools! Not only does it simplify your basic interaction with XEvents, but it also helps solve your day-to-day problems, such as capturing and notifying deadlocks or blocking sessions. Join SQL Server MVP Gianluca Sartori and PowerShell MVP Chrissy LeMaire to see how PowerShell can simplify and empower your Extended Events experience. Say goodbye to #TeamProfiler and join #TeamXEvents with the power of dbatools.

    • Regular Session
    • DBA
    • 200
    • English
  • Soft Skills for Success

    We developers spend a lot of time developing our computer / programming / data skills. These skills are only part of what developers need to be successful. In this session I would like to talk about some of the soft skills that I have used when working with colleagues, customers and even my family.

    • Regular Session
    • NEWCOMER
    • 100
    • English
  • Spatial Analytics with SQL Server, R and Power BI

    Everything in our world is located “somewhere” and is related to other things. Spatial analysis consists of studying these relationships to find out meaningful patterns and behaviors. Figure out, you’re looking for the best position to open a new store. It´s not only a matter of “where”, but also there are more implications; is the area easily accessible by customers? Is there any parking? Is it easy to reach for suppliers? Are there any competitors store around? What is the volume of shopping for the same business in the area? Here is where spatial analysis can help us collecting, comparing and matching data to build up a framework of possibilities. Since 2008 release, SQL Server is supporting spatial data type. Now new amazing features are offered with the addition of R. R is shipped with a huge number of packages for performing spatial analysis, mapping, geocoding, etc . There virtually anything you can’t do with R: finding relationships, measuring spatial autocorrelation, interpolating point data, mapping point data, … And, last but not least, we have Power BI that offers a full range of mapping capabilities. Not only bubble or choropleth maps, but visual for performing spatial analysis like ArcGIS, or for creating custom shape maps. And R scripts naturally. In the session, we will show how the joint use of these three tools empowers us to analyze and query the spatial properties of data. We’ll showcase a real-world example for a better understanding of the endless possibilities that are now offered to us. Come, have fun and discover a world of information inside your data with Spatial Analytics!

    • Regular Session
    • BI
    • 200
    • English
  • Spielplatz Cognitive Services – auch große Kinder dürfen hier spielen

    Microsoft bietet mit den Cognitive Services eine große Spielwiese für Jung und Alt an. Hier kann nach Herzenslust ausprobiert werden was vielleicht schon morgen überall im Einsatz sein wird. Mit den verschiedenen Baukästen wie Beispielsweise Bot Framework, Emotion, Face, Text Analytics oder Recommendations, um nur ein paar zu nennen, lassen sich in kurzer Zeit Eindrucksvolle Anwendungen zusammenstecken. Kommen sie mit auf eine kleine Runde auf diesen Spielplatz.

    • Regular Session
    • OTHER
    • 200
    • German
  • SQL 2017 New feature -Graph Databases

    When I read that Microsoft have added graph data to SQL Server 2017 I was intrigued as to what graph data is so I started doing some research. This presentation is the culmination of my investigations. If you design complex OLTP relational databases or have data that doesn't fit the rigid hierarchy of a relational database then this talk is for you. You may be in for a surprise! Some of the questions we will look at: What is Graph Data? Who uses it? What is it used for? How does it compare to traditional relational database design? What other companies support graph databases? How does it work in SQL 2017? Is there a new language to learn? What is the so-called Kevin Bacon problem? And finally. Will it replace traditional relational database design within the next 10 years?

    • Regular Session
    • DBA
    • 100
    • English
  • SQL Containers in the Cloud! An intro to running Docker in Azure

    As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure. I'll cover the following different options for running Docker in Azure: Running Docker on standalone VMs Docker for Azure (Swarm) Azure Container Instances Azure Container Services This session is aimed at SQL Server DBAs and Developers who have some experience with Docker (Docker for Windows) and want to know the different options that are available in Azure. Each topic will be backed up with demos (live and recorded, depending on the time needed) which will show how simple it is to get up and running with these technologies.

    • Regular Session
    • DBA
    • 200
    • English
  • SQL database on IoT devices, could you? should you? would you?

    The current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the edge /field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions.

    • Regular Session
    • DEV
    • 200
    • English
  • SQL migrate everything to the cloud - Managing SQL Server with Chat Automation

    What if instead of painfully managing your databases by hand, carefully configuring every option and meticulously monitoring every component we could do this differently. In a world where words like AI and Chat Automation heard frequently, we will be looking at what we can do today to make our lives easier tomorrow. After a short introduction about the platform we will be migrating databases, updating configurations and moving workloads to the cloud. This works on a chat based platform, supported by everyone’s favorite scripting language: PowerShell.

    • Regular Session
    • OTHER
    • 300
    • English
  • SQL on Docker

    In dieser Session erklärt Data Plattform MVP Frank Geisler die Containertechnologien Docker und Windows Container und zeigt wie man einen SQL Server in einem Container ausführen kann. In den zahlreichen Demos der Session wird die Arbeit mit Containern erklärt und gezeigt wie man Container bei der Entwicklung von Datenbankanwendungen nutzen kann.

    • Regular Session
    • DEV
    • 200
    • German
  • SQL Server & Containers 101

    There's a lot of buzz about containers in tech at the moment and this technology has benefits that the SQL Server community simply shouldn't be ignoring. This demo based session will provide an introduction to how SQL Server containers, explore the various options when running containers, and give a real-world example of implementing containers in a development environment. Attendees will be taken through the following: - The definition of containers Virtual Machines vs Containers Container networking fundamentals Installing the docker engine Pulling SQL images from the docker repository Running SQL Server containers Creating custom container images Persisting data in containers Docker compose A real world implementation of containers

    • Regular Session
    • DBA
    • 200
    • English
  • SQL Server 2017 - Intelligence Built-in

    SQL Server 2016 and SQL Server 2017 Just Works! But if you are a IT Professional you want to be armed with all the right diagnostics to react to a mission critical problem or tune the engine to the needs for your business. Dev-Ops also requires the right tools to build and tune queries for maximum performance. SQL Server 2016 and 2017 have all the diagnostics you need just built-in to the product. We also have intelligence built-into the engine based on these diagnostics to automate, learn, and adapt. In this demo-filled session we will show you the wide variety of these built-in diagnostics and performance tools, and you will learn why SQL Server diagnostics are the best in the industry, built-in, and spans all platforms across SQL Server, Azure, and Linux.

    • Regular Session
    • DBA
    • 300
    • English
  • SQL Server 2017: Schnell, schneller, am schnellsten

    Die Aussage Bob Wards, seines Zeichens Principal Architect Databases von Microsoft, „SQL Server 2017 is the fastest database everywhere you need it.” fasst es zusammen: SQL Server 2017 ist schneller als all seine Vorgänger, und auf allen Systemen die schnellste Datenbank: sei es auf Azure, unter Windows oder gar Linux. In dieser Session erläutert Andreas Wolter (MCSM Data Platform), welche neuen Features und Verbesserungen der Datenbank-Engine diese Aussage untermauern. Natürlich wird es auch einige Demos der neuen Möglichkeiten geben. Wer wissen will, ob, oder besser warum er auf das neue Release setzen soll, ist hier genau richtig.

    • Regular Session
    • DBA
    • 300
    • German
  • SQL Server Always ON Availability Groups 101

    You were just asked to setup an Always On Availability Groups infrastructure, but you don't know where to start? This session is the right one for you. Windows Clustering, Quorum, Witness, DTC, Disks, Installing SQL Server properly and creating your Availability Groups, we will cover the initials of those topics to make your life easier.

    • Regular Session
    • DBA
    • 100
    • English
  • SQL Server and XML Query

    XML was added to the collection of SQL Server native data types in SQL Server 2005. Being a complex data type, not only is XML accompanied by a set of dedicated T-SQL functions, but also with a complete querying language. In this session you will learn about the Microsoft SQL Server 2008 implementation of the World Wide Web Consortium's XML Query Recommendation, and learn how to compose XML data – from existing SQL Server data or simply "from scratch", how to retrieve (relational) data from XML Documents to be used in a SQL Server database, and how to manipulate XML data using Transact-SQL and the XML Data Manipulation Language (XML DML). You've already mastered all the primitive SQL Server data types, why would XML be an exception?

    • Regular Session
    • DEV
    • 300
    • English
  • SQL Server Audit

    Beginning with SQL Server 2016 SP1, all editions of SQL Server now support SQL Server Audit. SQL Server Audit is a feature that allows for administrators to capture and track activity at both the database and server instance level. Built upon Extended Events, SQL Server Audit will log details of events each time the audit action happens. Attend this interactive session for an overview of SQL Server Audit, learn how to create and configure audits, and discuss the best ways to consume, centralize, and analyze audit logs.

    • Regular Session
    • DBA
    • 300
    • English
  • SQL Server Backup in AD 2018

    A standard DBA responsibility - Backup. Not very frequent DBA task - Restore. Mature, but still not very important part of many DBAs till the first crash. But in 2016, 2017 our daily life, our products, our environment are changing frequently. Have we something new? How we can improve our backup, what new possibilities we have? How Microsoft SQL Server and Microsoft Azure could help us with having a good quality backup, spending less time and money for this, finally be more productive. Answers you will find in my session.

    • Regular Session
    • DBA
    • 300
    • English
  • SQL Server Backups In Depth

    Backups are a core part of a DBA's job, but what goes on under the hood. What are these LSN things, how does SQL Server knows what needs putting into a Differential backup and what does a transaction log backup do exactly? In this session we'll dive into some SQL internals to step through how SQL tracks your data changes and ensures that your backups will save you when you need them

    • Regular Session
    • DBA
    • 300
    • English
  • SQL Server DBA Tips That Can Save Your Ass

    In this session we will present and demonstrate many tips & tricks that can help database administrators take the best out of SQL Server. The tips you'll learn in this session will help you improve productivity, availability, security and performance of your system. We picked the topics that are less known and yet have a great impact. The session is based on SQL Server 2017, and includes some of the new features in the new version, but it is relevant also for older versions of SQL Server.

    • Regular Session
    • DBA
    • 300
    • English
  • SQL Server Developer Tips That Can Save Your Ass

    In this session we will present and demonstrate many tips & tricks that can help developers take the best out of SQL Server. The tips you'll learn in this session will help you increase productivity and improve performance of your application. We picked the topics that are less known and yet have a great impact. The session is based on SQL Server 2017, and includes some of the new features in the new version, but it is relevant also for older versions of SQL Server.

    • Regular Session
    • DEV
    • 300
    • English
  • SQL Server hates you(?) - what the DBAs never told the developers

    Have you had performance tank despite the code working fine in another environment? Maybe heard that some SQL is bad but not why? If so, this is the session for you! This session will start with a walkthrough of some of the basic settings in SQL Server and how they affect you as a developer. It follows with key tips on what settings to change, why some code will wreak havoc on your performance and how isolation levels matter (and why NOLOCK can be an exceptionally bad idea!) The session is led by a 20-year DBA veteran who decided to try to help developers understand performance issues by seeing things from his perspective. If you want to explore how default settings kill your performance, investigate why harmless SQL might not be quite so harmless and gain insight into how isolation levels affect function and performance, then this session will provide you with the tools to think outside the box and incorporate database engine knowledge into your developer prowess!

    • Regular Session
    • DEV
    • 200
    • English
  • SQL Server Problem Bingo!

    What's more fun then a Bingo? SQL Server and a Bingo, during this session we will be handling a variety of SQL Server problems you might face in your data platform environment. These problems are put into a bingo machine & will be handled as they get chosen by destiny! This is an action packed demofull session containing all of the most common SQL server problems as seen in the field. Come to this session and you might win a fabulous price!

    • Regular Session
    • DBA
    • 200
    • English
  • SQL Server Statistical Semantic Search

    SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.

    • Regular Session
    • DEV
    • 300
    • English
  • SQL Server surprises

    SQL Server contains a few surprises: transactions that don’t do what most people expects, NULL values that cause queries to spit out unexpected results, data type issues and many more. These are not bugs but features, nicely documented. But hey, who reads the manual?! In this very interactive session you can learn some SQL Server surprises, and how to avoid them in your own T-SQL code. This 1 hour session can save you from many hours of debugging...

    • Regular Session
    • DEV
    • 300
    • English
  • SQLServer under pressure: Can I fix it?

    Where to start when your SQLServer is under pressure? If your server is misconfigured or strange things are happening, there are a lot of free tools and scripts available online.These tools will help you decide whether you have a problem you can fix yourself or you really need a specialized DBA to solve it. Those scripts and tools are written by renouwned SQLServer specialists. Those tools provide you with insights of what might be wrong on your SQLServer in an quick and easy manner. You don’t need extensive knowledge of SQLServer nor do you need expensive tools to do your primary analysis of what is going wrong And in a lot of cases these tools will tell you that you yourself can fix the problem.

    • Regular Session
    • BI
    • 200
    • English
  • Stop everything! T-SQL tips to make a Developer life easier

    Writing T-SQL queries that perform good in any environment is a challenging task for a Developer. In this session I want to share with you some tips and tricks that can boost the Database Performance. By doing small changes in your T-SQL or in your Database design I can guarantee that your DB's will perform better.

    • Regular Session
    • DEV
    • 100
    • English
  • Streaming Datasets with Microsoft Flow and Power BI

    Streaming datasets offer the right here, right now view of your business. In this session you'll see how easy it is to set up a real-time dashboard in minutes with no code. Starting with an intro of Microsoft Flow, you'll see its array of data sources, triggers and actions. Moving to Power BI you'll see the streaming dataset, their setup & configuration and visualisations. Linking the topics together, you will then see an end-to-end demo of how Flow and Power BI get you up & running with real-time dashboards in a matter of minutes. You will also see some other options of adding additional value to your data by using Microsoft Cognitive Services and Google Map services.

    • Regular Session
    • BI
    • 200
    • English
  • Taming the Beast – How a SQL DBA can keep Kerberos under control

    The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators. What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works

    • Regular Session
    • DBA
    • 300
    • English
  • Temporal Tables - Ein Blick hinter die Kulissen

    Datenanalysten lieben die Auswertung historischer Daten; Datenbankentwickler verzweifeln – teilweise – an den Anforderungen. Welche Technologie stellt Microsoft SQL Server zur Verfügung, um die täglichen Herausforderungen in diesem Aufgabengebiet zu meistern. Mit Microsoft SQL Server 2016 kommen – endlich – Temporal Tables (Ein ANSI 2011 Standard), ein von den Entwicklern lang ersehntes Feature. Mittlerweile gibt es viele Standardbeispiele zur Verwendung von Temporal Tables; diese Session zeigt die technischen Hintergründe und die Besonderheiten, die mit der Verwendung von Temporal Tables einhergehen: • Welche Besonderheiten gilt es bei Temporal Tables und der Verwendung von NULL Werten zu beachten? • Wie bearbeitet Microsoft SQL Server das Umbenennen von Objekten / Attributen, wenn Temporal Tables im Spiel sind? • Trigger in Temporal Tables eher ein No Go? • Wie verhalten sich Veränderung von Metadaten in den Tabellen bei Temporal Tables? • Welche Besonderheiten gibt es zu beachten, wenn Temporal Tables mit InMemory-Tabellen verwendet werden? • Temporal Tables und berechnete Spalten – kann das funktionieren?

    • Regular Session
    • DEV
    • 200
    • German
  • The Force Awakens - Azure SQL Server for the on-prem DBA

    Have you ever been asked what the cloud means for your database environment or wondered if Azure is a viable platform for a new system? If so, look no further! This session begins with an overview of Azure and where SQL Server fits in among the other services of the cloud. It follows with key differences between SQL Server on-prem, SQL Server on a VM, Azure SQL Server and Azure SQL Server Managed Instance, as well as discuss some of the pros, cons, challenges and benefits of putting a database in the cloud in the first place. If you are eager to explore the database offerings in Azure, gain a basic understanding of which toys to use when and develop a plan for harnessing the power of the cloud, then this session will provide the tools you need to step into a new world.

    • Regular Session
    • DBA
    • 100
    • English
  • The In-Memory Engine Is Fast, But How Do I Use It ?

    This session aims to dispel the myth that you need to be running sql server behind a platform processing billions of transactions a day in order to get value from using the in-memory engine. It will present a series of "Low hanging" style use cases, of which there will, THE SPEAKER GUARANTEES !!!, at least one which every single member of the audience will find useful. The session will also provide an overview of the in-memory engine and how it differs from the legacy engine.

    • Regular Session
    • DEV
    • 300
    • English
  • The Internet of Things in the Real World

    nternet connectivity to everyday devices such as light bulbs, thermostats, smart watches, and even voice-command devices is exploding. These connected devices and their respective applications generate large amounts of data that can be mined to enhance user-friendliness and make predictions about what a user might be likely to do next. This demo-heavy session will show how to use simple device and sensors and the Microsoft Azure IoT suite, ideal for collecting data from connected devices, to learn about real-time data acquisition and analysis in an end-to-end, holistic approach to IoT with real-world solutions and ideas.

    • Regular Session
    • DEV
    • 300
    • English
  • The Microsoft Engineer's performance tuning toolbox

    You are a DBA and have a few years’ experience, but you are having performance problems in your SQL Server environment. In this demo-only session, you will learn how Premier Field Engineers at Microsoft troubleshoot performance problems and what tool and scripts they use. We will take a look at tools and scripts like SQLDiag, SQLNexus, PAL, and BPCheck.

    • Regular Session
    • DBA
    • 300
    • English
  • The SSIS Package that tunes itself

    There is a natural limit, on how many dataflows you can run in parallel in SSIS. The limiting factor may be the source or the destination and depending on these systems, your mileage may vary a lot. But there are limits. You’ve set up all the orchestration in a way that made sense at that time. But then some tables grew faster than expected. Others did not grow at all. Due to foreign key relationships, you may also not be able to just shuffle the dataflow tasks around in every kind of way. Manual reengineering would potentially be very time consuming – and the result would be obsolete shortly after. This session is about monitoring and controlling your orchestration based on these restrictions and results using Biml. By automatically analyzing the result of our ETL loggings, we’ll be able to automate our staging orchestration!

    • Regular Session
    • BI
    • 200
    • English
  • Think PowerShell and SQL is meh? Meet dbatools!

    Come and join one of the creators of the most popular SQL Server open source PowerShell module and learn how we have used blog posts from many of the SQL community as inspiration for over 300 commands written by over 80 contributors. Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools. Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve? Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session

    • Regular Session
    • DBA
    • 200
    • English
  • Transaktionale Isolationsstufen im Detail

    Datenbanksysteme sind darauf ausgelegt, viele Anforderungen möglichst schnell und effizient zu verarbeiten. Unterschiedliche Workloads führen zu Anforderungen, die Konkurrenz der Anfragen zu begrenzen/konfigurieren. Dazu stellt Microsoft SQL Server unterschiedliche Isolationsstufen für das ACID-Modell zur Verfügung. In dieser Session werden die unterschiedlichen Isolationsstufen, die ein modernes RDMBS-System zur Verfügung stellt, detailliert beleuchtet. An Hand von unterschiedlichen Workloads / Szenarien werden diese Isolationsstufen erläutert. Pessimistic Locking • READ UNCOMMITTED • READ COMMITTED • REPEATABLE READ • SERIALIZABLE Optimistic Locking • ALLOW_SNAPSHOT • READ COMMITTED SNAPSHOT ISOLATION

    • Regular Session
    • DEV
    • 300
    • German
  • Unit testing databases with tSQLt

    Database changes, normally, are triggered by application changes (a new feature for example) or can be triggered by other reasons (maintenance, performance, …). Either way, database changes and application changes need to be align to avoid breaking the proper behavior of the system. Unit tests at database level helps to avoid database breaking the contract with the application, and ensures that the database have the correct behavior (a stored procedure do what supposed to do, or a specific table/view exists in the database, for example). This talk will address the basic steps to introduce unit testing to databases, SQL Server and Azure Database, using tSQLt (database unit testing framework). So, the plan it’s to show since how to write the first to add a set of database tests to the deployment pipeline.

    • Regular Session
    • DBA
    • 100
    • English
  • Upgrading to SQL Server 2017

    Upgrading to the latest version of SQL Server is often seen as a comprehensive and difficult project. Management often fails to see the benefit for migrating to the latest version and your end users aren't interested in all of the extra testing. As a DBA you need to come up with a plan that earns both management and end-user support. In this session, we will cover all the information you need to collect and consider before, during, and after upgrading to SQL Server 2016. We will discuss licensing, upgrade approaches, and build out your own upgrade checklist. If you feel stuck on an older version of SQL Server, attend this session to understand the features and benefits of SQL Server 2016 that will justify your upgrade project. Come and learn about the tools and methods that will make your upgrade project be successful. You will learn: Pre-upgrade tasks Upgrade tasks and options Post-upgrade tasks

    • Regular Session
    • DBA
    • 300
    • English
  • What can you do with SQL Server on Linux?

    I didn't believe it when I heard the news, many months ago. SQL Server was being ported to Linux. Despite being a SQL Server consultant, I spend most of my computer time on Linux. What I have now is what I thought I couldn't dream of: my favourite RDBMS on my favourite operating system, natively. But do I have the same product? The same performances? the same features? Can I do replication? Can I setup an AlwayOn AG cluster? We'll see in this session!

    • Regular Session
    • DBA
    • 300
    • English
  • What I have seen so far in my performance tuning audits

    Relational databases, SQL databases are wild beasts that need to be gently tamed. We cannot use them like dumb data stores. There are rules. Instead of stating good practices out of the blue, this session is addressing the problem differently. Let's list very common implementation and SQL code antipatterns, which you are guaranteed to have at some level in your company, and see, practically, how to solve them. This session is based on real-world experience I have acquired by auditing clients SQL Server databases in ten years of independant practice.

    • Regular Session
    • DBA
    • 300
    • English
  • What is hidden in the query plan ?

    What are memory grants ? How can we see wait statistics for a query ? Can we have some warnings if our query is misbehaving ? Yes, we can. All those details are now in the query plan. More and more, new version after new version, Microsoft is adding invaluable information in the actual query plan. If you can understand it, you can solve many of your performance problems. In this session, we will open the quey plan, look at its XML content, open Plan Explorer, and analyze some tough queries.

    • Regular Session
    • DBA
    • 400
    • English
  • What Power BI users need to know about R

    You’ve probably already seen that R icon in the Power BI GUI. It shows up when creating sources, transformations and reports. But the ugly textbox you got when you clicked upon those icons didn’t encourage you to proceed? In this session, you will learn just a few basic things about R that will greatly extend your Power BI data loading, transformation and reporting skills in Power BI Desktop and the Power BI service.

    • Regular Session
    • BI
    • 200
    • English
  • What’s new in Azure Analysis Services?

    There are some great new features coming to Azure Analysis Services regarding model partitioning and processing that I would like to discuss and demo. Next to that other new features that will be released in the coming months.

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • What’s new in Azure Data Factory v2?

    An overview of what is new in ADFv2. Content similar to what I blogged recently: https://jorgklein.com/2017/09/26/azure-data-factory-and-ssis-better-together-with-adf-v2-preview/

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • Where Should My Data Live (and Why)?

    Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.

    • Regular Session
    • DBA
    • 100
    • English
  • Who, What, When. Monitoring usage of your MS BI stack

    You have created great cubes and Reporting Services reports but how do you know if it is being used? Learn how to set up the collection of the usage data and how you can use this data in your decision making. We will talk about how to collect the data, how to build something meaningful from the data and how you can report on top of the data. We will do this for SSAS cubes and for Reporting Services Reports and we will explore ways you can further develop this for your own organization. At the end of the session all participants will leave with all the code as well as the know how to get started with the collection of usage statistics for their Microsoft BI Solutions.

    • Regular Session
    • BI
    • 200
    • English
  • Working with Azure Data Factory & Creating Custom Activities

    In this session we’ll go beyond the Azure Data Factory copy activity normally presented using the limited portal wizard. Extract and load are never the hard parts of the pipeline. It is the ability to transform, manipulate and clean data that normally requires more effort. Sadly, this task doesn’t come so naturally to Azure Data Factory as an orchestration tool so we need to rely on its custom activities to break out the C# or VB to perform such tasks. Using Visual Studio, we’ll look at how to do exactly that and see what’s involved in Azure to utilise this pipeline extensibility feature. What handles the compute for the compiled .Net code and how can does this get deployed by ADF. With real world use cases we’ll learn how to fight back against those poorly formed CSV files and what we could to if Excel files are our only data source. Plus, lots of useful tips and tricks along the way when working with this emerging technology.

    • Regular Session
    • BI
    • 200
    • English
  • Working with Very Large Tables Like a Pro in SQL Server 2017

    A common use case in many databases is a very large table, which serves as some kind of activity log, with an ever increasing date/time column. This table is usually partitioned, and it suffers from heavy load of reads and writes. Such a table presents a challenge in terms of maintenance and performance. Activities such as loading data into the table, querying the table, rebuilding indexes or updating statistics become quite challenging. The latest versions of SQL Server, including 2017, offer several new features that can make all these challenges go away. In this session we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation, Delayed Durability and Stretch Database, and we will apply them on our challenging table and see what happens...

    • Regular Session
    • DBA
    • 300
    • English
  • X-ray your processes with process mining

    Process mining is a very powerful technique to get insights in process data. What is it? If you have - a case id (for example orderid or invoiceid) - an event (for example 'created', 'packed', 'sent', 'invoiced') - and a timestamp when the event happened it is possible to visualize your process in 1 minute. From that point it is really easy to analyse throughput times, rework, handover of work between people and so on. I will show you a number of powerful analysis that are hard to reproduce in for example PowerBI. For who? It could help - DBA's to visualize log data and for example quickly find outliers - DEV's to better understand a process using data from an application you are going to replace - BI'ers to have another tool to deliver insights into processes where most other visualization tools fail

    • Regular Session
    • NEWCOMER
    • 200
    • English
  • A day of R for SQL folks

    Dieser ganztägige Workshop stellt die Konzepte und Möglichkeiten der Sprache R vor, im Hinblick auf Datenanalyse, -visualisierung und ein bißchen Data Science. Alle Module sind mit Beispielen versehen, und am Ende des Tages können die Teilnehmer ihre eigenen Datensätze untersuchen und visualisieren, und ihren Aha-Moment erleben. 1 Einführung, Installation, IDEs und Grundlagaen 2 Datengewinnung: aus Dateien, aus den Web, Datenbankzugriff 3 Bereinigen, transformieren, Konzepte des Tidyverse 4 Erkenntnisse durch Visualisierung mit ggplot2 und Freunden 5 Modelle und Prognosen - Grundlagen 6 Ergebnisse präsentieren, online und offline 7 Eure Fragen, Eure Beispiele

    • Full-Day Workshop
    • OTHER
    • 200
    • German
  • A Game of Hierarchies: Hierarchien und Graphen in SQL Server meistern

    Hierarchien und Graphen sind das A und O der meisten Geschäftsanwendungen und gibt es fast überall: Produktkategorien, Verkaufsgebiete, Kalender und Zeit, Organigramme, Stücklisten, (soziale) Netzwerke, etc. Obwohl es großen Bedarf aus der geschäftlichen Perspektive gibt, ist die Lösung in relationalen Datenbank etwas umständlich. Je nach Modellierung sind die Möglichkeiten der Auswertung enger oder weiter gesteckt. In SQL Server 2008 wurde HierarchieID als Unterstützung eingeführt. Mit SQL Server 2017 gibt es eine GraphDB, die in die (relationale) Datanbank integriert ist.

    • Full-Day Workshop
    • DBA
    • 400
    • German
  • Applied Data Science for BI Professionals and DBAs

    Data plays an ever-increasing role in today’s society and provides a wealth of possibilities for you and the organization you work for. As a BI professional and/or DBA you are probably used to working with data every day, but what if business requirements can no longer be met through traditional solutions? In those cases, more-and-more organizations look to data science to provide a solution. But how and where do you start with things like exploratory data analysis or machine learning? Thankfully as a BI professional or DBA you have a head start when it comes to working with data, and through this full day workshop you will learn the additional skills you need to take your first steps in the area of data science! What you will learn during this workshop: • Understand the basic concepts of data science processes and why it’s different than traditional approaches; • Get more familiar with statistical terms and techniques and learn why they are important; • Making a start with programming in the R language; • How to use R and Azure Machine Learning to build your first machine learning models; • Operationalizing your models through various methods like in-database R using SQL Server or through the Azure Machine Learning webservices.

    • Full-Day Workshop
    • OTHER
    • 200
    • English
  • BI in the cloud hands on

    Sie benutzen eine BI Solution und interessiert diese in die Cloud zu bringen? Oder eine BI Solution steht auf ihrer Roadmap und sie sind sich nicht sicher ob On-Prem oder in der Cloud die richtige Strategie ist? Dann ist dieser Tagesworkshop genau das richtige für sie. Dieser Hands-on-Tag wird Ihnen einen ersten Einblick in Möglichkeiten und die Herausforderungen geben. Folgende Themen werden behandelt: - Was ist eine BI Solution - Überblick über die aktuellen Services in Azure und warum sie ihre Architektur überdenken müssen - Data Warehouse, Polybase und Analysis Services in Azure - Bewirtschaftung eines Data Warehouse in Azure mit Azure Data Factory, Logic App, Stream Analytics und dem Data Gateway für Lokale Datenquellen - Reporting in Azure mit Power BI - Administration, Wartung und User Access Voraussetzungen: - Laptop - Azure Account - Basic knowledge in Business Intelligence / Data Warehouse

    • Full-Day Workshop
    • BI
    • 300
    • German
  • Big Data Made Simple

    This pre-conference session provides an introduction to the world of Big Data with an emphasis on the Apache Hadoop platform. It begins with an overview of the challenges and concepts around Big Data, as well as the various data platform types, which evolved in order to address these challenges, such as key-value and columnar databases. The session also includes a detailed review of the current major vendors and products in the market, whether it’s in the cloud or on-premises. It includes a discussion about the pros and cons of each one and a comparison between the different platforms. We will also cover some Big Data use cases and scenarios, choose the best data platform for the job and design the Big Data architecture for each case. Outline a. Defining Big Data 1) Introduction to Big Data 2) Big Data Challenges 3) Big Data Lifecycle Management b. Exploring the Different Big Data Platform Types 1) SMP vs MPP Architectures 2) The MapReduce Programming Model 3) The Relational Data Model 4) The Key-Value Model 5) Document Databases 6) Graph Databases 7) Columnar Data Stores 8) Search Technologies 9) Streaming Analytics 10) Machine Learning c. Leading Vendors and Products 1) Open-Source vs Closed-Source Software 2) Cloud vs. On-Premises 3) The Apache Software Foundation 4) Big Data Market Research 5) Leading Products (Very Long List Here…) d. Introduction to Hadoop 1) Hadoop Distributed File System (HDFS) 2) MapReduce 3) The Hadoop Ecosystem 4) Hadoop Distributions e. Big Data Use Cases 1) Internet of Things (IoT) 2) Funnel Conversion 3) Behavioral Analytics 4) Predictive Analytics 5) Fraud Detection f. Summary 1) Big Data Made Simple 2) Big Data Roadmap 3) Additional Resources

    • Full-Day Workshop
    • OTHER
    • 100
    • English
  • Biml for SSIS from 0 to 100

    Get away from manual SSIS packages and automate their creation using smart metadata models and he Business Intelligence Markup Language (Biml). This session is all about getting away from manual SSIS packages. Instead of reinventing the wheel every time you need to change or extend a package, let’s talk about metadata models and how we can use them to design and describe our data warehouses and packages. We will cover the gamut from initial design, to maintenance and support, and even documentation and compliance. In addition, we’ll see how the Business Intelligence Markup Language (Biml) can help us translate our metadata into a ready-to-use SSIS solution!

    • Full-Day Workshop
    • BI
    • 200
    • English
  • Business Intelligence in Azure - The Lambda Architecture

    Business Intelligence in Azure - The Lambda Architecture (6hrs content, 1hr lunch, 2x 15min breaks) With new cloud services and advancements in locally hosted platforms developing a lambda architecture is becoming the new normal. In this full day of high level training we’ll learn how to architect hybrid business intelligence solutions using Microsoft Azure offerings. We’ll explore the roles of these cloud data services and how to make them work for you in this complete overview of business intelligence on the Microsoft cloud data platform. Module 1 (20mins) – Getting Started with Azure Using platform as a service products is great, but let’s take a step back. To kick off we’ll cover the basics for deployed and managing your Azure services. Navigating the Azure portal and building dashboards isn’t always as intuitive as we’d like. What’s a resource group? And why is it important to understand your Azure Activity Directory tenant? Module 2 (20mins) – An Overview of BI in Azure What’s available for the business intelligence architect in the cloud and how might these services relate to traditional on premises ETL and cube data flows. Is ETL enough for our big unstructured data sources or do we need to mix things up and add some more letters to the acronym in the cloud? Module 3 (60mins) – Databases in Azure (SQL DB, SQL DW, Cosmos DB, SQL MI) It’s SQL Server Jim, but not as we know it. Check out the PaaS flavours of our long term on premises friends. Can we trade the agent and an operating system for that sliding bar of scalable compute? DTU and DWU are here to stay with new SLA’s relating to throughput. Who’s on ACID and as BI people do we care? Module 4 (60mins) – The Azure Machines are here to Learn Data scientist or developer? Azure Machine Learning was designed for applied machine learning. Use best-in-class algorithms in a simple drag-and-drop interface. We’ll go from idea to deployment in a matter of clicks. Without a terminator in sight! Module 5 (60mins) – Swimming in the Data Lake with U-SQL Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake. Module 6 (60mins) – IoT, Event Hubs and Azure Stream Analytics Real-time data is everywhere. We need to use it and unlock it as a rich source of information that can be channelled to react to events, produce alerts from sensor values or in 9000 other scenarios. In this module, we’ll learn how, using Azure messaging hubs and Azure Stream Analytics. Module 7 (20mins) – Power BI, Sematic layer and All Things to All People Combining all our data sources in one place with rich visuals and a flexible data modelling tool. Power BI takes it all, small data, big data, streaming data, website content and more. But we really need a Venn diagram to decide when/where it’s needed. Module 8 (60mins) – Data Integration with Azure Data Factory and SSIS The new integration runtime is here. But how do we unlock the scale out potential of our control flow and data flow? Let’s learn to create the perfect dependency driven pipeline for our data flows. Plus, how to work with the Azure Batch Service should you need that extensibility. All content is subject to change dependant on timings.

    • Full-Day Workshop
    • BI
    • 200
    • English
  • Continuous Delivery for PowerShell modules

    Come and spend a day with Cloud and DataCenter MVP Rob Sewell and take your PowerShell skills to the next level We will have plenty of demos and scripts and discuss - From Scripts to Modules and why - Using VS Code - Using Plaster to create the customised framework for your modules - How to use Script Analyser to help you to code better - Why you should use Test Driven Development and how to do that for your PowerShell modules with Pester - The importance of Get-Help and why you need write good help - The PowerShell Gallery and how to create your own private PowerShell Gallery - How to continuously deliver changes to your PowerShell Module in the gallery using GitHub and VSTS We will have a lot of fun along the way and at the end of the day you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save your organisation time and effort.

    • Full-Day Workshop
    • OTHER
    • 200
    • English
  • Cortana Intelligence Suite: The whole Azure Big Data landscape in 1 day

    Big Data ≠ Hadoop. Microsoft developed over time a bunch of Azure services to load, store, analyze and report upon big data. These services are bundled in the Cortana Intelligence Suite (CIS). And yes, Hadoop (HDInsight) is one of them, but in this 1 day session we mainly focus on the other services in CIS. Although Hadoop is the most well-known approach to big data, it is not always the most user-friendly, cost-effective or most performant solution for every Big Data problem. In this 1 day session you will see many other services in the big data stack being explained and demonstrated: Azure Data Catalog to discover data sources, Azure Data Factory to copy data between on premise and cloud storage, Azure Data Lake and U-SQL to extract data out of semi-structured or unstructured data, Event hubs and IoT hubs, which together with Stream Analytics let us collect and analyze streams of data, and Azure Data Warehouse, which provides tremendous processing power to chew through large volumes of data. But intelligence is not only knowing things, it’s also learning things. That’s where Azure Machine Learning comes into play, either by using pre-defined models or building our own.

    • Full-Day Workshop
    • BI
    • 200
    • English
  • Database DevOps in A Day

    Learn the fundamentals of Database DevOps in a day! In 2009 John Allspaw and Paul Hammond changed the way millions of people would think about the software delivery process for years to come in one forty six minutes session. DevOps folk preach about the cloud, automation, rapid delivery and any database technology that isn't relational In 2013 Kenny Gorman declared "The DBA is Dead". For the record, I don't believe that, but a lot of people do. What is certain is that the world of IT is changing and traditional roles are changing with it. We all need to adapt. During the day we will explain what DevOps is, where it came from, and its implications for SQL Server. We'll demo example solutions to some of the foundational technical challenges (source control and test/deployment automation) and we will leave plenty of time at the end to answer your questions. Bring your laptop and we'll provide you with all that you need to follow along with the demos and take away a working template for database automation! (We will provide full details prior to the event). What We will cover: - Introduction to Devops - The Trouble with Data in a DevOps World -- Migrations vs Model - Source Control, Build, Release -- GitHub -- VSTS -- ReadyRoll - The beauty of containers - Practical Demos to bring back to your workplace - Q and A This will be a very interactive session and we expect you to join in and ask/answer questions. We will all learn from each other and each others experiences. Who You Are: You are an IT Professional who works with relational data and wants to understand and embrace the culture of DevOps with all the associated benefits whilst comforting yourself about the safety and security of your companies data. Your Job Title may be DBA, Development/Operational/Production DBA, Developer, BI Guru, Data Mangler, DevOps Engineer, Architect. It is not important. As long as you are the person, who in a technical role, works with data and delivery of a system, service or product you will benefit from our session.

    • Full-Day Workshop
    • OTHER
    • 300
    • English
  • Designing Azure Infrastructure for Data Platform Projects

    In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier. Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime. As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations.

    • Full-Day Workshop
    • DBA
    • 100
    • English
  • Getting Started with SQL and Microsoft Azure

    Azure and its many SQL offerings can be complex to get started with. Together we will understand the options, where and when to use them. Then through worked examples and labs we will setup, configure and use the different options available. The main areas that will be covered in this training day are: • Azure platform essentials • Azure SQL Database • Azure SQL Database Managed Instance • SQL Server in Containers • SQL Server in Azure Virtual Machines With a mix of theory and hands on labs. By the end of the day you will be able to make informed recommendations to your peers on which is the appropriate technology to use for a given task.

    • Full-Day Workshop
    • OTHER
    • 200
    • English
  • Indexanalyse und Performancesteigerung

    Nicht immer ist die Konfiguration des Microsoft SQL Server die Ursache für eine schlecht performende Applikation. Sehr häufig sind es Fehler im Design der Datenbanken, Indexe oder eine Mischung aus allen Komponenten. In diesem Workshop lernen Sie die unterschiedlichen Indextypen kennen, die in einem OLTP-System verwendet werden können. Neben den Grundlagen der Indexierung werden DMV vorgestellt, die eine Analyse von Indexen ermöglichen. Ausgestattet mit den Grundlagen der Indexierung und den eingesetzten Werkzeugen wird in vielen detaillierten Beispielen gezeigt, wie Indexengpässe analysiert, bewertet und gelöst werden.

    • Full-Day Workshop
    • DEV
    • 400
    • German
  • Modernize Your SQL Date Warehouse with Hadoop

    Modernize your data warehouse with SQL Server 2017, HortonWorks and Polybase. We will discuss installations and configurations for each, and include the pros, cons and when and why to use this architecture.

    • Full-Day Workshop
    • BI
    • 400
    • English
  • Power BI Round Trip in one Day

    Power BI – Is it THE new Business Intelligence Tool from Microsoft? Is it the holy grail of reporting? In this whole day workshop, I would like to take you on an expedition into the Power BI jungle: Powerbi.com, Power BI Desktop, Power BI on-premises and Power BI Premium - what are the differences and which tool is the right for which use case? Stuffed with numerous examples the different aspects of Power BI are demonstrated including their pros and cons. Self-service analysis requirements are compared and tried to fit with enterprise reporting demands. The Power BI journey starts with simple reports, jumps on to data modelling, collaboration, usage of on-premises data, touches administration and concludes with Power BI for developers and future prospects. During the day, the following topics are discussed: • History of Power BI and Self-service analysis • Powerbi.com vs Power BI Desktop vs Power BI on-premises vs Power BI Premium o What are the differences? Who’s the best choice for what? o Dataset – Report - Dashboard o Data first – visualization later o Data Access modes – Import versus DirectQuery o Data Analysis done right (and simple) o Ask me anything (about my data-model) – Power BI Q&A • Power BI Desktop – Advanced Data Modelling o Power the Query & Model the Data (M, Query Folding, Relationships, Functions, Parameters, ..) o Best Practices • Give the Model more Power – DAX in Action o What is DAX? o Power BI and DAX? • Reports – Beyond the Basics o Let’s talk about Drill Down, Filtering, Custom Visuals, Best Practices, Maps, Templates, Advanced Reporting techniques • Collaboration / Security / Distribution o How does Power BI sharing work? o Which Power BI artefacts can be shared? o Power BI Groups o Is it possible to filter data for certain user groups? o Power BI Apps • Mobile Experience • powerbi.com and on-premises Data o What is needed to connect the on-premises and cloud world? o Which gateway options are available? o Is there an instant data refresh or can it be scheduled? o Is there a way of streaming data to Power BI (aka doing Real-Time analysis)? • Data Refresh o Which ways are available for data refresh? • Power BI On-Premises: Power BI Report Server (PBIRS) o What is Power BI Report Server? o What are the differences between PBIRS and powerbi.com? o What are the differences between SSRS and PBIRS? o How can PBIRS be licensed? • Power BI Premium o Why a premium offering? o What are the differences between powerbi.com and Power BI Premium? o What are the costs and which licenses are required? • Licensing and Costs o What are the differences? o Can Free and Pro licenses be mixed in one tenant? o How do I get a Power BI Pro license? • Administration o What can be administered? o Is it possible to prevent certain actions for Power BI users? If time permits: • Excel and Power BI – best friends? o Excel Power Pivot versus Power BI o Analyze your Power BI Dataset in Excel o Excel Add-Ins – Power BI Publisher • Power BI for Developers o Power BI REST API o Power BI Real Time o Power BI Embedded o Power BI Custom Visuals • Roadmap and Power BI Resources o Power BI in the context of the Microsoft Reporting Roadmap o Power BI is an extremely agile product – How do I stay up-to-date? What are recommended resources? o Power BI community o Power BI ideas – “I think XXXX is a great new feature.. But how do I inform the Power BI team about my idea?”

    • Full-Day Workshop
    • BI
    • 200
    • German
  • PowerShell for all engines - Relational, RS, AS, IS

    In this session we will see which options we have, using PowerShell, to automate our needs and we go deepen with them for each engine (relational, RS, AS, IS) in ! - Want to migrate entire instances? Or just get information from all your estate in one line of code? - Deploy dozens of SSRS reports or copy hundreds of subscriptions? - What about processing dimensions or cubes? - Are you an SSIS person? I will show how you can collect information from Integration Services Catalog or change variables inside the projects. This is just a small sneak peak about some scenarios that we will cover. We will have a plenty of demos based on real daily basis scenarios. We will cover the basics of PowerShell and then we will leverage on existing Microsoft cmdlets (SQLServer module) and also open source projects such as dbatools and ReportingServicesTools. After this session you have learnt how to save dozens of hours of work in order to accomplish your tasks by adding this tools to your tool-belt. Also, if you have some special needs, at least you will leave with the basics to do further investigation and apply it to your reality!

    • Full-Day Workshop
    • DBA
    • 200
    • English
  • PowerShell on Linux - Skills to Manage Your Heterogenous Data Center

    PowerShell is now available on Linux and Mac and you want to use it to manage your multi-platform data center. In this workshop we will introduce Open Source PowerShell and learn why this is such a groundbreaking technology shift. Then we’ll get into the essentials of using PowerShell on Linux and Mac, we’ll start with installing Powershell and building PowerShell from source, work our way into using cmdlets and bash integration, building pipelines, remoting scenarios with heterogenous operating systems and discuss Desired State Configuration. Objectives Set up your environment for multi-platform management Bash and PowerShell scripting fundamentals Building command pipelines in Bash and PowerShell Toolmaking in Powershell Configure remoting in multi-platform environments Configuration management basics with Desired State Configuration Topics covered in the workshop: • Setting up your OpenSource PowerShell environment • Working with PowerShell cmdlets and bash integration • Comparing the PowerShell pipeline and a UNIX style text-based pipeline • PowerShell concepts for building more general toolmaking • Remoting in multi-platform environments • Leveraging OpenSource PowerShell in your data centers with Desired State Configuration • What’s next and limitations Attendee’s desired pre-requisites/profile This is the fundamental level workshop. This workshop's intent is to introduce you to the technologies and get you started. Attendees should a have basic understanding of the Windows and Linux operating systems. Required/Suggested Materials and Software Not necessary

    • Full-Day Workshop
    • DBA
    • 100
    • English
  • Practical Performance Monitoring & Troubleshooting SQL Server

    You are in a DBA, Developer or Consultant role, supporting SQL Server Databases and often someone asks you to take a look at a badly performing database application, certain queries or even “the whole server”. And over and over again you find yourself in the situation of “how to find the root cause in the least amount of time”. This full-day Precon will teach you techniques for general troubleshooting and performance analysis from start-up to advanced techniques. Among them are: • SQL Server Architecture & Internals – the fundament to understanding complex correlations • Monitoring Methodology, Tools & Techniques o Dynamic Management Views (DMVs) o Wait Statistics o Extended Events for Workload & Query-Analysis o Query Store • Investigating Memory Problems • Identifying and Remediating Plan Regression • Analysis of Indexes & Statistics • Detecting I/O Latency problems • Investigating Tempdb Performance • Locking & Blocking Analysis, Concurrency problems • Third-Party Tools Overview While no one has evolved into a Performance-Tuning-Master in one single day, you can be sure to learn valuable techniques and concepts to build upon for day-to-day work. And of course, we will also discuss possible solutions or even implement them live. So, at your next phone call “Help, the server is slow!” you know will where to start. Expect lots of demos and a deep dive into core concepts of SQL Server. Hands-on: If you want to play along please bring a laptop running SQL Server 2016 or 2017, with at least 5GB of free drive space for the demo databases and workload. But you are welcome to just sit back and consume this one fully packed one day precon. Prerequisites: Basic understanding of the SQL Server relational engine and Transact-SQL, Basic familiarity with Dynamic Management Views (DMVs) and Query Plans

    • Full-Day Workshop
    • DBA
    • 300
    • English
  • Prepare and serve machine learning models with AzureML

    Every business needs to guess. From core business (Will this customer default on its loan?) to IT management (How much disk space will this new database need?) they are making lots of decisions daily using some sort of ‘model’: from gut-feeling over averages up to linear regression. Machine learning offers more advanced techniques to build a model on historical data and apply this to new observations. In this one day pre-con we walk through the full process of building these models on AzureML, the cloud-based machine learning framework Microsoft released in summer 2014. We start from scratch, so no machine learning nor statistical knowledge is required. First we need to figure out what we try to cook: not all business problems can be solved with AzureML. After discussing which problems can be tackled by AzureML, we start looking for the main ingredients: data. Also we investigate how to clean these ingredients: data preparation is a crucial step! Then it’s time to do the actual cooking: There are many machine learning algorithms available in AzureML: we’ll browse through them and give some intuition on what they do, such that we can configure them properly. Once we’re done cooking it’s time to serve the result. AzureML allows us to convert our process into a web service. We’ll see both how to create and consume this.

    • Full-Day Workshop
    • BI
    • 200
    • English
  • Real-World ETL Design Patterns using SSIS and Biml

    ETL can be one of the most difficult and time-consuming parts of building a Data Warehouse. In this full-day workshop, you will learn best practices, techniques and design patterns that will help you steer away from common pitfalls that are made early in the ETL design process. We will start with an overview of ETL architectural approaches and SSIS frameworks, then show you how you can automate your SSIS development by using Biml. Next, we will go through load patterns for Staging and Data Warehouse layers, including incremental loads and slowly-changing dimensions. Finally, we will look at how to log, configure, orchestrate and tune our solution. Part 1: ETL Architecture and Design Considerations - Staging Design Patterns - Data Warehouse Design Patterns - SSIS Frameworks Part 2: Automating SSIS with Biml - Introduction to Biml and BimlScript - Biml Code Management - Designing and Consuming Metadata Part 3: Staging Load Patterns - Sources and Data Profiling - Data Cleansing and Transforming - Incremental Loads Part 4: Data Warehouse Load Patterns - Handling Data Change - Data Enrichment - Fact and Dimension Loads Part 5: Operations and Performance - Logging and Error Handling - Configuration, Deployment and Orchestration - Optimizing and Tuning Whether you are new to SSIS or have years of experience, you will leave this workshop with new techniques to build your first Data Warehouse or enhance your current ETL solution.

    • Full-Day Workshop
    • BI
    • 300
    • English
  • Show it Right! An In-Depth Guide to Visualization

    Course Description In this full-day session, you will learn the ins and outs of data visualization. The focus of this course is to help beginners and experts alike refine their visualization process. Participants will not just learn the theories and concepts of visualization, but the actual process to successfully implement them including the why's and not just the how-tos. Get hands on experience as we work through a complete cycle from the initial request to the successful delivery of the visualization. Join us for this session and become the visualization rock star you know you know you can be! Intended Audience · Database professionals wanting to learn more about perfecting their report writing · Business intelligence professionals trying to get more impact from their work · Anyone with a need to visualize data or just a curiosity about it Course Topics The following topics will be addressed during the course · Background and History · Schools of thought · Types of Data and Visuals · Data to Ink Ratios · Redefining requirement gathering · Storyboarding · Mockup Development · How we see the world · Choosing the right tool · Choosing the right chart\graph · Applying knowledge Course Objectives Upon completion of this course, attendees will be able to: · Understands the Why's and not just the How's of visualization · Understand key visualization concepts · Have a better process for eliminating rework through better requirement gathering · Determine what the best tool for the job actually should be · Determine the best visual to use to convey the story you want to tell · Understand how to get maximum impact from color choice · Become an organizational go-to person for visualizations · Complete an end to end visualization project in Power BI Prerequisites The only prerequisite for this course is a curiosity in visualization! Bring a laptop to make sure you can take part in the hands-on activities!

    • Full-Day Workshop
    • BI
    • 100
    • English
  • Show me the cache!

    Did you know that RAM has 1000x faster response than the fastest SSD, even PCIe? Although sometimes can be related to money, actually the cache is the crucial component if you want your SQL perform the best possible! No wonder that memory-optimized tables emerged and evolved in SQL 2016. Around 50 types of cache exist in SQL Server and they can tell you a lot about your system, its problems and how you might improve it. We will concentrate on the biggest and the most important ones, also caches related to memory-optimized objects and columnstore indexes.

    • Full-Day Workshop
    • DBA
    • 400
    • English
  • Software Development Life Cycle for databases as a part of nowadays DevOps

    Nowadays the DevOps is the topic number one in many industries and companies. However, in some case, you see that the code repository is or will be the most important topic. The number of tasks could be overwhelming at first glance, however, there is no other way - you have to use the new tools and solutions The code repository term is not really new but the way it is integrated with the database world is still sometimes questioned. And there are a lot more than that just naming Continuous integration, Continuous Delivery or Continuous Deployment. We would like to show you tools to efficiently manage database projects (SQL Server Data Tools), how to start working with projects, how to deal with problems you will probably see during daily operations and how to configure and manage the projects' deployment process on different environments. We will go to the Software Development Life Cycle (SDLC) process in great details from the database point of view. But we will not spend too much time on analysis but rather on the development part. We would like to show the usage of the Octopus application. Of course, there will be an entire module about best practices and how to efficiently use them in the database projects. At the end, we would like to touch the cloud and show how to migrate the existing on-premises database to the Microsoft Azure SQL Database and how no to get into troubles. After attending in our workshop you will be able to do / know: * create empty or import existing databases * resolve various problems during the import of database * manage database project and its objects * handling CLR objects * store data in a project (static data, dictionary, etc.) * what should be a part of project and what shouldn't (Linked Servers, security) * where and how to keep SQL Jobs * split database project into more chunks and why it's required sometimes * cope with unlimited amount of projects * Avoid known issues like: temp tables, triggers, circular references, OPENQUERY, lack of validation * Migrate project to Microsoft Azure (Cloud!) * Use hybrid approach * Apply tSQLt Unit Tests * Make a deployment manually and automatically (Octopus) * Distinguish (finally) all three types of "Continuous" * some helpful PowerShell scripts We are going to show you commercial tools as well as some tips& tricks as well. Requirements: Basic TSQL knowledge Basic Visual Studio knowledge The workshop will be done in the Visual Studio 2017 with the newest SSDT installed but you can use older version of the Visual Studio as well You can take your laptop with you as most of the task we are going to do with you! You will have access to all codes we present plus you will get printable version of the slide deck Trainers: Kamil Nowiński @NowinskiK Damian Widera @DamianWidera (SQLPlayer Team) - http://SQLPlayer.net (blog)

    • Full-Day Workshop
    • DEV
    • 300
    • English
  • SQL Server on Linux: Install, Configure, and Manage

    You’ve been managing SQL Server configuration, backups, and troubleshooting for a couple of years, but that was on Windows. Now, you’re looking at implementing SQL Server 2017 on Linux. Things are different on Linux. You want to learn enough Linux to be a good DBA – to install, configure, monitor, and troubleshoot SQL Server on Linux. In this workshop we’ll dive into SQL on Linux and get things started with installation and configuration, cover SQL on Linux fundamentals such as SQLPAL and SQLOSv2, installing, configuring and administering SQL Server on Linux. Topics include: Linux Fundamentals for Windows Admins Introduction and SQL Server on Linux Architecture Installing and Configuring SQL Server on Linux Administering SQL Server on Linux Configuration Best Practices Linux Performance Monitoring Backing up and Restoring SQL Server on Linux

    • Full-Day Workshop
    • DBA
    • 200
    • English
  • SQL Server Query Performance Tuning

    You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what? In this pre-conference session we will analyze common use cases of poorly performing queries, such as the improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. The topics in this session are relevant for SQL Server versions 2005 through 2016. We will also demonstrate some of the new features introduced in SQL Server 2016. At the end of the session, you'll have a list of tips and techniques to apply in your environment. Outline - Analyzing Execution Plans - Search Arguments - Data Type Issues - Indexes Best Practices - Temporary Tables vs. Table Variables - (Not) Using Cursors - (Not) Using Scalar Functions - Working with Parameters and Variables - Skewed Data Distribution - Window Functions - LOB Data - Manipulating Hierarchies - Row Identifiers - Manipulating Statistics - And More, As Time Permits…

    • Full-Day Workshop
    • DEV
    • 300
    • English
  • SQL Server Security in a nutshell. One day which saves your job.

    TITLE: SQL Server Security in a nutshell. One day which saves your job. ABSTRACT: Data breach. Security Risk. The leak of the Data. Yahoo. Ashley Madison. Local Government Authority. European Union Directive. We heard those headlines almost every week, even not every week. Not - what happens? Why does it happen? Someone attack infrastructure. Someone want to steal data. Someone want to get our secrets. Who the hell is responsible for it? General Manager? Security Officer? Windows Administrator? DBA? After data breach, this is the first question. What answer could be? It's not my fault, look somewhere else mistake. Are you confident to say this? Are you sure that you did everything which was possible to protect data under YOUR control? On the full day training before SQLDay 2017, we will talk about security. Seriously. PART ONE: (morning till coffee break) {level 200} Basics of the security. Best Practices. Worst Practices. Sharing Experience. TOP 10 OWASP. TOP 10 (or maybe just TOP 1) security issues for databases. Everything which is connected with security for databases. Principles, SWOT and Risk Analysis. Responsibility, compliance and governance rules. GRANT. ALLOW. DENY. PART TWO: (coffee break till lunch) {level 300} In this module, we will focus on SQLServer on-premise, based on our knowledge from the first module. Accounts, Users, Logins, Passwords. Transparent Data Encryption or Always Encrypted or maybe Row Level Security? Location of data, operating systems (not only Windows). Source Control. BACKUP GO. RESTORE OFF. PART THREE: (lunch till afternoon tea) {level 300} In this module, we will touch the sky. We will focus on Windows Azure Platform and Services. SQL Azure Database. Transparent Data Encryption, Data Masking, Key Vault and few other services and functionalities we will touch. CONNECTION TERMINATED. PART FOUR: (afternoon tea till evening) {level ???} In final module we will try to find the best way (based on several factors) to make our environment, our data secure. It will be a game, it will be a challenge but after all, you will know - how secure your data are. And what you should/need to do for bringing the security of your data level up. But be aware - we will not talk only about data. We will talk about DBA too. YOU. YES, YOU! REQUIREMENTS FOR ORGANIZER: • desk with space • wired connection (preferred for speaker) if not possible • wireless connection (separated from attendees) if not possible just good connection • please check that port 1433/1434 are open on both (speaker and attendees) networks • wireless connection for attendees • Desk (in class or oval/L/T style) room with place for laptops, notes with power connection • One big wall with possible to stick big paper on the wall • flipchart Proposed time schedule (as almost always could be change) • PART ONE: (morning till coffee break) {level 200} | 08:30-10:15 {105 min} • PART TWO: (coffee break till lunch) {level 300} | 10-45:12:30 {105 min) • PART THREE: (lunch till afternoon tea) {level 300} | 13:30-15:15 (105 min) • PART FOUR: (afternoon tea till evening) {level ???} | 15:45-17:30 {105 min) EXTRAS: (after hours discussions) 17:30-18:00 {30 min}

    • Full-Day Workshop
    • DBA
    • 200
    • English
  • The Best SQL Server Best Practices

    SQL Server is an enterprise level data platform with so many components and features. As a DBA or developer, you already know how to configure, troubleshoot, design and program in SQL Server. But there are so many hidden gems and less known features that have a great impact, either on performance, availability or security. Guy Glantser, with 20 years of experience in the field, collected 30 tips and best practices you may not be aware of, which will help you in your daily work with SQL Server. Here are a few examples: - What is trace flag 3226 and why should you be using it? - How to troubleshoot tempdb space usage? - How to efficiently manage nested transactions? - Why you should avoid using table variables? The topics in this session are relevant for SQL Server versions 2005 through 2016. We will also demonstrate some of the new features introduced in SQL Server 2016. At the end of the session, you'll have a long list of tips and techniques to apply in your environment. Outline 1. SQL Server Setup Best Practices 2. Don’t Use Table Variables 3. Don’t Use Cursors with Data 4. Don’t Use Scalar User-Defined Functions 5. File Sizing 6. Choosing the Right Indexes 7. Refactoring Opportunities 8. Contention on Allocation Pages in tempdb 9. The ARITHABORT Problem 10. Cost is Always Estimated 11. How to Read Execution Plans 12. Query Hints and Plan Guides 13. Parameter Sniffing Issues 14. Parameters vs. Local Variables 15. Simple vs. Forced Parameterization 16. LOB Storage 17. Monitor Query Statistics 18. The Ascending Key Problem 19. Delayed Durability 20. Remove an IDENTITY Property 21. Dynamic Stored Procedure Execution 22. Logon Triggers 23. Server Properties – Processors Page 24. Managing Hierarchies 25. Row Identifier Design Best Practices 26. Managing Nested Transactions 27. Update Top N Rows 28. Transaction Log Internals 29. Troubleshooting tempdb Space Usage 30. How to Investigate Dropped Objects

    • Full-Day Workshop
    • DBA
    • 300
    • English
  • Troubleshooting SQL Server, it's all in the process.

    It's 03:00, your phone has gone off telling you that something is not right at work. Now what? Troubleshooting SQL Server and a Data Platform system is all about having a process and following the clues. Working through to identifying the root cause and then solving the problem. However, in my experience a lot of this goes out the window when a major issue arises and the pressure increases. Here we will spend a day working building a process that you can use, as well as building a toolkit of scripts and tools you can use to help get at the data you need. We will spend the morning looking at some of the theory such as why a process is important and how to capture information. As well as familiarization with a number of free tools that make troubleshooting a lot easier. In the afternoon, we will have some fun with some hands on troubleshooting. You will be putting into practice the theory and tools that were covered in the morning. Identifying issues and finding the root cause. By the end of the day, you will be walking away confident that you can effectively troubleshoot problems. Whether it is 03:00 or 15:00.

    • Full-Day Workshop
    • DBA
    • 200
    • English
  • Tuning optional filters

    "Catch-all" queries are very common, found in nearly every database. You know those "give me a row with this @ID or give me all rows if @ID is -1"? That is an optional filter, and probably you have a combination of multiple. Tuning them is a nightmare that sometimes even professionals fail to solve completely. Such queries are sometimes fast and suddenly get slow without apparent reason, bringing server to its knees if often executed. You will see the secret mastery and wizardry of achieving the best possible performance for those queries, and understand internals of SQL Server deeper than before. Bringing your company huge benefits in smooth databases performance and increase your customers' satisfaction.

    • Full-Day Workshop
    • DEV
    • 300
    • English
  • Windows Azure SQL Database-A Journey from Zero to be Hero

    DBA's World, Architect's World changing very quickly. We observed a lot of changes in our IT systems in last three, four even five years. One of the parts of the vision of Architecture in the Future is Microsoft Azure Platform. From last seven years, the only one thing in this environment is constant: The Change. Still not too well understood. This year - 2018 - (few months after premiere newest SQL Server 2017) is a good time to learn more about Azure. To learn more about Microsoft Azure platform and Windows Azure SQL Database. During the entire day of my seminar will start from the standard on-premises instances, then we fly into the Clouds to touch the sky. At the end, we back to the Earth, where again we explore how, when, where, what, and why we should focus on this platform. On my full day Pre-Conf, I want to show you how we can work with Windows Azure SQL Database (formerly known as SQL Azure) and we will focus on • pros and cons • differences • where to start • security • tools, methods, and ideas • SWOT analyze • backup and restore • Service Level Agreements • compliance and responsibility • best and worst practices Slides, talks, exercises and demos with SQL Server on Premises, SQL Server in the Cloud, In eight (or maybe nine hours) you will learn everything about what you need to start your own journey to the cloud.

    • Full-Day Workshop
    • DBA
    • 200
    • English
  • Working with SQL Server & Containers - Deep dive

    SQL Server has been available to run in containers for a while now and offers the ability to transform how SQL instances are deployed. Starting off from the simple installation process and finishing with advanced configuration, this workshop will provide attendees with a deep dive into this exciting new technology.

    • Full-Day Workshop
    • DBA
    • 300
    • English
Call for Speakers powered by Sessionize.com icon-company icon-blog icon-linkedin icon-other icon-twitter