With the release of SQL Server 2012,we have a chance to review our existing HA + DR solution and there is always an option to test and understand how this…

March 7th 2012 ! This was the day when SQL Server 2012 was launched virtually to everyone.I was looking forward for this event with great expectations.Even though we had a…

Extended events are one of most powerful feature which was exposed from SQL server 2008(On wards).Till SQL 2012 most of your actions involving extended events used to be through TSQL…

Today I was dealing with one of the questions related to local language support for SQL Server sys messages and suddenly this idea came to my mind to check whats the improvement…

SQLServer2012 virtual launch was a great event, and I am still preparing a lengthy blog post on my experiences with the event. One of the sessions about File Table functionality in SQLServer 2012…

Today I decided to leverage performance dash board report for my SQL Server 2008 R2 instance and SQL 2012 RC 0 Instances. SQL 2008 R2 RTM I downloaded the msi…

Recently I had a blog post related to Transparent Data Encryption(TDE) on SQL Server 2012 RC 0 and today I wanted to clean up my test environment and started the whole…

Have you ever done a point in time restore? If not,then consider yourself lucky. In case you are forced to do a point in time restore in near future,then this…

TDE was introduced in SQL Server 2008 as an Enterprise/Developer edition feature.This feature allows to encrypt the whole database and includes database backup’s. I was interested to test TDE in…

I have been playing around earlier CTP versions of Denali and focus was mainly on contained databases.Today I had a chance to review Contained Databases on SQL 2012 RC 0…