Tag: database permissions

  • Series : SQL DBA Cheatcode

    Series : SQL DBA Cheatcode

    SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are trusted and tested however there are some chances that a script may not work with some versions of SQL Server. SN Date Topic Part…

  • 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 permissions back on it after restore but still all permissions were not applied correctly and user is reporting access related issues. I checked and found that the…

  • 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 be handy for any SQL DBA(Junior or senior) out there. In this series, I’ll try to share as many queries as I have or I…