linq usage doesn't need to be less secure !

Using linq as an excuse for open doors is the summum of laziness

some refs on using sprocs with linq:

http://www.mssqltips.com/tip.asp?tip=1542

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

http://blogs.msdn.com/b/zainnab/archive/2007/10/25/linq-and-stored-procedures.aspx

http://msdn.microsoft.com/en-us/magazine/cc500645.aspx

GilaMonster (5/27/2011)

---

Elliott Whitlow (5/26/2011)

---

Jan Van der Eecken (5/26/2011)

---

GilaMonster (5/26/2011)

---

One very uncomfortable PM sent...

From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf...

You clould find some info on the web, but I propose to just capture the full xml to investigate the availability of data and then have a look at bol...

- consider an "on delete" trigger to perform your insert into tableB

- On insert in tableA, you could also use an "insert" trigger to fetch the available missing data from...

I haven't performed such an action (edition upgrade) from 2005 to 2008 myself but

wouldn't such an action need a setup from the commandline using /ACTION=editionupgrade ?

Just some feedback ...

I use 2 clocks ( mainly for myself ! ):

1) single beep notification: to drink a bit of water. Prevention measure no1.

...

Must have confused me.

Did the upgrade succeed or didn't it ?

I've seen the same behaviour.

You'll have to alter the dblevel yourself if desired (even for system db)

That's one of the reasons why I don't upgrade an instance, but prefer...

george sibbald (5/20/2011)

---

you would create competing resources for memory so may have a slight degradation there.

On the other hand you would have to have sperate disk resources for the new...

John Mitchell-245523 (5/20/2011)

---

You're quite right - I said active-passive but I meant to say active-active. I'll...

colin.Leversuch-Roberts (5/20/2011)

---

log shipping didn't work for reporting because sadly all our reports need to issue writes ( don't ask ) to the data during generation - so I can only...

I...

concerning the number of active connections ... that is not a problem because you'll have to stop and restart the sqlinstance anyway to actually have it using your tempdb files...

Mind me asking why would you want to your instance to be in single user mode ?

Couldn't a user db in restricted user mode serve you well enough ?

This is what I would propose:

As last step of your JobA just run a ISQL script connecting to your ServerB and raising an alert at that sql instance and have...