What I would find impressive are case studies about state or even federal government agencies, like the IRS or the California Department Of Motor Vehicles, using SQL Server as their...

I read a note about a 1.1PB database, built on SQL Server to hold data from telescopes. That particular data warehouse is producing 1.4TB a day. I know it's mostly...

Peter Trast (5/4/2011)

---

Eric M Russell (5/4/2011)

---

A simple Google search can reveal page after page of web.config files located (perhaps inadvertently) in public web folders and contain a ConnectionString with uid="SA"...

A simple Google search can reveal page after page of web.config files located (perhaps inadvertently) in public web folders and contain a ConnectionString with uid="SA" and PW.

Eric M Russell (5/4/2011)

---

kim.etcheson (5/4/2011)

---

We bought a vendor package where the vendor hardcoded the db logon and password in the application that we couldn't change on the database or the...

kim.etcheson (5/4/2011)

---

We bought a vendor package where the vendor hardcoded the db logon and password in the application that we couldn't change on the database or the app wouldn't work....

Least privilage is actually east to setup. First create a role that grants exec permission on the stored procedures that the application needs access to, add then add the application's...

Unfortunately, at 10:15am PDT, one of the operations engineers developing the playbook touched the keyboard. This resulted in a full outage of the network infrastructure sitting in front of Cloud...

Revenant (5/3/2011)

---

Eric M Russell (5/3/2011)

---

. . . <big snip> . . .

There are so many questions asked on the web by so many people that even right answers for commonly...

Revenant (5/3/2011)

---

Eric M Russell (5/3/2011)

---

Steve Jones - SSC Editor (5/3/2011)

---

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and...

Steve Jones - SSC Editor (5/3/2011)

---

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and reference tables) to return...

paul.knibbs (5/3/2011)

---

The public perception of computer systems is that they are mindless robots who interpret commands from operators literally and then follow through with them relentlessly, even when the operator...

It's the kind of error an operator could makes as a wrong choice on a menu or the entry of the name of the last network worked on instead of...

maverickza (4/21/2011)

---

Hi,

I want learn SQL server but want to do it self study - company I work for don't want to send me on a course.

What is the best...

Revenant (4/29/2011)

---

Eric M Russell (4/29/2011)

---

geert.bens (4/29/2011)

---

I would like to see developpers and DBA's in thought of building a house. the developper is the constructor, the DBA responsible for the fundations...