• Applying Agile in Business Intelligence

    In this presentation, we will be discussing the merits of Agile processes in Business Intelligence (BI) development.
    First of all the focus will be on explaining the differences between Agile methodology and Waterfall processes in BI and why Agile is here to stay.
    Agile requires a specific mindset in BI projects due to our full stack mindset and we will spend time giving pointers on what rules can make your communication with the business more fluent.
    This will include the value of maintaining live documentation for both business and developer.
    We then look at why there are technical limitations for implementing Agile that are specific to BI and examples of how to overcome these.
    One of the tools we will look at Test Driven Development (TDD) and Behaviour Driven Development (BDD) and how these apply for a BI setting.
    By following the previous notes we can describe how we're pragmatically going to apply these principles, and elaborate on splitting up the different scopes in a project (staging, Data Warehouse, and reporting layers). This will, in turn, enhance the quality of our deliverables.
    By the end of this session, you will have a better understanding of Agile development in BI, and some tools of how to apply this to your day to day operations.

    Anzünder
    Thu 09:15 - 10:30
    • English
    • Business Intelligence

  • Ready for take-off - How to get your databases into the cloud

    "Cloud: the next frontier.
    These are the voyages of enterprise databases. Their mission: to move all its data to the cloud; to help administrators and developers build stable and scaling applications; to empower every organization on the planet to achieve more."

    In this talk, we will have a look at how to get your databases into the cloud. What are the possibilities? Which effort is needed? And even how to get the data movement started.

    Sit back and enjoy the safe and smooth journey of your databases to the cloud.

    Zange
    Thu 09:15 - 10:30
    • German
    • DBA/Admin
    • Cloud

  • 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.

    Spieß
    Thu 09:15 - 10:30
    • English
    • Big Data / NoSQL

  • TensorFlow & Co as a Service

    Wer mit beliebten KI-Frameworks, wie beispielsweise TensorFlow, CNTK, Caffe, Chainer & Co, ein Modell bauen wollte, musste sich bislang selbst um die komplette Infrastruktur kümmern und seine Data Science IDE entsprechend konfigurieren.
    Doch das hat jetzt ein Ende.
    In dieser Session zeigt Sascha Dittmann wie man mit dem Azure Machine Learning Service und weiteren Diensten, wie beispielsweise Azure Batch AI eine durchgängige und einfach zu nutzende Data Science Umgebung aufbaut. Mit dieser lassen sich dann im großem Umfang parallel experimentieren, sowie Deep Learning- und KI-Modelle trainieren.

    Grillrost
    Thu 09:15 - 10:30
    • German
    • Cloud
    • Advanced Analytics

  • 15 can't miss commands in dbatools 1.0

    From finding all of your SQL Server instances to masking your data to supporting VLDB migrations, we had some lofty goals for dbatools 1.0. In this session, you'll find out more about the must-haves the team wanted to include before going RTM.

    Handschuh
    Thu 09:15 - 10:30
    • English
    • DBA/Admin
    • DevOps
    • Automation

  • Introduction to Advanced Analytics on Azure Databricks

    Azure Databricks provides Data Engineers, Data Scientists and Business analytics with an awesome unified analytics platform workspace that allows for collaboration right across their analytics pipelines.

    In this session, I'll use live demos to show you how easy it is to get started with Azure Databricks, start working with different types of data and use the combined power of Spark and Machine Learning to get some amazing insights out of your data which you can communicate to all types of business stakeholders.

    Anzünder
    Thu 11:00 - 12:15
    • English
    • Cloud
    • Advanced Analytics
    • Big Data / NoSQL

  • 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.

    Zange
    Thu 11:00 - 12:15
    • English
    • DBA/Admin
    • Cloud

  • 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.

    Spieß
    Thu 11:00 - 12:15
    • German
    • DBA/Admin
    • Development
    • DevOps

  • SQL Server 2019 Big Data Clusters

    Big Data Clusters are probably the biggest feature in SQL Server 2019. They provide additional AI, ML, Scale Out and Data virtualization capabilities.

    But what does that mean?

    We will take a deeper look at the extended Polybase options (Data Virtualization) as well as the option to integrate and query Big Data in SQL Server with the use of Kubernetes Clusters, Spark, Notebooks and more!

    This session covers all aspects of Big Data Clusters from deployment to the final big data solution.

    Grillrost
    Thu 11:00 - 12:15
    • English
    • Information Management
    • Big Data / NoSQL

  • Benchmarking in the cloud

    Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on premises is hard enough, but benchmarking in the cloud can get really hairy because of the restrictions in PaaS environments and the lack of tooling.
    Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
    With WorkloadTools, benchmarking will be as easy as pie.

    Handschuh
    Thu 11:00 - 12:15
    • English
    • DBA/Admin

  • Dat kannse zwar so machen, aber dann isset....

    Dieser Vortrag ist ein kleiner Themenmix. Es geht über Fehler im SQL Server Umfeld, die ich selbst in der Vergangenheit gemacht habe.
    Über Fehler, die andere gemacht haben und wie ich diese behoben habe bzw. welche Alternativen gefunden wurden.
    Und über einige Fehlinformationen, die ich sogar noch in jüngerer Zeit über den SQL Server gehört oder gelesen habe.

    In diesem Vortrag geht es nicht um irgendwelche speziellen Konfigurationskniffe, „schwarze“ T-SQL Magie oder Ähnlichem,
    sondern schon fast um banale Punkte rund um die Themen: AlwaysOn, Maintenance und Security.

    Anzünder
    Thu 13:15 - 14:30
    • German
    • DBA/Admin

  • Sql Agent In The Cloud

    Azure’s Platform as a Service solution, SQL Azure is a compelling solution for many who don’t want to manage their own highly available SQL implementation. SQL Azure, however, does not replicate all of the services of on-premises SQL, and one of those missing is the SQL Agent.

    This session looks at what alternatives exist for running and managing SQL jobs in Azure without SQL Agent. In particular, we focus on Elastic Database Jobs, Azure Automation and Azure Functions. The presentation includes a brief overview of these services and how they are applicable to SQL workloads, followed by demos creating and running SQL jobs.

    Zange
    Thu 13:15 - 14:30
    • English
    • Cloud
    • Automation

  • Power BI Cheat Sheet explained!

    In this demo-rich session, Dave & Marc discuss the Power BI Cheat Sheet that went viral on social media. The sheet is crammed with Power BI tips and best practices based on years of experience, but with little to no room for comments. No worries! We will describe, demonstrate and discuss all the items! And of course, there will be a Cheat Sheet for everyone attending!

    Spieß
    Thu 13:15 - 14:30
    • English
    • Cloud
    • Business Intelligence

  • Hands on with Machine Learning

    Looking at the code & approach to a number of hands-on Machine Learning projects, including:
    - Creating a basic predictive model and deploying as a web service
    - Using pre-built Azure Cognitive Services
    - Using Python to build a deep learning neural net that can play games

    Grillrost
    Thu 13:15 - 14:30
    • English
    • Advanced Analytics

  • Approaching Zero: Minimizing Downtime During Deployments

    Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

    Handschuh
    Thu 13:15 - 14:30
    • English
    • DBA/Admin

  • Easing the pain of database migrations, a closer look at the new cloud citizen - DMS

    An essential part of migrating your application workload to the cloud is how to transfer your data securely to its new home. If you in addition want to change the underlying database system, for instance Oracle to SQL Server, it can quickly escalate to an overwhelming task. What if your application have a very high uptime requirement and your database is so large that you don't have a downtime window long enough to do a traditional backup/restore operation?
    In order to overcome these pain points we have now available, both in Azure and AWS, services and tools that alleviate these pains and brings your valuable data safely across with near-zero downtime.

    In this talk we will:
    - Guide you through how to set up a migration process with checks and balances
    - Compare the schema analysis and conversion tools provided by AWS and Microsoft
    - Compare the migration services provided by AWS and Azure
    - Demonstrate near-zero-downtime migration for a live database on AWS and Azure

    Anzünder
    Thu 15:00 - 16:15
    • English
    • DBA/Admin
    • Cloud

  • Administrating SSRS/PBIRS was a boring task! Sorry...did you said WAS?

    Do you manage one or many SQL Server Reporting Services instances? Or even the newest PowerBI Report Server? 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/PBIRS management tasks? The module counts with more than 40 commands and the community is the main responsible for 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.

    Zange
    Thu 15:00 - 16:15
    • English
    • DBA/Admin
    • Automation

  • SQL Notebooks in Azure Data Studio for the DBA

    An Azure Data Studio recent release introduced SQL Notebooks as a capability.

    While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.

    You will learn about SQL Notebooks from installing them in Azure Data Studio to creating a Notebook for Glenn Berry's Diagnostic queries as well as numerous use cases for you to use in your daily workload

    Spieß
    Thu 15:00 - 16:15
    • English
    • DBA/Admin

  • Designing an Impactful KPI Scorecard in Power BI

    Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Learn about some great custom visuals in conjunction with DAX calculations to build out a quality scorecard template to use in your business. The scorecard talk will be broken down into three sections. Section One will cover the basics of the report layout & design, native card visuals, and supporting DAX. Section Two will cover custom visuals, KPI’s, and additional supporting DAX. The final Section Three will cover visualization practices and design principals to clean up the report for delivery to the client.

    Grillrost
    Thu 15:00 - 16:15
    • English
    • Business Intelligence

  • Database DevOps with Containers and Azure DevOps

    Containers are becoming ever popular but other than spinning one up to have a play around with SQL Server 2019 CTP's new features, what else can they be used for?

    In this demo heavy session we will show how Containers along with VSTS (now Azure DevOps) can be the perfect solution for your CI/CD pipeline.

    You will leave this session with the ability to start creating your own bespoke SQL Server development / testing environments with automated image builds and testing of the deployed changes.

    Handschuh
    Thu 15:00 - 16:15
    • English
    • Development
    • DevOps

  • You can run SQL Server on AWS?

    In this session, I aim to show the different ways of running SQL Server on AWS. I will show the differences between running as a managed service (RDS) and running SQL Server on virtual machines (EC2). I will show the pros and con of both methods and I’ll also show AWS console.

    This purpose of this post is to show that you do have options when it comes to the cloud. Azure is great however If you are working for a company or client already heavily invested in AWS, it may make more sense to stay there. Even if not, AWS’s SQL Server offering is mature and RDS’s features are improving all the time.

    Anzünder
    Thu 16:45 - 18:00
    • English
    • DBA/Admin
    • Cloud

  • ETL with Azure Databricks, The Complete Introduction

    Azure Databricks seems to be the new sheriff in town. It promises easy but capable ETL (amongst other things). But how does it work? For an SSIS (and possibly BIML) person this all looks new and strange. Python notebooks? Scala? Spark? What is all this, and where do I start? Well, you start by coming to this presentation. We’ll take a look at how to approach making an Azure Databricks based ETL solution from start to finish. Along the way it will become clear how Azure Databricks works and we will use our SSIS based ETL knowledge to see if it can handle the common use-cases from our daily jobs. And of course we will also have some fun and see how fast it can go!

    Spieß
    Thu 16:45 - 18:00
    • English
    • Cloud
    • Development
    • Business Intelligence
    • Big Data / NoSQL

  • 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 analysing demonic possession based on selfies, to analysing how "metal" a song is. In this session we will explore all the crazy things that are possible with data science. And who knows? You might even learn a thing or two!

    Grillrost
    Thu 16:45 - 18:00
    • English
    • Advanced Analytics

  • Expand your CI/CD pipeline

    So, I've got my initial CI/CD pipeline set up, and now I want to work with data.
    What happens If I want to drop a column? What are my options if I want to prevent certain changes to certain tables? Can I source control data of my lookup tables?

    In this demo-rich session we look at the data side of CI/CD, because, hey, the code side is easy!

    Handschuh
    Thu 16:45 - 18:00
    • English
    • DevOps
    • Automation

  • Azure SQL Managed Instance - Experiencies from the Field

    In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Managed Instance on production environments. You will learn how to monitor, configure, restore, backup, VNET, NGS, created a replication environment, etc for Azure SQL Managed Instance. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.

    Anzünder
    Fri 09:15 - 10:30
    • English
    • DBA/Admin
    • Cloud
    • Automation

  • 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.

    Zange
    Fri 09:15 - 10:30
    • English
    • Cloud
    • Advanced Analytics
    • Big Data / NoSQL

  • Dive into Azure SQL Database Managed Instance

    Azure SQL DB Managed Instance is here, Microsoft want us to use it, but what is it good for and how should you use it? Let us get past the marketing hype and take a more in-depth look at Managed Instance and see what we can do with it.

    To get the most out of Managed Instance you need to understand the Azure infrastructure that underpins it and how this behaves, as well as understanding the differences between General Purpose and Business Critical tiers.

    There is far more to Managed Instance than meets the eye and if you do not understand the details then you run the risk of spending a lot more money and not getting the performance you want.
    During this training day we will cover the core Azure infrastructure components that underpin Managed Instance and look at how these can impact its usability and performance. We will work through use cases and migration scenarios that are available for us to use when it comes to making the jump to Azure. We will also look at how applications that use with SQL Server on-premises can be updated to get the most out of Managed Instance, including authentication and high-level architecture.

    Spieß
    Fri 09:15 - 10:30
    • English
    • DBA/Admin
    • Cloud
    • Development

  • ETL in Azure made easy with Data Factory Data Flow

    What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure. In this session we’ll look at Azure Data Factory v2 and how it integrates with Azure Data Bricks to produce a powerful abstraction over the Apache Spark analytics ecosystem. Now we can transform data in Azure using Data Bricks but without the need to write a single line of Scala or Python! If you haven’t used either service yet, don’t worry, you’ll get a quick introduction to both before we go deeper into the new ADF Data Flow feature.

    Grillrost
    Fri 09:15 - 10:30
    • English
    • Cloud
    • Advanced Analytics
    • Business Intelligence

  • The Microsoft Power Platform - What is it?

    May I introduce you to the Microsoft Power Platform!?

    This new term was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications. PowerApps as the data manipulation part, Microsoft Flow as the connecting workflow engine and Power BI for analysis and reporting. In addition, the Common Data Service (CDS) and the Common Data Model (CDM) provide a solid framework for data storage and modelling.

    Join me in this session if you want to get an overview about the involved technologies, how they work together, see them live & working together in many demos and how they will definitely change the way of building powerful solutions in the future!

    Handschuh
    Fri 09:15 - 10:30
    • English
    • Cloud
    • Development
    • Business Intelligence

  • Arguing with myself - self-service BI from an infrastructure perspective

    Self-service BI is coming, and as an infrastructure professional it's time to either get with the program or get run over. The infrastructure control that the IT department spent years consolidating is starting to unravel, and left to its own devices, self-service BI will spell as much technical doom as business boom. But what IS "self-service BI", what can it provide and why would the infrastructure people care? This session outlines how the notion of self-service BI really impacts the technical infrastructure, explains the risks of a governance disaster, and tells the story of how a Power BI implementation skirted disaster and turned into a success - all done in three different voices and from two different viewpoints.

    Anzünder
    Fri 11:00 - 12:15
    • English
    • Information Management
    • Business Intelligence

  • 3 tips for getting executive buy-in for DevOps

    DevOps practices are powerful tools to build productive, engaged teams who constantly learn and regularly deliver value to their customers. High DevOps performers report greater workplace satisfaction than their peers. But implementing DevOps isn’t a matter of being great at writing code: to become a high DevOps performer, you need the powerful catalyst of executive support. In this talk, we will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. We will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation. You will leave the session with a fresh take on how to discuss DevOps with company leaders, and an understanding of how to explain the value of DevOps to people in these roles.

    Zange
    Fri 11:00 - 12:15
    • English
    • DevOps
    • Personal/Professional Development

  • SQL Server 2019 Always Encrypted: The Searchable Encryption!

    With SQL Server 2019 Microsoft added a feature to Always Encrypted called Secure Enclaves,
    which enables us to easily search through encrypted data.
    In this session we'll take a look at what this feature exactly is, how it works,
    and how we can utilize it to maximize our data security.

    Spieß
    Fri 11:00 - 12:15
    • English
    • Development

  • 3 ways to bring Power BI under Source Control

    People love creating content in Power BI but how do we track changes or backup all these new reports? We’ll look at 3 different ways to bring your reports under source control and how to automate the process using Microsoft Flow, AzureDevOps and PowerShell.

    Grillrost
    Fri 11:00 - 12:15
    • English
    • Cloud
    • DevOps
    • Business Intelligence
    • Automation

  • Azure Cognitive Services - AI for everyone?

    Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs, and services that developers can use to make their applications smarter, more engaging, and more discoverable. Cognitive Services extend Microsoft's AI platform.

    This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.

    Handschuh
    Fri 11:00 - 12:15
    • English
    • Cloud
    • Advanced Analytics

  • Uhms and Bunny Hands: Tips for Improving Your Presentation Skills

    Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Have you already presented a few sessions and want advice on how to improve? Do you learn more from seeing examples of what you should NOT do during a presentation instead of reading a list of bullet points on how to become a better speaker?

    Don't worry! I have made plenty of presentation mistakes over the years so you won't have to :)

    In this session, we will go through common presentation mistakes and how you can avoid them, as well as how you can prepare for those dreaded worst-case scenarios. Don't let those "uhms" and "uhhs" dominate your presentation, help the audience focus on the key message you're delivering instead of making them read a wall of text in your slides, recover gracefully from any demo failures, and stop distracting your attendees with floppy bunny hands.

    All it takes is a little preparation and practice. You can do this!

    Anzünder
    Fri 13:15 - 14:30
    • English
    • Personal/Professional Development

  • The ABCDs of testing your data ​

    This session is for any Data Professional who cares about the state of both their data and database.

    The session will educate you on how:
    Automated Builds,
    Containers,
    & DevOps
    ​(the ABCDs)
    can help protect your data.

    We will look at Unit Testing, Test Driven Development, Integration testing as well as what free tools are in the industry. Containers are a game changer for testing and part of the DEMO will showcase how you can incorporate running SQL Server in containers as part of your data testing regime.

    A comprehensive DEMO will reveal how using automated builds, containers and DevOps processes can help you deploy your database code changes safer.

    Zange
    Fri 13:15 - 14:30
    • English
    • DBA/Admin
    • Cloud
    • Development
    • DevOps
    • Automation

  • From Data Lake to DAX Query

    Collecting data from and combining data out of different data sources is the essential requirement for BI. In times of cloud services this is getting a lot easier.
    Azure offers a variety of services that work hand in hand and can be fully automated using PowerShell or.NET.

    In this session we will show an example of how data from various sources such as FTP, databases or streaming data can be loaded via ADF and processed in Azure Data Lake.

    But getting the information out of Azure Data Lake still requires a special scill set and doesn‘t allow for usage by the broader audience or standard visualization tools. This is a typical requirement of Azure Analysis Services.

    But how to implement the model ? Can this even be automized in a way?
    We will present you one approach to accomplish this.

    Spieß
    Fri 13:15 - 14:30
    • German
    • Cloud
    • Information Management
    • Business Intelligence

  • Inside Kubernetes - Architecture Fundamentals

    In this session we will introduce Kubernetes, we’ll dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, and Deployments and how they can be used to ensure the desired state of an application and data platform deployed in Kubernetes. By the end of this session, you will understand what's needed to put your applications and data platform in production in a Kubernetes cluster

    Session Objectives:
    Understand Kubernetes cluster architecture
    Understand Services, Controllers, and Deployments
    Deploying applications in Kuberenetes

    Grillrost
    Fri 13:15 - 14:30
    • English
    • DBA/Admin
    • Cloud
    • DevOps

  • Microsoft Power BI Premium: Building enterprise-grade models

    Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session will dive deep into exciting, new and upcoming features including aggregations for big data to unlock petabyte-scale datasets that was not possible before! The session will focus on performance, scalability, and DAX improvements. Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations

    Handschuh
    Fri 13:15 - 14:30
    • English
    • Information Management
    • Advanced Analytics
    • Business Intelligence

  • Install & Configure SQL Server with PowerShell DSC

    Get on the cutting edge by implementing infrastructure as code for your SQL Server environment. Using PowerShell Desired State Configuration (DSC) we'll look at how to take a newly built Windows Server and get it ready for prime time while discussing the benefits associated with infrastructure as code.

    - Setup Pre-Requisites
    - Install SQL Server
    - Configure SQL Server
    - Make SQL Server Application Ready

    Anzünder
    Fri 15:00 - 16:15
    • English
    • DBA/Admin
    • Automation

  • Data Security and Privacy Techniques for Modern Databases

    Data security and privacy is big challenge. With so much data flowing in and out of servers it’s easy to understand how data breaches take months to discover. For decades our industry placed a value on performance at the cost of security. Those days are over. Data security and privacy are now at the forefront of any project.

    In this session we will examine available tools and methods to protect data at rest, in use, and in motion. Topics for discussion will include:
    - Data discovery and classification
    - Data encryption
    - Data masking
    - SQL injection
    - Audit and threat detection
    - Penetration testing

    Attend this session and leave with confidence knowing you have the ability to lower the risk of suffering an expensive data breach. Don’t wait until tomorrow, start securing your data today.

    Zange
    Fri 15:00 - 16:15
    • English
    • DBA/Admin
    • Information Management

  • 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.

    Spieß
    Fri 15:00 - 16:15
    • English
    • DBA/Admin
    • Cloud

  • Power BI Report design Tips and Tricks

    "A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports 

    In this session you’ll learn about:
    - How to use background images and useful resources to create the background templates 
    - Use of colours, various resources to get appealing colour pallets 
    - Multiple ways of using conditional formatting to highlight the specific data points 
    - How to create Power BI theme files 
    - Various DataViz resources"

    Grillrost
    Fri 15:00 - 16:15
    • English
    • Information Management
    • Advanced Analytics
    • Business Intelligence

  • Use advanced Power BI techniques for text mining

    In the age where we are overloaded with information it becomes essential to identify what to read first. For this reason a Power BI app helps to analyze all the emails using methods from text mining and text analysis. Using just the Power BI tool stack this solution makes email analysis versatile and easy to use.
    This session provides a short introduction into text mining and text analysis and demonstrates how certain concepts can be utilized using Power BI. Throughout this session some advanced techniques from the whole Power BI stack are applied, ranging from Power Query, to data modeling topics, to advanced DAX usage, even Cognitive Services are incorporated in this analytical pipeline. Technics are used to filter out stop words from the email body and to create a whitelist to easily discover emails that contain content that is of special interest.

    Handschuh
    Fri 15:00 - 16:15
    • German
    • Advanced Analytics
    • Business Intelligence

  • 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.

    Anzünder
    Fri 16:45 - 18:00
    • German
    • DBA/Admin

  • From adaptive to intelligent: query processing in SQL 2019

    As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.

    In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.

    Zange
    Fri 16:45 - 18:00
    • English
    • DBA/Admin
    • Development

  • Profiling Your Data

    Have you ever started a warehouse or ETL project and realized that the data wasn't as "clean" as you were told? If only you had profiled your data before you started then you wouldn't have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.

    Spieß
    Fri 16:45 - 18:00
    • English
    • DBA/Admin
    • Development
    • Information Management
    • Business Intelligence

  • The modern Cloud Data Warehouse - Snowflake on Azure

    The era of cloud data warehousing has finally begun. Gone are the days where you had to provision expensive servers and spend days configuring and tweaking to get the technical details right. Using cloud infrastructure, we can skip past the technical set-up and start loading data immediately.

    Snowflake is a vendor offering a native cloud data warehouse, hosted on Azure. In this session, we'll introduce you to this new technology and explain the important concepts to get you started. Walking out of this session, you'll have all the knowledge you need to embark a project with Snowflake.

    Grillrost
    Fri 16:45 - 18:00
    • English
    • Cloud
    • Business Intelligence
    • Big Data / NoSQL

  • Modeling scenarios in DAX, the awesome language of Power BI

    The right tabular modeling is the cornerstone that allows us to build the best dashboards, control panels and analytical models. In this session, we will analyze some scenarios of data modeling by using DAX and Power BI. These scenarios, which come from real projects, can also be adapted to tabular models with SQL Server Analysis Services in SQL Server Data Tools and Power Pivot in Excel.

    Handschuh
    Fri 16:45 - 18:00
    • English
    • Advanced Analytics
    • Business Intelligence
Session and Speaker Management powered by Sessionize.com