Category: Scripts
Database Permissions extraction script

Database Permissions extraction script

Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before refresh and applied the ...

READ MORE +
0
SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

In continuation of our DBA Cheatcode series :-   I started this series on Queries\T-SQL commands that we use in our day to day operations or those queries which should ...

READ MORE +
2
How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

READ MORE +
0
How to create Drop and Recreate Script of all Indexes in a database?

How to create Drop and Recreate Script of all Indexes in a database?

I found this interesting script once so thought of sharing with everyone. Special thanks to the Unknown-Creator of this script.  This script generates the 'create' & 'drop' ...

READ MORE +
0
SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy ...

READ MORE +
0
SQL DBA Cheatcode Part 1 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 1 : Few Important Queries for any DBA

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy ...

READ MORE +
0
Common Human Errors as DBA (part 2)

Common Human Errors as DBA (part 2)

You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error - Data or Log file ...

READ MORE +
0
Hide Your Real Data  – Data masking/ Data Scrambling/ Data Obfuscation

Hide Your Real Data – Data masking/ Data Scrambling/ Data Obfuscation

Data masking/ Data Scrambling/ Data Obfuscation – is the task for hiding actual data before sharing it with Users, UAT Testers, Vendors, Developers or anyone else who MUST NOT ...

READ MORE +
0
Common Human Errors as DBA (part 1)

Common Human Errors as DBA (part 1)

“Human Error” is not a new word. Most of the time if there is screwed up done by any one – these golden words are used. For sure, these are the Human Errors and its hard to ...

READ MORE +
0
Database Accidents : Unwanted Restore

Database Accidents : Unwanted Restore

Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or not. As a thumb rule ...

READ MORE +
0