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