This is a cross post. Please post any comments/answers here.

Raul, please post once so people don't waste time answering in 2 places.

Thanks,

I agree with Grant.

How do you plan to restrict access to the personal information if you have a link from the non-personal information?

If keeping the data in the same DB I would recommend creating another filegroup and file for that data. If possible place it on another physical disk as well....

Sounds like you could be okay.

The service users should be fine as the install grants them appropriate rights.

You might want to check out this thread, which I started a couple...

Steve Jones - Editor (4/24/2008)

---

Is LINQ-> SQL only named pipes? That would be interesting.

Not sure it's the dark side, and I think we need more independent information. If there's one...

Andy Warren (4/24/2008)

---

Resist the dark side Grant!

We all should want data access to be easy, or at least straight forward. Somehow we gotta get knowledgeabout people that aren't zealots from...

Timothy,

Thanks for the instructions, I have not used Linq To SQL enough to have gotten to that point yet. I did know that you could use SP's for methods...

Timothy (4/24/2008)LINQ does not equal LINQ to SQL. ... I think LINQ is a great technology so I hope others don't throw out the baby with the bath water in...

Timothy,

Your example is a good use of Linq, yet does not use Linq To SQL which is the Linq implementation most folks on this thread take issue. I think...

Looks good.

Michael,

Thanks for the nice words.

The issue you are having is that you have not created the 2 columns in the Input and Output screen in the Script Transformation Editor. ...

Ben,

Here is a basic SSRS report for the data in the load_errors table. Admittedly basic but it works.

You do not have to have the reports deployed to a report server when using the ReportViewer control. You can create a local report which has an rdlc extension.

Anders Pedersen (4/22/2008)

---

Horrible idea in my opinion.

Who cares if a developer saves 10%-20% (the numbers I have heard bandied aroud) by using LINQ during development time? How much time...

I have not looked at the Entity Framework, but have looked into and played with Linq to SQL. Linq to SQL does do some good things and, I think,...