-
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
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…
-
March towards SQL Server : Day 2 – SQL DBA Interview Questions Answers – Security Permissions
1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is authentication. Authorization is the process of verifying that you have access to something. Authorization is gaining access to a resource (e.g. directory on…
-
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…