Kazmerelda (10/25/2016)

---

Now they want to offer me RAID5 instead of RAID10 *weep*.

Eric, I think you could be right here I am a belt and braces person and I don't overspec...

A disgruntled DBA is the equivalent of a zombie clown with...

Gary Varga (10/25/2016)

---

Geoff.Sturdy (10/25/2016)

---

Gary - the two digit year was born out if the need to conserve memory in early systems - back in the late 70s /early 80s...

Super_Grover (10/23/2016)

---

Hi all,

I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

It appears that first...

This is why corporations hire their own staff lawyers and scientists; they don't want to know how best to do things; they just want to know how close to the...

When we speak of no-schema databases and analytical tools, I assume we're referring to a data store essentially intended for staging and exploration. It truly is a bucket of 1s...

I'm not too concerned about how masking or hashing of demographic data in development skews data statistics and performance testing. When coding SQL or designing indexes, it's best not to...

In addition to using a version control system like Git or TFS, where a copy of working code is committed both locally and on the server, it also helps if...

scarr030 (10/21/2016)

---

Hey all,

I actually just got promoted to our DBA position, which has been vacant for quite a while. There is very little documentation on our set up and what...

Ed Wagner (10/21/2016)

---

Phil Parkin (10/21/2016)

---

chocthree (10/21/2016)

---

All, I thank you for each of your responses. Much appreciated.

Ok, here is the deal. I'm a little long in the tooth and have done...

Yes, checklists are essential for database administrators, and even experienced DBAs are not in the habit.

However, it's not exactly a ground breaking idea.

Brad’s Sure DBA Checklist

https://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

Brent Ozar's SQL Server...

The next phone I get, I'm just going to snatch one out of the recycle bin at the grocery store. Considering the way so many folks upgrade every time a...

Arriving home around 6pm, after cooking and eating dinner, helping kids with homework, having some one-on-one time with the wife, and then an hour of exercise or household chores, there...

So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints on each of these...

ZZartin (10/20/2016)

---

Eric M Russell (10/18/2016)

---

One thing that can be said for single tier development tools like MS Access and FoxPro, they allow a developer to quickly stove pipe a complete...