1. Fully parameterize all your SQL calls, whether they're stored procedures or not. This is your best protection.

2. Get Firefox 3.5 (perhaps on a VM), and install addons like...

What's the Fill Factor on the indexes with the fragmentation issues?

If you're doing updates or inserts throughout the values of the index, I would recommend trying a value lower than...

Thank you for such an informative post. I've been involved in initial benchmarking of more standard enterprise SATA SSD's on a local RAID controller, and while the results are...

For the record, I checked with the user, and of the two 2/29/2007's in there, one was supposed to be 3/29/2007 (typo), and the other should have been 12/29/2007 (the...

Welcome to health care.

Do hire a reputable and fully up to date legal and regulatory compliance expert (or two). The penalties for noncompliance can be very serious.

Do consult the...

WayneS (3/26/2010)

---

One year isn't enough; three years is probably too much. Two sounds like a good middle to me.

Now, how would one go about getting documented experience? I think figuring...

As far as standard vs. proprietary: it depends.

If you need your work to be portable with a minimum of fuss, then you must write as standard a set of code...

I agree with GSquared; an apprenticeship system is what I have been supporting for decades. Yes, you have a varying education based on the master you study under (i.e....

As another poster mentioned, anyone interested can start with some of the NIST Special Publications.

For example, if we look at the path of, say, SSL encryption, we might start at:

SP...

I would also, in your experimenting, be cautious; certainly with SQL Server 2000 I've seen the database engine choose to use absolutely the wrong index, even with up to date...

I think Perfmon is missing in the list; I find it a useful tool for watching, in particular, disk and network IO.

A packet sniffer of choice can also be very...

A few more, and some "I support the previous posters":

Look for Enabled but Untrusted constraints

+1 on check for index fragmentation

Check for external (OS level) fragmentation

Check for databases on OS compressed...

Alan Vogan (2/12/2010)

---

Wow. Reading everyone's post, it sounds like many have a problem with 'IT' or 'System Admins' whining about DB's taking up to much disk space. Disk space is...

As my SQL Server backups are usually a mix of backup and archive:

Backup: the ability to restore a system to functionality following a problem (DML or DDL (DROP) mistake by...

As another example of the issue: assume the data actually changes in the base table, but the checksum of the new data is the same as the checksum of the...