You may think that there is much in SQL Server that appears to work as if by magic? And you would be right! But despite this magic, everything is actually quite easy to understand. This 500-level report contains information about the internal data storage format in SQL Server (MDF files), as well as about how you can work with the data using only a hex editor. You will learn about how SQL Server stores internal metadata for objects and about how you can find and read the data on the disk.
Even though the cloud provides elastic scale and seemingly infinite resources, you still have to design, monitor and tune performance. Microsoft Azure SQL Database has architectural differences from SQL Server and understanding how these can impact performance is critical. In this session, Microsoft Azure MVP, Eric D. Boyd, will show you how you can identify bottlenecks and the cause of performance problems in SQL Database. This session will introduce you to the tools you can use to investigate throttling, connection events and resources, and poorly performing queries such as dynamic management objects (DMVs and DMFs) and cloud-based tools in Microsoft Azure. You will also learn how to appropriately handle throttling in your applications and scale by partitioning databases.
Version 6 of the Entity Framework (EF), .NET’s data access and object-relational layer, is included with Visual Studio 2013. Features such as async query/save, connection resiliency, command interception/logging, custom Code First conventions, code-based configuration and Code First stored procedure mapping make EF6 a significant upgrade. Watch this video to see new EF features in action.