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

Business Intelligence is a "tip of the spear" IT role. Not only does it requires someone who has several years of general IT experience in a corporate environment, but it...

For consistency and ease of maintenance, you only want a calculation to be performed once. How far up in the stack a particular computed attribute is introduced depends on who...

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 functional solution without being...

If you havn't already, then read Kimball's book "Data Warehouse Toolkit", particularly chapter 2 which covers various standard approaches to fact and dimensional table design.

https://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247

VB6 and even FoxPro applications still thriving and multiplying in some IT shops despite having no evolution in it's digital DNA for almost 20 years.

Aside from the probability that the physical model of a "code first" database will suffer (no proper indexing, poorly typed, etc.) another issue is that the logical model itself will...

I occasionally encounter SQL that was originally coded back in the early '90s, even though it has been migrated to newer hardware and RDMS platforms several times since. The way...

When I'm experimenting on some project at home, it's usually something vertical like loading my bank statement transactions into SSAS or programming a home automation controller. I'm not trying to...

It sounds like you have data corruption, but you can also try the following to quickly search for an object_id across a multiple databases.

exec sp_MsForEachDB

'

USE ?;

print ''Searching ... ?''

print ''Found:...