Know Your Database Statistics?

Its very important to know your database stats while planning for some architectural update or database migration. The beforehand information would always add a plus to mitigate any risk and proactively take actions. Below is SQL Server script that provides information about database stats which include list of all tables, there respective record count, allocated …

Get Absolute URL – Web Application

Getting fully qualified absolute path of ASP.NET application is always tricky and problem arises when code moves across various platform. Hard coding the Application Path is no where a good solution here. The URL syntax is:

Two solutions that you can look for in such scenarios: 1. Add an entry in your web.config file …

Upload Binary data as HTTP POST

Below is the ASP.NET C# implementation of Uploading binary data like images as POST request to target URL:

The binary data so posted can be retrieved on target post URL using below code:

This scenario is very handy specifically in establishing communication between two different web technologies. For example: You can POST image …

Reverse Data Synchronization

Synchronization of data from Production to Development environment is merely a task of taking backup of Production DB, restoring it to Development environment and running to cleanup scripts to hide/overwrite user-specific critical information. This is pretty straight forward and does not even require domain knowledge. However, reverse is tricky, risky & surely need good insight …

Software Life cycle: How to do reviews?

Software life cycle is a relies on systematic solution specification, design, development, and implementation subject to continuous review and approval processes. Review process starts, right from the beginning, with the Requirements Document reviewed by the entire team and once the feedback/comments are finalised, the Requirement Document is freezed. Then comes the turn of the Technical …

Marketing – Goes Online

Marketing involves everything from identifying customer needs (through research), creating products to meet those needs and making sure they are aware its available. Marketing introduces your products and services to your potential customers and target market. Thus, plays an important factor in the success of a business. Traditional offline marketing majorly focussed on Tri-Media (Print Ads, Television & …

Detect Executable file or Virus during File Upload

Many times we fall in a situation where we have implemented detection of file type based on file extension. It’s pretty easy to do that on both client as well as server side. But does it guarantees that file uploaded is not actually an “exe” file. Well, anyone can rename an “abc.exe” to “abc.txt” and upload it to your …