GilaMonster (2/11/2012)

---

None whatsoever. In addition to the fragmentation problems, shrink too much (not leaving enough free space) and the DB will be frequently growing and that growth will slow down...

High quality...

wmt (2/7/2012)

---

Hi,

I'm trying to setup my SQL instance to encrypt connections.

My plan was to get a certificate, install it, then goto SQL Config Manager, turn on Force Encryption = Yes...

cengland0 (2/10/2012)

---

Someone mentioned in another article that all you need to do is run a trace and you can get all this information. So, should the hashing be done...

L' Eomot Inversé (2/9/2012)

---

I would be unhappy with 64 bits; basicly I think of the salt length as being comparable to key length for symmetric excryption, and for symmetric encryption...

Steve Jones - SSC Editor (2/9/2012)

---

The idea here would be to use this in your table. So if I have salaries:

CREATE TABLE employees

( firstname VARCHAR(50)

, pwd VARCHAR(200)

)

GO

INSERT dbo.Employees

VALUES...

Adding a salt in and of itself is merely a device to 1) prevent the trivial identification of the same cleartext (i.e. hash A5BC is...

Eric M Russell (2/9/2012)

---

The script you posted is great...

Very useful, though for anyone doing a more comprehensive security audit, I'd also run Vyaskin's code, which I modified only slightly, and which does not list sysadmin roles, but does...

I would say the question as intended is a useful learning tool, but it was written poorly.

HASHBYTES does...

Thank you for the articles!

Are you going to cover auditing who reads which data, as well as changes?

If you're doing this for auditing reasons, you might also want to see what happens when you set up an account without the complexity enforced with a password that would...

We've experimented with local Enterprise SATA SSD's here, starting with TempDB (Data and Log sharing SSD RAID sets), to extremely good effect. So far, we've been using them over...

This looks good, and makes sense as well.

For extra credit, include instructions on how to cause OS/filesystem level fragmentation as well :).

mtillman-921105 (1/30/2012)

---

Well, if they're not already doing so, I hope that new programming languages start using another delimiter for strings other than quotes. Even brackets "[]" would have been...