In a recent project we needed to block a series of IP addresses from accessing our website. IIS makes this easy with its IPv4 Address and Domain Restrictions feature, which lets the webmaster specify specific or ranges of IP addresses that are either al...

Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately I was not able to digest the concept till I wet my hands.I will keep this point in my mind while explaining the f...

Musings on technical writing......

Technology,networking,knowledge sharing under one roof and that too for 3 consecutive days !!! Wow,thats TechEd for you. [Picture courtesy - http://yodigo-contrablog.blogspot.com] TechEd India 2012 gave me a fabulous ride this time.Even though I couldn...

This blog about the practical solutions for the problems that SQL server DBA face in their day to day work...

Featuring posts on SQL, Azure, Cloud. Syndicated from ParasDoshi.com...

SQLSailor - Personal Notes on Microsoft SQL Server...

We often need to change the name of a column of a table to a new name. We can do this with the help of the Exec Sp_rename command. The Syntax of the Sp_rename is given below:- Exec sp_rename 'TableName.[OldColumnName]', '[NewColumnName]', 'Column...

Learning is a never ending thing and just one life is not enough to learn all the things you want to learn. The ocean of knowledge is very, very deep. This blog has been created for the same objective. I write on things which I come across in my daily l...

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement SELECT * FROM MASTER..SYSPROCESSES WHERE BLOCKED != 0 Yes, I’ve found the culprit SPID that is occupying more reso...