SQL Server and SDS


Q&A: Philip Japikse on Hands-On with ASP.NET Core and EF Core

'I think ASP.NET Core is the biggest game changer in the history of Web development using the Microsoft stack.'

Quick Tip: Switching to SQL Azure

If you're thinking about moving to the cloud, the first step might be the easiest.

Q&A with Leonard Lobel: Top New Security Features for Developers in SQL Server 2016

SQL Server expert Leonard Lobel explains exactly how Always Encrypted, Dynamic Data Masking, RLS and more can make a real difference in securing your enterprise databases, plus he shares his favorite overall new feature in SQL Server 2016.

Azure Data Factory Takes Visual, Low-Code Route

In response to developer feedback, Microsoft is taking a page from the growing visual, low-code development approach to simplify Big Data analytics in the cloud with Azure Data Factory.

How to Query JSON Data with SQL Server 2016

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Second SQL Operations Studio Update Ships

The lightweight, cross-platform offering combines functionality found in tools like SQL Server Management Studio and the Visual Studio Code editor in order to help data developers and operations pros work with SQL Server, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Managing Temporal Data in SQL Server 2016 and Azure SQL Database

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.

Tracking History in SQL Server 2016 and Azure SQL Database

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the history of your data.

New Realm .NET Caters to Mobile Dev Platform's 'Fastest Growing Segment'

Realm has boosted the Microsoft stack capabilities of its mobile development platform, catering to C# coders and .NET developers, who constitute the platform's fastest growing segment of users.

Retrieving and Updating JSON Objects in SQL Server 2016

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.

Building the Object Model You Want with Entity Framework

When it comes to inheritance, relational database theory and object-oriented programming have more in common than you might think. Understanding that overlap is critical in designing the object model that will generate the database design your application needs.

AI-Based Automatic Tuning Is New Default for Azure SQL Database

Automatic tuning assisted by artificial intelligence will be enabled by default for the Azure SQL Database service starting early next year.

Microsoft Updates Entity Framework, Even as EF Core Ascends

Microsoft shipped a new release of the nine-year-old Entity Framework object/relational mapper (O/RM) runtime even as it cedes mindshare to the newer, lightweight, open source and cross-platform version, Entity Framework Core.

Two New Features in SQL Server Management Studio

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.

Querying JSON Data in SQL Server 2016

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.