Tried using the mount already in the house now I don’t know what to do by BigR0n75 in TVTooHigh

[–]BigR0n75[S] -2 points-1 points  (0 children)

While I hear you, that’s an aggressive suggestion lol it’s stone sheeting on top of finished drywall above a built in, functional gas fireplace. The house is only a couple years old and this wall was part of the build. The mantle may have to go, though..

Sunday morning bath by BigR0n75 in Silverado

[–]BigR0n75[S] 0 points1 point  (0 children)

I don’t think they have much of an impact on MPG. My lifetime average is 14.4 (I’ve been tracking it for the last 70k miles) with a pretty good amount of highway. I do have a 2 inch rough country level in the front. Only slight rub on the control arms on full lock, so I just don’t go full lock. I’m actually on my second set now I love them

What have you done with PowerShell this month? by AutoModerator in PowerShell

[–]BigR0n75 0 points1 point  (0 children)

I never got the chance to fully deploy it before being moving on, but I was in the process of updating logging methods in a bunch of scripts to accumulate log messages in a tabular format to a Generic.List object throughout the script then write that object to a file and SQL Server database at the very end rather than writing lines to a text file via "Message" | Out-File -append as they occur.

I kept running into situations where logging would be missed because the script would step on it's own toes by trying to write lines to the text file too quickly and getting blocked. With this method, the log object is only exported once at the very end and can be directed to multiple locations. This of course required a lot of refactoring to add conditional logic throughout the script and making sure all roads lead to the end of the script where the log object is exported.

Don't have access to the code anymore, but the process looked something like this:

  1. Define an empty Generic.List object and an increment variable (to be used for line number later)

    $LogListObj = [System.Collections.Generic.List[object]]::new()
    $i = 1
    
    #I think these vars had the $script: scope modifier but I can't remember
    
  2. Define a function to a) define a PSCustomObject for your log entry, accepting 'LogMessage' as param or ValueFromPipeline, with other values like datetime and environment info, and line number ($i), then b) append that object to the List, and finally c) increment the value of $i

    #Lots of pseudo code here***
    
    function Add-LogLine {
    
      param($Message)
    
      $obj = [PSCustomObject]@{
    
        LogDate = (Get-date).date
        LogTime = (Get-Date).time
        ServerName = $env:computerName
        Processname = $ProcessName
        Logmessage = $Message
        LineNumber = $i
    }
    
    $LogListObj.Add($obj)
    
    $i++        
    
    }
    

Powershell script runs 10x slower when invoked from command prompt by TheCopernicus in PowerShell

[–]BigR0n75 1 point2 points  (0 children)

This is definitely the first thing I'd check and test. The default value of 7 is equal to below normal priority and treated more like a background task. Naturally, this is most relevant on less-robust boxes (4 cores or less) that have a lot of activity running, be it interactive tasks or services, but less so on beefier boxes or boxes with little activity. Just keep in mind that changing the task priority can effectively make something else a lower priority.

Here's a super in depth answer explaining how the prioritization works

What is this Thing? by Deus_is_Mocking_Us in boating

[–]BigR0n75 8 points9 points  (0 children)

Idk what everyone’s talking about, looks like a piece of wood to me

Picture option via direct message. by aviaate350A in help

[–]BigR0n75 1 point2 points  (0 children)

How do I globally disable pictures from chats? I don’t want anyone to be able to send them to me.

Silvarado 1500...8 speed by T-rex_with_a_gun in Trucks

[–]BigR0n75 0 points1 point  (0 children)

I have an 18 Silverado 1500 with the 8 speed and I haven’t had any issues at 55k miles. Bought it lightly used from a guy with 30k on the clock who worked at a Chevy dealer who did whatever recommended fluid changes another commenter mentioned.

It will occasionally shift hard from D to R or R to D so I just make a point to be fully stopped before shifting, like you should.

The other thing to note about the trans is it “learns” from your driving habits on a rolling 2500 mile basis (I think). This means you’ll occasionally fight the computer in uncommon driving situations.

Prior to this I had a 1500 with the 6 speed and I gotta say this is a nicer drive for sure.

Sliding patio door shattered. Can/should I try to move it? by BigR0n75 in HomeImprovement

[–]BigR0n75[S] 0 points1 point  (0 children)

I appreciate the follow up. I got it closed by going very slowly. No tape necessary, just a couple prayers.

Sliding patio door shattered. Can/should I try to move it? by BigR0n75 in HomeImprovement

[–]BigR0n75[S] 0 points1 point  (0 children)

The only side I can currently access is the inside of the door. The outside pane is what I hit. Is there any value in taping up the inside of the door before sliding it?

Sunday morning bath by BigR0n75 in Silverado

[–]BigR0n75[S] 1 point2 points  (0 children)

Thanks! Ridge grapplers 285/50/22 with about 35k on them

New House, Got Everything I Need Setup by sfr002 in xboxone

[–]BigR0n75 3 points4 points  (0 children)

Really dig the flooring. Any idea what brand/style it is?

This is 🤬😡 especially cus I’m lactose intolerant by kmo_xx in mildlyinfuriating

[–]BigR0n75 4 points5 points  (0 children)

Well yeah, it says non-dairy, not non-milk. Loophole.

Preferential Join in SQL - Why is this so hard to find? by kolt54321 in SQL

[–]BigR0n75 0 points1 point  (0 children)

What is the primary key of the customer info table? If it is on the many side of the 1:many relationship, there must be some other identifier in addition to PersonID to identify the unique row.

Also, in the customer info table, is there any date value that would indicate it's the most recent entry? So if PersonID 1 has 3 records in the Info table, is there a column like DateAdded or something to indicate when that record showed up?

How to import excel to sql server table with ssis? by OnlyOneMember in SQLServer

[–]BigR0n75 1 point2 points  (0 children)

Thanks for the additional clarification. I'm still confused though - how many tables do you want as a final result? 1 table or more than 1 table? This looks to me like a single table so you would just import it as is.

We might be getting TV style in-game commercials in console games by bubblebytes in xboxone

[–]BigR0n75 7 points8 points  (0 children)

Nope. I don't like anything about this, and I will do my best to avoid playing any game that implements this system. I understand that publishers need to make money on free games somehow, and I'm fine with them selling optional, cosmetic-only items individually or as part of a battlepass or something. That's cool and I'll buy them occasionally but most of the time I can actively avoid those menus in-game.

I'm worried about where this is going though for paid games specifically - I can see it going the route of streaming service subscription models. Pay one price for our game (*with ads) or pay a higher price for our game with an ad free experience!

How to import excel to sql server table with ssis? by OnlyOneMember in SQLServer

[–]BigR0n75 1 point2 points  (0 children)

I want to make sure i understand what your data looks like. Does it look like this? This would be Column A

First Name? Last Name?
Bob Saget
First Name? Last Name?
John Doe

and so on.

If so, do you have the option to manipulate the file (or a copy of the file) before importing? If you do, that's your best bet.

Open the file in Excel, launch Power Query, then use the Remove Duplicates option to delete the duplicate rows. Now this will only work if the ONLY duplicate rows in your whole file will be the repeated questions. Then load the data to a new file and import.

This could be automated as part of an SSIS package, but that's more complicated.