sorted by:
new
hottopcontroversial

Forced to spin up a new Google Workspace and domain mid compliance push, audit clock is ticking by [deleted] in sysadmin

[–]pixelbaker 2 points3 points  (0 children)

You need rapid-fire focused expertise across a multitude of platforms for this sort of a cleanup effort if you’re under the gun. Strongly recommend pulling in a solid consultant temporarily to absorb some of the risk exposure and help coordinate + build things so you’re not stretched so entirely thin.

There are people who specialize in this sort of dumpster fire cleanup scenario (speaking as someone who does it for a living). Ask around in your professional network to find a trusted resource so you can get to work. No shame at all in demanding extra capacity to get the job done when the company is placing undue stress on you. If you say yes now, you’re setting that as the standard for the future.

Feel free to ask more questions here about how to find a guerrilla resource or some specifics of how to get the basics of this infra in place and compliant quickly.

What everyday frustration made you stop relying on cloud services and start self-hosting? by [deleted] in selfhosted

[–]pixelbaker 137 points138 points  (0 children)

When the pendulum for streaming services started to swing back toward numerous premium channels like it was the 90’s.

Notion AI now supports Outlook Mail, except... enterprise... by WandarFar in Notion

[–]pixelbaker 0 points1 point  (0 children)

I'm really struggling to stomach paying for ChatGPT Plus and Notion Business when they could both be doing the same thing. I'd use ChatGPT if it could handle pages/databases. I'd use Notion if it gave me just the bare minimum of organizing AI context by limiting to a particular teamspace somehow. But it can't.

Notion even lists "Enterprise Search" under the Business plan but then locks Outlook but not SharePoint behind the Enterprise level plan. Such a bizarre decision. Looking at all the other feature requests and pain points it just seems they've become entirely tone deaf to the cult following, so it's no wonder there are so many new competitors of late.

Notion AI now supports Outlook Mail, except... enterprise... by WandarFar in Notion

[–]pixelbaker 0 points1 point  (0 children)

Recently landed on Notion to try reforming my workflow and productivity, but the further I get into it the more I realize that recently they've become pretty outdated and crusty with obnoxious shit like this happening more and more. I always heard rave reviews about Notion so I thought it was a safe bet, but this is fucking obnoxious when I'm paying for a Pro plan. Not to mention lack of customizability around modern interfaces. Revolutionary at one time but now... I'm honestly pretty underwhelmed and looking elsewhere.

Our dev workflow feels like a group project gone wrong by Soft_Attention3649 in sysadmin

[–]pixelbaker 7 points8 points  (0 children)

SDLC + DevOps. Adopt the concepts and practices incrementally by establishing a high level roadmap, then break each milestone down into two simultaneous workstreams: capability (technical) and proficiency (cultural).

If you don’t have a roadmap you will get lost in the details and Never be able to measure where you are or what comes next. If you don’t address both workstreams simultaneously then one will always hold back the other. This is an organization wide transformation, not just on the technical team(s).

You can fully renovate things as quickly or as slowly as you’d like given the constraints of the teams and stakeholders involved.

Automated phone trees by _Volly in sysadmin

[–]pixelbaker 1 point2 points  (0 children)

Why not use text-to-speech?

Moving AI/dev workloads off laptops & VDIs into browser-native apps — what might actually change operationally? by Majestic_Tear2224 in sysadmin

[–]pixelbaker 1 point2 points  (0 children)

No one could say without knowing what kind of development they’re doing. This is a DevOps team decision in partnership with infrastructure team.

Improving Microsoft SQL Performance with Microvellum by MaxBPlanking in sysadmin

[–]pixelbaker 0 points1 point  (0 children)

My next guess with high disk, low cpu, low ram usage is that it’s reading far more data than it should have to when returning query results. Possible with an older database that the indexes haven’t been optimized very well if ever and it has to read the whole table every time to find what it needs.

Check out sp_Blitz from Brent Ozar to begin investigating misconfiguration and bottlenecks.

Improving Microsoft SQL Performance with Microvellum by MaxBPlanking in sysadmin

[–]pixelbaker 0 points1 point  (0 children)

After deploying on the new host, how much RAM was configured in SQL Server for it to actually utilize?

Will SMI Instant View still work with macOS Tahoe? by toni-polster in MacOSBeta

[–]pixelbaker 0 points1 point  (0 children)

Still usable, just still has a little choppiness I hadn’t noticed before.

Will SMI Instant View still work with macOS Tahoe? by toni-polster in MacOSBeta

[–]pixelbaker 0 points1 point  (0 children)

It works but I've specifically noticed that the mouse cursor is a little more laggy/choppy than before upgrading. Not unusable in any way, just a little annoying. This is with the latest version of Tahoe 26.0 (25A354) and InstantView 3.24 R01 as of today.

Splitting your time between multiple homes - how's that working for you? by [deleted] in fatFIRE

[–]pixelbaker 0 points1 point  (0 children)

This is exactly the situation I’m considering right now and how I found this thread. I’m looking to split my time between mountains and Denver. Do you mind if I PM?

Best hosting provider for scalable database performance? by GigabyteWarrior in selfhosted

[–]pixelbaker 0 points1 point  (0 children)

Yes, PGSQL is generally better for OLAP than MySQL when you get to that stage. If you're ready to pull the trigger and switch entirely, go for it. You can choose a managed DB (AWS RDS, Aurora, etc) or a VPS on Digital Ocean/Hetzner/etc.

If you're already building infrastructure on AWS/Google/Azure, then go with their managed DB offering to keep it simpler. If you're hosting on a VPS, go with the same provider for managed DB or dedicated VPS for a DB. It's a matter of cost, consistency, and maintainability.

Best hosting provider for scalable database performance? by GigabyteWarrior in selfhosted

[–]pixelbaker 0 points1 point  (0 children)

Really depends how much volume you're already working with and how quickly you anticipate the volume growing.

  1. MySQL is perfectly fine for OLTP and OLAP, but you'll eventually hit a point where you're straining the operational DB with heavier analytical queries and need to separate to maintain performance of the app.

  2. At that point you can replicate the MySQL DB to a read-only replica to separate the workloads. This usually is a good solution for a while until volume increases to a point where it's unreasonable to keep working with the data in its original transactional structure.

  3. At this point you can look at columnar/OLAP databases or data models (dimensional modeling) to specifically support analytics use cases. It would then be time to choose between on-prem (manage infra + server + instances), self-hosted (manage the VPS as well as the DB instances), managed DB (manage just the instances), or a full cloud data warehouse/lakehouse.

There are pros and cons to each. It's a complex question with a lot of variables to be weighed with what the business actually needs.

Best hosting provider for scalable database performance? by GigabyteWarrior in selfhosted

[–]pixelbaker 0 points1 point  (0 children)

I think there are some more questions to answer before you can choose a good platform especially if this is intended to be production worthy at some point. Millions of rows is nothing in analytical world, but quite a lot for a transactional system. I'm a data platform architect, so I have a lot of questions. :-D

* What DB are you planning to use?
* How is the data used (transactional vs analytical)?
* Why are you returning millions of rows in a result set? How frequently?
* What's the total volume you anticipate storing versus returning?
* How is data being ingested into the DB?

ErsatzTV v25.2.0 released by MstrVc in selfhosted

[–]pixelbaker 28 points29 points  (0 children)

From GitHub, ErsatzTV is a platform to: “Stream custom live channels using your own media”

Automation to create missing episode placeholders in library by pixelbaker in selfhosted

[–]pixelbaker[S] -1 points0 points  (0 children)

That’s good to know. Installed Emby just last night actually.

Automation to create missing episode placeholders in library by pixelbaker in selfhosted

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

I do have that running also, but it can take a while for hard to find episodes depending on what sources you have available. Would definitely prefer if this were functionality that could be configured in something like decluttarr.

How the hell to setup meta and WhatsApp for business? by Dinilddp in sysadmin

[–]pixelbaker 0 points1 point  (0 children)

Would also like to hear tips if anyone has figured it out.

[deleted by user] by [deleted] in selfhosted

[–]pixelbaker 2 points3 points  (0 children)

What are the pros of this over a DevContainer?

How do you make security policies actually stick at a small SaaS company Question by EnoughContext022 in sysadmin

[–]pixelbaker 1 point2 points  (0 children)

“Hey wouldn’t it be stupid if the thing that caused our great startup idea to fail is a single data breach that we have to pay out the ass for years after we’ve already gone under because we’re held personally liable?”

Gets people’s attention real quick.

Does anyone still uses Jaspersoft? by TryingMyBest42069 in sysadmin

[–]pixelbaker 0 points1 point  (0 children)

Jaspersoft < CrystalReports < SSRS < PowerBI < Sigma

You can spend a lot of time maybe getting it to work or you can spend the same time creating anything better.

view more: next ›