In addition to responding to data breaches, you also need some type of monitoring process in place to detect a breach. Any thoughts on the best methods or services to...

How you approach this really depends on how the table and column are being used and what applications or reports that currently reference the table would be affected. If 'ASP'...

I'm not sure what useful information could be gleamed from database "transaction logs" in the event of a data breach, unless the hacker was modifying data.

In addition to the...

ibzmiller (1/4/2011)

---

Hi Eric,

I had approached it this way initially. I had a script ready and everything. But thought that maybe it would be cleaner to delete/less prone to error...

ibzmiller (1/3/2011)

---

Hi Guys,

I'm working with SQL Server 2005 and need to deploy table changes to the live database which has existing data. All I'm doing is adding a couple...

CirquedeSQLeil (12/30/2010)

---

I have seen both places to be productive. I prefer a good mix between both environments. That way some face-to-face resolution can be done. Also, by...

Stefan Krzywicki (12/30/2010)

---

Yeah, I do need to get around to buying that DMV book I've been meaning to get. I was just waiting for it to be finished first, but...

There is a reason for multiple indexes. For example, if a reporting type query only searches on BusinessDate,...

When you post a resume on a job site, I think that most employers just text search and skim over the online version. However, when we interview candidates, we do...

You could call MS Access a low end development tool, because it supports the construction of complete applications, having a scripting language, forms, database, and reporting engine all bundled together....

...

Steve Jones - SSC Editor (12/29/2010)

---

I'd highly disagree with this. Just...

Is this what you mean by sorting a string in numeric order?

1

1.1

1.3.4

1.22.0

I haven't worked in an office in some time, but I do remember a constant stream of interruptions. An hour of time without someone talking to you was rare, and...

DBA Rafi (12/28/2010)

---

Thanks for your detailed answers.

As you said, If such warning is not available in SQL Server, then It's fine. No Issues. I should go with that.

But I don't...