Recently a friend of mine asked me how to calculate investment rates of return in PowerPivot.  In order to do this, one must be able to run over a list of values using a multiplication. Currently, DAX does not have a ProductX or MultiplyX function ...

Employee Provident Fund i.e. EPF is a significant part of every working professional pay slip. All working professional save a chunk of their hard earn money through Provident Fund in India. A similar tool is available in other countries worldwide.Emplo...

Reading and writing data with Ms-Excel is a very common in SSIS. A lot of individuals, organization, offices store their data in Ms-excel. To add security to their file and data, they do protect their Ms-Excels files with a password. In this article we ...

You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create function with RETURNS NULL ON NULL INPUT, this option introduced in SQL Server 2005. You can use this while creating a function as below: US...

Season's Greetings and Merry Christmas! In the spirit of the holiday, I am rerunning my original parody on "Twas the Night Before Christmas". This sql soliliquy is called "Twas the Week After Christmas", and you can click on the highlighted link for th...

Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine. In recent past we had a situation where customer asked us to move MASTER database to new location, below are the steps I have taken: &#...

Check out the following sample code to understand the basic differences between ISNULL and COALESCE functions in SQL Server. Code is self explanatory and comments are provided for ease of understanding. /*************************************************...

Together with the traditional Christmas and New Year wishes, I wanted to give all European developer a small Xmas present: Web.NET Conference 2013 will be held in Paris, around the end of May This year's edition is possible thanks to the help of Rui C...

Today there was an interesting conversation between me and a young SQL Developer on how we can get a custom order of a resultset in TSQL. We spoke about different combinations starting from Table Variables, Temp Tables till Sub-queries. I am not able to...

There are majorly 4 different ranking functions in SQL Server. They are – ROW_NUMBER() RANK() DENSE_RANK() NTILE(INT) They all are different and in my own terminology they can be used to define row versions in programmatic point of view. I ...