SQL Server


Returning JSON from SQL Server Queries

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

SQL Server 2017 Inches Toward General Availability

The venerable relational database management system is now feature-complete, with support for Linux and containers running on Linux and Mac OS X, and it's available as a release candidate this week.

How I Approached Gaining Microsoft Certification

If you’re thinking about pursuing a Microsoft Certification, here’s how and why Peter went through the certification process for the second time, including his feedback on some of the resources available to you.

Entity Framework 6.2 Emerges Out of Preview

This more fully-fledged version of Microsoft's object relational/mapper is now at the initial beta testing stage, with quicker startups and a number of fixes from the preview, but there's also more work to do to resolve some issues that can impact EF providers. Also: a list of new features of the EF Core 2.0 preview released at Build.

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.

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.

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.

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.

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.

Getting All the Results When Joining with LINQ

When you want to find all the objects that are missing a corresponding object, then you need the LINQ equivalent of an outer join. Here, step by painful step, is how to build that query.

Tools for Data Access in Visual Studio

Whether you're building an application database or generating data access code, we've got a round-up of tools to make the job easier.

Build Data Applications for the Universal Windows Platform Using Entity Framework and SQLite

Saving and retrieving data is a fundamental part of all but the simplest of applications. In this article, Nick walks through getting started using Entity Framework with SQLite to persist application data.

SQL Server SP1 Gets Connected

One highlight of this roll-up release is the addition of row-level security and dynamic data masking, which were only available in the Enterprise version, are now in Standard, Express, and other versions.

What Makes SQL Server 2016 a Game-Changer

Polybase, Query Store, dynamic data masking, row-level security, and temporal data JSON support -- just some of the new features that veteran SQL Server Live! presenter Leonard Lobel covers in this exclusive Q&A with Lafe Low.

Azure Outage Rolls Through Europe, India

A significant disruption of Microsoft's Azure cloud services has affected a large number of customers in Europe and India, and it's really trying the patience of developers using Visual Studio Team Services, with only partial use of services back online as of Friday afternoon.

It's Not the Names that Matter

As you work with other developers (and seek advice from experts) you need to make sure you're discussing what matters rather than arguing about terminology.

With ASP.NET MVC and Data Transfer Objects, The Bigger the Better

Create the best object for moving data from your Controller to your View.

Integrating SQL Server Reporting Services Reports and ASP.NET MVC

There are so many ways to integrate an SSRS report into your page that the biggest problem you'll face is deciding which one to use. Peter runs through all the solutions he can think of, including those cases where you want to download the report as a file.

Now In The AWS Marketplace: WinDocks

WinDocks is now available for .NET developers looking for a smoother solution for spinning up Windows Server 2012-based Docker containers in the AWS cloud.

SQL Server 2016 To Be Released June 1

Microsoft's venerable RDBMS gets a major update, with a developer-enabled version that unclutters the enterprise database solution development process.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.