Data has always had the power to transform business and Microsoft SQL Server and the Microsoft Data Platform have been at the heart of that transformation. The new wave of groundbreaking Microsoft solutions with SQL Server 2014 and Power BI address your needs for mission-critical performance and availability, faster insights on any data, and greater efficiency and flexibility. We’re excited to take you inside the technologies behind these database and business intelligence solutions—both on-premise and in the cloud. Learn more about SQL Server 2014, the next release of SQL Server. SQL Server 2014 delivers higher performance on large volumes of data with our new In-Memory OLTP technology as well as greater availability through our hybrid disaster recovery and backup solutions. Explore Power BI for Office 365, our new cloud-based BI solution that empowers you to search, discover, and access data within and outside your organization and unlock insights with rich visualizations using familiar tools on any device. See Microsoft Azure SQL Database in action, delivering predictable performance for business-critical applications in the cloud. Learn how to take advantage of these and other technologies to add greater value to your organization.
This Exam Prep session focuses on what you need to know to get certified and pass the C# Microsoft Certified Professional exam 70-483 (Programming in C#). The session is led by an expert Microsoft Certified Trainer (MCT) who regularly presents on this topic. The presenter walks you through the objectives that are covered in the exam, and gives you some general exam taking tips and technology “gotchas” about programming in programming in C#. This session will be your last step in getting ready for this exam.
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.