Taken at face value, it looks like an interesting job, but the description doesn't indicate where the client is located.

In MSDB, the following database level roles grant members various levels of permission to do things like monitor or start jobs.

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

https://msdn.microsoft.com/en-us/library/ms188283(v=sql.110).aspx

Lynn Pettis (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Sounds interesting, unfortunately New York City isn't really where I would like to work. Too bad this may not be a position open...

ChrisM@Work (6/7/2016)

---

Eric M Russell (6/7/2016)

---

Jeff Moden (6/7/2016)

---

Eric M Russell (6/7/2016)

---

So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer....

Jeff Moden (6/7/2016)

---

I do expect Senior...

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that you should answer on your own.

I could have...

The more abstracted your application developers are from the database, then the more abstracted your logical model needs to be. I've worked on projects where the application developer was sitting...

So what's consuming disk space on your data file drive?

This will give you the outcome you requested, if not the implementation.

select Name from table where ID between 1 and 3 order by ID;

They're asking the wrong type of questions for a job interview.

Jeff Moden (6/3/2016)

---

Heh... you can't imagine how many times I've seen supposedly "one time" things suddenly become a requirement. 😉 The company...

Many folks botch their phone or in-person interviews because they are too nervous. When you interview, try to maintain a layed-back attitude, and you'll come across as more confident and...

David.Poole (6/6/2016)

---

One of my managers always volunteered to keep the minutes, that way his points were always recorded and inevitably signed off.

There's clearly an art to running a meeting and...

If you're deleting millions of rows, then it's probably the transaction logging, not the actual join or delete operation that's killing you. It's been a couple of weeks since your...

If you don't have a LinkedIn profile, then create one. If you have "SQL Server" anywhere in your profile, then recruiters WILL contact you... frequently... for the rest of your...