I got motivated to write this post as there was a question on twitter which was like – The user was checking if there was a way to prevent procedures…
Cloud is the future and moving there is now as easy as few mouse clicks. Today we will see how an On-premise database can be moved to a SQL Server…
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ? Wikipedia defines redundancy as “In engineering, redundancy is the duplication of critical components or functions of a system with the…
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check some processes details and opened Activity Monitor after a long…
Today I will discuss about an issue which was observed while creating a linked server via script. The existing linked server was scripted out from a SQL2005 instance and the same script…
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from http://support.microsoft.com/kb/2812412 Similar to CU2 there are some interesting hotfixes which are included in this…
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have found this very much needed for all my SQL2012 SP1…
Adding a linked server is an easy task which can be done at any point of time. I was under this same assumption until I came across a strange scenario.…
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would you love to get a report which will help you…
This post is a quick tip to find the version of Windows Installer installed on your box. You might wonder why I ever need to check this version, so here…