Brian Keller sits down with Aaron Bjork (Visual Studio Online) and Bret Grinslade (Application Insights) to talk about some of the latest updates being made to this set of cloud-hosted services for developers and operations.
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.
Windows Azure SQL Database is a fully managed relational database service based on SQL Server technologies. In this video, we will take a brief tour of Windows Azure SQL Database, and show how SQL Server Data Tools in Visual Studio 2013 interfaces with it, enabling rapid development of sophisticated relational databases in the Windows Azure cloud.