Tags
Content Type
Search
Conference
We introduce the concept of aggregation, we show several examples of their usage understanding the advantages and the limitations of aggregations, with the goal of building a solid understanding on how and when to use the feature in data models.
Find out how a major UK hotel chain unified their wildly different sources of data to build a supercharged analytics and pricing engine to power their business. Find out how Cosmos and Databricks helped them get to know their customers, how best to retain them, and how best to keep them happy, all while ensuring GDPR compliance and the right to be forgotten.
Do you want to know why customers chose Cosmos DB? Come learn about the business goals and technical challenges faced by real world customers, and learn about key Cosmos DB features so you can help your customers deliver their high-performance business-critical applications on Cosmos DB.
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Look inside Query Store to see what it does and how it works
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
In this session, we’ll look at the different options within the Cognitive Services suite, show you how to connect to the APIs using Python code, walk through a live bot demo, and build an Azure Cognitive Search index. You should leave this session feeling like you’ve had a jump start to further your AI developer skill set.
In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.
If you've been using Extended Events the same way you used to use Trace, you might be wondering if there's more to it. There is! In this session we will explore what else you can do with XE besides capture long-running queries.
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
Start your database off right so you can scale when you need to
The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps
Relational database engines are great, but with increasing data volumes and user patience decreasing we need to look for other options. Step forward ElasticSearch, a search engine for our data!
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 2017 / 2019 has introduced many new features.
Learn how to understand and read execution plans.
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
Join this session to learn how managing performance is even more critical with Azure SQL DB. Learn what key performance indicators are most applicable, what auto-tuning really means and get some tools to help you identify and fix issues.
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
<<12>>