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.
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.
Cosmos DB Serverless in a Nutshell
The video is not available to view online.
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.
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.
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.
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.
Improve analytic queries by unlocking the secrets of columnstore compression!
The video is not available to view online.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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>>