SQL Server and SDS


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.

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.

Visual Studio 2017 15.3, .NET Core 2.0 Trio Previews Now Out

It's the third preview for VS 2017 15.3, which sports mostly fit-and-finish improvements of many user-reported issues, and second preview for the .NET/ASP.NET/Entity Framework Core 2.0 trio.

AI Gets Smarter with Microsoft's Cognitive Toolkit 2.0

Microsoft's second release of its open source deep learning framework earlier this month adds support for Java bindings, Spark, and Keras.

Reduce Overhead When Retrieving Objects with Entity Framework

If you're only retrieving an object so that you can read its data, you can reduce your costs by turning off Entity Framework tracking. Which is exactly what you want to do in ASP.NET MVC, as long as you're careful.

Azure Cosmos DB Is Out of This World

Microsoft dubs it the "first globally distributed, multi-model database service delivering turnkey global distribution with guaranteed uptime and millisecond latency at the 99th percentile." Also announced: Azure DB for MySQL and PostGreSQL previews.

The Fraternal Twins of Equals and GetHashCode

Lots of searching through lots of data means potential app performance degradation. Hash codes can speed things up.

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.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.