I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...

The purpose of the job is to plan, manage, administer and secure system databases as well as troubleshoot any database issues affecting system performance and ensure data quality across the databases.

I'm very sad to say that after 5 ½ years I am leaving Quest and, as a result, this will be my last column for Database Trends and Applications. I have greatly enjoyed writing these articles and I hope ...