Windows 8.1 Update and Metro Application Crashes

Windows 8.1 updates has pretty good features which attracts but it doesnt contain lot of feature as expected.

Windows 8.1 requires Video Graphic driver properly installed. If you install Windows 8.1 from ISO then it will install a seperate and fresh installation which will let you install all the softwares once again. Which is quite tiring. Also Windows 8.1 requires NS enabled from your bios settings. If you didnt install contact with your administrator or get a updated bios update from their manufacture website.

Remember this update is not that stable and has many issues which existed Metro applicaiton which crashes most of the time. If you are lucky you might get some application which will work fine with Windows 8.1.

It is more frustrating when Metro Skype application crashes. you might found some fixes from internet about graphic setting but this is not going to work at all.

Conclusion: Please don’t update Windows 8.1, Its not stable and surely will disappoint you.

Software architect Interview questions compilation

When it comes to a job interview, software
must display the right mix of technical knowledge, project
management experience and effective communication skills. Because of this, the
conversations are generally divided into three parts: how the architect displays
knowledge and skills in a hypothetical situation, past projects and how he or she
communicates. Yet above all, software architects should be a good cultural fit who
can understand the specific needs of a business and work successfully with all
the people involved in software projects.

Eleven Interview Questions for Software ArchitectsThe following are commonly asked interview

Show me how you would go
about architecting this software solution.

will often give you a hypothetical software design solution to sketch out on a
white board, or simply explain. One such question asked by Vasanthan Dasan,
CTO and vice president of engineering for staffing firm the Armada Group, is: architect a software solution for a platform
as a service for the state of California’s vehicle registration records.

candidate should explain not only the technology aspect of the problem – such
as the front and back end of the Web technology, tables, databases and the like
– but also reveal good communication skills,” says Dasan. “They
should explain how they gather and translate client and user requirements to a
team of software engineers that is developing the solution.”

Explain a project you worked
on previously.

This is the blanket interview question intended to gauge experience
and communication skills. You should explain in depth previous work including
the planning, problems, team building with engineers, time spent and obstacles
you faced.  A common follow up question: Did the project work the way you originally
designed or intended it too? Why?

Talk about one of your
successful projects and why it was successful.

This question is used to find out what you value in the software
development process and to help the interviewer see if you’ll fit the needs of
a particular organization.

What kind of atmosphere
do you like to work in?

is designed to ascertain whether you’re the right cultural match at a company
or project

try to really have a genuine and sincere discussion about what they like and
don’t like,” says Matt Allison, It product manager for Kelly IT. Another question Allison likes
to ask: What do you think
the best way for software to be architected?

How would you define a
database table for information to be stored and why did you choose that

Similar questions: What
database management systems have you worked with? Can you work with MySQL
and/or Oracle Database?

‘This gives me a good understanding of how this person thinks and
their familiarity with the latest technology,” explains Dasan.

How do you manage conflicts
in Web applications when different people are managing and working on data?

Similar question: How do you
help identify who is responsible for changes in a software project?

You’ll need to explain how you manage a team, including how the
team documents a project in order to avoid design conflicts. You should give
examples of how you’ve used effective communication for successful results in a
team environment.

“Just because somebody can architect software doesn’t make
them a successful software architect, which is why I ask project management
questions,” explains Kelly O’Connell, a branch manager for Robert Half

Which tools have you used
for testing code?

Similar question: Tell me something
you know about testing or QA?

You should know the difference between functional or exploratory
testing and explain how you’ve used it in the past. 

How do you find a middle
item in a linked list?

“I ask simple algorithm questions, since any programmer,
engineer or software architect should be comfortable talking about algorithms,”
says O’Connell.

Name the differences between
object-oriented design and component-based design>

This question is not only intended to test your knowledge, but also
to find out your design expertise.

Give an example of when
you were innovative with software architecture.

question: When did you think creatively
and create software that wasn’t seen before?

What do you think is the
best way for software to be architected?

questions: What methodologies have worked
with? Which do you prefer? Why?

– Chandler Harris

Found from:

Some good resources:

Good thread from forum

flowchart shapes, ERD,Visio

We normally use visio to build documents which helps developer to understand the flow of the modules and projects. These are common used shapes that’s why I am just taking the definition from Microsoft itself so it would be consistent for everyone.  

Its just a copy paste from Microsoft visio but the main concept behind is to share

What the flowchart shapes represent

When you open the Basic Flowchart template, the Basic Flowchart Shapes stencil opens too. Each shape on the stencil represents a different step in a process.

Of all of the shapes on the Basic Flowchart Shapes stencil, only a few are commonly used. Those commonly used shapes are described here.

  • Terminator  Use this shape for the first and last step of your process.
    Terminator shape
  • Process  This shape represents a step in your process.
    Process shape
  • Predefined process  Use this shape for a set of steps that combine to create a sub-process that is defined elsewhere, often on another page of the same drawing.
    Predefined Process shape
  • Decision  This shape indicates a point where the outcome of a decision dictates the next step. There can be multiple outcomes, but often there are just two —yes and no.
    Decision shape
    Document  This shape represents a step that results in a document.
    Document shape
  • Data  This shape indicates that information is coming into the process from outside, or leaving the process. This shape can also be used to represent materials and is sometimes called an Input/Output shape.
    Data shape
  • Flowchart shapes  You can right-click this multi-shape to set to any of the following shapes: Process, Decision, Document, or Data. Any text you type onto the shape, or information you add to its Shape Data, remains with the shape.This is what the shape looks like on the stencil:Flowchart shapesThis is what you see when you drag the shape onto the drawing page and right-click it:Flowchart shapes with right-click menu
  • Stored data  Use this shape for a step that results in information being stored.
    Stored data shape
  • On-page reference  This small circle indicates that the next (or previous) step is somewhere else on the drawing. This is particularly useful for large flowcharts where you would otherwise have to use a long connector, which can be hard to follow.
    On-page refference shape
  • Off-page reference  When you drop this shape onto your drawing page, a dialog box opens where you can create a set of hyperlinks between two pages of a flowchart or between a sub-process shape and a separate flowchart page that shows the steps in that sub-process.
    Off-page reference shape

HideLess frequently used flowchart shapes

  • Dynamic connector  This connector draws a path around shapes it encounters.
    Dynamic connector shape
  • Line-curve connector  This connector has adjustable curvature.
    Line-curve connector
  • Auto-height box   This is a bordered text box that adjusts to accommodate the amount of text you type. You can set the width by dragging the sides of the shape. Although this shape doesn’t represent a step in a process, it is a handy way to add a text box to your flowchart.
    Auto-height box
  • Annotation   This bracketed text box adjusts to accommodate the amount of text you type. You can set the width by dragging the sides of the shape. Like the Auto-height box shape, this shape doesn’t represent a step in a process. Use this to add comments about your flowchart shapes.
    Annotation shape
  • Manual input  This is a step where a person provides information to the process.
    Manual input shape
  • Manual operation  This is a step that must be performed by a person.
    Manual opperation shape
  • Internal storage  This shape represents information stored on a computer.
    Internal storage shape
  • Direct data  This shape represents information stored so that any single record can be accessed directly. This represents how a computer hard-drive stores data.
    Direct data shape
  • Sequential data  This shape represents information stored in sequence, such ad data on a magnetic tape. When data is stored in sequence, it must be retrieved in sequence. For example, in order to access record 7 you would have to first go through records 1 through 6.
    Sequential data shape
  • Card and Paper tape  This shape represents a physical card or paper tape. Early computer systems used a system of punch cards and paper tape to store and retrieve data and to store and run programs.
    Card shape
  • Display  This shape represents information that is displayed to a person, usually on a computer screen.
    Display shape
  • Preparation  This shape indicates where variables are initialized in preparation for a procedure.Preparation shape
  • Parallel mode  This shape shows where two different processes can operate simultaneously.Parallel mode shape
  • Loop limit  This shape marks the maximum number of times a loop can run before it must go on to the next step.
    Loop limit shape
  • Control transfer  This shape indicates a step that goes to a step other than the typical next step when certain conditions are met.
    Control transfer shape


Please visit my official blog for future.


The difference between tags and categories

One of my friend ask me about difference between TAG and Categories.

I found good definition on wordpress itself. 🙂

The difference between tags and categories

These allowed the broad grouping of post topics but when you wanted to describe a post in more specific terms you had to use more categories. That lead to very long category lists inside the blog, very long lists in sidebars. It was also confusing in that what we said were categories others said were tags.So now we have tags as well.Tags are similar, but instead of a list of words to choose from, you write them in a list (separated by commas) in a text box below your post. They are free form words and generally describe your post in more detail.

For example, a post titled “Last Night At Burger King” might be filed under the “Dinner” category, but could have tags like, “burger, chicken fries, chocolate shake, dr. pepper”.

for more details :

StripHTML function

If you know the meaning of Strip word you will know what does it do.  just kidding 🙂

The StripHTML function removes all HTML code from a string.
string = StripHTML(string)
Example Usage:
dim a

a = a & “<HTML>” & vbCrLf
a = a & “<HEAD>” & vbCrLf
a = a & “<TITLE>Rana’s Blog</TITLE>” & vbCrLf
a = a & “</HEAD>” & vbCrLf
a = a & “<BODY>” & vbCrLf
a = a & “-Code Project!!!” & vbCrLf
a = a & “<A href=”” mce_href=””./Rana.asp””></A>” & vbCrLf
a = a & “</BODY>” & vbCrLf
a = a & “</HTML>” & vbCrLf

response.write StripHTML(a)


Rana’s Blog – Code Project

One of my reader asked me how to do in ASP.NET 

In ASP.NET you can strip the HTML using Regex

Dim StrStripped As String

StrStripped = System.Text.RegularExpressions.Regex.Replace(“Input as String”, “Pattern like (.|\n)*?”, String.Empty)

View as HTML

Today i received an email from one of my blog’s reader.

Dear Code project,


Actually I am a Biology teacher in one of the private school.

I had prepared my lesson plan in a word document and a part of the lesson

was a graph diagram. I then send it to my gmail account and open it at school

to print the lesson plan.

I had noticed that the printed lesson plan did not have my graph.

Can you advise me how I can have my graph along with my lecture?


Reply :  Here are the options when you open an email having attachment . 





If you are trying to open by clicking on View as HTML It will never


show the diagram. You need to download the file first in your computer


anywhere C or D drive and then open and print it.


Hope this will resolve your problem.




Rana’s Blog Code Project 

SQL SERVER 2005 , How to Partition the table.

All we know SQL Server 2005 has new features are going to discuss in this article is the Row Number function and Partitioning.
Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Server 2005 provides a function, which replaces all of the additional resources we used to generate row numbers.
In a few word this means that you can horizontally partition the data in your table, thus deciding in which file group each rows must be placed.
This allows you to operate on a partition even with performance critical operation, such as reindexing, without affecting the others. In addition, during restore, as soon a partition is available; all the data in that partition are available for querying, even if the restore is not yet fully completed.
For reference:

In this article I am going to create a query which will return a selective data from a particular city

Scenario is; I wanted to display the only three records from each city.

Here is the example below.

Create Table #tempTable
( City varchar(255),
EmployeeName varchar(255)

Insert into #tempTable Values (’Alabama’,’Rana’)
Insert into #tempTable Values (’Alabama’,’John’)
Insert into #tempTable Values (’Alabama’,’Richard’)
Insert into #tempTable Values (’Alabama’,’Kash’)
Insert into #tempTable Values (’Alabama’,’Michele’)
Insert into #tempTable Values (’Alabama’,’Nicole’)
Insert into #tempTable Values (’Alaska’,’Nadia’)
Insert into #tempTable Values (’Alaska’,’Parker’)
Insert into #tempTable Values (’Alaska’,’Peter’)
Insert into #tempTable Values (’Alaska’,’Nash’)
Insert into #tempTable Values (’Alaska’,’Birds’)
Insert into #tempTable Values (’Missouri’,’Shani’)
Insert into #tempTable Values (’Missouri’,’Zeekh’)
Insert into #tempTable Values (’Missouri’,’Rashi’)
Insert into #tempTable Values (’Missouri’,’Sharon’)
Insert into #tempTable Values (’Missouri’,’Jack’)
Insert into #tempTable Values (’Missouri’,’Jerry’)

From #tempTable
AS RowNumbers
WHERE Row > = 1 and Row