I'm afraid I don't understand the logic for the first query.

If I query it so that it gets the Donation IDs that match all criteria, it just comes up with...

Steve Jones - Editor (12/21/2009)

---

I'd like to see it as the default for some files. Like SQL Server files. Adding this option to Express, AND making it the default, would...

In BIDS, go to Files, Save Copy of Package..., and pick the option to save a copy to SQL Server.

Intelligence usually isn't the issue. ...

Those reports get their data from DMVs and other T-SQL commands, so yeah, you can roll your own in Reporting Services or some such. I haven't done that, but...

Virtualization does have a performance penalty for SQL Server, but it has the advantage (if set up correctly) that it can handle one part of a virtualized cluster going down,...

sjsubscribe (12/21/2009)

---

Encryption in general should be a default install at the OS level and apply to all files, not just to database files or express editions. Files like formatted reports,...

In the Data Flow task, you can add Derived Columns to the source definition. That'll do what you need.

I suggested one of RedGate's products. It'll probably do what he needs.

Appears...

I recommend taking a look at RedGate's SQL Response product (link is at top...

I'm not sure what you're asking for. The tables seem pretty clear, but is what you need just a query that joins preferences to people and to options? ...

Looks like a couple of simple selects inserted into a table variable. Are you familiar with how to write Insert...Select statements?

I have Thursday and Friday off this week, and Friday next week, otherwise I'm working all normal days.

My neighbors are both school teachers, and they have quite a bit of...

I tend to agree that the devil is in the details of the service contract. If they didn't expressly say they were going to be doing backups, it would...

Adi Cohn-120898 (12/20/2009)

---

I’m not so sure that users will use the TDE on Express edition. Most of the time Express edition is not managed by a DBA. In...