Yes, by necessity the role of a typical DBA is changing. If you work in a massive hosting data center with dozens of DBAs, then maybe you can get by...

A session can be held for an extended period of time in a wait state without being blocked by another session. For example, it could be a complex and long...

On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there are some employers who advertise for...

Bill Talada (1/27/2016)

---

And Eric...how is it that foreign keys are a performance penalty, other than one time at insert? Don't they provide information to the optimizer to make queries...

Charles Kincaid (1/27/2016)

---

Actually FKs for the purpose of documentation only seems like a bad idea.

The...

mjh 45389 (1/26/2016)

---

Eric M Russell (1/26/2016)

---

Alan.B (1/26/2016)

---

Ivanova (1/26/2016)

---

...

In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent 79-year old (today)...

I assume the goal of inferring foreign key relationships is for documentation purposes, that is when you're trying the puzzle out how to map from an unfamiliar source system into...

titsiros (1/26/2016)

---

The databases are on different machines but for the purpose of the merge we could move them to the same one. This would also make sense in terms of...

Luis Cazares (1/26/2016)

---

Eric M Russell (1/25/2016)

---

Luis Cazares (1/6/2016)

---

Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this: http://i.imgur.com/shDmF0L.jpg

I hope I...

Given a database with no defined foreign key constraints, analyzing schema information is essentially inferring relationships by static analysis. Another approach is looking at join operators within stored procedures or...

Alan.B (1/26/2016)

---

Coding and earning $$$,$$$...

mjh 45389 (1/26/2016)

---

Eric M Russell (1/22/2016)

---

Ed Wagner (1/22/2016)

---

mjh 45389 (1/22/2016)

---

I think I am somewhat underpaid but I do work in a pleasant location with agreeable individuals which is worth a...

Ivanova (1/26/2016)

---

Sad to say, part of crafting a resumé which will pass the first stage of eliminations and get you in front of an interviewer may well be to omit...

I...

If your employer is tired of paying taxes and upkeep on a DBA with 20 years experiences, then it's not hard to find another employer willing to resume payments.