DAX is not only an expression language, but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. This session introduces DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations. Many practical examples based on common patterns and an analysis of the query plans will show how to get the best out of DAX.
You've migrated parts of your application to in-memory. But now you are not seeing a serious performance improvement, or maybe even a performance degradation! What's going on? In this session we walk you through several performance problems we have seen with customers, and show how to diagnose and resolve the issues to ultimately obtain the performance improvement you're looking for from in-memory OLTP. We address a variety of issues, including log IO bottlenecks, index tuning, and query plan problems.
In April at Build 2014, Microsoft unveiled universal Windows apps, a new approach that enables developers to maximize their ability to deliver outstanding application experiences across Windows PCs, laptops, tablets, and Windows Phones. This means it's now easier than ever to create apps that share most of their code. Code can be shared using the new shared app templates, as well as by creating Portable class libraries. This session will walk through the development of a shared app and will discuss where it still makes sense to implement platform specific features.