Steve Jones - SSC Editor (4/11/2014)

---

Eric M Russell (4/11/2014)

---

Obviously the government, whether it be Congress or some agency dedicated to the task, can't come up with the standards; it has...

Steve Jones - SSC Editor (4/11/2014)

---

Eric M Russell (4/10/2014)

---

The standards would not have to be very technical. Dedicated sysadmin accounts, removal of service accounts from sysadmin role, seperation duties, application...

Gary Varga (4/11/2014)

---

john.riley-1111039 (4/11/2014)

---

There are many circumstances in life where we prepare for relatively unlikely events. We install sprinklers and fire extinguishers in buildings,

air bags in cars, pilots...

Gary Varga (4/10/2014)

---

Just define legal requirements to be best endeavours. I think that most sectors where it counts there are further standards, for example in the UK we have the...

OCTom (4/10/2014)

---

Hackers are not going to try to hack all severs. They look for the easiest path. This is one area where it's best to be the ugly duckling at...

I believe that SQL Server already has the required features to implement auditing (SQL Server Audit and extended events), granular controls (permissions), and seperation of duties (database and server roles)....

Jeff Moden (4/9/2014)

---

Eric M Russell (4/9/2014)

---

In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft?...

Look around on the website http://www.sqlskills.com/blogs/paul/ for articles by Paul...

defyant_2004 (4/9/2014)

---

I am trying both these queries out, thank you.

It appears I have to run the first query individually for each database, unlike the dbcc sqlperf ('logspace') which gives all...

defyant_2004 (4/9/2014)

---

Hello,

I use dbcc sqlperf ('logspace') to keep an eye on the logs for our databases. I like that it tells me how big the log file is and...

In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft? 🙂

enriarg (4/8/2014)

---

I was let go of a company when I first started as a programmer because I fall a doze of in a meeting... truth to be told I have...

Yet Another DBA (4/9/2014)

---

Eric M Russell (4/8/2014)

---

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is...

I don't think anyone here has provided an example of executing dynamic SQL. There are various approaches and pitfalls, so I'll provide a link the definitive tutotial...

jay-h (4/8/2014)

---

Eric M Russell (4/8/2014)

---

I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is through government...