Do humans need to perform these tasks on particular edits or does the system? The approach will vary widely depending on the two.

If the system needs to perform a...

lianvh (8/2/2012)

---

Good Day ,

our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...

Well, will try to help, but you...

Cadavre (8/1/2012)

---

SELECT

CASE WHEN a.id IS NULL THEN b.id ELSE a.id END AS id,

CASE WHEN a.value IS NULL THEN b.value ELSE a.value END AS value

FROM (SELECT [id], [value]

...

Lynn Pettis (8/1/2012)

---

Evil Kraig F (8/1/2012)

---

GilaMonster (7/31/2012)

---

Vacation! Mine! (no, you're not invited :-)...

LOL! Bah, shame you...

Ugh, sick for a week blows. I miss anything of import since last Tuesday?

Heya Chad.

Sorry, came down very sick for a week, haven't reviewed a thing for a while.

The other primary reason I like SB vs. other messaging apps is the fact that...

Ow G2, that SUCKS. Been there done that though. However, my version of that report got every consultant let go because they couldn't 'let go' normal employees while...

Since noone else came...

sequelite (7/24/2012)

---

Thank you. When I asked, I was thinking of the Maintenance Plan route, where you select all databases you want backed up. I guess in that scenario, they will...

Would it be possible to provide the schema, some sample data, and the expected results from that data? The first question was simple enough to extrapolate for me but...

Chad, you might want to include a piece on how limiting the # of activations can allow for lowering the impact of multiple high-impact bulk work simultaneously requested, so it...

Jeff Moden (7/24/2012)

---

Koen Verbeeck (7/24/2012)

---

Jeff Moden (7/23/2012)

---

Thanks for the response, Jason. Do you have any good examples of where SSIS might outshine T-SQL? Please don't say "anything that...

Gianluca Sartori (7/19/2012)

---

That's a good idea! Thanks.

I'm working in an industry where data theft is very common and intellectual property is the most important assset. I understands the reasons behind...