SQL Master

In one of my previous post I showed you how to UNPIVOT multiple columns .  On similar lines I also wanted to write on “How to PIVOT multiple...

By default the default TCP Port for SQL Server is 1433.  It can be changed for security purpose to minimize the potential threat of a hacker...

Now lets see how to get alternating row background colors in Reports. This is one of the 1 st typical report enhancement you might be doing...

Well we all know how to add the values in a column using SUM and GROUP BY.  But what about multiplying the column values?  And also how to c...

If you have installed the Evaluation / Trial Version of SQL Server, you may like to find out what is the expiry date of the Trial Version.  ...