One way I can think of to make it a little more simple to read would be to concat all of the columns together then search for the string BUT...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense...

First step - I'd read the documentation and make sure you are following the proper configuration as documented by Veeam - https://helpcenter.veeam.com/docs/vbr/userguide/agents_dag_hiw.html?ver=13

Failing that, I'd reach out to Veeam support -...

I've found that if you are using the 4 part naming in a linked server, performance can be unpredictable and a "quick fix" is to change the query to use...

I agree with David Poole except on his last point about the system being deprecated - I've heard that too many times and then seen the system still...

Just to add to Steve Jones answer - If you are on a modern OS, you could use powershell/command prompt as well to call the sftp command if you needed...

I agree with David Pool except on his last point about the system being deprecated - I've heard that too many times and then seen the system still up and...

Not sure I fully understand what you are asking, but what I suspect is that you are looking at the linked server from the GUI. If so, try scripting it...

If I had to guess, I'd say you are running into a limitation of Azure Query Editor. Likely either the 5 minute timeout or the "multiple statements only give results...

I can't see the article, but with the premise I think it, like all things with a DBA, depends. If I am building a life support system and it is...

I personally prefer the dynamic SQL IF you are working with changing table structure as then if you add or remove a column you don't need to add or remove...

another approach, although will become messy if there are a lot of columns, would be to have 1 "master" stored procedure that takes the parameter (such as fpartno in your...

Well, MSSQL has several mechanics that can do something similar.

If you want to run a huge SELECT but don't care about the results open the Query Options  go to...

• This reply was modified 3 months, 1 weeks ago by Mr. Brian Gale.

I am a fan of having things like "current" or "latest" with the expectation that I will rename it when a newer version comes out. Where possible, I like having...

I like CDATA as a concept, but it is an expensive tool for sure AND it still requires other tools to do the heavy lifting. If you want the ODBC...