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

samuel.shollenberger (10/20/2016)

---

While I agree that much of the "codswallop" could be done away with tomorrow, there is a certain amount of "irreducible minimum" that is needed to be sure it's...

Grant Fritchey (10/19/2016)

---

The best way to do this is to give each developer their own local instance and their own local copy of the database. For this to work well,...

You can do something like this. What it does is delete all rows where there are matching rows having the same key columns but a greater DateAdded. You'll need to...

It's good that you have database backups. However, you also need to script out your database and maintain it a version control system. In addition to recovery of objects, it's...

Before going through the time and trouble of restoring the database just for a single object, the following is worth a shot. What will do is search for any prior...

Jeff Moden (10/18/2016)

---

Just to throw my opinion into the ring...

I've been tremendously successful and I barely know how to spell SSIS, SSDT, SSAS, SSRS, or any of the other 4...