Here I would like to help for common question that every DBA has when it comes to SQL Server Licensing. Refer http://www.microsoft.com/en-in/server-cloud/products/sql-server/buy.aspx for different licenses available.…
Solving Rubik’s cube is very simple if we follow some algorithm correctly. There are several algorithms available in the web or youtube. Out of them,…
Below script helps restore several databases on to a SQL Server instance in one go. We just have to place all the .bak files in…
To check for any changes in the files. git status View Change history and comments. git log To see the change history per file git…
This stored procedure helps automatically create new partition on a new file group to an already partitioned table. I have tested the script in my…
One fine day, I was given a project to deploy a failover cluster on Windows server 2012. I did all the usual steps. Enabled failover…
Normally until Windows Server 2008, we use to have the .net Framework available to enabled from Server features section in Server manager. We just have…
Final: Question 1 Problems 1 through 3 are an exercise in running mongod’s, replica sets, and an exercise in testing of replica set rollbacks, which…
Hey. Its not just me. Even Microsoft makes spelling mistakes in their softwares… Just found below in an error window from SQL Server 2012 Enterprise…
We have heard enough of the new feature in SQL Server 2012 that replaces our conventional Database Mirroring notion. It is the Always-on Availability groups…
You must be logged in to post a comment.