SQL Server and SDS


Azure Outage Rolls Through Europe, India

A significant disruption of Microsoft's Azure cloud services has affected a large number of customers in Europe and India, and it's really trying the patience of developers using Visual Studio Team Services, with only partial use of services back online as of Friday afternoon.

It's Not the Names that Matter

As you work with other developers (and seek advice from experts) you need to make sure you're discussing what matters rather than arguing about terminology.

Storing Lots of Data on the Client in JavaScript and TypeScript

IndexedDB allows you to store data on the client to let the user work offline and to reduce demands on the server. Here's enough code to both get you started and to show you the difference between doing it in JavaScript and doing it in TypeScript.

With ASP.NET MVC and Data Transfer Objects, The Bigger the Better

Create the best object for moving data from your Controller to your View.

Reduce Trips to the Database Service with EF.E's Future Queries

One way to slow down your application is to make multiple trips to the database. Here's a way to cut those trips in half (at least) and it has to do with the EntityFramework.Extended library.

It's All About Character in C# and Visual Basic

How C# and Visual Basic handle characters and single-character strings is a bit inconsistent. There's no tidy solution, but it's something you do need to know.

Making Your Data Updates and Deletes More Efficient

By adding one open source library to your application (and adding two methods to your LINQ statements) you can cut the time spent on database updates and deletes in half.

R Language Basic Data Structures

Vectors, lists, arrays, matrices and data frames -- a look at five of the most fundamental data structures built into R.

LINQ Query Enters the Age of Big Data

Integrating distributed, in-memory computing with distributed caching can easily extend LINQ semantics to create important new capabilities for real-time analytics on fast-changing data.

Potentially Save a Trip to the Database with Updates in Entity Framework

Here's a tip about how to exploit Entity Framework's change tracking mechanism to -- possibly -- eliminate a trip to the database when you update an item. But, without some additional code, you probably can't use it.

A Lifetime of Data in C# and Visual Basic

Or, how lifetime can mean different lengths of time, depending on whether it's procedural- or block-level.

Integrating SQL Server Reporting Services Reports and ASP.NET MVC

There are so many ways to integrate an SSRS report into your page that the biggest problem you'll face is deciding which one to use. Peter runs through all the solutions he can think of, including those cases where you want to download the report as a file.

Permutations Using R

R has limited support for mathematical permutations, but it's there. Here's what R is capable of accomplishing.

Visual Studio 2015 Update 3, .NET Core and ASP.NET Core 1.0 Out Now

Finalized versions of Microsoft's venerable software technologies are now generally available, and for Visual Studio 2015 U3, it includes the resolution of some high memory consumption issues that bedeviled some larger VS customers.

Creating a Flexible, Extendable Update Process

In any real-world business, updating data isn't simple and changing the rows in the table is just the start of a complex set of processes. Fortunately, you can break those updates down into a bunch of simple processes that can be easily extended.

Subscribe on YouTube