SQL Server and SDS


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.

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.

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.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.