jay holovacs (1/6/2011)

---

Americans (the culture I am most familiar with) seems to have a dangerous fascination with the hero who breaks the rules-- the A team, the renegade cop or...

If an application accesses the database though an account with ad-hoc query privillages, then how is a DBA to know there has been a breach? There would have to be...

We can't expect a good result simply by wrapping process around un-trustworthy people. The fast food and financial industry have proven that. More can be done in less time by...

TravisDBA (1/6/2011)

---

I think that as more Indian developers purchase their first home, while a...

For what it's worth, the dynamic management view [sys.dm_db_index_physical_stats] returns...

I think it's best to have a small and well thought out number of business policies (or personal principles or religious doctrines), and dedicate our time and engergy to upholding...

Pete23Mid (12/30/2010)

---

This question must have been already asked hundred times, but maybe somebody, who tried both can give some sort of comparison. I am using MySQL right now and I...

You can download and install Oracle 10g Express edition on your XP or Vista laptop, no need for a seperate PC. Last time I checked there not yet an 11g...

Revenant (1/5/2011)Over the last five years I had several clients for whom I did this. Unfortunately, what I did is confidential in perpetuity. So far asw I know, confidentiality is...

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