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.
Entity Framework is Microsoft's recommended data access technology for new applications in .NET. We'll explore how the current release of Entity Framework can be used to build applications. We'll also look at an early preview of EF7, a modern, lighter weight, and composable version of Entity Framework (EF) that can be used on a variety of platforms, including ASP.NET vNext, Windows Phone and Windows Store. This new version will also support targeting non-relational data stores.
The Lync Call Quality Methodology (CQM) is a practical approach that applies the broad guidance we have published in the Lync Networking Guide. CQM is a data driven framework backed by SQL queries and an operational process to systematically improve and maintain call quality. CQM was derived from Microsoft and some of our largest customer deployments. CQM was published in v2 of the Networking Guide complete with queries and an updated set of 2010/2013 KHIs. This session will go through the individual components of CQM, describe our recommended process for implementing it, show findings from using CQM and go into detail on how the SQL queries work and how you can customize them for you or your customer's needs.