Yuck, who let a sales repsentative for Red Hat wander into the data center? 😀

Apparently app programmers building a persistance layer think they're real database developers. 😛

First, use a schema comparison tool between the old and new database to confirm all indexes were migrated over.

Welsh Corgi (9/1/2015)

---

Ed Wagner (9/1/2015)

---

Finding performance problems can be difficult. Fixing them can be difficult. However, it doesn't usually matter how hard it is to find or fix...

Here are a few TEMPDB related scripts from my toolbox.

This...

Welsh Corgi (9/1/2015)

---

Eric M Russell (8/31/2015)

---

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed....

Estimating an IT development project help if you start with a framework. For example, in the home construction industry, unless you're going for a multi-million dollar Frank Lloyd Wright style...

The idea of telling a computer to do x seems more bounded and contained than other professions, but it's really not. This is often because developers don't get a complete...

I have some idea of what doo doo would happen without foreign keys.

Iwas Bornready (8/31/2015)

---

This was fun to read. I saw myself through out the brief article. Keeping in mind that not all problems presented to us are done so to get...

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is...

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is competing for storage with other...

I guess there will always be differences of opnion between those who see a database as basically a data reposity for an application, versus those who see a database as...

Orphan records can pose serious problem in an operational or OLTP database. However, they are less of an issue in a data warehouse. There is this thing called "late arriving...

Complaining about foreign keys is sort of like when folks complain about those cement barrades that divide north bound and south bound lanes on a highway or the speed bumps...