I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What kind of permissions would need to be set for that?< ...

How do I assign permissions ... add a user as a member of the SQLAgentReaderRole, you can execute the following command: It is also worth mentioning the other two SQL Agent roles available in SQL ...

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS ... does not have access to the file (as far as SQL permissions go). Fixed the tab ordering on the Job ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...