Microsoft Power Query in Power BI suite

I’m really excited today to be able to write about what I was working on for the past year. It is now officially announced as part of the “Power BI” suite – the Microsoft Power Query for Excel (Download).  Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel…

5

Your WebAPP’s Worst Performance Bottleneck Maybe in the CSS Stylesheet

Recently our team is making a big push for general UI performance improvements. Our UI layer is mostly a HTML5 web app that sits on top of ASP.net MVC host. The javascript code base is rather old and poorly factored, so most of our initial efforts were focused onto profiling and cleaning the javascript. We…

0

Serializing the WCF Data Service Client State

With the release of Windows Phone 7, developers using WCF Data Service Client often find themselves needing to preserve the state their data context is in, and be able to continue from a previously saved state. This is called “Tombstoning” an app – the process which the phone framework notifies the app for shutting down,…

4

Using ASP.net Output Caching with WCF Data Services

We all know hitting the database is an expensive operation, adding the cost of serialization on top of that means that caching the output makes even more sense. The fact that WCF Data Services is built on top of the ASP.net platform means you can utilize all of its power to help you build a…

11

Using WCF Data Service With Restricted Characters as Keys

If you are hosting your WCF Data Service on top of IIS+ASP.Net/WCF, then you may discover that there are certain characters that will cause the server to throw when they are contained in entity keys. The result is either a 400 Bad Request or 404 Not Found. In VS 2010 RC, you can potentially configure…

11

Overwriting the service root URI in Wcf Data Service

Suppose you are hosting a WCF Data Service on a particular URL, but for some reason you’d like the consumers of your service to hit another URI – perhaps an IIS re-write, or a cookieless session. You can do this via setting one of the custom properties in the OperationContext: OperationContext.Current.IncomingMessageProperties["MicrosoftDataServicesRootUri"] = serviceUri; You need…

3

SDET Openings in Our Team

For those of you who love the technology, and want to put your amazing skills to good use – well, now it’s your chance! The Data and Modeling Group at Microsoft has two open Software Development Engineer in Test positions, you can find the description here and here. Don’t let this exciting opportunity just slip…

0

WCF Data Service V2 and the updated JSON format

In V1 of WCF Data Service (aka ADO.net Data Service), the JSON serialization format for entity sets look like: { "d" : [ {entity1}, {entity2} ] } Where “d” is the “data” wrapper, used as a security measure, and it is defined as the array of elements in the entity set. For example, if you…

2

Versioning Protocol of Astoria II

In my previous post on the protocol versioning scheme for Astoria, I’ve explained the two HTTP headers DataServiceVersion and MaxDataServiceVersion. These headers are used by the server and client library to determine how and what to communicate with each other. This mechanism is defined by the Astoria Protocol and our library’s implementation does not require…

3

Working with Local Entities in Astoria Client

Although the Astoria client is really designed to query data existing in some remote service location, it does keep a local copy of all entities it has seen. If the MergeOption is not set to NoTracking, you can find all of the entities currently been tracked in the DataServiceContext.Entities property. The property is defined as:…

1