Its quite common that when there is some upgrade, change or release in application, there are chances that our database objects get modified. It may…
If your linux root partition ‘/’ is an LVM, you could easily extend the drive. Make use of the commands listed later in this post.…
Being a DBA, it is good to have some kind of automated health check report that gets delivered to inbox with quick glance of DB health.…
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…
You must be logged in to post a comment.