A second vote for Gail's post. You need to determine the reason the log is growing. If it's replication, then you need to clear that or solve the issues before...

You check the maximum memory that the OS can see. If you don't know how to do that, search for it. It's a basic item to check, and if you...

Good catch, Carla. It was on the main page, but not in the article. I've added it, and I'll miss it as well :(, already have vacation scheduled that weekend...

djackson 22568 (12/6/2011)

---

Vendors still push for "sa" accounts for access and there is little I can do when I am told to implement a system with that poor of a...

sqlnyc (12/6/2011)

---

Steve - I'm not sure where you're located, but here in NYC, some financial institutions implement what is known as a "professional day". In case this is foreign to...

There is a lot more to encryption than creating a Database Master Key and a certificate. You, in general, don't want to encrypt data with a certificate or asymmetrical key...

I agree with Grant. Leave 2GB for the OS, then set the rest for SQL Server. You can also look at what SQL Server lists for the Target SQL Server...

A couple of things. The month of payment, is that a date?

Also, where does the beginning wage come from? Is that supplied by you?

You don't have a SELECT that retrieves...

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...