dbta

SQL SERVER DRILL DOWN: DBAs Keep Asking: “Will I Have a Job in the Long-Term?"

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 ...
Houston Chronicle

How to Find All Scheduled Jobs in SQL

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...
TechRepublic

How do I assign permissions to users to see SQL Agent Jobs?

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 ...
dbta

SQL Server Real-World Trends

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 ...