Getting started with ELMAH and ASP.NET MVC

We all need a framework to log exceptions in our web application. Today, We are going to learn about same. ELMAH(Error Logging Modules and Handlers) is an application wide error logging framework. How we can install it in ASP.NET MVC. What is ELMAH: ELMAH(Error logging Modules and Handlers) is...

Continue Reading

How to find days in year except Saturday and Sunday in C#

Before 2 years I have written a blog post to find Saturday and Sunday in given date range.  It has gain a lot of popularity and on that blog post one user ask about how we can find days in year except Saturday and Sunday in C#. This post is a in reply for that. Following is a code for that. using...

Continue Reading

My visual studio settings

Lots of people send me email about what kind of visual studio settings I am using and I am replying them again and again so I thought it will be good idea to write a blog post about it. Yes, Since last 2 months I have been using dark theme of Visual Studio 2012 but I am not using default dark theme...

Continue Reading

How to find space used by table in SQL Server

Recently there was requirement for a client where we need to find space occupied/used  by particular table in SQL Server. I did some research a found a very cool way to get space used information from SQL Server. With SQL server 2005 and higher version you can use ‘sp_spaceused’ to find space...

Continue Reading

How to find path of database data files and log files in SQL Server

In this post, We will learn about different technique to find path of data files and log files on SQL Server. Let’s go through one by one of them. The first technique, We are going to use is very simple way to finding file path for database. But with this you can find path for one database only. It’s...

Continue Reading