sqldba_icon (1/7/2011)

---

Thanks. If i give only exec permissions on the procedures,lets say i am deploying 80 procs( which we do) then i will need to individually grant exec perm to...

Technically speaking, you...

sqldba_icon (1/6/2011)

---

Yeah i can try that i think i might end up giving sa priviledge to the account since the app also kicks off few jobs unless i manually...

It not what's important to me personally as a DBA or developer, but what's important to the business: users, clients, and management. Technically speaking, a partial restore that's still functional...

Resender (1/7/2011)

---

today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours the best answer i can think off atm...

Resender (1/7/2011)

---

today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours the best answer i can think off atm...

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