database level Archives - SQLServerGeeks

SQL Server Security Audit – A (time consuming) task for DBA simplified

January 30, 2015July 3, 2020 - by Manohar Punna - 2 Comments.

Many DBAs need to perform SQL Server security audit and save the permissions for each account at server level and database level. This will be done time to time and verified …

SQL Server

SQL Server Database States – simple talk but not simpler

September 13, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Very recently while imparting training to junior DBAs someone from them asked me what are the different states of a database and how they can move into each stage? …