These are the sessions submitted so far for SQLBits 2020.

Remember those “choose your own adventure” books from when we were little? Yep, that’s what we’re doing in this session.
SQL Server 2019 comes with Python as an installation option. Let’s use this to gather data from various sources to create your test and development data.
Ever need somebody to run a script and send the results to you? Had problems with csv or XML fields? Let's build a C# app to do it easily and simply.
Azure Data Studio is the newest tool from Microsoft to query your databases. Come to this session to see if it's something that could replace SSMS in your environment.
You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems.
What is blockchain? What can it do for my organization? How does it work in Azure? How can I visualize the data in Power BI? Join this session to learn about blockchain using Power BI as a dataviz medium.
Data can be viewed as having a product lifecycle, where it can be collected, analysed, visualized, utilized and then monetized. This session is focused more on the destination of the data, rather than the journey.
In this session, we will examine the complexities involved in ethics, with a focus on bias. We will look at ways in which Microsoft technology can be deployed to tackle bias in AI and Data Science.
Manage and monitor SQL Server on Linux from the command line.
Azure Synapse Analytics combines the power of Data Lakes with Data Warehouses, empowering the organizations to build Big Data, Advanced Analytics and Business Intelligence in one single platform.
Azure Synapse Analytics combines the power of Data Lakes with Data Warehouses, empowering the organizations to build Big Data, Advanced Analytics and Business Intelligence in one single platform.
Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Don't worry! I have made plenty of presentation mistakes over the years so you won't have to :)
Learn how to use a financial transaction dataset and build out interactive, automated and secure reports that can be extended to manage modelling and planning scenarios
Recommendations Engine is at the core to success of most of the organizations from E-commerce to Retail to E-Learning etc. In this session we will deep dive in how to build the Recommendations Engine in Azure.
Learn how to scale your Power BI reports in a performant manner across a large enterprise and get the required engagement/adoption from users
Learn the techniques for developing a gripping story with your data visualizations, focusing attention on important patterns and ensuring that the insights are actionable.
Getting your data model right is key to having a performant report and avoiding the use of unnecessarily complex DAX for your calculations. This session will show you how to effectively design and build your data models.
Containers - Day 2! You’ve been working with containers in development for a while, benefiting from the ease and speed of the deployments. Now it's time to extend your container-based data platform’s capabilities for you
Are you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? Then this is the session for you.
You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure
The most challenging area of machine learning are Data acquisition, Feature extraction, Feature Selection. Almost in all data science project, 80% of time people spend in Data acquisition and Feature engineering.
Here we will learn step by step building of your first ensemble model. How to tune your model and improve accuracy.
Choose the right chart for your data - and understand why it is the right choice.
Three examples of a business analysis problem , and my data model and DAX solution.
Learn various features offered by databricks and how it works. How to set up databricks enviroment and build machine learning model.
You will learn every detail of logistic regression and build your model to address a real world problem.If you wanted to learn how to learn a particular algorithm , this session is good for you.
Have you met Azure Cosmos DB yet? Let me introduce you to Azure Cosmos DB in this beginner level session. I promise you won't regret it!
Are you a data professional working with out-dated tech or feel your skills are becoming irrelevant? Join Mohammad Darab this session to explore cutting-edge technology that SQL Server 2019 is offering: Big Data Clusters
Isn't it awkward when someone asks you, "So, where do you see yourself 5 years from now?" Brent Ozar will share how he analyzed the data job market to build his career path.
Power BI brings the concept of self-service BI, and gives a chance to incorporate Data Science models into analysis using R and Python. It also analyse data with a feature called Dataflows.
Trying to efficiently import Excel spreadsheet data into an RDBMS can be, at best of times, challenging! Issues such as drivers, versions, OS architecture, sheet formats and other spanners are often tumbling in the mix.
SQL Server does use bit hashing (bitmaps) under the hood, this session will explain how to effortlessly work with the bit maps
In this session one will learn about the Cosmos DB emulator that is provided, and how to work with it. The session will show how to load data and how PowerBI can be used to visualize said data.
Need to transfer data to and from an application? JSON is what you need. This session will show the tools that Microsoft has provided to work natively with JSON in your SQL Server Database.
In this session we will look at the basics of the Power BI data model and why it is important to have a 'proper' model. We will then look at some real world modelling challenges and how to solve them.
In this session, we will follow a Premium capacity admin on his day to day activities on managing his capacities, from refreshes, slow queries and a busy capacity.
In this session we will look at the Power BI and Azure Synapse Analytics integration in details.
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
How can the AI make my BI application smarter? Everybody is talking about AI but what can you do with it today?
The example in this session is about the evaluation of the service quality of the #SQLKellner. It explains step by step how to assemble all components to get a "Service AI Power App" that runs on every device.
We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. You'll know what you can do to make your job easier, where to find help, and how to still be able to advance your career.
Let’s talk about how using Twitter, Slack, LinkedIn and even Facebook cannot only enhance your career but make you better at your job. We'll also discuss the pitfalls & risks that sometimes accompany these tools.
Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently.We will go over some of my go-to performance tricks that you can implement to get the biggest bang
Let's learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt.
A beginner's guide to indexing from a user perspective. What to consider when defining an index and what not to consider. Many demos including clustered, non-clustered, covering indexes, and primary keys.
This session will give you the background knowledge on how SQL Server stores and uses various indexes. The attendee will gain valuable insight into index composition and increased index performance. 75% demos.
Everyone thinks they know all about Foreign Keys, but this session yields the rest of the story. FKs are needed for data integrity, but they can have a significant impact on performance. Come learn the pros and cons!
Have a plan to tune every query you meet.
Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!
I want to introduce you some of the uncommon but very useful features of SQL Server in this session. You don't need to have latest version to use any of these features!
Azure Data Studio allows us to manage your Data Platform Fleet in this fast paced arena we work in as a Data Professional. This demo heavy session will introduce you to the what, then when, the how and the why.
So your company has no budget for fancy 3rd party tools. Don’t worry, the SQL community has got your back. Come and hear about the many free tools available to data professionals that will help you in your daily life.
You got introduced to Azure Cosmos DB and you want to learn more about Azure Cosmos DB's features. Join me in this intermediate level session to learn about Cosmos DB's features.
In this session, I discuss what I believe are the some of the fundamental skills needed as a modern DBA. We'll discuss activity monitoring, backup/restore and how PowerShell can make you mega-efficient.
Blogging is a great way of boosting your career and participating in the SQL community. Maybe you’re thinking of blogging, but it seems like a big step. Let me help you get started, you'll never look back.
Learn how to properly model data for transactional applications.
Learn to make better analytic solutions by following current thoughts on data modeling.
This presentation will demonstrate how to build a full modern data platform with CI/CD. Resources will be deployed as ARM templates. In addition SQL Database, Analysis Services, and Power BI content will be deployed.
Learn how to supercharge your visualizations in Power BI with little to no code. Clever techniques involving visual layering. unique conditional formatting, and utilizing DAX measures will be covered.
This presentation covers best practices related to: importing only required data, building optimized queries, minimizing query load time, and intelligently identifying and handling errors.
SQL Server Indexes are not always as much as helpful as we like to think. Often they work against our overall server performance. In this session, we will see some troublemaking scenarios and their workarounds.
Sometimes there is not enough time to save the SQL Server World via troubleshooting it comprehensively. At times we take the shortcut to stabilize the system and restore equilibrium. Inspired by true stories.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we wil
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
It could be your code. It could be the .NET kids' code. It could even be SQL Server optimizer doing it. RBAR. Row By Agonizing Row. What is it, why is it bad and how can we fix it?
For the company I work for, we have implemented Group Managed Service Accounts (GMSA). We have gone through the whole organisation to get it working, I will show you all the steps we have taken and what we have learned
Overview of SQL 2019's new Intelligent Database features, can you make use of them and what will they mean for you?
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code.  Knowledge of this language opens doors that remain closed if you only use the GUI.
Parsing an XML data set into a relational schema in SQL Server is a well-established process but there are alternatives, which can simplify the task.
Authentication and security in Azure use a different model. In this session you will learn how that works, and how to make it work for you applications.
Data and statistics are excellent tools for conveying information - information that doesn't even have to be true. Come see ways of misrepresenting data for sinister purposes using Power BI!
Self-service BI is amazing. Empowered users are amazing. Data leaking all over the place is not amazing. Learn how to securely share data with Power BI and avoid finding out firsthand just how not bad lost data can be.
Reusing by duplicating runs the risk of diverging data, and shared data that doesn't have adequate quality is useless. Solve this and more with Power BI dataflows!
Stop implementing a BI solution the old, agonizing way. Slow, too much work, and a less than satisfied customer. Use Power BI and Power BI dataflows to create an iterative, relevant and simple to use solution instead.
Find out what machine learning is, explore what Azure Machine Learning can offer, Gain an understanding of how machine learning can be utilized.
SQL Server has been supporting Spatial Data since 2008. Don't pay to third party tool for Spatial Data needs. Join me to learn what SQL Server can deliver for you when it comes to Spatial Data.
This session is for all developers who want to learn about the new Dev features and enhancements of SQL Server 2017 and 2019
What is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.
We are going to look at 3 hot topics of Azure SQL DB: migration, synchronization and troubleshooting. You will be challenged with a customer situation where you must design a solution using Azure SQL DB functionalities.
It's time to meet SSDT - a rich toolset for integrating SQL Databases with the software development lifecycle: Using it for source control, version history, unit testing, CI/CD, and much more.
In this session, we will look at the science behind effective data visualizations, color theory, how to create Power Bi theme files, introduction to design approach and how it helps us to tell a good data story.
A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports
Join John as he introduces Terraform as a cloud agnostic management interface for taking a code first approach to cloud infrastrucutre deployments.
Automating infrastructure deployments alongside the application & database code deployments is driven by Infrastructure as Code. Together we will look at how to combine Terraform and Azure DevOps to automate deployments.
Making the jump from Individual Contributor to 'Manager' can be daunting, no more so than building a high performing team. In this session I will talk through my approach to interviewing and leading people.
SQL Server estate managment can be wrought with pitfalls for maintaing a properly configured environment. PowerShell DSC gives us the ability to automate all of this by leveraging Infrastructure as Code principles.
Azure Data Share enables organizations to simply and safely share data with their customers and partners. Watch a live demo, hear how customers are using the service and how we're thinking about governed data sharing.
Azure Data Share enables organizations to simply and safely share data with their customers and partners. Watch a live demo, hear how customers are using the service and how we're thinking about governed data sharing.
Power BI is an amazing BI platform out of the box, but there is a lot of things that you can do with Power BI that probably you don't even imagine! Come to my session to find out....
This session aims to give an overview of all the possibilities for the Developer in Power BI from Custom Visuals to Power BI Embedded.
This session is all about demystifying what you can and can't do in powerbi.com, my goal is to give you an overview of all the features you have available on powerbi.com from content organization to real-time analysis.
This session is all about showing the real-time analysis options in Power BI and how to do it properly. Discussing the Pros & Cons in every option.
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then (if needed) evolve it into a fully scalable Azure BI solution.
I will discuss the concepts of DevOps and showcase how Data Professionals can benefit from it. A comprehensive live demo will illustrate how to implement DevOps for your databases.
Azure Machine Learning is in very high demand and is been used by almost every digital organization. See how Azure ML can be customized for Power BI reports.
Come learn how to use advanced AI features in Microsoft Power BI to solve your business problems.
An opportunity to learn the AI capabilities in Power BI that will make analysts to solve problems, that were once reserved for dedicated data scientists
Microsoft Artificial Intelligence is in very high demand and is been used by almost every digital organization. What if these AI can be easily exploited to use within our day to day Power BI platform?
Come and learn how to build a chatbot to ask question on weather forecast, speech to text, language translation & handing over the bot to a live agent.
One of the newest buzzwords of the last few months and years is definitely Kubernetes - or K8S. Microsoft has made with SQL Server 2019 a huge investment into Kubernetes.
Running a SQL Server Virtual Machine on VMware vSphere is a quite simple, straightforward process. But how can you get the best possible performance out of your SQL Server VM?
Docker, Docker, Docker! Everyone talks about Docker! But how can you use Docker in combination with SQL Server?
This session shows you the various performance enhancements of the relational engine of SQL Server 2019
Hyperperscale is a new service layer that leverages Azure architecture to scale horizontally the storage and the compute power available on a SQL database beyond the limits available for general purpose
In this session, we will discuss the basics of IA and how we can apply it in our business using the Azure Machine Learning Services
You are a developer and you want to leverage the 'Power' features in Azure DevOps via YAML pipeline as code, then this session is for you !
When you design and build an application, do you think about security first or is it an afterthought? In this talk, you will learn strategies for designing and securing your data layer.
Your database deployments are still stuck in the proverbial dark ages! In this talk, we will learn techniques to utilize SQL Server Data Tools, tSQLt, Azure DevOps, and Docker for automating your database deployments.
DBAs lose sleep over ORMs touching their databases. Developers lose sleep thinking about using stored procedures. Is there a middle ground? Yes! I’ll introduce techniques and tools that help keep both happy.
PowerQuery is often used in combination with PowerBI. But what if the only tool you can use is Excel and data is not in databases. What are the pitfalls in this scenario?
testing databases focus mostly on Stored Procedures. Datawarehouses and reporting solutions uses databases in a much different way. Testing is as important as important but less simple.
Do you want to build a centralised datahub but find yourself drowning in a sea of SSIS / ETL packages, if this is the case a big data cluster powered datahub might be the answer.
Where to start when your SQLServer is under pressure? There are a lot of free tools and scripts available online.These tools will help you decide whether you can fix yourself or you need specialized DBA to solve it.
Bi developpers are using Visual Studio for SSAS, SSRS and SSIS development all the time,but tend to forget to use Visual studio for there database development. For CI/CD you really need a database project in VS
After more than two years live with BI in Azure Alexander Klein would like to give an honest feedback.
Container Orchestration with Kubernetes. Techniques to quickly persist multiple copies of a VLDB. Show moving a container on premise from the cloud.
A single workspace environment, for DataScientists, DataEngineers and DataAnalysts to collaborate on the same data with limitless analytics and on-demand query compute at scale.
SQL Server 2019 introduces ground-breaking query performance enhancements under the Intelligent Query Processing family.
In order to get the most out of the latest hardware innovations, you need the latest software innovations as well. SQL Server 2019 introduces a suite of new and improved memory optimized technologies.
Azure SQL Database Edge offers the same SQL database engine which is optimized to run at the edge with a small resource footprint and with built-in capabilities like streaming support.
As businesses and applications reach global scale, you know that SQL Server and Azure SQL can support international applications. But there's much more than meets the eye.
What is a query plan is and what information does it hold? Dagnose and understand how the code you write is actually executed by the Database Engine.
Seasoned or new DBAs, you may be unsure of the latest and greatest recommendations for configuring and maintaining a high-performance tier-1 database system. This session is for you!
In this session you will learn all about branching approaches with Database code, best practices and things to consider with each step you take towards robust version controlling of your database code.
In this session we will go through what hurdles you will need to jump to create a data masking strategy, as well as how to use Azure and PowerShell to create a rudimentary masking set for non-production.
In this session you'll learn some of the key data privacy problems facing database developers and DBAs and 10 steps to help your database team build a "defensible position" through development.
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.
Learn the basics of evaluation context and the role of filter context and row context in DAX expressions.
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
Create the right Date table and use DAX time intelligence functions or custom filters to get the desired calculation aggregating and comparing data over time.
Need to integrate data from both cloud and on-premises sources? Azure Data Factory lets you build scalable data pipelines - without writing any code!
Learn how to use parameters, variables, expressions, functions, lookups, and loops to build a dynamic and reusable Azure Data Factory solution.
Learn how to configure source control and use Azure Key Vault to implement Continuous Integration and Continuous Delivery (CI/CD) for Azure Data Factory solutions using Azure DevOps pipelines.
Find out how to get the most out of SSMS. Let me show you some of the features and shortcuts inside SQL Server Management Studio that can make your day to day work much easier and more productive
In this session we will merge practice and theory, analyzing what is data virtualization and data lake, what their benefits and how to implement them using SQL Server 2019 Big Data Cluster
Self-Service ETL is fundamental for every company to avoid leaving the IT department overwhelmed with report requests. Power BI dataflows are able to achieve this goal.
An into into Power BI and why Michael Jordan is the G.O.A.T - A look into the basics of how to start using Power BI in your Organisation by analyzing professional Sports data.
Advanced data security for SQL Servers is a unified package for advanced SQL security capabilities.
This session will cover developers' / architects' point of view towards what Azure data platform has to offer for batch data analytics workloads. The main focus is going to be on native Azure technologies.
This talk is how to implement modern IoT server-less solutions in Azure, based on event driven design, and powered by Cosmos DB and Power BI.
If data is the new oil, then "Big Data" is the new snake oil. For over a decade, "Big Data" has managed to delude far too many smart, honest, experienced, and hard-working data practitioners. This madness must end!
Have you ever stopped to wonder why almost every table has a “table_name_ID” identity column as its primary key? If you’ve never gave it a second thought, and even more so if you did, this session is for you...
Tabular Editor is a free alternative to Visual Studio / SSDT for Analysis Services Tabular development. Its intuitive UI will instantly boost your productivity. Learn how to get up and running in this 50 minute session.
If you're not afraid of a little bit of C# and LINQ, Tabular Editor can take your productivity to a whole new level. This session will teach you how to use Tabular Editor's scripting and Best Practice Analyzer features.
Continuous Integration and Delivery can be a pickle for Analysis Services Tabular Models when using the standard tools. With Azure DevOps, GIT and Tabular Editor, there's a better way...
This presentation covers: Indexing documents , performance tuning deep dive, how to design and create applications using different API, real life examples
This talk is about how to optimize the performance and cost of Cosmos DB in your solutions. We will have a deep dive in client and server side sittings, which will allow get the best from Cosmos DB on the most attractive
This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
After this session, attendees will have knowledge on the major concepts, related to Power BI Embedded Analytics: - Use-cases - Architecture - Licensing - Security - Application development - Application deployment
We show a collection of useful DAX formulas to improve the quality of reports by mixing the power of visuals and DAX.
This session introduces calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.
Analysis and comparison of a model with DirectQuery (with and without aggreations) and in VertiPaq mode. We show the speed of the engines and guide students through an educated choice of the best techology
Look beyond the marketing to understand how, when and why you should consider Cosmos DB. Based on real world experience, we'll explain the complexities and gotchas in building realistic cost and performance models.
This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement.
Learn how to build and manage enterprise-grade semantic models that are reused throughout enterprise organizations.
Introduction to writing functions in Power Query from basics to more complex functions. Lots of demos and ideas to take away.
How to use SVG as visuals in Power BI to build custom graphics for KPI.
This session will Power Query which is now a must for the keen citizen developer.
In this session we look at SQL Server 2019 Big Data Cluster. We look at the various components: Kubernetes, Spark, HDFS, PolyBase, etc., and what you can do with them.
In this session we look at the SQL Server Extensibility Framework, and we see how we can call out to external languages, such as R, Python and Java, from inside SQL Server.
In this talk we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.
In this demo filled session we look at how Azure Databricks and Delta Lake together with Machine Learning can help you calculate Customer Lifetime Value.
In this session we look at building data pipelines with Azure Delta Lake in order to enrich and structure data suitable for machine learning / analytics.
Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB.
Social media, when used properly, can be a gateway to a new prosperous career or help with that sticky production issue you are having. We'll go over some facets of social media and get you moving down the right path!
SQL Server 2019 just released and with it came a plethora of enhancements that are really beneficial to data professionals. In this session we'll go over some of the notable ones and how they benefit you.
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
You, as a SQL SERVER DBA are used to troubleshooting Windows as a Master. Now we have a different OS flavor. Are you ready to add a few more tools to your DBA skill set? In this section let´s see how to perform the most
Would you like to increase your AG functionality and make it work cross-domains? Want to transfer data between AGs? In this section lets dive into the the Distributed AGs and what they can do for you!
Get to know the newest features of SQL SERVER 2019 and why it is the best choice as a data platform currently on the market. In this session we will have an overview of the new features of SQL SERVER 2019!
Learn how SQL Server 2019 can help you meet your strict service level agreements and recovery objectives.
Get introduced to SQL Server on containers and what you need to know as a DBA to start deploying and managing them in both development and production environments
Don't get off-guard when a SQL Server Always On outage strikes. Know the smart way to bring them back online as quickly as you possibly can
Platform as a Service database offerings like Azure SQL DB, Cosmos DB, and Managed Instance offer many advantages to both you and your applications. Learn how to choose the right one.
You're comfortable managing your databases in SQL Server Management Studio, but you've heard more and more people using Azure Data Studio. Why should you switch? I'll show you what I use it for - and what I don't.
Find out how you can build event-driven applications that implements event sourcing using Azure Functions and Azure Cosmos DB.
You can use the Gremlin API offering in Azure Cosmos DB to build highly available graph databases in the cloud that scale! Don't know what a graph db is or where to start? Make sure you attend this session!
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
You can't just ignore index fragmentation, so come learn about the less discussed effects of fragmentation as well as the best ways to prevent and/or get rid of it!
This demo-heavy session will show you advanced methods Paul's used extensively over the years to salvage data for real-life clients after catastrophic corruption.
Learn how backup and restore work and how to put together an effective backup strategy.
Learn to write code that's not just faster to run but also more readable and faster to write through Common Table Expressions, the APPLY operator, Window Functions, pivoting and unpivoting data and more.
There are many ways to deliver a presentation. Two experienced speakers with different styles share their top tips for improving your presentation skills.
Improve your DAX by learning how simple filtering can spoil a punchline, how filter and row contexts work together like a barn dance and how CALCULATE can work like a distracted boyfriend.
An opportunity to explore Scala, and why it is truly a “Data Engineers language”. Using Azure Functions, Data Factory, Azure Data Lake Gen2 and Databricks the basics will be explored, followed by real world examples
Explore the Cosmos! Get to know what Cosmos DB is, review advanced scenarios, showcase Azure's quick starts, and demo a lift-and-shift scenario using MongoDB.
A deep dive into partitioned tables. This session discusses the pros and cons of running smaller multiple tables to scale your operations, and how SQL Server 2005 saved the day.
Walk through partitioning strategies and look into partitioned views to consolidate distributed data. Enterprise features makes this easy, however hacks will be demo'd to make this work in Standard edition.
Identify the technologies Microsoft have made available to address various GDPR articles whilst focusing on discovery and classification of sensitive data both on-premise and Azure databases.
Although not ideal you might need to run a couple of SQL Servers on Azure IaaS with AlwaysOn Availability Groups. This session will explore the basics to make this work.
An introduction to the philosophy of tidy data and the collection of R packages called Tidyverse that help to treat your data appropriately. Including lots of demos from ingesting to cleaning to visualizing your data.
Let's refresh your memories on how geospatials work in SQL Server: data types from 0 to 2 dimensions, functions on geometry and geography objects, including practical applications.
A walkthrough of all the JOIN operators that are supported in T-SQL scripts with their syntax and use case demos, including a glance "under the hood" of query plans, right up to CROSS and OUTER APPLY.
We'll develop a dashboard-like overview of you agent jobs and their durations with the help of R. Graphical representations including trendlines instead of staring at number columns, without spending extra ££.
If you saw the beach or enjoyed your gap year in Thailand, did you ever dream of going back? This session based on personal experiences covers being an expat in Thailand and Hong Kong
This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows.
Graph Databases bring new ways to deal with our data, making some requirements easier. Although a bit incomplete in SQL Server 2017, it has improved in SQL Server 2019.
Query store is present since SQL Server 2016 and sometimes is very underestimated. Let's learn some very good results we can extract from query store.
So you want a Windows service without the code? Pushing SQL Agent past it's limits can achieve what you need.
We will see how to construct a cloud-first architecture based on serverless data analytics. We will look at specific challenges and cost saving strategies, to produce a reliable, scalable and cost effective solution!
Join this session if you are interested in the administration scenarios of the big data clusters, such as monitoring cluster health, deployment, HA, security and to learn about the latest improvements to the system.
How do you prevent unexpected data or erroneous files from blocking the refresh of your dataset? In this session you will learn what possibilities you have to make your Power Query ETL more robust.
In this session we will learn how in database Machine Learning works across the SQL Platform and how you can do Machine Learning in SQL Server 2019 Big Data Clusters.
Curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Get up Speed with the Vision API in less than an hour!
Played around with SQL Server in containers and want to delve further into the platform? This session is for you! In this session we'll dive straight into the Docker platform and investigate its internals.
In this session we will explore the concept of Chaos Engineering, its core concepts, and how it has been implemented at various companies. Then we'll look at how it can be implemented with regard to SQL Server.
This session provides an overview of the different options for running SQL Server containers in Azure. We'll push images to the cloud and deploy to either Azure Container Instances or Azure Kubernetes Service.
Availability groups are great for HADR but there are a few little gotchas that could make your failovers less than seamless. In this session we're going to look at those and how to make sure they don't catch you out.
This session is all about how the optimiser works, so we'll be jumping straight into phases, stages and transformation rules!
An introductory session around the Power Platform and, specifically, the Common Data Service, and why SQL addicts the world over should consider using it as part of their next project.
Learn what is necessary to keep an eye on your Azure SQL Database in order to better tune it and reduce costs.
Learn 10 steps that can help ensure your organization is meeting the rising global compliance requirements.
Learn what SQL Injection is and all the mechanisms you should employ to help stop it.
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.
Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise
Deploying virtual machine-based SQL Server solutions in the cloud is not as easy as it may appear. This session will cover the good, bad, and ugly of VMs in the cloud based on real world customer experiences.
In this session we'll focus on the benefits of using Azure Data Lake. We will cover how we use ADLS in real projects to produce a security architecture which is adaptable, scalable and provides monitoring capabilities.
R is a fantastic language for data science and there has been substantial investment in a clean, easy to use, and scalable workflows in tidymodels and tidyverts. Get up to date with Rs capabilities and kickass workflows.
As more and more businesses and public sector organisations are using data science to change the way they do things or to automate processes, we’re changing interfaces and interactions. So are we experimenting on people?
Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse. However, in this session, you will discover why synapse analytics is way more than that.
You will discover in this session the benefits Notebooks and Azure Data Studio can bring to SQL Server developers
Back by popular demand is my Adventure based session originally presented at SQLBits in 2019. Aimed mostly at administration and based on real life scenarios, this popular audience interactive session we will go through
Test your T-SQL skills in this live quiz, and see in demos that SQL Server doesn't always do what most people expect. Covers topics such as indexing, transactions, null handling, types, ...
Azure Stream Analytics makes real-time processing of data easy. But it can be linked with Azure machine learning such that predictions can also be applied in real-time. This sessions demonstrates how to implement this.
This session will discuss how to look at your workload holistically using a variety of methods, so that you can target and address patterns in your code and query plans, rather than troubleshooting one query at a time.
If you have heard about Query Store but don't know what it can offer, or why you really need it, this session will answer those questions and demonstrate the value of this feature that continues to evolve.
In this session you will get a birds eye view of all the features in Azure Data Factory, and see this demonstrated in a cloud ETL.
AI and data is at the center of the digital feedback loops. At AI engineering team we partner with our customer to democratize AI. you will get an update on Azure AI and customer scenarios.
Has your manager said to you "I expect the SQL Server databases to have zero downtime?" Learn how on-premises and cloud resources in the SQL Server ecosystem can work together to help you get closer to that lofty goal.
How can data professionals help a company deliver more personal and prompt communication to customers that are demanding it? Learn how data knowledge and the power of Azure Cognitive Services APIs can make that happen!
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" Learn how Azure Data Studio notebooks can make our responses faster and more organized so we can get more sleep!
The only DBA at your company just quit and your boss says to you "You do data stuff, right? You're our new DBA!" Congratulations, I guess? Walk through an action plan of how to tackle this opportunity!
Exploring Functional Programming in Scala and how it can help aid your Data Engineering pipelines
Take a look at how I solved a problem taken at face value should have been easy. I'll show you how to query a json from SQL Server, looking at other providers like AWS Athena and the little nuances.
A few of you have heard of SQL Server Data Tools (SSDT), you may have started using it but not entirely sure where to start and you're being pushed to make sure it's "Agile", "DevOps", "CI/CD" etc etc.
Application and Database migrations can be a cause for concern. How many times have you heard, "If it isn't broke don't fix it". Come see how you can give confidence to key stake holders on testing the process.
Database migrations can be hard, but you can make it predictable and less painful through diligent preparation. Join me for this talk to learn about how to structure you migration and see in action some great free tools.
Power BI contains all your important data so understanding how it is secured is important. In this deep dive session we will look at all the aspects of security of Power BI.
The first time you’re introduced to Azure DevOps you’re confronted to an array of different items on the screen. Do you want to learn how to start with Azure DevOps, then come to our session?
Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
Within Azure DevOps there are so many ways to get useful analytics. In this session we will discuss how to get the analytics within Azure DevOps and what are the different scenarios where this may come in handy.
Exploring execution plan operator elimination, performance measurements, alternative methods and first and foremost, having a bit (bashing) fun with the Microsoft flavor of the Structured Query Language.
Deploying a SQL Server database doesn't have to be a complicated, manual process, and it doesn't have to cost a fortune either.
Azure's breadth of products can make technology selection a challenge. Learn how to make pragmatic and informed choices that meet your application's data transformation, processing and storage requirements.
Learn how Azure supports interactive, exploratory notebooks (e.g. Jupyter) for data processing and experimentation across a range of scales from simple single-computer work up to massively parallel Databricks clusters.
SQL Server has numerous metadata facilities to help you document, manage and tune your SQL Server. This session will demonstrate these functions and how to use them effectively.
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO? Hint: You attend Revenge: The SQL!
This session will cover the features and administration of log shipping in SQL Server. We will describe high availability and disaster recovery, and how log shipping can be used in those scenarios.
In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.
This session is to assist the Microsoft professional in how to move Oracle workloads to Azure- what options exist, what questions to ask, what data to collect and how to simplify post migration to the cloud.
This session used a real use case to demonstrate how to go from zero to hero with automation, why the solution that is in place was chosen and what tools and scripts were used for everyone's success.
Microsoft was one of the earliest companies to advocate for an ethical perspective on artificial intelligence. Join this session to see what tools Microsoft have to offer to help you put ethics at front-and-centre of AI.
GDPR 'right to explanation' mandates the personal data of EU citizens ensure fair and transparent processing by providing meaningful explanations about logic in automated decision systems. Can Power BI help?
The data lake has become extremely popular, but there is still confusion on how it should be used. I'll explain it in full, including the characteristics and benefits of a data lake.
I’ll discuss deployment strategies, common usage scenarios, how to store and refresh data, prototyping options, how to share externally, and then finish with how to administer and secure Power BI.
Understanding the differences between relational database and non-relational databases, and the proper use cases for each.
I'll tell you why you should move your databases to cloud, covering all the available options in Azure.
Learn all about Azure Synapse Analytics, including demos so you can see exactly how it works and how it can make your life easier.
Version control can be difficult to implement within the organization. This session will cover the different methods and let you leave with enough information to get it implemented.
Having an automated build and release pipeline for database development is rather new. Many people struggle to get the process working and sometimes even give up. Within this session we will discuss the build and release
Run SQL 2019 big data cluster on your own Docker cluster on-prem
Step-by-step towards building a SSIS Custom Pipeline Component
SSIS ScriptComponents are not that bad
Are you a .NET developer who's being FOMO'ing over all the machine learning goodness? Thanks to ML.NET, this is no longer the case! Learn how you can use your C# skills to build some awesome ML applications!
Testing data in SQL Server is hard, but it is easier than having to restore your database. This session will show how easy it is to test database code using industry frameworks, tools and processes
Data is needed in all kinds of scenarios but we don't want our developers to work with production data. In this session you'll learn how you can achieve this with the masking functionality in dbatools
Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
When seeing execution plans, you might be overwhelmed with all the different operators. What do they all do? Where to focus first? In this session, we will only focus on operators that are most likely to cause slowness.
Learn how to estimate the cost for your move to Azure
Overview of the ways you can license SQL, when you may want to choose which model and common mistakes that people make that can cost you.
Discover common reasons why you may be paying too much or too little on your SQL licenses and what you can do to fix it
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it.
See how easy it can be to integrate PowerApps, Power Automate (Flow) and Power BI. All built on stage and you take home the precise recipe
Is your Power BI environment out of control? Do you need to get more structure to it and start to govern is in a structured way? This session will give you a method and a structure to your Power BI governance
In this session we will explore the pro's & con's of Managed Instances compared to other DBaaS offerings, IaaS and on-premise instances, the different sizings & offerings, and the inevitable gotchas.
The session takes through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
During this session, core concepts of Power BI Dataflows will be explained, and we'll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your Power BI reports, and take actions on these insights.
We'll go through some steps on how to maximise the potential of data visualisations. Starting at choosing the right types of visualisations, and which colour palettes are good matches for your message.
In this session, we'll look at different sharing mechanisms for Power BI Reports and Dashboards, and how to distribute them. Using these different mechanisms, we'll lay out a possible lifecycle process.
SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.
Learn the four core practices which enable high performance for database development and delivery.
In this interactive session, the group will tackle three tough challenges in database development and deployments, including very large databases, changing timelines, and automated tuning.
An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
100% demos: We will create a new public repository in GitHub, script out a database using SSDT, and set up an automated Azure DevOps Services Release Pipeline to deploy our source code to Azure.
Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and PsDatabaseClone.
Moving to a safer release cadence, based on smaller, more frequent deployments, normally requires deployments to occur while the systems are running. That’s scary. In this session we’ll discuss how to do it safely.
Ever since XML was first implemented in SQL Server more than 15 years ago, it has earned the reputation of being an SQL Server conversation killer. In this session we are certainly going to debunk that reputation.
What is Azure Data Lake, and how can an organization benefit from it? Attend this session and find out about a great technology that can enhance your existing environment and skillset!
What happens when multiple processes hammer your database, reading and writing all at the same time? Isolation level settings help decide this. Attend this session to learn how to use them to your advantage!
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.