*scratches his head* Out of curiousity, you realize these are other people you're talking to, not your...

You need a way to identify the new records on the OLTP system so you can limit your 'pull' from that system.

Typical solutions:

1) A LateUpdateDatetime or a Timestamp which you...

I'm with the others on this, Steve. Shadow IT is not the problem. The centralization of *all* IT is.

IT is still too heavily lumped together. Hang...

ryetimothy (8/28/2012)

---

In theory, I should be able to allow access by adding new users (I'm an administrator for all of the servers we use for the database) in the servers...

I'm not entirely sure this is possible in SSRS. If it is, you'll have a few hoops to jump through to be able to keep the collapsability of the...

Fell off the planet for a few days, RL stuff. The admin issue will be hard to troubleshoot over the net. As to the file disappearing, does the...

I'm of the personal opinion that I work for money, my money. That's not what employers want to hear, however. So, as mentioned, there's a balance point. ...

Fal (8/24/2012)

---

I need to deal with a critical issue, but unfortunately fixing it keeps getting bumped. I was wondering what metaphors Threadizens might have to describe just how low...

I have more practice, no worries. 🙂

1)...

Two things are going on here, and they're not entirely independent but a few questions.

I assume you originally built this package from your local system, but the server is not...

Sample was nearly perfect, but didn't run out of the gates, was missing a parenthesis or two. I also modified it to be using #Temps instead of hard tables...

SQL Kiwi (8/22/2012)

---

The NOT EXISTS...INTERSECT thing works in SQL Server...

That. Is. AWESOME.

I stand humbly...

It's unfortunately not hard to need it on an overly active...

Nope, compare them in a non-null version (using ISNULL), or build the incredibly...