You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.
Learn about the component of Power BI and best practices for implementations
In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
DirectQuery best practices in Analysis Services and Power BI
Introducing the ROC curve and its use in Azure ML.
For anyone frustrated by column-hoarding users and developers
<<12345678910...>>