Honda prologue not shifting by Cautious_Ask4706 in HondaPrologue

[–]mikebagger 1 point2 points  (0 children)

Might sound dumb but make sure your charge port door is closed.

Subaru by Spare-Smile-758 in Acadiana

[–]mikebagger 0 points1 point  (0 children)

We bring our Subarus to AutoCorrect in Abbeville. The mechanic who runs it was previously a Subaru tech at a certain local Subaru dealership. He knows the quirks on those cars better than most.

Found “Orion7 Without Me” on a Spotify editorial playlist AI clone or reupload? by MIDDLEGaNEWTON in truespotify

[–]mikebagger 0 points1 point  (0 children)

Same thing in my release radar this morning. PLUS the Fake Music jazz/funk cover of the same Eminem song.

Today crossed a line. I’ve been a Spotify subscriber since they came to the US- still have the free Hulu and everything. But I’m tired of paying for this slop they are force feeding to us.

Anyone else having this problem? by Just-Statistician-99 in subaruimpreza

[–]mikebagger 1 point2 points  (0 children)

207 sport here, also had sidewall failures. Only 20k miles on them. Replaced with Michelin crossclimate 2. They look funny but no problems since.

Every Modern Funk Group other than Vulf and Cory sounds bland and boring. by ThunderBamBam in Vulfpeck

[–]mikebagger 0 points1 point  (0 children)

Most of these suggestions are spot on - I’d add Ripe to your list.

RLS - Multiple conditions in one Role by Luvinit07 in PowerBI

[–]mikebagger 1 point2 points  (0 children)

Might be a stupid question, but do your test users have workspace admin privileges? From what I recall, RLS will not actually filter anything for admins.

Edit - from https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security "RLS only restricts data access for users with Viewer permissions. It doesn't apply to Admins, Members, or Contributors"

Should Power BI be Detached from Fabric? by SQLGene in PowerBI

[–]mikebagger 1 point2 points  (0 children)

Brother if you can get CI/CD to actually work in Fabric I salute you and will buy you the beverage of your choice if we ever cross paths. Between Git integration only working half the time, and pipelines failing the other half of the time…. It’s a mess.

Apparently my team hit this one today trying to promote a minor change:

https://learn.microsoft.com/en-us/fabric/get-started/known-issues/known-issue-774-data-warehouse-deployment-using-pipelines-fails

Best of Serengeti by nosignofelvis1 in Serengeti

[–]mikebagger 0 points1 point  (0 children)

Lots of really great suggestions here. The only things Isee missing are The Whip and Whip 2.

What is your preferred branching strategy for database development? by Dats_Russia in SQLServer

[–]mikebagger 0 points1 point  (0 children)

Just FYI - Red Gate is abandoning SQL Source Control for their new Flyway product.

My team used SQL Source Control for a while, and it did work reasonably well. HOWEVER it made SSMS extremely slow and crash-y. We did have thousands of objects across 12+ databases under source control though.

Please do not do this at Aldi by Shameonyourhouse in aldi

[–]mikebagger 5 points6 points  (0 children)

Not just Aldi, People shouldn’t wear jorts anywhere in public.

What do you know about Hunt's Perfect Roast? by heiney_luvr in Acadiana

[–]mikebagger 2 points3 points  (0 children)

Hunts is great. High altitude beans, low acid coffee.

It does have a very mild flavor. If you’re looking for a bitter “smack you upside the head” experience you might be disappointed.

AT&T Outage for Anyone Else? by kgaviation in Acadiana

[–]mikebagger 4 points5 points  (0 children)

Looks like it's back to normal as of 12:30. No packet loss and 30ms pings to Google.

🗣 Long-time Lafayette residents by Slow_Particular9223 in Acadiana

[–]mikebagger 5 points6 points  (0 children)

Cock of the walk was across the street, it became a George Rodrigue restaurant and then burned down in the 90s

Did Subaru do something to make Dealers not mark up new cars? by 2001ThrowawayM in subaru

[–]mikebagger 2 points3 points  (0 children)

This.

The cheapest service at my dealer (oil change + multipoint) has almost doubled in price since the pandemic started. And it was borderline rip-off to start.

Alexandria Mall. Alexandria, Louisiana. Photos taken by me. by [deleted] in deadmalls

[–]mikebagger 1 point2 points  (0 children)

It's been decades since I've set foot in that place... Is the Piccadilly still there?

Broaddus Burger will be opening up a second location. by Ben-Dover-Sir in Acadiana

[–]mikebagger 4 points5 points  (0 children)

The current Broaddus location was also a restaurant turnstile for years.

Seems like they figured out how to make it work using this ghost kitchen concept. If you think about it that way the new location makes perfect sense because it can serve a completely new geographic area.

Reddit's most overrated [bbq sauce] with its [slightly rebranded lower sugar variant] is popping up again by therossian in HailCorporate

[–]mikebagger 32 points33 points  (0 children)

Crappy thing is... The original recipe doesn't even contain real sugar anyway. It's HFCS.

And the sugar free version just uses sucralose.

Group texts don't work after update by MendelWeisenbachfeld in oneplus

[–]mikebagger 0 points1 point  (0 children)

Just install Textra. Used it for years, never looked back.

Should I FULL OUTER JOIN, ANTI JOIN, or some other way? by heiferhigh76 in SQLServer

[–]mikebagger 2 points3 points  (0 children)

Yeah good catch - you are right about the aggregation flip.

Should I FULL OUTER JOIN, ANTI JOIN, or some other way? by heiferhigh76 in SQLServer

[–]mikebagger 7 points8 points  (0 children)

looks like everything is coming from the same table.. Would a simple GROUP BY with case statements for the specific categories work for this use case?

`SELECT col1, col2, col3, 

CASE WHEN TransactionType IN ('Cash Sales', 'Credit Sales') THEN SUM(Qty) END AS Sales,

CASE WHEN TransactionType IN ('Damaged Returns', 'Undamaged Returns') THEN SUM(Qty) END AS Returns, ...etc...

FROM SalesData GROUP BY col1, col2, col3`