SQL Server and SDS


Dynamic Data Access with Plain Old SQL and SqlQuery

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work with your data in an object-oriented way.

Supporting Updates and Deletes with Backbone and TypeScript

Peter finishes off his series on creating single-page applications by showing how jQuery integrates with Backbone to support updates and deletes (also: how to convert a string to a number in TypeScript).

NCache Distributed Cache for .NET Gets Open Sourced

Alachisoft frees up its in-memory distributed cache solution through the Apache 2.0 open source license.

Microsoft To Buy R Language Specialist for Big Data Portfolio

Microsoft today said it will bolster its extensive Big Data portfolio with the acquisition of Revolution Analytics, a company that specializes in products and services based on the R programming language.

Anypoint Platform Goes Mobile

.NET developers can now use MuleSoft's Anypoint data connetivity middleware solutions to extend its services out to enterprise mobile apps.

Multi-Swarm Optimization for Neural Networks Using C#

Multi-swarm optimization (MSO) is a powerful variation of particle swarm optimization. Understanding how MSO works and how to implement it can be a valuable addition to your developer toolkit.

The Long and Short of It

Not just once, but repeated in various lucrative apps -- a humongous chunk of code that should've been reduced to a mere line.

A Visual Studio Trick for Creating External Lists for SharePoint

Make Visual Studio do the hard work to simplify the creation of external lists that can be used to connect outside data to your SharePoint projects.

Creating Complex XML Documents with XML Literals

If you're creating an XML document and want to write code that you'll actually be able to maintain … well, it may be time to learn a little Visual Basic, just so you can use XML Literals. It's a good solution even for C# shops.

Integrating JavaScript with TypeScript (and Backbone and Knockout)

Peter looks at how to call a JavaScript function from your TypeScript code and do it in a type-safe way. Along the way, he dramatically simplifies a Backbone application by integrating Knockout.

Leveraging a Visual Studio Database Project

Peter shows how a Visual Studio database project can make you more productive when making changes to your database. But a database project also gives you a variety of tools to let you keep track of what those changes are -- which will make moving those changes to your production environment considerably safer.

Microsoft Data Platform Further Embraces Big Data

Microsoft has updated several components of its data platform to deliver more Big Data technologies to customers.

Simplifying Development with Visual Studio Database Projects

Peter learns something by listening to readers: Visual Studio database projects provide a great environment for making changes to your databases. Here's a brief introduction about how they'll make life easier for you and all the steps for setting one up.

11 Visual Studio Tools to Simplify Data Access

If wrangling queries is getting you down, these 11 data access extensions for Visual Studio can help.

Visual Studio Online Updates Identity Controls

New identity controls are among the sprint 74 updates being made to the service. Plus, Brian Harry explains the outage from last week.

Subscribe on YouTube