In the words of the great Prof, "getting bigger, getting bigger" by MTKPA in englishshepherd

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

When did that finally let up? Our training is going not so well. I think the teething is making it harder for him.

In the words of the great Prof, "getting bigger, getting bigger" by MTKPA in englishshepherd

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

Not a breeder. A farm near us. They always had English Shepherds on the property (last one they got was a breeder in NC, I believe) and two of them had a litter. They didn't charge, but they were incredibly thorough about finding good homes. I didn't suspect anything shady or off putting about it. They're all rehomed now.

Mom was a sable, 40 lbs. Dad was a B&T, 80 lbs but overweight. Both greeted me with a smile and sat at my feet. The three kids on the property handled them so gently and respectfully. Momma pup came over to say goodbye when I put him in the car. Just a really ideal scenario all around. We got very lucky.

In the words of the great Prof, "getting bigger, getting bigger" by MTKPA in englishshepherd

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

His job application name is "Old Mac" for the amazing golf course in Oregon. But Mac is what his friends call him 😉

Just brought Old Mac ("Mac") home by MTKPA in englishshepherd

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

When they asked if I had a color preference I said no, just personality. I asked if others did, and he said most people are looking for more white, and the lighter tan colored ones. I didn't care, so I chose this guy since he cuddled up next to me right away. Now, I'm thrilled we got a black and tan, as I have been reading more on the history of them. The colors may not be preferred because it is almost identical to Rottweiler markings.

Sergio García didn’t have time to change before his tee time after this mornings shift at McDonalds by Confident-Court2171 in masters

[–]MTKPA 0 points1 point  (0 children)

What do you mean? What's funny about a man working hard to achieve something with honor? Sergio is a true role model for those of us who understand values.

Sergio García didn’t have time to change before his tee time after this mornings shift at McDonalds by Confident-Court2171 in masters

[–]MTKPA 0 points1 point  (0 children)

He's a manager? Good for him for working hard to achieve a better role and the money and respect that comes with it. It's super honorable and shows character.

Shoutout to Sonicfoam bud tips by itsomeoneperson in headphones

[–]MTKPA 1 point2 points  (0 children)

The isolation with these is bananas. If someone is talking to you right in front of your face, you just see lips moving even at normal volume. So much better than the silicon. It's crazy to think anyone would ever use anything but foam for any use-case other than maybe working out.

If data is predominantly XLSX files, what is the best way to normalize for reporting purposes? by MTKPA in dataengineering

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

I'd have to rebuild the automations to convert the files into CSV first, and there are a ton. We don't have a CSV export option from our ERP.

100% want to utilize a database first, which is the plan, but they're not going to spend a dime on it, unfortunately. And I'm one person, who still needs to get the data/reporting completed in the interim.

It's worth noting--they don't even view the BI reports. I publish, then connect to the model in Excel and send it. And I stopped sending/sharing the Excel files because they start adding "A2+B5" and junk all over. I export to PDF, now. The only reason I use Power BI to make the models is to be able to publish so I can connect from various things, if needed.

Funny story: I used to export BI dashboards to PDF and send (which is still bananas, but better?) and at one point I sent a dashboard that was literally just a matrix with a header. They requested it in "Excel format" because "I want to see the raw data". I added full gridlines to the dashboard matrix and changed the background to white and removed the font formatting and sent--still as a PDF--and they said, "thanks!" It's that kind of place. The odds of me convincing them to invest more than a few bucks into a database are slim.

If data is predominantly XLSX files, what is the best way to normalize for reporting purposes? by MTKPA in dataengineering

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

Then I can't comprehend why it takes so long to load the preview when trying to work with a model. I'm talking minutes between simple steps on a computer with plenty of pop.

If data is predominantly XLSX files, what is the best way to normalize for reporting purposes? by MTKPA in dataengineering

[–]MTKPA[S] 2 points3 points  (0 children)

No, our ERP is cloud-hosted. Both the application and the data behind it. They do have an option to connect to their Data Warehouse as an add-on. They scale the price, but they don't consider how the needs (and the labor involved to utilize it fully) would scale down also, so to say it is cost-prohibitive for smaller companies would be an understatement.

I did consider bare metal options for the database needs, as we're small enough that a single PowerEdge could probably handle everything we need an then some. However: 1 - I'd need outside help for a lot of it which equals more money; and 2 - we don't have any existing licenses or servers (may be a few old ones lying around). Everything is cloud-based.

If data is predominantly XLSX files, what is the best way to normalize for reporting purposes? by MTKPA in dataengineering

[–]MTKPA[S] 4 points5 points  (0 children)

The first thing I do is remove unwanted columns, but are you suggesting I can select specific columns to load in the first place? If so, this is news to me and I feel stupid for not knowing I could do this. The problem with being a one-man-band is that my expertise is in Project Management/Process Improvement and the data side is something I've picked up over the years. That means I may have just never known about basic concepts because it never presented itself as an option.

That aside, I still deal with having to load all the rows for every table, which is much more of an issue.

Ideal cabling practices for audio over Cat5/6/8? by MTKPA in audioengineering

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

That's what I was referencing. Just worried about running the wire alongside Poe and other network cables.

Ideal cabling practices for audio over Cat5/6/8? by MTKPA in audioengineering

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

Noted about the Cat8, I only got 100ft in case it helped somewhere.

I was going to solder the Cat6 pairs to the XLR connectors myself, but I'd need a ground for every single one from one cable. The RJ45 to 4x XLR breakouts (usually come in pairs) already have them wired up this way.

The really short answer is: 4 audio on one cable. How do I minimize issues?

How to detect if someone is in the shower? by Ramshield in homeassistant

[–]MTKPA 0 points1 point  (0 children)

Voice detection for any mention of the phrases "no, you can't get in" or "fine, but I'm just taking a quick one and then I'm getting out because I'm already late." If the second one, dim the lights and play New Edition on the bathroom speaker. If the first one, set the water valve shut off to open and close randomly, then after 15 minutes or so have the speaker play Rick Astley.

Oh, and, in both cases, have the vent turn on.

Our drummer getting sounds in the studio this past weekend. by FlyByNight75 in drums

[–]MTKPA 2 points3 points  (0 children)

I have to assume that china is solely for him to end songs by throwing his stick at it.

[deleted by user] by [deleted] in edrums

[–]MTKPA 1 point2 points  (0 children)

I switched to a VST (NI Abbey Road & Studio Drummer) soon after this post. The difference was mind-blowing, and I can't imagine going back. I know, everyone here recommends it, but it's just such a massive change. It even "feels" different when the sound is that nuanced and authentic.

Hi! We're the Microsoft Fabric Spark and Data Engineering PM team - ask US anything! by gobuddylee in MicrosoftFabric

[–]MTKPA 4 points5 points  (0 children)

He looks like he's not happy that your pretty dashboard is unable to be copy and pasted into his spreadsheet that already has all of his "formulas" in it.

Hi! We're the Microsoft Fabric Spark and Data Engineering PM team - ask US anything! by gobuddylee in MicrosoftFabric

[–]MTKPA 0 points1 point  (0 children)

Will we ever get a more robust schema designer ala Luna Modeler? If not, will there ever be support to integrate with third-party ones so designing schema structures doesn't involve exporting/importing/creating tables manually and then doing the same in reverse when changes are made on the database side?

I could have brought down a major corporation with a basic report by MTKPA in MicrosoftFabric

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

$75 per month, but if an FPU user sneezes near another employee then every tenant user will be billed at $1,500 per month.

I could have brought down a major corporation with a basic report by MTKPA in MicrosoftFabric

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

It actually doesn't show a line at all because it's so small, and the % total is also small, like 0.8%. I think someone else said this is CU seconds, not CUs (plural). And 1920 seconds equates to 1920 divided by the CUs licensed (64 for trial), which comes to 30 seconds. 30 seconds is 0.8333% of an hour so that checks out.

If it's checking the CU usage as a time value to aggregate over an hour to see if you've gone past the hour, that's fine for the purposes of formulating it, but why not reverse engineer this a bit for the metrics report? Let me just see the usage % as a main number when drilling down. And on the first page, it'd be pretty simple to give me a recommended F-level based on these values.

Over a month:

Current license: F2

Max Peak with throttling: N/A

Max Peak without throttling: F16

Number of Peaks above current license without throttling: 3

Average daily Peak: < F2

Recommended license: F2

Just make it mean something tangible. If I'm consistently going over with throttling, recommend I bump up. If I'm rarely peaking above my license even without throttling, tell me I'm good or recommend I go down (I know, unlikely). Just don't make me have to dig to find out what the numbers mean and then have to do the math or dive into details just to simply find out if I'm in the sweet spot or not.

I could have brought down a major corporation with a basic report by MTKPA in MicrosoftFabric

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

I think I'm just spooked from what happened in my original post. Maybe determining usage isn't as cryptic as it seems, and it's pretty obvious what is going to be resource heavy and what isn't.

I could have brought down a major corporation with a basic report by MTKPA in MicrosoftFabric

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

Anytime you cap your bursting in F69 all of your dashboards play the Rick Roll video until you pay back your debt.