CirquedeSQLeil (3/17/2011)

---

I think a huge it depends is in order for NoSQL v RDBMS. One thing to consider is if the data consistency or data recoverability in your application...

Ron Porter (3/17/2011)

---

Mike B in AK (3/17/2011)

---

Interestingly, I inherited a process where the previous person stored integer values in a varchar(3) field and did poor quality checks on the data...

richardd (3/17/2011)

---

How can anyone claim that storing a date as the string "09/01/2001" is...

The representation of dates as character strings in a database (what I'll call a "VarDate") is one of the leading causes of business intelligence disasters.

The day will come when another...

There are many different scenarios, but if what you need is access to the database itself, then you can always attach a copy of the mdf file(s) to a SQL...

Just because a database platform is good enough for Facebook or Google, that doesn't mean it's good enough for online banking or e-commerce. I believe that financial and operational data,...

So after the staging server has finsihed updating it's copy of the database, you do what with the synonymns on the production server? Point your queries to a different database?

Generally speaking, transaction logging is trivial during the normal day to day operations of a OLTP database, especially if the log files are on separate storage from data files.

If...

[Jim].[dba].[Murphy] (3/10/2011)

---

mmmm. Not sure about that. A log truncation could have bad side effects if any part of that database is used by others; rows being modified in...

Carl B. (3/9/2011)

---

It could be helpfull to avoid logging in scenario where you want to "UPGRADE" the data in a BD with numerous conversions script:

1- You take a full backup...

Steve Jones - SSC Editor (3/9/2011)

---

Mark W Johnson (3/9/2011)

---

I don't see my job as writing code so much as solving the user's problem through code; my job is to help...

This piece is a few years old, and it talks about how quality has become more important at many large software vendors. Looking back across the five years since the...

Those of us who were developing applications in FoxPro, MS Access, or some other ISAM platform back in the 80's and early 90's know the perils of a transactionally inconsistent...

Transaction logging usually isn't an issue unless you're inserting 100,000+ records one.. at.. a.. time.. in a loop, or the DBA allows the transaction log to grow until it fills...

Of course wether or not a security flaw or bug makes public headlines determines how it is triaged, however it doesn't mean that Microsoft is just sitting on it.