SQL Server and SDS


Integrating Updates, Deletes and Inserts with TypeScript and ASP.NET MVC

Peter returns to his AJAX-enabled ASP.NET MVC application to show how Partial Views and TypeScript work together to simplify delivering a Single-page application.

Use OData Containment To Make the Easy Connections in an ASP.NET Web App

The Open Data Protocol allows for creation and consumption of REST APIs. Sam Nasr demonstrates OData 4 in a sample app that demonstrates containment, a new feature for facilitating data access.

The Power of Talking About Your Business Processes Correctly

One of the biggest problems in designing applications is the conversion from how the business talks about the business to how the developers think about coding it. Domain-driven design has a solution.

Entity Framework 7 Beta 6 Out in Preview

EF7 Beta 6 adds data annotations, customization of reverse engineer via templates, and support for raw SQL commands.

Why I'm Excited About DocumentDB

DocumentDB brings together the best of No-SQL and the cloud, to give you a robust scalable data persistence engine. Here's what you need to know to start developing projects with it.

C# Developers Can Tap Into Azure AD Reporting Data

Developers can tap into Azure AD reporting data and create custom dashboards with the availability of a number of reporting APIs that Microsoft has released as previews last week.

Dynatrace 6.2 Gives .NET Devs a Deep Dive into App Performance

The performance monitoring suite adds new components that provide for deeper looks at applications as well as the user experience with those apps.

Tips for Snagging That Senior Developer Job

You're vying for a senior developer position. Here's what you need to know to win over your interviewer.

Speed Up Stored Procedures with Table Valued Parameters

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the call.

Leveraging Custom ASP.NET MVC Templates to Support Real-World Views

In the real world, you'll often need to display constant and repeating data, a.k.a. Master/Detail pages. Custom templates are the cleanest, simplest way for you to manage them.

Displaying Data Flexibly with Custom View Templates in ASP.NET MVC

You don't always want to display the same data the same way. Here are your options for leveraging custom templates in Views to meet all of your needs -- and the code you need when a template won't do the job.

Neural Network Train-Validate-Test Stopping

The train-validate-test process is hard to sum up in a few words, but trust me that you'll want to know how it's done to avoid the issue of model overfitting when making predictions on new data.

The Danger of Received Wisdom (or, Stupid Things I've Said)

Peter reviews some of the more spectacularly incorrect things he's told other people and then draws some conclusions.

'Always Encrypted' Leads New SQL Server 2016 Features

Microsoft said a new Always Encrypted security feature highlights its upcoming SQL Server 2016 -- "the biggest leap forward in Microsoft's data platform history" -- shipping this summer in a public preview.

10 Takeaways from Microsoft Build

Microsoft believes Windows 10 will be big for consumers, and an even bigger opportunity for developers. The company trotted out nine more solutions that should keep developers busy.

Subscribe on YouTube