Database
Are you still rebuilding all of your SQL Server indexes every week, but you’re still having performance problems. Odds are, you’re not actually making things better: you’re making them worse! Learn about the 3 kinds of fragmentation, the 2 worst things you can do about it, and the 1 way …
It’s incredibly easy to make big mistakes with indexes in SQL Server. This video presents the three most common mistakes people make with their indexing. You’ll learn how these mistakes can have disastrous impacts and practical steps you can take right away to identify if these problems exist in your …
This short video explains how to set up a connection to MongoDB with C#. MongoDB is an open source NoSQL database.
This session covers the use Entity Framework in .NET based applications. It includes model creation and organization as well as schema evolution via migrations. The role of data annotations in Entity Framework model creation and validation will be highlighted.
If you want the most out of your SQL Servers, then it’s essential you’re monitoring them constantly. SQL Server performance is affected because of high memory and CPU usage. Many times, this leads to bottlenecks in your SQL environment bringing your applications to a complete halt. Ensure other aspects such …
The session focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this session you will learn the details and capabilities of T-SQL: Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Type Related Problems; Programmable Objects; Graphs, …
