Sessions & Content

Search
Content Type
Conference
Tags
A DBA's Guide to the Proper Handling of Corruption Brandon Leach
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to corruption when it strikes.
The video is not available to view online.
A low cost serveless synapse data platform Eivind Halmøy Wolden
If you like writing SQL and need a cheap data platform in Azure, this session is for you. This session will describe the architecture for a metadata driven, minimalistic Azure data platform using Synapse Analytics (serverless SQL) and data lake. You will get to know when this works well, and when it does not.
The video is not available to view online.
Azure Cosmos DB Serverless Unleashed Mihail Mateev
Cosmos DB Serverless in a Nutshell
The video is not available to view online.
Azure Data Explorer - a Torch in the Dungeon of Observational Analytics Pawel Potasinski
Join this session to learn what Azure Data Explorer (aka Kusto) is, see it in action and get a quick start in this great platform for observational analytics.
The video is not available to view online.
Azure SQL MI End-to-end Demo Party for DBAs and Devs Dr. Dani Ljepava
Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.
The video is not available to view online.
Banishing Slow Queries with Intelligent Query Processing John Morehouse
An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,
The video is not available to view online.
Beware of nondeterministic T-SQL code Itzik Ben-Gan
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
The video is not available to view online.
Building an Open Data Lakehouse using Apache Spark, Apache Iceberg and Dremio Mike Flower
In this session, we will discuss the evolution of the big data landscape, to the data lakehouse concept. We will focus on how an Open Data Lakehouses are developed, and how to secure, govern and augment using Dremio.
The video is not available to view online.
Chaos Engineering for SQL Server Andrew Pruski
How can we test potential weaknesses in SQL Server? In this session we will explore the concept of Chaos Engineering, its core concepts, and the methodologies behind it.
The video is not available to view online.
Choosing the Right Data Store--An Overview of Azure Data Platform Choices Joey D'Antoni
There are a lot of options in Azure for your data. In this session you will learn about the various options for how to store data fro your app, and a decision tree for how to make the best choices for your application.
The video is not available to view online.
Columnstore Index Compression in a Nutshell Edward Pollack
Improve analytic queries by unlocking the secrets of columnstore compression!
The video is not available to view online.
Don't be scared with Hybrid, they are only tables… Bruno Mairos
Hybrid Tables in Power BI - Do you have the courage to mess with them? Jump in and together let's chop the data in static, incremental and instable data that is changing every second…
The video is not available to view online.
Efficiency up, failed releases down; compliant production data for your test and dev environments Chris Hawkins
In this session, we’ll tackle the challenges that come with getting yours hands on quality data for test, QA, and CI practices.
The video is not available to view online.
FinOps, how data engineers get their cloud cost under control André Kamman
Managing cloud cost is no longer a "management approves the budget" type of thing. Cloud Engineers need to architecht their solutions in such a way that cost can be kept under control. This is not a one time thing. Monitoring, automatic downsizing, re-factoring are all parts of the yearly tasks of any cloud team. We'll discuss theory, techniques, best practices and lessons learned.
The video is not available to view online.
Go With The (data)Flow Maria Gabriel
What are Power BI Dataflows? Who is affected? Who benefits? Where is this taking place? When does it make sense? Why is this important in the big picture? How to do it? Attend this session for an overview of Power BI Dataflows and to understand how this piece fits into a Business Intelligence architecture. Some use cases will be presented, and we will let the data flow!
The video is not available to view online.
Hear me out - Don't go offline because of your index deployment strategy Cláudio Silva
Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
The video is not available to view online.
How changes to Azure Synapse Analytics impact data architecture designs Ginger Grant
Explore the changes that have been made to Azure Synapse Analytics and how this has changed it’s use over time. We will review how these feature additions have impacted the methods used for transforming, storing, and querying data so that you can evaluate whether it would be a good fit for your data environment.
The video is not available to view online.
How Do I Reduce My Cloud Bill? Joey D'Antoni
Learn some of the root causes of high cloud bills and what you can do to solve them.
The video is not available to view online.
How to Architect your Data Platform for Success Ben Jarvis
In this session we will look to understand the components and patterns that are required to set your data platform up for success when defining a high-level architecture. At a high-level we will cover areas from ingestion through to transformation and serving and look to identify the key components and architectural considerations required at each stage. During the session we’ll cover areas from security to error handling and metadata-driven execution to give you an understanding of the basics required to put a successful data platform solution together. This session is suitable for anybody that has a basic understanding of the components in the Azure data stack who wants to understand how to put them together to build a best-practice solution.
The video is not available to view online.
Keeping historical data in tables forever – mission (im)possible! Margarita Naumova
Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.
The video is not available to view online.
Lessons learned from optimizing enterprise data models Nikola Ilic
What should you do when DirectQuery is the ONLY available option? How to reduce the data model size, while at the same time satisfying business requirements? I'll share tips, tricks and workarounds learned and implemented in real-life scenarios on enterprise data models.
The video is not available to view online.
Lessons learned from refactoring multi terabyte databases for the last 10 years Sergey Olontsev
Database refactoring could be tricky sometimes. To learn more about it come to my session, where I will tell you about different situations and scenarios I've came across during the last 10 years. I will share my experience; traps, you easily can get into, and what solutions did I choose to come over it.
The video is not available to view online.
Parameter Sensitive Plan Optimization in SQL 2022 ... As Cool as it Sounds? Erin Stellato
We'll provide a balance perspective of the benefits and limitations of the new Parameter Sensitive Plan Optimization feature in SQL 2022 to help you decide if it's right for your environment.
The video is not available to view online.
Query folding in Power Query Chris Webb
Find out what query folding is, why it's important for performance and what can stop it happening.
The video is not available to view online.
Report Design & Psychology (Quick Tips) Jon Lunn
How to make you reports more intuitive, by looking at how you brain processes information in two modes
The video is not available to view online.
Should We Defragment Indexes? Rob Mandeville
You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.
The video is not available to view online.
Spark Execution Plans for Databricks Falek Miah
Introduction into Spark Execution Plans for Databricks for optimizing code and execution.
The video is not available to view online.
SQL 2022 and S3 – Dell’s overview of consuming object data via Microsoft SQL Robert Sonders
Join Dell for an overview of the architecture, components, and deployment steps for the SQL Server 2022 S3 Data Analytics validated solution on Dell’s hardware stack. This solution demonstrates data virtualization by connecting SQL Server instances to external object storage using S3 protocol, enhancing data protection by backing up and restoring from Dell ECS object storage, and exploring newly introduced T-SQL functions for better analysis of data.
The video is not available to view online.
SQL Server vs Azure Cosmos DB Hasan Savran
Do you need to move your legacy application to the cloud? or maybe you need to select a database for a new cloud project. This session will help you by comparing the functionalities of Azure SQL and Azure Cosmos DB in detail.
The video is not available to view online.
Stop Indexing the Query Rob Mandeville
Find out how to index for YOUR workload instead of adding an index for a problem query. I'll share my methodology with you to make you a better optimizer.
The video is not available to view online.
Supercharge Power BI Tooltips Reid Havens
Discover secrets of tooltip design in Power BI. Learn how to upgrade your tooltips with DAX, add dynamic charts to report page tooltips, and add design elements to information/help tooltips.
The video is not available to view online.
Synapse Q&A with PG Mark Pryce-Maher
SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.
The video is not available to view online.
The Most Important Performance Factor in SQL Server and Azure SQL Guy Glantser
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
The video is not available to view online.
Thē wönderfűl wôrld of ćollåtions, eñcodingß and téxt sţoræge Mladen Prajdic
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 all fit together.
The video is not available to view online.
Time Intelligence in Power BI Alberto Ferrari
Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation? This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.
The video is not available to view online.
Top 10 Azure Data Factory Tips & Tricks Alpa Buddhabhatti
ADF Tips and Tricks which help you to speed up your Azure Data Integration solution,save operational cost and improve performance.
The video is not available to view online.
Troubleshooting Power BI Reports Benni De Jagere
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.
The video is not available to view online.
What the heck is a checkpoint, and why should I care? Taiob Ali
This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.
The video is not available to view online.
$%*# I Learned Working for Denny Cherry John Morehouse
A quick 20 minute discuss about learning how to deal with emotional hurdles when working for a SQL Celebrity.
The video is not available to view online.
2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition) Mark Broadbent
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
3 things you don’t want to store in a database (but sometimes have to) Gianluca Sartori
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
About time: how to work with timeseries in Azure Benjamin Kettner
A guide to available services and solutions for timeseries data
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them Nikola Ilic
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
An evening with Power BI CAT team Prathy Kamasani
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
The video is not available to view online.
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
AutoML: An Introduction To Get You Started Gavita Regunath
Understand how to get started with any machine learning project using Databricks AutoML
Azure SQL and SQL Server 2022: Intelligent Database Futures Pedro Lopes
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
The video is not available to view online.
Azure SQL Database - A true story journey from migration, through synchronization and beyond. Pieter Vanhove
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
Beyond Buttons: More Than Meets The Eye Reid Havens
In this presentation you'll see many unique and creative ways to implement both both bookmarks and buttons to supercharge the filter and navigation experience for your users.
Building the Lakehouse Architecture with Azure Synapse Analytics Mike Dobing
A intro session showing the whys, how's and what's for building a Data Lakehouse in Azure Synapse Analytics
<<1234>>