In this article I am going to show you, how to change the prompt of your PowerShell and few lines about Execution Policy in PowerShell.

In this article i discussed about creating single, multi dimensional arrays and working with Hash tables in PowerShell.

Additional capability of PowerShell is expression

Today i would like to show you simple code to find the active connections in SQL Server using PowerShell. PowerShell code is very easy to write. All you need is the Class names to connect to the Database to do the required job.

IntelliSense is a great feature of SQL Server 2008 but some times it is giving me hard time. Are you also having tuff time??

Postback is a concept introduced in ASP.NET and is a very handy method. Postback is built into the ASP.NET and most of the web controls support it without writing any code. There may be some scenario where you may want to explicitly postback to the server using some clientside javascript. It is p...

I found one very interesting article, which talks about Windows Power Shell. This article explains the differences between various scripting languages in layman terms.

Today, I started to learn Windows PowerShell. Initially I thought it is difficult but by it surprised me completely. It’s very easy to learn in fact if you have knowledge of VBScript or .Net then it is much easy to learn.

This Automatically generates unit tests in SQL for programs in SQL Server. The unit tests created are written in TSQL . This framework is intended to be used with the TSQLUnit framework.

Yesterday, I was working on excel sheet and I was so frustrated with the function key F1 Key. Generally I use F2 key to edit the contents of the Cell. F1 & F2 are so close together, so accidentally I pressed F1 instead of F2 to edit the cell. All most half of my time went off closing the help wi...

60 seconds with Sugeshkumar Rajendran: Adding the TAG MVP to my name, distinguishes me from other technologists near me. VJ caught up with Sugeshkumar Rajendran, MVP in SQL Server, to get his view on the Microsoft Most Valuable Professional Program(MVP).

There are several ways to create one column with comma separated values from multiple rows. Today, I would like to show you, how to achieve this with very simple query using XML features of SQL Server.

In this article I would like to list out most common errors and their solutions that occur in SQL Server. This article will also you tell how to reproduce them.

Today I would like to give you simple tip to debug TSQL programs, which would save lot of time in fixing the problems. You don’t have to install any additional software; this option comes with SQL Server Management Studio.