Forum Replies Created

Viewing 15 posts - 781 through 795 (of 2,917 total)

  • Reply To: List file shares from TAR file

    I think it depends on your source.  I am assuming this is still the TAR source, in which case you would just need to treat it like a bunch of...

    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: List file shares from TAR file

    What command are you using for tar?  If you are using the native tar built into windows 10, then you would run:

    tar -tf <archive name>

    which will give you the contents...

    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: Activity Monitor always paused for "sa" login

    Have you tried unpausing it?

    Personally, I am not a big fan of activity monitor.  It shows information in one nice dashboard, but even some Microsoft employees recommends against - https://redmondmag.com/articles/2021/08/25/activity-monitor-sql-server-performance.aspx.

    I...

    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: Getting Beyond Passwords

    I had some "fun" last night trying to get into my playstation account with 2FA turned on.  Enter username and password, next it tells me it sent a text to...

    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: High Log Reads on Readable Secondary Databases

    Maybe I'm a bit out to lunch here, but those read stalls look pretty small.  1000 ms is 1 second, so your read stalls on the primary and secondary average...

    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 Agent step won't write to SQL log directory

    One other thought - is the folder a network share?  If so, you will need to use the FQDN path to the location (ie //server.domain.com/share/path) rather than the letter (ie...

    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: ReportingService2010 soap call to set report credentials

    NOTE - the below is based on my understanding of your code and doing a quick translation into C# as I know C# a bit better than the language you...

    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: When to Use a Database

    My thoughts - a database should be used when you need to have a centralized location for shared data for medium to long term storage for data.  With exceptions.  I...

    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: Report Server Project Wizard vs. Report Server Project

    At times it is really nice because you have the freedom to do the full development from end to end, but at other times it is painful because you start...

    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: best way to extract name and number

    Since you are able to get the full name which is half of your battle.  I see multiple approaches to this, none of which are "pretty".

    The most supportable approach I...

    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: Report Server Project Wizard vs. Report Server Project

    I agree... Our walls are low, but they still exist.  And in some cases they should exist.  For example, you wouldn't want me mucking around with AD or spinning up...

    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: Data Masking

    Quick check online, masks are applied at the table level, not the view level. So to answer question 1 no you cannot use the built-in masking function on a view...

    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: Query Performance Tuning

    Looking at that, the temp table is a heap, so unless tempdb is on slow disk OR tempdb is nearly full and your INSERT is causing a lot of auto-grow,...

    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: how to solve error Conversion failed when converting the nvarchar value '24VAC/D

    My opinion - this is a data problem, not something to be solved in your ConStr variable.  I would fix this in the TCondition table as it contains the ">1000"...

    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: Table Date field format

    @Erland - my mistake.  I had meant "SQL Server Management Studio presents the date in the format that is configured on the server", not SQL Server.  SQL Server stores the...

    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 - 781 through 795 (of 2,917 total)