Viewing 15 posts - 1 through 15 (of 2,883 total)
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...
December 15, 2025 at 7:00 pm
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 -...
December 14, 2025 at 5:55 am
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...
December 14, 2025 at 5:49 am
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...
December 14, 2025 at 5:21 am
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...
December 12, 2025 at 2:37 pm
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...
December 12, 2025 at 2:29 pm
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...
November 27, 2025 at 9:06 pm
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...
November 27, 2025 at 9:03 pm
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...
November 26, 2025 at 7:42 pm
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...
November 20, 2025 at 7:12 pm
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...
November 14, 2025 at 10:21 pm
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...
November 12, 2025 at 3:22 pm
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...
November 7, 2025 at 9:46 pm
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...
November 6, 2025 at 3:53 pm
Is the different domain in the same AD forest? If so, then you should be able to authenticate across and see the other servers and everything should just work. If...
November 5, 2025 at 10:26 pm
Viewing 15 posts - 1 through 15 (of 2,883 total)