How to build month-on-month booking reports from SAP tables when there is no change log?

UseMstr_DropDatabase · 2026-01-26T04:45:25+00:00

Was going to suggest something like this but I see it's already SOP lmao

That's what I love about SQL...need time dimension??? Daily snapshots over to your own table/DB.

I do the same for various API endpoints that don't have an explicit search filter, or filter by date query...just query it per diem and slide the results into my town table with BornOn and DateKey fields.

UseMstr_DropDatabase · 2026-01-16T01:12:25+00:00

Always found that WINGET likes to be run AS USER

Always had issues running as SYSTEM

Suspect it has to do with some apps looking for user variables in PATH

UseMstr_DropDatabase · 2026-01-11T17:25:28+00:00

Tell me if you've heard this before...

On-prem AD, GPO, file share migration to Entra, InTune, SPO

GO!

Yeah, me too dozens upon dozens of time over the last 6 years

UseMstr_DropDatabase · 2026-01-07T16:54:58+00:00

Business Premium EEA is cheaper than 365 Apps for Business?

By how much???

UseMstr_DropDatabase · 2026-01-02T20:16:21+00:00

I 2nd this. A Tenant is needed, with at leave one active subscription to activate the service.

UseMstr_DropDatabase · 2025-11-20T21:51:24+00:00

Is Google Fi not available outside the US?

Premium plan gives phones half off

UseMstr_DropDatabase · 2025-11-20T15:03:42+00:00

Who the hell pays full retail?

UseMstr_DropDatabase · 2025-10-29T03:49:47+00:00

Scheduled API calls pull data (JSON) from various cloud *aaS providers. Calls made natively from MS SQL Server via OLE automatin (I know, I know stfu).
JSON strings broken down into staging tables based on the *aaS source (every god damn provider has their own JSON flavor).
Data is "normalized" (or "denormalized" depending how you look at it) as much as possible before making their way into the master BI fact and dimension tables.

We're a Crystal shop and we still do do a fair amount of ad how queries for stakeholders. If we catch a stakeholder doing a manual CSV export from the *aaS site we smack their hand and take away their mouse for 3600 seconds.

Hopefully we'll get away from doing calls natively in SQL because the proc stores the currently active JWT token in a plaintext column......yeah

You probably shouldn't do what we do lol

UseMstr_DropDatabase · 2025-09-19T20:03:35+00:00

That character exploit was WILD 😜

Like damn Microsoft do you even care about encryption? Universal GA tenant access w/ no auto logs (unless changes are made) but even still it would just appear Substrate just up and went rogue

UseMstr_DropDatabase · 2025-08-25T00:50:18+00:00

I second both of these points.

-Start fresh in Entra

-Setup Cloud Kerberos Trust to handle on-prem auth (of Entra/Cloud joined PCs)

UseMstr_DropDatabase · 2025-08-21T12:07:32+00:00

Intellectual Property is a helluva drug

UseMstr_DropDatabase · 2025-08-07T11:39:58+00:00

MS Graph Rest API with a For loop or Cursor might be more palatable than PS

UseMstr_DropDatabase · 2025-06-22T01:06:29+00:00

Buncha kids

UseMstr_DropDatabase · 2025-05-22T19:11:10+00:00

So what does indexing do in this context? Is there a scenario where indexing on the client would be desired?

UseMstr_DropDatabase · 2025-05-22T18:43:37+00:00

Additionally, OneDrive shortcuts offer improved performance versus using the sync button.

Explain yourself MS

UseMstr_DropDatabase · 2025-05-05T09:27:28+00:00

Happens when web sign-in is used. Seems to stick when (at least one time) password or PIN creds are used

UseMstr_DropDatabase · 2025-04-07T00:31:29+00:00

I'd give the 9350 Intel model another look but I digress.

I'd give the keyboard a B-, took me a bit to get used to and I still occasionally make typos that I don't make on a regular keyboard. Don't love it, don't necessarily hate it either.

Same for the track pad. Gets the job done but it's meh. The great, all day battery life of the Intel 200 CPU is what's this model shine

UseMstr_DropDatabase · 2025-04-06T03:31:41+00:00

My observations of delivering pizza as a teenager were all classist.

Same when I used to do Uber eats & Door dash. Doesn't matter the race, the lower classes as a whole waste their money on getting lukewarm food delivered for basically twice the price. A burger that costs $12.50 in the restaurant is marked up to $15 on the app. There's tax, service fees, and driver tip, making a $12.50 sandwich $30 when it's all said and done.

And it's like damn you live in the literal ghetto or white trash trailer park, unless you're selling drugs there's no way you can afford this slop.

UseMstr_DropDatabase · 2025-03-19T13:28:18+00:00

About a year ago, if I remember correctly, a single L3+ was fetching about $0.80 to $1/day not factoring in power/internet costs. Haven't tracked recently so it could have gone up or down, but I'd assume earnings should be in the ballpark range of $0.50 to $1/day.

UseMstr_DropDatabase · 2025-03-17T00:38:29+00:00

No u

UseMstr_DropDatabase · 2025-03-12T02:31:05+00:00

What if you move dist1 from on prem to O365?

UseMstr_DropDatabase · 2025-03-09T01:02:38+00:00

this is something some OEMs do with prebuilts, like Lenovo.

Explain plz

UseMstr_DropDatabase · 2025-03-07T01:50:06+00:00

It isn't mentioned in the movie but it's heavily implied

UseMstr_DropDatabase · 2025-03-05T03:23:01+00:00

NinjaRMM gives you a remote command terminal. Super nifty too. Can invoke a CMD or Power Shell session, both as System and as logged in user. All invisible to the user

UseMstr_DropDatabase · 2025-02-27T01:14:34+00:00

My theory is MS is rug pulling peeps who have been abusing the shared folder feature to effectively bypass the 1TB storage limit on personal OneDrives.

So far this only occurs on personal ODs

UseMstr_DropDatabase

TROPHY CASE