• Connecting to your data securely with Synapse and Data Factory Integration Runtimes

    Moving data from A to B has been made easy through the use of integration tools such as Azure Data Factory and Azure Synapse Pipelines, but when you’re working inside a highly secured environment, the reference architecture quickly goes out the window. How do you enable secure data movement into your data platform? How do you easily move data around in private networks? Azure provides many options beyond the default Azure-hosted Integration Runtime but which one is right and how do we set them up?

    In this talk I will explore how the different types of Data Factory and Synapse Integration Runtimes can be used to access and transfer data in a secure network topology. I will discuss some common secure architectures and explain how Integration Runtimes can fit into these designs to facilitate simple yet secure data integration.

    Anzünder
    Thu 10:00 am - 11:00 am

  • Branding Yourself for a Dream Job

    Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it’s important to raise your profile in today’s highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.

    Grillrost
    Thu 10:00 am - 11:00 am

  • The Untruthful Art - Five Ways of Misrepresenting Data

    In this age of information it is imperative to be able to be able to clearly, simply and accurately explain and communicate sometimes complex data.
    Right at the intersection of journalism and statistics lies visual communication - the art of using data, charts and maps to convey information.
    This has been called "the truthful art" as it is an extremely powerful tool that must be wielded with the utmost care.

    Just like any other tools, however, it can be used for sinister purposes. This session is all about exploring ways that data can be misrepresented to further a goal - while still seem perfectly reasonable. It is intended as an eye opener for anyone interested in the how and why of data deception.

    We will walk through five stories and explore where the trickery is hidden, discuss a more honest way of communicate the information as well as look at ways to spot potential foul play with data.

    Holzkohle
    Thu 10:00 am - 11:00 am

  • Performing successful cloud migrations - Chalk & Talk

    Moving databases to the cloud is relatively easy, but doing it in a way that ensures successful outcomes for our business or customers is less so. The database is one piece of a larger puzzle, putting all the pieces together is important.

    Together we will look at a scenario, then walk through and discuss just what it would take to make it work and answer any questions you might have about the process.

    This session will focus on the situations, questions, and challenges that need to be overcome rather than specific technologies.

    Bierbank
    Thu 10:00 am - 11:00 am

  • Dimensions demystified

    Dimensions; something you probably use on a day-to-day basis when building a star model in Power BI. But, did you know there are many types of dimensions? A slowly changing dimension, junk dimension, role playing dimension and degenerate dimension, they might already be part of your model without you even knowing! Therefore, in this session I will explain these type of dimensions and how they could help you optimize your data model.

    Anzünder
    Thu 11:15 am - 12:15 pm

  • A deep dive into Docker

    Running SQL Server in a Docker container has many benefits (and drawbacks!) that we as SQL professionals should be aware of.

    In this demo heavy session we'll dive deeper into running SQL Server in Docker containers. We'll cover: -

    What exactly is container isolation?
    Container networking
    Persisting data for SQL Server in Docker containers
    Building custom SQL Docker images
    Running SQL containers with Docker Compose

    This session is for anyone who has run SQL Server in a container and wants to learn more about the platform

    Grillrost
    Thu 11:15 am - 12:15 pm

  • Cloud Scale Analytics

    Do you have an outdated data architecture that can't keep up with the latest requirements? Is the notion of "data as a product" becoming more important in your organization? Do you need an ecosystem of data products rather than the one all-encompassing data warehouse that may not be best suited for your data scenario? And a unified approach to enforce data governance and security across the enterprise?

    Then you've come to the right place to learn how Microsoft's Cloud Scale Analytics approach can help you deploy infrastructures in Azure that provide a scalable, manageable and controlled analytics platform.

    Holzkohle
    Thu 11:15 am - 12:15 pm

  • Understanding Azure Active Directory for Data Professionals

    Security is more important than ever in our interconnected world. As workloads move into Azure, our security model shifts from on-premises Active Directory to Azure Active Directory (AAD), which uses a different authentication model called OAuth. You will learn about how AAD interacts with SQL resources and other resources in Azure, and how to design authentication models for complex cloud applications and databases.

    Bierbank
    Thu 11:15 am - 12:15 pm

  • Racing with/on Azure

    How racecar data can be captured, engineered and analyzed with all the flexibility thats available in Azure.

    Anzünder
    Thu 1:15 pm - 2:15 pm

  • How We Provided A dbatools Training Day at SQLBits using devcontainers

    In March Jess and I gave a Training Day for 5 million* attendees about dbatools.

    For those that dont know, dbatools is the most popular SQL Server open source PowerShell module and has used blog posts from many of the SQL community as inspiration for over 900 million* commands written by over 4tn* contributors.

    As we did not know even right up till the day whether we would be delivering together or separately, in person or remotely, we decided to put our demo into a repository and deliver it from a controlled environment (two containers) using GitHub Actions, Docker Hub and VS Code.

    We learned some things along the way and had some fun also and we shall share this all with you.

    * It is highly likely that some numbers may have been exaggerated

    Grillrost
    Thu 1:15 pm - 2:15 pm

  • How does SQL Server store that data type?

    If you've ever been curious about how each data type looks on your storage subsystem, this is the session for you. We'll step through each data type, and how the hex looks at the storage layer.

    You will understand why certain data types are better choices than others. I'll show you a few surprises, and settle an old score with DATETIME.

    Breaking out the hex editor might automatically qualify this as a 500-level session depending on your appetite for nerdy goodness, plus you should be able to use this information for data recovery (like I have).

    Holzkohle
    Thu 1:15 pm - 2:15 pm

  • Problematic projects and what we can learn from them

    At conferences we talk a lot about doing the right things and what this right things could be. But even though everyone made experiences with problems in projects - nobody I know was blessed with projects where everything was going perfect -, we talk rarely about failures and what to do, when everything is falling apart.
    Thinking about my previous career and what experiences I made, I learned the most with a big gap in projects or situations, that were problematic. I didn't want to go through those failures again, so I learned what to do to prevent them.
    But it is not neccessary that everyone has to go through the same failures, we can and should learn from each other.
    This is the reason, why I want to talk about my worst projects in an interactive session and what concrete learnings I could make, hoping it encourages you to do the same.
    You didn't found a good solution of your problems in projects in the past? This is also fine, let's discuss what could have been done. Maybe someone with a similar situation is there and did find a way to handle it.

    So let's talk about our "Worst Of" projects and how to prevent them for us and for other.

    Bierbank
    Thu 1:15 pm - 2:15 pm

  • Troubleshooting Power BI Reports

    So you've built a Power BI report with all the shinies? Good!
    After some usage, users have reacted that it's a bit sluggish in usage, and they're not keen on using it anymore.

    Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
    With the myriad of root causes that are out there, an elimination approach might suit us very well.
    Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.

    This talk will place emphasis on leveraging external free community tools to assess the state of the data model, and go further on fixing the groundworks of your solution.

    Attendees should note that is not a DAX Deep Dive class, before wandering in :-)

    Anzünder
    Thu 2:30 pm - 3:30 pm

  • Data Governance with Azure Purview

    Azure Purview is Microsoft's answer to Data Governance and Data Lineage.
    But what is Azure Purview actually?
    During this session I will give answers on the following questions:
    • How can we manage and govern our on-premises, multi-cloud, and software-as-a-service (SaaS) data?
    • How can we classify our data?
    • How can we use data lineage?
    • How can we integrate Azure Purview in Azure Synapse Analytics, Azure Data Factory and Power BI?
    • How can we get control on access and use of data?
    After this session you should exactly know what Azure Purview can mean for you and your company.

    Grillrost
    Thu 2:30 pm - 3:30 pm

  • Time Series for relational people

    Relational databases have been around for 40 years and they are a great choice for most data management needs. On the other hand, telemetry data has some properties that make it not exactly a great fit for a relational database. The last few years have seen the rise of time series databases, specialized for data that has a time attribute.
    Join me to see what a time series database is, how it works and how you can use it in your projects. I will demonstrate how this technology enables new possibilities and overcomes some limitations of relational databases. Are you working with IOT telemetry data or performance metrics? This is the session for you!

    Holzkohle
    Thu 2:30 pm - 3:30 pm

  • Containers - VB6 Edition!

    Learn what you need to know to package those legacy applications that you just can't seem to get rid of as containers and deploy them at scale in the cloud using Kubernetes! We'll discuss key concepts like building bespoke Windows-based containers, controlling application roll-outs by using advanced Kubernetes deployment techniques and then crossing your fingers and performance management for business critical VB6 applications or just paying for more hardware in the cloud!

    Bierbank
    Thu 2:30 pm - 3:30 pm

  • Improving Team Collaboration Using Database Projects and Azure DevOps

    Having source control in place sounds like the default these days. Although, a lot of companies didn't implement source control yet. This session will guide you how to setup source control step by step, using Database Projects and Azure DevOps. The session is devided in 3 courses: appetizer / starter , main course and finally dessert.

    At the beginning of the session, we will start with the appetizer/starter: a couple of use cases will be explained why it is important to use source control within your organization (use cases out of personal experiences how things went terribly wrong / took a lot of time because of the lack of source control). Some examples: deployments take a lot of time, change of priorities, urgent bugfixing, fast growing team perhaps...

    As soon as main course is served, multiple ways how to setup source control will be explained step by step in multiple demo's. Do you want to have everything in source control at once or would you like a phased approach, everything is possible if you know how to start. Principles of Git will be explained shortly. The demo's will demonstrate the ease of use of Database Projects at first and the integration with source control in a second phase.

    For dessert, a couple of topics will be covered how to move forward after a successful implementation of database projects and Azure DevOps since this is only the beginning. What about peer reviewing, testing or Automatic deployments?

    At the end of the session you should have a starting position to be able to start your adventure and where you might get to in the end.

    Anzünder
    Thu 3:45 pm - 4:45 pm

  • Power BI Composite and Hybrid Models

    Learn how to take Power BI to the next level to support BIG data, layering logic over the top of an existing dataset for unlimited flexibility, and find out how hybrid models can help bridge the gap between Direct Query and Import.

    This session will look at 'Composite models' as well as 'Direct Query over Datasets' and 'Hybrid models' to see how they can enhance our Power BI world, as well as understanding the pros, cons and use cases of each.

    Using a combination of live demos and theory, this session will explain and show the concepts, leaving you ready to experiment with your own data.

    Grillrost
    Thu 3:45 pm - 4:45 pm

  • Save money and maximize performance of yours SQL Server VM on Azure IaaS

    Even if the Azure SQL portfolio is full of PaaS services that can support almost any SQL workload, Azure SQL VMs are still relevant for many customers.

    Suppose you're working in a hybrid BCDR scenario or have to deal with an application that needs complete control over SQL Server or the operating system, or you need extreme performance. In that case, an Azure SQL VM might be the right choice for you.
    Unfortunately, it's also one of the more complex ways to obtain a SQL Server instance in Azure.
    A less-than-optimal configuration can compromise the performance or the availability of the instance, with a potential impact on licensing costs.

    Of course, you can click on a SQL Server image from Azure Marketplace. Still, these pre-built instances are meant to be used in a large variety of scenarios and consequently use generic settings which aren't optimized from a performance point of view.

    This session will cover all the topics you should know while deploying a suitable virtual machine to host a SQL Server instance that won't drain your wallet.
    We'll briefly explore the key aspects you want to address while sizing a virtual machine and what IaaS features you can leverage to avoid sizing it for the peaks. Then, let's quickly go through all the operating system and SQL Server settings that Microsoft suggests configuring to improve the performance and availability of your solution.

    Holzkohle
    Thu 3:45 pm - 4:45 pm

  • Performance Tuning Azure SQL Database

    Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.

    Bierbank
    Thu 3:45 pm - 4:45 pm

  • Building trust in your data. Why data governance is the key to success.

    Data governance is seen as boring and something you don't really need. But it is in fact the key to success for your data platform. As the amount of data sources, as well as the size of the data from the various sources increases - how can your users know what data is available? Or where to find it and what state it is in? When your users trust the data you deliver, they will use what you develop.
    Another aspect to that trust is personal identifiable information - can citizens trust that you keep their data safe and respect their privacy?
    This session will show you how to establish both kinds of trust, using Azure native tooling as well as third-party tools. But most importantly - tips on methodology, routines and people!

    Anzünder
    Thu 5:00 pm - 6:00 pm

  • Cracking the Power BI performance!

    Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more...

    And, if you feel lost, I don't blame you - I've also been there!

    That's why this session is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.

    And, I'll tell you a little secret: there are no slides in this session - from the beginning to the very end, we'll be only in Power BI Desktop!

    Grillrost
    Thu 5:00 pm - 6:00 pm

  • Ransomware Sucks. Beef Up Your Databases Against It.

    How can you protect your databases against ransomware? What about mitigations after you've been hit? Join this session to get tons of tips and ideas on how to deal with one of the worst cyber threats out there.

    Holzkohle
    Thu 5:00 pm - 6:00 pm

  • Test Driven Database Development

    Test Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test coverage, it's automated and it gives us good regression testing.

    To isolate the unit tests, so that they only verify the behaviour of an invidiual method or function, everything outside of the function is mocked. This is a really good idea. If we write a function ConvertCurrency and that function calls service GetCurrencyRate(date,currency), create a mock service which always returns the same value.

    How about unit tests for the service GetCurrencyRate? The service probably gets the currency rate for a certain date/currency combination from a database, perhaps through the stored procedure call Finance.GetCurrencyRate. And just like the unit tests for ConvertCurrency uses a mock service for GetCurrencyRate, the unit test for GetCurrencyRate will use a mock for the stored procedure Finance.GetCurrencyRate.

    But who will test the stored procedure Finance.GetCurrencyRate?

    In this session we will talk about test driven database development. How we can apply the TDD methodology to database development. We will look at the most common unit testing frameworks and how they integrate with database development environments. We will look at unit test design and how we can isolate unit tests to only test the logic of an individual statement, view, stored procedure or user defined function.

    Bierbank
    Thu 5:00 pm - 6:00 pm

  • Analytics at scale with Power BI and Azure Synapse Analytics

    For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabillities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons.

    The advanced capabilties of both worlds can really complement eachother. Learn how to design and build a truly scalable solution that spans both Power BI and Azure Synapse Analytics. We will help you to get the best out of both worlds, sharing our learnings and best-practices along the way in a demo-rich session!

    After the session you will be able to:
    • Better design and implement complex data models, including hybrid tables, aggregations, and combined storage modes (import, DirectQuery, dual).
    • Orchestrate the end-to-end data processing, with a pipeline chain from data ingest in the data lakehouse to the incremental Power BI dataset refresh.
    • Use different techniques to identify performance bottlenecks in your solutions and how to solve those ("does it fold"?).
    • Implement a cost-efficient solution, that still meets the scalability demands.

    Anzünder
    Fri 8:45 am - 9:45 am

  • Azure Data Factory for Beginners: Let's Make some Data

    Does Azure Data Factory really make data? Of course not, but what it does is allow you to make your data into something new and different! In this presentation you will learn the basics of Azure Data Factory, what it DOES do, the sections of the “factory”, and how to build a basic factory output. You will learn the basic skills of a Data Factory “machinist” and how to rebuild your data.

    Grillrost
    Fri 8:45 am - 9:45 am

  • DevOps for Databricks

    Applying DevOps to Databricks can be a daunting task. In this talk this will be broken down into bite size chunks. Common DevOps subject areas will be covered, including CI/CD (Continuous Integration/Continuous Deployment), IAC (Infrastructure as Code) and Build Agents.

    We will explore how to apply DevOps to Databricks, primarily using Azure DevOps tooling, but we will also explore the alternatives, including Github Actions. As a lot of Spark/Databricks users are Python users, we will look at the Databricks Rest API (using Python) to perform CI/CD tasks. For IAC we will primarily look at Terraform, but also explore other options, including ARM templates, Azure Bicep and Pulumi

    As data professionals come with a variety of different backgrounds and skill sets, this talk will focus on providing options, and live demos, that demonstrate ways of achieving a DevOps solution that can be understood and maintained by everyone

    Holzkohle
    Fri 8:45 am - 9:45 am

  • SQL Server and PowerShell walk into a bar...

    Managing SQL Server can be very exciting, but there are times when one needs to do a number of similar operations and it may become frustrating.

    In this session, you will learn about PowerShell community modules that will help you to manage the SQL Server in a way you only dreamed of years ago.

    The talk will cover dbatools and dbachecks, as well as importExcel.

    Bierbank
    Fri 8:45 am - 9:45 am

  • Bratwurst, Beer and Binaries: A conversation about stereotypes and unconscious bias

    We use different languages every day, for all kinds of communication. But how we use language matters, in not only how we see the world and what we understand it, but also how we shape it. Join this session to find out more.

    Anzünder
    Fri 10:00 am - 11:00 am

  • Designing Data Architectures that InfoSec will actually approve

    Building your data platform in the cloud is easy, but as soon as that dreaded word "security" becomes involved it suddenly becomes incredibly painful. How do you go about integrating it with your existing networking, how do you manage user security, what on earth is a private endpoint? Over the past year, a lot of these tools have evolved and we now have a set of mature patterns we can apply to actually make a modern data platform secure.

    In this session we'll guide you from through a secure reference architecture with Data Factory, Databricks, Data Lake, and Azure Synapse, working together as a secure, fully productionised platform. Each has their own idiosyncrasies, but this session will teach you the options available and the pitfalls to avoid.

    Grillrost
    Fri 10:00 am - 11:00 am

  • Building the Internet of Hams

    When we are talking about digitalization of production processes, most people think about big machinery and large factories. But digitalization is not only for global players, even individually crafted goods can be produced data-driven.
    In this session, I will show, how I digitalized my private ham smoking production and how I was able to capture and analyze the data in the cloud. Thus building the internet of Hams.

    Holzkohle
    Fri 10:00 am - 11:00 am

  • Looking under the hood of the parquet format

    Understanding how this format works helps with understanding why it can help you retreive your data fast, or perhaps why you struggle to get the desired performance out of your design.
    And since the formats significantly overlap in architecture, this session can help you with design choices also if you're not using parquet but are using the SQL Server based columnstore type instead.
    This is a bit of a deeper dive into the inner workings. But it's not merely aimed at satisfying the geek inside us. The goal of this session is to provide you with practical guidance through knowing well enough how it works internally.

    Bierbank
    Fri 10:00 am - 11:00 am

  • Choosing the Right Data Store--An Overview of Azure Data Platform Choices

    Choosing the right data store can make or break the performance and costs of your application. In this session, you will learn about all the options available to you in the Azure Data Platform. You'll learn about CosmosDB, Azure SQL Database, Azure Postgres and MySQL services, as well as Databricks and HDInsight. You will also learn how to leverage caching to reduce the overall workload on your data tier. We will discuss the notion of polyglot persistence, storing different data in different data stores with the goal of optimizing your overall data architecture, for flexibility and performance.

    Anzünder
    Fri 11:15 am - 12:15 pm

  • Deploying Azure Resources with PowerShell Azure Functions

    Sometimes we want to make things easier for ourselves with just one simple click to deploy all our resources.
    With Azure Function you have the ability to access Azure and create resources using PowerShell.
    Come to our session and learn how awesome Azure Functions can be to setup your entire environment

    Grillrost
    Fri 11:15 am - 12:15 pm

  • Building an Azure Data Resource with Bicep

    As you know Azure Resources can be built via ARM Templates. In this demo packed session german Data Platform MVP Frank Geisler will show how to build Azure Data Resoures with Bicep, the new way of declarative creating Azure Resources.

    Holzkohle
    Fri 11:15 am - 12:15 pm

  • Lessons learned from 5 years of Power BI implementations

    Power BI has come a long way since it has been on the market for over 5 years. In that time we have seem Power BI grow from self service to full blown enterprise BI platform. In this session we will share the most important lessons learned over that time to be successful and avoid pitfalls for example with self service vs enterprise, modelling, performance, security, data lakes, COE and exec sponsorship.

    Bierbank
    Fri 11:15 am - 12:15 pm

  • The Data Talks Back: Speech & Language AI for the Data Professional

    AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for data professionals to enable richer reporting, create chatbots to answer repetitive questions, or just bolster their resume for their next job. Even though my day-to-day job is a DBA/Data Architect, I've worked with these AI technologies for years to provide instant information to my employees, enable richer interactions on internal and external websites, and easily localize apps and documentation to local languages. Want to know more about AI and how it can help you? Attend this session. Want to know more about AI and how it can help you level up in your career? Attend this session. Want to know more about how much fun it is to play with Language and Speech in Cognitive Services? Attend this session. Let's kickoff your AI journey, wherever it leads, together!

    Anzünder
    Fri 1:15 pm - 2:15 pm

  • SQL Server Partitioning from Zero to Hero

    Ever since the incident, you’ve been wanting to learn more about database partitioning in SQL Server. This session walks you through what partitioning really does, and what it doesn’t do. We’ll take a look at some of the quirks of partitioning, as well as how to use it to boost performance, enable high(er) availability, and even build lightning-fast data retention policies.

    Grillrost
    Fri 1:15 pm - 2:15 pm

  • That's So Metadata: Discover Your Database From The Inside

    Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

    SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

    - Document your database schema objects such as procedures, functions, tables, columns and indexes
    - Investigate performance and look for bottlenecks and tuning opportunities
    - Discover metadata to administer your databases backups, index maintenance, and security
    - Apply your own metadata using extended properties

    We will also cover the official Microsoft documentation on these features and other resources on how to use them.

    Holzkohle
    Fri 1:15 pm - 2:15 pm

  • About the journey to find the best beef ah..data in your organization - And how Azure Purview helps

    To know your data estate and where data of a certain kind is stored and processed is one of the main pillars of data governance. A data cataloguing tool is the answer to solve these questions in an (semi-) automated way.
    Azure Purview was introduced to support you on your journey to a better understanding of your data systems, their dependencies and how easy it is to find the (beef/bratwurst/tofu/vegetable) data!

    Bierbank
    Fri 1:15 pm - 2:15 pm

  • Banishing Slow Queries with SQL Server 2019 Intelligent Query Processing

    Slow queries can be the bane of any data professionals existence. Let's face facts, no one likes it when query performance is abysmal. We continuously strive to tweak things attempting to ensure query execution is as fast as possible. What if we could magically make things faster with the push of a button or two? Now we can.

    Reborn from SQL Server 2017 Adaptive Query Processing (AQP) to Intelligent Query Processing (IQP) with SQL Server 2019, Microsoft brought forth enhancements making the query optimizer an efficient learning machine. With this new found knowledge, SQL Server can now generate better optimized queries with minimal effort.

    We will -
    • Discuss how IQP works behind the scenes
    • Show how to implement various IQP features
    • Look at real world demonstrations of IQP in action

    You are -
    • Interested in new SQL Server 2019 enhancements
    • Looking to make things faster with as little effort as possible
    • Looking for a reason to migrate to SQL Server 2019

    Nobody likes slow queries. Nobody. Take advantage of these new features in SQL Server 2019 and see how much of an improvement can be gained. You won't be disappointed.

    Anzünder
    Fri 2:30 pm - 3:30 pm

  • Data Movement and Transformation using Azure Data Factory

    In this session , I will provide a basic introduction of Azure Data Factory, a scalable cloud-based data integration service. I will show a case study to move data from Azure Blob Storage to Azure SQL Server. Furthermore I will show you how you can transform data on-the-fly with Azure Data Factory Mapping Data Flows. In the demo I will also demonstrate how you can parameterize your pipelines for more metadata-driven development. This demo will also use the following technologies:
    * Azure Key Vault
    * Azure SQL Database
    * Azure Blob Storage
    * Azure Devops
    * Azure Data Factory and its Data Flows.

    The main goal of this session is to provide basic knowledge of ADF using case study so attendee will leave with ADF knowledge and how to apply this in different scenarios.

    Grillrost
    Fri 2:30 pm - 3:30 pm

  • The Ins and Outs of SQL Server Data Compression

    While data compression is best-known for reducing a database's size on disk, it's also an effective tool for making your queries fly. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and updateable columnstore indexes. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation. Since there's no such thing as a "free lunch" in computing, the drawbacks of these features will also be discussed.

    Holzkohle
    Fri 2:30 pm - 3:30 pm

  • Less Clicking, More Coding! Azure Data Platform Development Using Infrastructure as Code

    Infrastructure as code is *the* way to deploy Azure services - right? But under looming deadlines and time crunches it can feel way faster to use the tried and tested method of going to the portal and creating resources manually. In the back of your head, you know there must be a faster, better way of managing resources - but how do you make the jump?
    Without having a developer background it can be difficult to know where to even start with infrastructure as code. Especially if you are working with a team of multiple people managing and operating Azure resources - this requires a full cultural change!

    In this session we will go through the concepts that you need to grasp in order to get started with infrastructure as code for Azure. We will look at how the process for managing resources in Azure changes compared to the way we've previously done it, and finally we will explore a complete workflow of deploying your Azure data platform architecture as code using Terraform and how to work on that code with your team.

    Bierbank
    Fri 2:30 pm - 3:30 pm

  • Creating Accessible Power BI Reports

    Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone in your intended audience can use them? While this question is relevant for every organization, this can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we’ll discuss accessibility features available in Power BI today and how to design your Power BI reports with inclusiveness in mind.

    Anzünder
    Fri 3:45 pm - 4:45 pm

  • Goldilocks and the three business bears; story telling for business

    We have all heard stories, we go to the movies to watch stories, someone has told us a story. Stories are an excellent way to communicate facts and information to people in a way that they can remember. They are also a really good way persuade people to buy into ideas / projects / take actions.

    The next thought you might have is, is story telling not just something you are born with. Something that some people have and other do not, so why bother

    The best news is that being a good story teller is something you can learn. This topic has been studied and examined by scientists. Others have looked at the how the best story tellers in our industry do it, Steve Jobs for example?

    In this session we will look at stories. How they are constructed, how they engage with people. Not only that we will look at how you to can use the same techniques and strategies. Using these techniques you can help others to see why your business case is so much better.

    Grillrost
    Fri 3:45 pm - 4:45 pm

  • Write-back with Power Apps in Power BI

    Have you ever wondered why you can't edit your data in Power BI like in Excel? Now you can!
    Well, not directly in Power BI, but you can accomplish this with a Power App inside a Power BI report.
    In this session you will learn how to create a basic Power App and how to use that in the Power Apps visual in a Power BI report. You will learn how to connect Power BI and Power Apps together to update data in a database and display the results in Power BI.
    During the session, we will also run through different use cases where this can be brought to practice.
    This is an intermediate (Power BI) session, so experience with Power BI is assumed, prior experience with Power Apps is not necessarily needed.

    Holzkohle
    Fri 3:45 pm - 4:45 pm

  • Thē wönderfűl wôrld of ćollåtions, eñcodingß and téxt sţoræge

    In today's world the chances of having data in a single language are slim to none.
    Your customers speak and write many languages with many different letters.
    Once you get to talking or thinking about characters, collations, encodings,
    sort orders, diacritics, code pages, etc, a brain melt is what you end up with.
    In this session we'll look at what all of these things are, how they fit together
    and how to use them properly as each of them can break your applications in various ways.
    Since SQL Server 2019 brought improvements in UTF-8 area, we'll look at that as well.
    Because sometimes it's not enough to just use NChar or NVarChar and thinking everything will be ok.

    Bierbank
    Fri 3:45 pm - 4:45 pm
Session and Speaker Management powered by Sessionize.com