ILT - Click-Once Deployment Error - Cannot Publish Because a Project Failed to Build
28-08-2012 Deploying using click-once setup is very easy. If you need a step by step guide to deploy a click-once, I'd recommend this article. Even though it is easy to create a click-once deployment package, the visual studio can face problems if ...

File Reference vs. Project Reference in .NET
31-05-2012 File reference is when you add reference to a dll file. This is what you do when you have to use a 3rd party dll. The project reference is when you load a project into your solution and then add reference to it. Rather than adding a refe...

Using TextEditSettings.DisplayFormat To Format Your Data In DevExpress DataGrid
07-03-2012 // // Devexpress doesn't provide much information about how you can use this to format your data when you use DevExpress DataGrid. I have a code to create and format a devexpress datagrid dynamically at run time. I had to automaticall...

5 Ways to Get Rid of Financial Stress and Optimal Utilization of Money
2008-12-14 With the rise of Global Financial Crisis, Financial stress has become a hot topic in the Internet. Since I am also a victim, I thought to make a small research on this. In this post I am trying my best to explain what I gained during m...

Failures are the Pillars of Success!
2008-12-01 Today I went to the embassy to get the response for the visa application I submitted about a month back. I had kept a lot of hopes on this. Today was like a junction in my life. If I get the permission to work, I would get a much better fi...

How To Temporarily Undo Or Turn Off Auto-Correct In Excel
22-05-2012 The auto correct feature can run you mad sometimes. For example, today I had to type EHR in Excel and it kept auto correcting it to HER :( I did a quick search and following are our options around this: Try Undo-ing (ctrl+z) - this wor...

Nothing is more beautiful than a kind person's heart - Cassian Menol Razeek

Crosscutting concerns (in software design)
2015-09-22 In software designing crosscutting concerns are concerns (requirements) that span over many layers (tiers) of your application. Generally, the majority of the application functionality will be arranged in tiers and there will be som...

How to Get the Underlying DataRow of a DataGridViewRow
23-07-2012 How to get the underlying data row of the bound data table linked to a DataGridViewRow in a DataGridView? How to get the underlying DataRow of a DataGridView.Row? How to get the underlying DataRow matching to a Selected Row of a DataGri...

Best Management Lessons Can Be Learnt Whilst Working For Worst Managers - Cassian Menol Razeek

How to use (escape) single quotation mark in sql statements
06-10-2011 // // We all get that day when we get an exception complaining about the single quotation or apostrophe that was in our SQL statement. The best advisable thing to do is to use stored procedures so that all data are passed as parameters...

It's all about the way we see...
2008-11-22 Today I went to a party at my dad's office. There I met this wonderful person who is 57 years old now. Let me tell something that I found about him: He's 57 years old now and married. His wife still works abroad as a house maid and his all...

If You Keep An Employee Hungry He Will Work Hard For His Hunger But If You Keep Him Happy Then He Will Go The Extra Mile For You. - Cassian Menol Razeek

How to: Exclude Projects from a Build
How to exclude a project from your visual studio solution. Source: How to: Exclude Projects from a Build

The Structure-Conduct-Performance Model
2010-04-01 In 1930s, a group of economists developed an approach to understand relationship among a firm’s environment, behaviour and performance. This theoretical framework, since then, is known as the Structure-Conduct-Performance (S-C-P) Mod...

Posted in General | Comments Off on

ILT: [Solved] Nexus 5 Randomly Restarting After Upgrading to Marshmallow

One night I allowed my Nexus 5 to upgrade to the latest Android version (Marshmallow) but from next morning my phone was behaving very strangely.

It kept restarting randomly and became almost useless and completely unreliable.


The Problem

The problem seemed to be related to battery calibration information. Upgrading to Marshmallow somehow corrupted or changed this information making the phone unaware of its accurate battery state.


The Solution

Following these steps cured my phone.

  1. Use your phone until it drains the battery and shuts down.
  2. Keep starting the phone to make sure you drain all of the remaining battery charge. You don’t need to worry about the amount of charge that the phone tries to preserve. Just do your best as a regular user to drain the battery. Don’t try advanced stuff.
  3. When the phone is off connect your charger (A/C adapter is recommended over USB) and let the phone charge to full amount without starting the phone.
    You can check this by checking the charging indicator that is shown when you briefly press the power button. DO NOT start the phone.
  4. When the battery indicator shows a full battery, start the phone.
  5. When started check the battery status on the top of the screen. If it is NOT very close to 100% (97% ~  99% should be fine) then turn off the phone and connect to the charger (step 3).
  6. Keep repeating steps 3~5 until you are happy the phone is charged to its maximum capacity. This may be less than 100% depending the quality of the battery.
  7. Then unplug the charger and keep using the phone until it’s fully drained. Do not charge the phone before the battery is fully drained.

Continue above steps several times over a few days and this will solve the problem. It worked like charm for my phone.


Posted in General | Leave a comment

How Software Engineers Became Software Developers


This article looks at how and why modern software projects easily become messy and extremely convoluted. This article should not be understood as against new concepts but as a promoter of software engineering education, skills, and experience that allows engineers to make rational decisions to choose when a concept should be practiced.

The History

Software development (programming) was always a sub category of software engineering. However, over the last decade, software development was pretty much forcefully divorced from software engineering.


It is human nature to make things easy for everyone. In addition to this a lot of money was invested into software related projects making everyone wanting to become a software developer.

But everyone didn’t want to go through the hard work of serious education and then starting from the bottom of the ladder to gain experience. it was not fun.

So software development technologies became very simple and the need to have proper education in IT was taken down as a compulsory qualification to become involved in serious software engineering projects.

This created a massive boom in numbers of software engineers which also resulted in a large boom in supporting services for this large crowd.

While many companies stepped forward to provide educational and other services for this crowd, more experienced already established Software Engineers became technical writers. The concept of blog and blogging was boosted by potential advertising revenue.

Soon there was a great competition among these service companies and bloggers who basically had to bring in new and unique articles (resources) to keep their businesses, websites, and blogs popular.

The Crown went to Cool from Practical

For many years software engineering (like any other engineering discipline) was practiced with main focus on providing practical and reliable solutions.

This obviously required a lot of background knowledge and experience and there was not a lot of money to be made for the booming “developer support” industry.

So the supporting industry started creating new libraries and tools to make developers life easy. The most talked about topic in the industry became “the next helpful library or tool” that would reduce developer workload.

Mushrooming Concepts

* mushrooms just pop up randomly Reliability, stability, and logic are not concerns for mushrooms. They just pop up overnight.

The critical issue was that in addition to specific tools and libraries, some experienced bloggers and companies started creating their own flavors of established concepts.

As of now, you can see many new concepts arriving at the Internet every night.

Basically, everything that an experienced developer do to implement a known concept would be written on their blogs as if it’s a new concept and will be called cooler than the original concept it inherits.

The next morning all blindly following developers will read about this new thing and do their best to implement it on their projects because it is the cool thing to do.

Mushroom Filter

While the more experienced and educated engineers had the skill set to understand and decide when to use these new branched “cool” concepts, the large potion of “software developers” do not have that critical knowledge or relevant experience to make such decisions.

Every Pie is a Mushroom Pie

So the unfortunate result we see is that eventually this coolness took over. All semi-skilled developers blindly follow whatever they read on the Internet.

Then they put pressure on the management to bring all of these cool stuff into the projects they are working on.

This is why most of the projects you see today look nothing better than the inside of a badly made mushroom pie.

Posted in Practical Software Engineering, Software Architecture, Software Engineering Concepts | Leave a comment

Using sqlpackage.exe parameters and properties to publish your db with less hassle


This article is for anyone who already knows how to use sqlpackage.exe. Visit the Microsoft link at the bottom to learn about sqlpackage.exe usage.

Where I work we use sqlpackage.exe to deploy our database snapshots (DACPACs) to various locations.

Since I have started to use this I faced several problems as the script was trying to make changes to the target database.

There were two main problems I faced:

  1. The main reason was that the script would not (by default) ignore data loses. It will normally break and error when it detects a data loss.
  2. The script does not (by default) rollback everything when it aborts the script (e.g. when it detects data losses).
    I had real bad situations when the script failed half-way through and left a lot of changes it made till it decided to abort.
    I had to restore the db from a backup and go through the whole thing again.

So I found these settings/switches you can use to instruct sqlpackage.exe to get around above issues.

  • Ignore data losses and continue
    Specifies whether the publish episode is terminated if the publish operation might cause data loss.

    Set this to to ‘true’ and the resulting script will not abort when it detects data losses

  • /p:IncludeTransactionalScripts=True
    Specifies whether to use transactional statements wherever possible when you publish to a database.

    Set this flag to true and sqlpackage.exe will do its best to use transactions as much as possible.
    This will make sure that you will not end-up with a mess when the script fails.

There are many other useful properties provided by this tool.

for example, you can use /p:GenerateSmartDefaults=True to get sqlpackage.exe to generate default values for new columns that don’t allow nulls.

Read the below link for the full set of options you can use.


Posted in SQL Server | Leave a comment

See the good and go for the best

See the good and go for the best   –  Cassian Menol Razeek

Posted in Quotes | Leave a comment

Crosscutting concerns (in software design)


In software designing crosscutting concerns are concerns (requirements) that span over many layers (tiers) of your application.

Generally, the majority of the application functionality will be arranged in tiers and there will be some functionalities (examples below) that would span across those layers. these are crosscutting concerns.


  • Authorization
  • Caching
  • Exception handling

It is important to consider how crosscutting concerns are facilitated at the design stage to avoid untidy and unreadable solutions.

This Microsoft article explains the topic further and also explains methods to handle common crosscutting concerns.

Posted in Software Architecture | Leave a comment

You need a 64bit text editor to open IIS config files on a 64bit computer


If you wanted to open or edit IIS 7+ config files on a 64bit computer and if you try to use an editor like 32bit notepad++ then you would get a random error from windows.

The error I received was “The operation could not be completed. Unspecified error”.

Well, it turns out the reason behind this not very helpful error is that you cannot open these files using 32bit editor.

Simply use windows notepad or any other 64bit text editor.


Posted in Web Development | Leave a comment

Browser and length independent CSV download code


Downloading a csv string as a file on browser can be troublesome. Some techniques don’t work for very long CSV strings and some techniques only work on some browsers.

Below code is tested on Internet Explorer 11, Firefox 27.0.1, and Chrome 45.0.2454.93 m

And you can extend the code (where it alerts user that their browser isn’t compatible) to support more browsers.

Please comment if you do so, it will help others.

var csvString = your csv string;
var blob = new Blob([csvString], { type: 'text/csv;charset=utf-8;' });
if (navigator.msSaveBlob)
{ // IE 10+
navigator.msSaveBlob(blob, fileName);
var link = document.createElement("a");
if ( !== undefined)
{ // feature detection
// Browsers that support HTML5 download attribute
var url = URL.createObjectURL(blob);
link.setAttribute("href", url);
link.setAttribute("download", fileName); = 'hidden';
// extend support for additional browsers here.
alert('Sorry, your browser does not support this export. Please contact support');


Posted in Web Development | Tagged , | Leave a comment

Protect your (software) architecture


The most common problem I have seen in software projects that don’t have a responsible, capable, and experienced architect is that those projects tend to be very messy.

Most such projects are filled with pretty much all technologies and libraries that were popular during the projects life time.

The main reason behind this problem is:

Software developers get blown away by the overwhelming amount of new products that reaches the industry everyday.

Recent booms in software industry has made many software library vendors as well as software related writers who promotes these new libraries and products.

They talk about “what” but hide “where” and “when”
For some reason (I believe it’s the competition among them) these technical writers (a.k.a. bloggers, geeks, etc…) fail to include thorough information about WHERE and WHEN each concept or library can make an improvement to a software project.

The only message you can see in most sites and reviews is, “hey, this is a really cool library and you should use it”.

Most developers fall in:
According to my experience most developers, regardless of their technical expertise, have not trained themselves on decision making skills.

Therefore developers are under constant pressure to implement these “cool stuff” into their projects.

This is where you come in:
As a technical leader it is important that you maintain an open atmosphere in your team encouraging your developers to bring in ideas and new suggestions to use new things.

At the same time, as a strong architect you need to measure all potential benefits of these new suggestions and make a judgement with respect to following factors:

  1. Implementation cost – how much effort will it cost to introduce this.
  2. Validity – validate if your project would actually benefit from this change or if the benefits are minuscule, or even simply theoretical.

Your past experience should indicate whether it’s a good idea by conceptually applying it to your project.

The deference between an architect and a skilled developer is that the architect can visualize implementations and changes without having to try and fail.

Know how to say No!
It is important that you know how to explain-away wrong suggestions without making your important developers disappointed.

Posted in Software Architecture | Leave a comment

Always on top web browser


Today I wanted to watch an online video while working on other windows but couldn’t get my browser to do it.

After failing with recommended solutions such as browser extensions I thought to quickly bring together a little browser using .Net.

I built this as a windows application (C#) and didn’t go for WPF to keeps things simple.

This is very simple and uses the off-the-shelf web browser tool in windows application tool box (Visual Studio).

I have attached the solution as well as the executable as separate downloads.

Feel free to further implement this and please let us know how you get on.


always on top web browser









Download links:

Important: password to open archives : aabc

Executable: always on top web browser

Source code: browser

Hope this help someone!


Posted in C#.Net, Products | Leave a comment

html css it is not possible to have inline styles for different aspects of an element like hover, and visited

You cannot specify css styles for different aspects of an HTML element.

e.g. I wanted to do something like this. But you CAN NOT do this.

<a href="" style="hover(color:00AEFD);active(color:00AEFD)">

Unfortunately the only solution is to write a custom css class and use it.

Like this:

a.unicef:link {
color: #00AEFD;
text-decoration: none;

a.unicef:visited {
color: #00AEFD;
text-decoration: none;

a.unicef:hover {
color: #00AEFD;
text-decoration: none;

a.unicef:active {
color: #00AEFD;
text-decoration: none;

Then use the class in your link

<a href="" class="unicef" target="_blank">Please Donate To unicef</a>


W3 Schools
Stack Overflow


Posted in General, Web Development | Tagged , , , | Leave a comment