SQL Administration
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want to have a data breach, or c) you are testing in a sandbox to improve your skills.
Related Posts:
- SQL Server Fixed Role Permissions March 6, 2017
- SQL Server User Already Exists – Back to Basics January 24, 2018
- Extended Events Permissions December 25, 2017
- Easy Permissions Audit January 21, 2019
- SQL Server Permissions – Database Roles March 2, 2017
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help you get a reasonable deduction for that offline event in the absence of better data.
Related Posts:
- Monitor Database Offline Events November 15, 2018
- Audit Database Offline Events November 13, 2018
- Capture Index Maintenance Operations December 20, 2017
- Automatic Tuning Monitoring and Diagnostics January 4, 2019
- Extended Event Help Queries July 19, 2016