This is a complicated question. It's not easily answered.

TDE will encrypt the data files and backups. Without the password, people will not be able to attach/restore the database.

However. Every person...

Yes.

So the way mirroring works is that you'll move a full backup over to the secondary. So that if you restore it, compression will be enabled. This means you need...

Same as a non-mirrored database. What you do to the primary will be sent to the secondary. The big concern is load while this occurs.

Shrinking the log makes sense, but...

Greg A Goss (10/17/2013)

---

Not knowing anything about your environment, here are a few suggestions, most of which assume this machine isn't required to be up 100% of the time.

I...

Read the articles Gail mentioned.

As noted, you need log backups. The transaction log will keep all data around on transactions until it is backed up (some exceptions for mirroring or...

I don't have direct experience here with support. We run SQLServerCentral as a cluster on virtual machines (Not AG/AlwaysOn) with 2008. Both nodes are provided to us by our hosting...

You have filestream enabled.

Filestream has a separate filegroup for its data and there will be a file or two in this filegroup that are actually pointing to files. These need...

Well, I'm back. 8 days on the road was a lot. Met many people, saw many more, including Rodney in Charleston and Charlotte, along with Wayne, Jason Brimhall, and more....

This is a good chance to learn. It's not terribly difficult and you have a specific project here to work on. Do a little...

Yep, that's an easy one and makes sense. My developer is on holiday, but I'll send this over.

djackson 22568 (10/14/2013)

---

You won't ever be able to stop 100% of all spam, wihtout blocking legitimate posts! So, maybe you can find a way to add a "Report Spam"...

It isn't completely clear what you mean here. If you are just storing the points that describe a circle or square, you can easily create two tables. however from your...

Nevyn (10/16/2013)

---

Its possible that smaller businesses developing new systems from scratch are thinking cloud first, or starting to.

But I haven't seen any sort of groundswell to move existing database implementations...

chrisn-585491 (10/16/2013)

---

Sigh! Four years and folks are still trying the upsell the cloud. Maybe the NSA is offering an additional bonus? 😛

Most of us who've been in this business awhile...

It's not clear at all what you mean. You should provide a better description of what you are trying to model here.