If your application or user accounts are members of the sysadmin role, then it's like having a house full of kids and then leaving the gun cabinette unlocked.

However, most...

I understand why xp_cmdshell would would be disabled in a non-dedicated environment hosted by a 3rd party. In that case there is a clear distinction between the database owner and...

jfogel (3/25/2013)

---

Good point but the writings of Frank or King were one offs and of value from the start. Important information will migrate to new storage methods so it is...

There are some settings that arn't just tweaks; they fundamentally change the behaviour of SQL Server and should be chosen based on the case usage of the database:

Optimize for Ad...

Steve Jones - SSC Editor (3/21/2013)

---

In a practical sense, it doesn't matter if it's cat videos or anything else. We still need to manage the data, which means work for...

Eric M Russell (3/21/2013)

---

Good point.

How percentage of...

Good point.

How percentage of total data consists...

On MSDN and TechNet, there are various visual guides that present a high level overview of the SQL Server architecture stack and then drill down to more detailed technical articles....

I don't understand why a script to scan across all tables in a database would be needed. Generally speaking, we know ahead of time if we're looking for a customer...

Here is one technique I use when there is a need to perform bulk deletes on a large table. It is not an online operation, but it should be able...

That's a denial of service type attack that I hadn't expected, but it is an interesting attack vector. I wouldn't expect this to impact servers, but if servers are consuming...

paul.knibbs (3/5/2013)

---

I could be really smug because I always use Firefox, but instead I'll allow myself to be gobsmacked that such an obvious flaw has made it into three major...

Miles Neale (2/26/2013)

---

Dave62 (2/26/2013)

---

Definitely not.

I do .NET development and SQL Server development/administration. ...

pdanes (2/22/2013)

---

It's not obsolete if it still does the job it was designed to do. I've written my share of FORTRAN, RPG, COBOL and who knows what else over the...

Michael Valentine Jones (2/22/2013)

---

Eric M Russell (2/22/2013)

---

Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language...