Massoud Mazar

Sharing The Knowledge

Sql Server Spatial and Unmanaged Memory Leak

Encountering memory leaks in a .net application is not very common, but when dealing with one which is not common and you cannot find any mention of it online, it is even harder to resolve. I had one of these encounters this week and took me a couple of days to find a solution for it.

A product I'm working on, makes extensive use of SQL server DbGeometry types to store and manipulate GIS data. DbGeometry type is provided in the System.Data.Entity.Spatial library, which can be added to your .net code using the Microsoft.SqlServer.Types NuGet package. After a trivial change in the code I realized it is failing on the QA server where it was deployed to. Strangely there was no failure on the development machine. Failure on the server was surfacing as processing taking so ling it would timeout. Observing the server health revealed unprecedented memory use when this new part of code was being executed. More...

Restrict Access to your Google App Engine API using Service Account

I needed to access my restricted Google App Engine API from an Android App using a Service account. Let's say, I don't want to ask my users to authenticate with their Google accounts to my Android App, and I also don't want any third party access my App Engine API. All the documentation I found online was about how to authenticate with backend using users, but nothing about using service accounts. Even on many StackOverFlow articles people say it is not possible.

So, here is summary of steps: More...

From T-SQL to NoSQL

I know I have been stuck with SQL server for too long and a lot behind in adopting newer database technologies, but late is better than never. While updating a web application which uses SQL Server, I realized the current relational structure of my database is not really the optimal solution. I have more than 120 million rows of data in one of the tables which represent Option Chains for Stocks, one row per Option. I store this data as snapshots in time and do not change them after they are stored. Anyone familiar with this type of data knows that these individual rows are not really interesting by themselves and they are normally looked at alongside others which belong to the same Stock, and with same expiration. In real world you are presented with the whole chain (see an example of such data here). More...

Quick and easy Custom 404 page for ASP.net MVC 5

While ASP.net MVC makes it easy and clean to create a professional looking website, it seems to be a little harder to incorporate custome error pages (e.g. 404 page) which are part of general look and feel of your site. There are many good write-ups on how to do this (for example http://benfoster.io/blog/aspnet-mvc-custom-error-pages), but I was looking for an easy way to point to one of my views as the 404 page.

What I ended up doing was to create a controller for my error views and use the httpErrors section of web.config to point to it: More...

Adding and removing Self Signed Certificates in IIS

It took me a little bit to get a handle of creating and using Self Signed Certificates for IIS on a Windows Server 2012. Problem was not so much about running a couple of commands to create the certificate, but more related to where things are and what to do when things go wrong.

This page provides 2 commands to create a self signed certificate to be used by IIS. I had to make the key length equal to 2048 so Chrome browser does not complain about the keys:  More...

Simulate asp.net authentication for Roku player

Few weeks ago I decided to add a channel to my Roku box to play live videos from a Free-To-Air Satellite TV channel. This specific channel has a live video stream from their website which requires authentication. My challenge was to build a Roku app using provided SDK to simulate the authentication process of the asp.net website so I can grab the URL of the live stream. (URL has a token attached to it which requires authentication).

To accomplish this More...

Trick Google Chrome to save password

Today I was trying to get Google chrome to save my username and password for a web site but it would not offer me to save it. This web site uses the browser popup for login credentials (which is caused by the server sending back HTTP 401: Unauthorized). Chrome would show the popup and I could login after entering credentials, but would not offer to save it. My settings related to saving passwords was correct and this site was not in the "Do not save" list. I tried many solutions, like deleting files from App Data folder or even uninstalling and re-installing chrome. Until I found an interesting behaviour by accident. More...

C# code to play PCAP capture of HTTP request

If you have been involved in troubleshooting web applications providing APIs to clients, you know how easier it is to have the actual request sent from client and be able to replay that against your server code to find the problem. Tools we use in my team is WireShark and NCAT. When QA team finds a problem, we always ask for the WireShark capture of the communication. More...

SQL server vs AppFabric Cache: Performance and Memory consumption

There are many great articles on the internet comparing MS SQL server and AppFabric, and all of them show how AppFabric has better performance over SQL server. It is completely understandable that with complex queries, AppFabric would out perform SQL server. But in an environment where you have a huge number of very small objects to be cached and looked up, AppFabric shows very weak results. More...