steve smith-401573 (9/15/2011)

---

Assumptions to verify for the cloud:

1. The security environment is suitable

2. SLA is ironclad and something you can live with

3. Response time performance to inquiries...

Tom.Thomson (9/13/2011)

---

Steve Jones - SSC Editor (9/12/2011)

---

I agree that people should maintain some understanding of what's going on at a low level, and that if they don't they may lose...

Revenant (9/14/2011)

---

Nadrek (9/14/2011)

---

Revenant (9/14/2011)

---

Nadrek (9/14/2011)

---

. . . Single hashed SHA1 passwords can be cracked at a rate in excess of 13 billion tries per second per machine with GPU's......

Revenant (9/14/2011)

---

Nadrek (9/14/2011)

---

. . . Single hashed SHA1 passwords can be cracked at a rate in excess of 13 billion tries per second per machine with GPU's... . ....

Security is a very specialist area, once you get past the basics. And, like other posters stated, most of the simple measures which should be put in place are...

djackson 22568 (9/11/2011)

---

First off, there may be hoardes of algorithms to sort, but I laugh when young developers try to tell me how Java can sort faster than the quick...

If you're going to use the values in joins, use referential integrity, or otherwise have value added by a relational database, yes.

If they're going to pull the data to their...

Get both - good CS degrees for senior/architect/lead positions, and vocational training for the lower levels!

A good CS degrees tends to lead to multiple language proficiency, multiple ways...

Dave Mason (9/6/2011)

---

Ok, so now that I've gotten that out of the way, here's some of the details of the path I've started down:

I created a db user [BuiltinAdminUser] in...

Agreed. See also the Unicode Byte Order Mark FAQ for...

I have; SSD's and (D)RAM serve different purposes; there's some overlap, but not 100%.

So far, SSD's are used in a very limited role as an experiment; RAID1, 10, and 5...

Watch out for instance ("server") level settings, such as collation, MAXDOP, cost threshold of parallelism, default fillfactor, and so on.

Vendor apps that collate to the server default, expecting...

And will you have a need to index those columns?

In general, I agree with the above posters.

Note that a "generalist" is merely someone with more than one specialty and/or sub-specialty; they may, but are unlikely to, have reasonable knowledge...

+1 on the page split/fill factor optimization.

If you really want to argue with your co-worker about fragmentation on SSD's, use SQLIO and run tests on sequential vs. random. My...