I agree with Steve here.

On top of that, if you are wanting someone to help with a project, you should provide some details on the project.  Is it strictly a...

I just read the article and I think I am a mix of gatekeeper and flexible.   Some things I see as hard-fast rules that should not be debated with new...

To recovery the master key, if the password is known, you run (the button for adding SQL is missing for me right now, sorry for the poor formatting):

OPEN MASTER KEY...

My first thought is it the same version of DTExec on your machine and the server?

One thing I am reading about that particular error (0x800004005) makes it sound like error...

Since you are on 64-bit and Enterprise Edition, it is likely that the system is running out of  memory to process the data.

I would check things out on the server...

How large is the file?  From what I remember (and a quick bit of googling), SSRS doesn't limit file types by default and I'm not even sure it supports limiting...

Few things i would check before looking at upgrading from 2016 to 2017. My expectation is that upgrade won't help, but it might if it is a 32-bit vs 64-bit...

It seems that it is the two operators following each other "/-" that causes unexpected behavior (not the minus at the beginning).

SELECT -100.0/-100.0*10.0 => 0.1

SELECT (-1*100.0)/-100.0*10.0 =>0.1

SELECT -100.0/(-1*100.0)*10.0 =>...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

My opinion, that should work.  I see no obvious reason why it wouldn't work.

The only case where I can see it being problematic is would be if you set database...

Is sharepoint referencing the SQL Instance directly, or is it referencing the web interface?  If it is referencing the web  interface, then you don't have much to worry about as...

I personally have not seen that error before, but my first thought here is going to be either permissions or a typo.

First step that I would do is if you...

My first thoughts on this are that renaming a SQL instance is tricky and can be problematic.  I would recommend picking a name that works for the new server if...

I think the only way to limit this is to put restrictions on the linked server itself.

What I mean is to set the authentication on the linked server to be...

I agree with all of the comments.  To add to this though, if you want to search inside files and not use powershell, astrogrep is my tool of choice.

My process...

I think in this case if I understand things right, windowing functions are going to be your friend.

something like:

SELECT [site],
ISNULL([LCRate],0) as LCRate,
SUM([Eligible]) OVER (PARTITION BY [site]) AS...