News

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.
SQL Agent runs jobs on a local database server or, using a master server, on multiple target servers. In addition, Elastic Jobs can dynamically enumerate the database in a target group, including or ...
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 ...
NetIQ’s SQL Management Suite is intended to ease administration of Microsoft’s SQL Server production systems by providing configuration management, diagnostic and recovery functions. Three of ...
A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.