Hmm... after a long gap writing this post on my blog... not sounds right... but I was little engaged with both personal and official work which blocked me to spend more time on my writing...  In this write up, I've provided couple of MDW queries which helps DBAs very much when they need to investigate some issues. You can tune up these queries depends...

Today I was working on one of the SQL instance on a four node cluster. There are 4 data drives which were mounted already and yesterday I imported 2 new drives (Data5 and 6) in the cluster, they are all mounted drives (Eg. D:\Data1, D:\Data2, where D:\ is a smaller size SAN on it mount all the required drives) The plan was to add new data files on the...

When I'm trying to setup log shipping for a database, I got the below certificate error and I understood that the database got TDE enabled and encrypted with Master key (private key). After struggled for a while and got the steps to fix it. So before restore that database on the secondary database backup the certificate with master key (private key)...

ARE YOU USING THE RIGHT SQL SERVER PERFORMANCE METRICS? This article talks about the five important SQL metrics when you need to help in solving performance problems. Source: http://thomaslarock.com

Recently our team builted around 60+ DR servers in our new datacenter and I thought to register them in SQL management studio, of course it will take some time to register them all together and thought that if a script does the same that would be wonderful. After searching the indernet for sometime I found a peice of code and tweaked it to register...

Today I worked on a Transactional log full issue on one of the critical production database server, the database involved in this issue is configured both Mirroring and Log shipping.  From the mirrored database a scheduled job generating snapshot for every 30 mins.  The production database is involved high volume of ecommerce OLTP, everything were...