As annoying and loud as the office environment can be, I never thought I would actually miss that background noise. I see the drive to and from the office as...

You may have solved it by now, but I was wondering if the web server was trying to look locally for the job rather than remotely submit the job on...

That sociopathic descriptive got me. I've met a few, and could not get out of there fast enough in those situations.

Good one. But sometimes I wish there was a better row by row method available for those few times when there appears to be no other option.

Luther

should have gone with my gut instinct. But, I see some potential for the function in a couple of places, so will go look it up.

Thanks!

I did find this: https://docs.microsoft.com/en-us/learn/paths/implement-sql-data-warehouse/

Its one of the training modules, and it falls under the Data Engineer role. But I had to work backwards, first to find the course, then...

I got no kick with the questions and the editorials. In fact, the questions and editorials help me focus on things that might improve my queries, so keep it up....

I got it wrong, but 42, which is the answer to life, the universe, and everything was not an option for this question. At any rate I learned another valuable...

The car I miss most is the 62 Chevy Biscayne I drove back and forth to college. straight 6 3 speed, it could take all manner of abuse and keep...

I do have days when I wish Microsoft would offer SqlAgent as a standalone product. I've tried a number of job management systems, and I continually come back to SQLAgent...

technically, I would think that you would work a half day and then knock off, so if you normally start at 8 am your time, you would knock off at...

Are your VM's in different data centers by any chance? I have a slightly similar situation where the test ETL server is in one data center and the test database...

I have no experience at all with that command, so I can't help you there, but I think I would find it easier to pull them into Visual Studio, convert...

Is the previous 5 years worth of data available for you to retrieve the 2 new columns for your historical data?

If its not, then you can only modify your SSIS...

I've recently purchased a nice Thinkpad, and have set up Hyper-V to manage virtual environments. At the moment I have one VM running Linux and a second one running a...