Refactoring T-SQL with Windowing Functions

You’ve been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and subqueries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Watch a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to write.

AngularJS and ASP .NET MVC Quickstart

AngularJS is a JavaScript framework that enables provides features such as two-way databinding and templating. It enables you to build awesomely responsive user interfaces while avoiding big-ball-of-mud JavaScript implementations. This session explains how to get started with AngularJS and provides a broad view of many of the features and concepts that make this library ever […]

Introducing ASP.NET SignalR 2

The first version of ASP.NET SignalR was released earlier this year and with it, ASP.NET developers have been adding amazing real-time Web functionality to their applications. This video explores some of the improvements in the new version of SignalR included with Visual Studio 2013.

Index Fragmentation in SQL Server

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 to fix the problem permanently.

Positioning Microsoft Development Technologies for Custom Application Development

The approach for every type of application (“A single architecture/approach to rule them all”) won’t work. The Microsoft development stack and .NET are extremely flexible and offer many possibilities, but you have to select specific approaches and technologies depending on what kind of application or even subsystem you are going to build. Each application will […]

Sharing C# Across Windows, Android and iOS

1.4 Million new Android devices are activated every day. 500 Million iOS devices sold. You can target all of them today from your existing C# skills and code using MvvmCross. MvvmCross is a Mvvm Platform for Xamarin.iOS, Xamarin.Android, WindowsPhone, WindowsStore, WPF and Mac. It includes databinding support for Android XML, for iOS XIBs and for […]

TDD: Where Did it All Go Wrong?

Since Kent Beck wrote the book on Test-Driven Development (TDD) in 2002 a lot of words have been dedicated to the subject. But many of them propagated misunderstandings of Kent’s original rules so that TDD practice bears little resemblance to Kent’s original ideas.