SQL Server and SDS


Azure Database Migration Service in Limited Preview

With previews announced at Microsoft's Build Conference, the database migration service will allow developers to migrate on-premises databases to the cloud without so much as a hiccup.

Speed Up Your ASP.NET MVC Application with Doughnut Hole Caching

The OutputCache attribute is a great way to improve both response time and scaleability, except there are many times when you can’t use it. Here’s how to leverage the HtmlHelper Action method to handle those exceptions.

Microsoft Build 2017: Evolving the Mobile-First, Cloud-First Message

Microsoft CEO Satya Nadella provided the framework of Microsoft's developer tooling and services so far and a nicely detailed glimpse into future direction. Then EVP Scott Guthrie detailed the vast number of new and upcoming offerings as a preview to the sessions taking place the rest of the week.

This R/S4 Demo Might Take You Out of Your Comfort Zone

Let's explore factor analysis again, this time using the R ability to tap into OOP, but we won't use the RC model.

Monitor and Respond to Document Store Events in Marten

It's possible to hook into document store events to monitor (and even modify) behavior.

The Best Option for Selecting Related LINQ Objects

Here's the best performing option when you're retrieving the objects at the end of an entity class's navigation property, either when you only want some of the objects or when you only want them some of the time.

SQL Server 2017 CTP 2.0 Now Available

The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community Technology Preview 2.0.

Grouping in LINQ with Methods

Peter follows up -- yet again – on a column on how to group results with LINQ using the SQL-like syntax with the same solution using the method-based syntax. And, no, you're not seeing double.

Controlling Process Flow with the Template Method Pattern

If you have a process that needs to be performed -- but with variations -- then implementing the Template Method pattern will give you simpler, more extensible code. You’ll also recognize this pattern from all the times you work with it in the .NET Framework.

Getting All the Results in LINQ with Methods

Peter follows up on advice for joining collections with LINQ and getting all of the results, but this time, he uses the method-based syntax.

Adding New Formats to Old Data

The custom formatters in the .NET Framework provide a more seamless way to mix traditional and custom formatting situations.

R Tools for VS Plug-In Launches

It's at 1.0, with a version supporting Visual Studio 2017 to follow some time in May.

Checking Up on Your Entity Framework Objects with DbEntityEntry

The Entity Framework DbEntityEntry object lets you do all sorts of things you probably didn't think were possible, including getting the latest data from the database (without losing your current data) and invoking the .NET Framework validation subsystem.

Revealing Secrets with R and Factor Analysis

Let's use this classical statistics technique -- and some R, of course -- to get to some of the latent variables hiding in your data.

Efficiently Loading Related Objects in Entity Framework

If you're not using the Entity Framework DbCollectionEntry object when working with an entity class's related objects, then your application is running too slow. Using DbCollectionEntry lets you asynchronously retrieve related objects and get only the objects you want.

Subscribe on YouTube