Data and Modeling Customer Advisory Team

Check out the Epicor Case Study that was recently published by one of our partners. Epicor is a global software company that creates enterprise resource planning (ERP) solutions for manufacturing firms and other customers. They have been able to leverage...

A previous post discussed potential issues with Compiled Query recompiles. The cause of the recompile issues were actually uncovered by using the Visual Studio 2010 Profiler . This blog will cover how the Profiler can be used to discover performance issues...

Introduction Working with customer’s solutions, we often have to track down potential performance issues or uncover areas for improvement. One of the techniques is to try and measure the relative performance gained using the different configurations or...

When calling a query multiple times with Entity Framework the recommended approach is to use compiled LINQ queries. Compiling a query results in a performance hit the first time you use the query but subsequent calls execute much faster. The CompiledQuery...

Author: Dana Kaufman Reviewers: Jaime Alva Bravo, Chris Sells, Kraig Brockschmidt, Matthew Snider, David Miller Introduction The RouterManager sample uses the recently released SQL Server Modeling CTP and the new WCF Routing Service in .NET 4...

Welcome to the SQL Server Data and Modeling Customer Advisory Team (DM CAT) blog. Our team assists customers in adopting Microsoft’s Data Development Technology and shares the knowledge we gain with the rest of the Microsoft community. You can look forward...

Author: Dana Kaufman Reviewers: James Podgorski, Jaime Alva Bravo, Chris Sells, Matthew Snider, David Miller, Scott Roberts Introduction One of the major new WCF features in .NET 4 is the Routing Service which is a configurable WCF-based service...