Archives for March 2014

ASP.NET Web Optimization Framework

ASP.NET Web Optimization Framework was introduced by Microsoft as a way of optimizing the ASP.NET Web Application performance. To optimize the application, the framework works by reducing the number of requests to the server, and reducing the size of the requested resources.

Why should we use this framework and why is it the necessity of this framework? First, we need to understand what it does. There are several reasons for using this framework:

Single web pages use many Javascript binaries for different functionalities thus the cost of downloading a lot of resources grows significantly. This framework reduces latency.

Most browsers limit the number of simultaneous connection for each hostname. If more than 6 requests are process, then additional requests are queued by the browser.

Read the rest of the post here:

Windows XP Security Tips for Those Who Still Love Windows XP

Microsoft offered some last-minute security, advice for those who are still planning to be in Windows XP after the support ends. Most companies should have already upgraded from Windows 7 to 8.1 before Windows XP loses its extended support on April 8. After that date, systems running in Windows XP are considered unsupported and won’t get any monthly security updates from Microsoft.

Despite a lot of potential security implications of losing product support, Windows XP is still widely used today. Some organizations won’t just quit using Windows XP, so here are some security tips for those who just love Windows XP.

Read the rest of the post here:

How to Generate Bar Code Using ASP.NET MVC

A Bar Code is a machine-readable code in the form of numbers and pattern of parallel lines in varying width usually used for stock control. In this article, we’ll show you how to make a bar code using ASP.NET MVC 4. To start this task, you will need a font named “FREE3OF9.tff”. Download it at

First, we need to create a database for storing barcode image, or the barcode number used for displaying the bar code.

Then we create model in model for data accessing.

Now, using Visual Studio 2012, create a new ASP.NET MVC4 Web Application in Visual C#. Name it BarCode or whatever you like.

Then create a view.

Then follow this guide for full instructions:

SQL Server Indexing Questions We Are Shy To Ask

The first thing you need to understand about SQL Server is indexes.  Somehow, some of the basic questions are often overlooked. They aren’t get asked or not much has answered it in forums. In this post, we’ll share some of the indexing questions we are shy to ask but often an integral part in understanding SQL Server.


Why can’t a table have two clustered indexes?

There are a lot of benefits in clustered tables, so why bother with heaps?

How do I override the fill factor when creating an index?

Can you crate a clustered index on a column with duplicate values?


And more…

Read the rest of the article here:


What is the Difference Between Latches and Locks in SQL Server

What is latch/locks waits in SQL Server? If you are seeing waits in a wait type of  %latch%, does it mean that the process is waiting to place a Latch on a resource or is it a process waiting on a resource currently has a latch on it? If you are seeing waits with a wait type of %LCK%. Does it mean that the process is waiting to place a lock on a resource that currently has a Lock on it?

The answer is simple. This post will explain the difference between latch and lock and what it does in your page.

Read the rest of the post here:

Upload Files to Database From an ASP.NET Page

Using C#, it is possible to upload files to SQL Server database. Here we demoed how to do it by creating a sample database that has one table with columns: FileID, Filename, Extension, ContentType, Document. The FileID serves as the primary key in table.

Here is the code:

 <form id="frmMain" runat="server">
<input type="file" id="txtFile" title=" Browse for file which you want to save " Runat="server"/>
<input id="btnSave" type="button" value="Save" onclick="document.frmMain.submit()" />


The code below is to create a statement for FileID Table: 

CREATE TABLE [dbo].[File](
[FileId] [int] IDENTITY(1,1) NOT NULL,
[Filename] [varchar](100) NULL,
[Extension] [varchar](8) NULL,
[ContentType] [varchar](50) NULL,
[Document] [varbinary](50) NULL,
[FileId] ASC

Read the rest of the tutorial here:

Database Integration with SQL Azure

Did you know that we can integrate our database with SQL Azure? W will use the SQLAzureMW tool that is the Azure plugin for migrating database from our local database to the azure cloud.

Windows Azure SQL Database does not support all the features and data types found in SQL Server. However, Analysis Services, Replication, and Service Broker are not currently provided in the Azure Platform.

Windows Azure SQL Database performs physical administration and any statements and options that attempt to directly manipulate physical resources will be blocked like the Resource Governor, file group references, and some physical server DDL statements. It is also not possible to set server options and SQL trace flags or use the SQL Server profiler, etc.

Initially, we generate SQL scripts but we’ll have a lot of problems with it. So in this post we resolve an ew way to generate the replica of the database on SQL Azure.

Read the rest of the article here:

MVC Application Life Cycle

As developers we are aware that some components used by the MVC framework to process the request. Most of the time, we work with controllers and the action methods.

When you invoke an action, everything happens as if you were calling a method in the controller class. How can we go from an HTTP request to a method invocation with arguments? It’s simple. Lets look a the frameworks as it is the always useful to find solutions to recurring problems.

There are 5 steps of an MVC application life cycle. Let us look at these steps in detail, read the full article here:


What is Private Cloud and Why You Need It

Private cloud is presented to organizations as solution for all their computing issues. It promises a lot of benefits like cost savings, rapid depolyment, energy savings, and customer empowerment. What is private cloud? Why are people considering using Private Cloud?

A private cloud is a cloud infrastructure that is dedicated to one customer. A private cloud can be located in the customer’s data center or computer room but must be hosted in a service provider’s data center. A private cloud is managed by the customer, the hosting provider, or by a third party. The customer will be responsible for cost of the solution at all times.

Why do we need it? Let’s dig into detail.

Read the rest of the post here:,-what-is-it-and-why-do-you-need-it/


Introduction to Web API Versioning

Versioning of API is required especially if you are providing services for the public. It is also a way of your APIs to support forward and backward  compatibility. Through versioning, you can’t affect the existing customers and break their applications which depends on your API.

By default, the Web API routing logic finds the controller by class name. The controller selection is handled internally by Web API through DefaultHttpControllerSelector that implements IHTTPControllerSelector.SelectController. We cannot version Web API’s with the default controller selector but we can plug in our custom implementation for selecting the right version at run time. By implementing IHTTPContrllerSelector interface, you can create a custom API easily.

Read the rest of the article here: