Toggle navigation
Arcade
Sponsors
Sessions
Travel
FAQ
Videos on Demand
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Search
Content Type
Video
69
Conference
SQLBits I
0
SQLBits II
0
SQLBits III
0
SQLBits IV
0
SQLBits V
0
SQLBits VI
0
SQLBits VII
0
SQLBits VIII
0
SQLBits IX
0
SQLBits X
0
SQLBits XI
0
SQLBits XII
0
SQLBits XIV
0
SQLBits XV
0
SQLBits 2017
0
SQLBits 2018
0
SQLBits 2019
5
SQLBits 2020
64
SQLBits 2022
0
>
Tags
Optimising
(69)
"Stop that!": What does compliance mean for development?
Christopher Unwin
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.
5 Mistakes in Cloud Data Migration
Justin Langford
We're fortunate in seeing tons of customers migrate to the cloud - this session covers major
Advanced Plan Explorer Usage for Tuning Execution Plans
Andy Yun
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Azure AI, Power new possibilities for every organization
Lindsey Allen
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Azure Cost Management
Dustin Dorsey
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Azure data services on Azure Arc
Umachandar Jayachandran
In this session you’ll learn more about Azure data services on Azure Arc
Azure DW and Power BI, reporting at the speed of light!
Stijn Wynants
In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
Azure Machine Learning and the Python SDK
Robin Lester
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
Azure SQL and SQL Server: Path to an Intelligent Database
Pedro Lopes
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
Azure SQL Hyperscale Deep Dive
Denzil Ribeiro
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Azure: Maxmise your bang for Buck
Justin Langford
Considerations in how you buy Azure to provide maximum bang for buck
Baselining Performance with DEA
Dustin Dorsey
Learn what the Database Experimentation Advisor is and how you can start using it to baseline performance from a target and source server when new changes are introduced.
Big Data Processing with .NET and Spark
Michael Rys
Come learn how to use .NET and Spark together in Azure Synapse and elsewhere to cook and analyze your data!
Can SQL Server 2019 auto-magically fix my bad T-SQL code?
Andy Yun
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Combatting illegal fishing with Azure for less than £10/mth
Carmel Eve
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!
Common Data Model-Our new buddy for Data Governance
Oliver Engels
Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach
Creating Custom Visuals in Power BI with TypeScript and D3.j
Mihail Mateev
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.
Databricks, Delta Lake and You
Simon Whiteley
Databricks, Lakes & Parquet are a match made in heaven, but explode with extra power when using Delta Lake. This session will dive into the details of how Databricks Delta works and how to make the most of it.
Deadlocks: Lets Do One, Understand It, and Fix It
Brent Ozar
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
Deploying SQL Server in Kubernetes
Anthony Nocentino
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.
De-risk Your Azure SQL Migration: 5 Critical Considerations
Kevin Kline
The session takes you 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.
Designing performant and scalable data lakes
Rukmani Gopalan
Come learn how to design your enterprise-scale data lake on Azure using Azure Data Lake Storage
Elementary! The Curious Case of Deceptive Query Optimizer
Pinal Dave
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.
Execution plans ... where do I start?
Hugo Kornelis
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!
Fast Focus: Scalar User-defined Functions in SQL Server 2019
Hugo Kornelis
SQL Server 2019 introduces FROID, a framework to inline user-defined functions, promising much better performance. What problem does it solve? And how does it work?
Faster SSIS
Andy Leonard
Learn tips and tricks to make SSIS perform better.
First Dates: AI & DBAs. Any Chance to be a perfect match?
Sascha Lorenz
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Getting Started with Learning Azure
Monica Rathbun
Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.
Hidden Gems of SQL Server 2019
Denis Reznik
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
Implementing AI using Azure Machine Learning Services
Vitor Fava
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
Introducing Deployment pipelines- The future of content lifecycle management in Power BI
Nimrod Shalit
BI professionals continuously improve datasets, reports and dashboards to provide their users with the best analytics experience, but managing all those content updates can be a challenge.
Introduction to Perf Troubleshooting Using Wait Statistics
Paul Randal
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Kick Start! SQL Server 2019 Performance Tips and Tricks
Pinal Dave
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
Microsoft certifications for the Data & AI professional
Sandra Marin
Are you looking to take your career to the next step? Microsoft Certifications help validate knowledge and ability required to perform current and future industry job-roles in a modern digital business. Our certification
Modern Database Design – Do’s and Don’ts
Conor Cunningham
The goal of the talk will be to show you how to choose among the various storage technologies that exist when building your next application.
My Power BI report is slow: what should I do?
Marco Russo
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
Next Gen: Intelligent Infrastructure
Shawn Meyers
Every day our organizations expect us to do more with less. Writing scripts to automate some tasks will only get you so far. It is time for the DBA to leverage Intelligent Infrastructure to remove routine tasks.
Notebooks in Azure Data Studio
Julie Koesmarno
In this session, learn from the tools team about what a notebook is and how to use SQL, Python, and Powershell notebooks for deployment, automation, troubleshooting and analytics.
Optimize price-performance using Azure SQL Database serverless
Morgan Oslake
Learn about using serverless in SQL Database to optimize price-performance and simplify performance management
Optimizing your Azure SQL Database workloads
Denzil Ribeiro
In this session we will demonstrate a few workload patterns on Azure SQL Database and discuss how to identify and remove bottlenecks in order to scale those applications.
Performance Mythbusters
Paul Randal
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Performance Optimization with Azure Databricks
Richard Conway
Azure Databricks has become one of the staples of big data processing. See how to make the most of it by understanding how Spark works under the covers.
Power BI Report design Tips and Tricks
Prathy Kamasani
A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports
Predictive Maintenance with Azure Synapse
James Broome
This session provides an end-to-end walk through of how to use Azure Synapse for cloud-hosted advanced analytics, based around a real-world predictive maintenance use case.
Query plans: a map to query performance analysis
Pedro Lopes
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Scaling databases using partitioned views
Ralph Attard
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.
Simplify your ETL with Databricks Delta Lake
Piotr Mucha
Databricks Delta Lake brings new levels of reliability and transformation abilities to big data solutions. Come and learn how you can simplify your ETL and maximise data consistency and resilience, no matter the size
SQL Managed Instance: Fully managed SQL Server in Azure
Mladen Andzic
Come and hear about the best practices of cloud migration, the latest enhancements of Azure SQL Database Managed Instance, and the future roadmap.
SQL Server 2019: The Modern Data Platform
Bob Ward
SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.
SQL Server Big Data Clusters: The Full Story
Ben Weissman (he/him)
A complete overview about SQL Server Big Data Clusters including it's major components and use-cases!
<<
1
2
>>