I haven't seen the VS for DB Developers yet, however, I've been using the "Database Projects" of Visual Studio for years to integrate scripts into Source Safe! They've been...

And hence forth, you...

keassnow (3/20/2006)

---

Say your malicious person deletes your symmetric key? You can restore a master key, but I've seen nothing that tells me how to restore a symmetric key.

You can recreate...

I think I'm in the boat of not agreeing with this. Although I do like bleeding edge stuff being a developer AND a DBA, this just doesn't jive. ...

No, actually he's correct. There are only 2 columns on each table. I'm pretty sure I've already tried your suggestions but they didn't work 100% of the time....

I've also have a background in healthcare software. You can usually accomplish everything very efficiently with some base line fields in the Patients table (FirstName, LastName, NationalID (SSN), etc)...

Steve Jones - Editor (9/27/2007)

---

The second option gets more confusing for data manipulation. I like it better, but you have to understand the 21 values in the registration form will...

I agree with Jeff. Since this "app" needs the Xml, IT should generate from the table that's being inserted into. All you really need is a "Status" column...

Well, actually, I don't really agree. Usually, in the case where you have Teams and Players (or maybe even Companies and Contacts) every designer tends to do what you...

Umm, don't let these guys scare you away from an EAV model. I use them all the time and I've never had a problem. If you just sit...

Your best option is to try to get partitioning going. I always hear "you should archive". Well, that's pretty much what partition does except you can always search...

Your database is fine, it's your controls that are the problem. You basically need one Column to display the Categories assigned to the File. Ideally you'd have a...

Hands down method 1! If you've ever done any large database designs, you'll thank yourself for doing it as the millions of Procs and Views you write won't cause...

Your going about this all the wrong way.

You only need 2 tables and 2 Cross-Reference tables (what you call junctions) in your design.

1.) Parts

Let's start simple

...

You can handle this using 2 design techniques.

The first phase is to use something similar to the ASPNET Membership Provider database. Although the base implmentation probably won't suit your...