If the application developers want the data pivoted in some funky way, then grant them select permission on the tables, and tell them to create the SQL dynamically. There is...

What's called a database in Oracle is an instance in SQL Server.

What's called a schema in Oracle is a database in SQL Server, and SQL Server may contain multiple databases.

SQL...

jkelly (1/5/2011)

---

Follow-up: per articles such as this ("SQL Server Best Practices – Implementation of Database Object Schemas" http://msdn.microsoft.com/en-us/library/dd283095%28v=sql.100%29.aspx ) it does indeed seem possible, per the documentation and example, but...

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