<p>Being the acting DBA while at the same time doing development &amp; managing a team of .NET developers, I've learned a trick or two through the years. For this session, I've gathered my list of top tricks any .NET developer should know about, and use, when dealing with SQL Server. I will cover how to use TransactionScopes without locking up the database, avoiding MSDTC escalation, utilizing internal batching functions in the BCL through reflection, avoiding unnecessary round trips, and much more. These are tips, tricks &amp; best practices I ensure all my developers are taught, before they have a chance of committing code to our production systems.</p> <p>In this session I will walk you through some of the most typical mistakes that .NET developers make when using SQL Server. Things like ignoring the default isolation mode, sending multiple queries that can easily be batched together, wrongful use of transaction scopes, and much more. This won't be a 101 on how to use SQL Server, but rather an in-depth look at how to optimize the use of SQL Server, from the perspective of a .NET developer&nbsp;</p> <p>&nbsp;</p>