SQL Server and SDS


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.

Build Your DOM Additions with Angular and TypeScript

Here’s how, in Angular, you can use directives to dynamically modify HTML in Views without polluting your business logic.

SQL Server 2017 Debut Highlights Ignite Conference

SQL Server 2017 will officially hit general availability on Oct. 2, Microsoft announced today at its Ignite conference in Orlando, Fla.

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.

Angular Q&A: Components, Getting-Started Tips (and that 'Total Rewrite' Thing)

Noted database expert and author Ted Neward discusses his favorite features of Angular and explains how to get started with the popular platform for building Web, mobile Web, mobile native and desktop apps.

Your First Angular App: Events and Updating

Peter completes his walk-through of creating a simple Angular app with TypeScript by responding to events, accepting data from the user and updating data back at the server with an AJAX call.

LocalDB: The Database Without a Connection String

If you just want to get going with a code-first database, you don't even need to define a connection string -- just write your objects.

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.

Create Parameterized Queries in ADO.NET

Squash the dangers lurking in your SQL queries by setting parameters by way of parameterized queries.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.