Ashok Basnet

Engineer | Entrepreneur | Programmer | Blogger | CEO / Co-founder [Mantra Ideas Pvt. Ltd.]


Ashok Basnet

Randomly generate password in SQL Server 2008

There are lots of ways of generating random strings in SQL Server. But instead of spending much time on finding solution to random password generation, here is an easy way to do that. SELECT SUBSTRING(convert(varchar(50),NEWID()),0,8) as password This generates 8… Continue Reading →

Using Cursor to iterate through records in sql server 2008

Cursors are great way to loop through records in SQL specialy when you need to deal with individual records from certain table. Here is a example using cursor; DECLARE @StudentID char(11); DECLARE crs CURSOR READ_ONLY FOR SELECT student_id FROM students… Continue Reading →

Conversion of Imperial to Metric System in SQL Server 2008

There will be case when you need to convert the values in Imperial system i.e. in feet and inches to the one in metric system. The conversion logic seems simple, but when it comes to SQL Server, it takes a… Continue Reading →

Reset indentity value of Auto increment Key to 0 in SQL server 2008

I have been searching for resetting the Auto increment value of ID Column in MSSQL Server 2008 and finally solved the problem. You can simply do the following in SQL. The following line resets the Identity value for the ‘MyTable’… Continue Reading →

Detect face area using Matlab

Image processing can be used to process various objects in various ways and one for them is the face detection. The face detection system has got many applications and developing such a system is even easier by use of the… Continue Reading →

Extract Frames from Video MATLAB

There may be situations when we need certain frames from video. You can extract the video frames easily in MATLAB and save to any image format that MATLAB imwrite function supports or you can process the frames directly. There is… Continue Reading →

Number Plate Extraction using MATLAB

The number plate extraction in MATLAB can be accomplished using Image Proccessing Tools available in MATLAB. The functions provided by the Image Processing ToolBox makes it easy to process any images to extract the data from it. The algorithm for… Continue Reading →

Node.js : Introduction

Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices. Node.js… Continue Reading →

MATLAB and Image Processing

Matlab contains a huge resources for image processing. It has Image Processing Toolbox which can be used to process any kind of image files.Image Processing Toolbox™ provides a comprehensive set of reference-standard algorithms and graphical tools for image processing, analysis,… Continue Reading →

Model View Controller ( MVC ) Architecture

MVC Framework is a software architecture used in software engineering. Model View Controller (MVC) pattern creates applications that separate the different aspects of the application (input logic, business logic, and UI logic), while providing a loose coupling between these elements…. Continue Reading →

© 2018 Ashok Basnet

Powered by WordPress - Up ↑