Interative development with a series of deliverable milestones. I've found that stakeholders and users are more willing to accept long (and even expensive) project lifecycles, if they can get their...

Documentation of the database architecture and processes is especially critical when the disaster your organization is attempting to recover from is the sudden death of the DBA.

A Proof Of Concept doesn't have to be a mockup of the entire solution. For example, if I want to prove the concept that loading data into a staging table...

robert.sterbal 56890 (4/12/2016)

---

Eric M Russell (4/12/2016)

---

I like SQLBits talks, because they are more conversational and don't use live demos. That works well for me, because I rip a lot of...

Gary Varga (4/13/2016)

---

This....

below86 (4/13/2016)

---

I've got a question on how I should handle a situation. I've been looking at local companies and I've found one that has an opening I think I...

below86 (4/12/2016)

---

I...

While job searching last year, the biggest obstacle I had to overcome was IT recruiters. My advise is: Don't rely (or even waste your time) on 3rd party recruiters, always...

below86 (4/11/2016)

---

Eric M Russell (4/6/2016)

---

We have open positions for SQL Server DBAs and Database Developers (v2008 - v2016), if anyone is interested in the North Atlanta area, specially Kennesaw/Marietta. Good...

I like SQLBits talks, because they are more conversational and don't use live demos. That works well for me, because I rip a lot of SQL Server related audio tracks...

GSquared (4/11/2016)

---

No...

First, to prevent this from happening again, take steps to insure that you are not restoring good data on top of faulty hardware, so run a disk subsystem diagnostic.

Going forward,...

Both UserID and NTAccount should have a unique index. If UserID is clustered, then that should be the fastest access path.

Is MyColumn of type VarChar? Perhaps what they intended to do was convert NULL values to the string 'NULL'.

For example:

ISNULL(MyTable.MyColumn, 'NULL') AS MyColumn

This is how IT management sees it. 😛

'Cat Herders'

https://www.youtube.com/watch?v=m_MaJDK3VNE&feature=player_detailpage