List file groups and indexes for each tables
This is one of those quick tips and trick posts I do once in a while. Â If you ever want...
Encrypting SQL Server Columns
If you have been working with databases long with large company you would have definitely encountered a requirement to encrypt...
A powershell script to copy files from one folder to another based on part of file name
A requirement came up for me to copy thousands of file to another drive with directories named depending on part...
Quick way to get size of databases on a sql server instance
Here is a dirty little sql that will give you the size of all the databases in your instance :...
SQL Server recovery using differential backup
One of my DBAs said while trying to restore differential backup he was getting  : Fix : Error : Msg...
Checking on HADR
By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution....