Forum Replies Created

Viewing 15 posts - 31 through 45 (of 2,917 total)

  • Reply To: High Availability setup - has anyone seen this method?

    Another consideration is licensing.

    If I am not mistaken, SQL Server doesn't cover a passive spare unless you have software assurance and even then, it covers 1 passive spare for failover...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Intermittent Service Freezes and "State 23" Authentication Failure

    What could be interesting to see is the entries in the log prior to the error 18456 and 18056 entries.

    And I know you said that no GPO's were messing with...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: lookup error

    Since this works in the web view but not in the export, the problem is likely that the lookup is returning more than 1 result. SOMETIMES the web interface will...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: advice on diving into devops for managing BI projects

    Phil Parkin is right about what I was thinking of - I was thinking more of the TERM DevOps and initially thought of CI/CD and was thinking this was going...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Loading a Database for USD$5

    My experience with AI is that you still need to "do your homework". I've had AI tell me to run commands that have syntax errors or that are completely invalid....

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: advice on diving into devops for managing BI projects

    My opinion - I think it really depends on your team and how you use your tools but it sounds like you are talking about Jira specifically (I could be...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Simplifying WHERE Condition with LIKE test on multiple columns

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Refactoring SQL Code

    hmbacon wrote:

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Veeam Backup DAG issue. Access to availability group is not permitted.

    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 -...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Help! MEMORY_ALLOCATION_EXT wait stalls

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Refactoring SQL Code

    David.Poole wrote:

    Mr. Brian Gale wrote:

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: any reason to avoid asking ssis to extract files from ftp

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Refactoring SQL Code

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: SQl Server 2014 linked server remote server

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Reply To: Cannot execute SQL cursor in Azure Query Editor (Preview)

    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...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 15 posts - 31 through 45 (of 2,917 total)