I predict that within 5 years the Internet of Things, Social Media, and Big Data will be passé. Companies just can't find a way to build profitable business model around...

A cursor or any other "sequential row by row" construct to isn't needed to insert rows from one source table to a destination table, and it's actually the least efficient...

Lynn Pettis (6/8/2016)

---

Just saw a message from the recruiter, Jeff....

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