you cannot directly delete the log files. You need to empty them with log backups and ensure the one file you need is the active file.

Also, make sure if you...

Books Online is a good resource for getting started, as is this site. Use the searches to pick a topic and learn.

SQL Server doesn't encrypt backups unless you have TDE enabled and then the key is auto-generated. You do need to back this up.

The native SQL Server backup just uses passwords,...

!= seems easier to read to me, but I'm not sure it matters.

I've worked 40 hours for week in a number of jobs. Not every week, I had a few 50-60 hour weeks, and even had a few 100 hour weeks, but...

This is such a general question. There aren't necessarily a specific list of things to set/change on your server without getting into a huge document.

Basic things:

1. pick service accounts...

Does the inclusion/use of TDE on Express preclude or interfere with FDE? Not sure this is...

Thanks....

paul.knibbs (12/5/2011)

---

I kind of disagree here. In the case of laptops, if there is any sensitive data on there at all--doesn't matter if this is in the form of SQL...

Big blog changes. Not sure I love it, but it's a change.

I wish the comments would pop a new window, but overall I think this is a good move.

You're missing the point. It's not all...

john.campbell-1020429 (12/5/2011)

---

2.) Employers already pay a stiff administrative cost to comply with numerous "labor regulations". This money could be going to much more deserving recipients, me for example, instead...

SQLLearner1 (12/5/2011)

---

Hi,

I guess I don't fully understand, but maybe someone can help me out.

**** This bill is aimed squarely at reducing pay for those people in the industry that make...

I'd agree that a workgroup offers less exposure than a domain, in general. That's usually a size thing, however. Not sure a small workgroup is more secure than a small...

?? Not sure what...