Don't forget that for small values, like those you have with letters, a single page will have thousands (potentially) of entries on it. Since SQL Server will read the entire...

I actually like Bruce Schneier's solution better. We will get hacked, we will have data breaches, so we ought to have better monitoring. Better analysis of what is happening.

To me,...

I certainly find some frustration with the level of writing at times. I think that the 8th grade target is a laziness/greed level. Get the message out and make sure...

Thanks for the note. We constantly are tracking down blacklisting. Some companies are quicker to report us for a complaint than others. We do try to remove people as soon...

Thanks, Joe. I haven't worked for a Six Sigma company, but that's a good suggestion for those that do.

I think that the receipt issue could be a flaw in this system, depending on the way the business is defined. Perhaps Bob always wants the up to date information...

This is a hierarchy, and the recursive CTE handles it well. You can read more about it here:

http://www.sqlservercentral.com/articles/T-SQL/65540/

This might be in the default trace. There is an event that shows the database name, the object of NULL and then a class of 164 when I bring it...

20GB, as Grant mentioned, isn't large. However if you are considering this to be a small system that is growing, I would split the table to a separate filegroup and...

There is no way to determine when the last time a table was accessed in terms of SELECT queries, and unless you are auditing somehow (even with a GETDATE() in...

Have you read this? http://technet.microsoft.com/en-us/library/cc917684.aspx

no, it is restoring and cannot be accessed. You can create a database snapshot from it, or you can get read only mode from log shipping, but not database mirroring.

rick-507511 (1/15/2011)

---

MB, TB, whatever. The hours relate more to how much of your life you are willing to commit. I spent more hours managing a single server single...

The pros are cracking our systems and selling information!

We ought to have this discussion, and the best thing that can happen is better disclosure and more openness about how security...

If the sectors have not been overwritten, then someone could read the disks. Arguably not easy, but possible.