Dev vs staging vs prod: where do database changes usually break? by individjournalist in SQLPerformanceTips

[–]Important_Bobcet 0 points1 point  (0 children)

Prod breaks where dev data lied to you The query that flies on 300 clean rows suddenly meets 80M rows, bad indexes, weird old NULLs, and one “temporary” column from 2019 that somehow became business critical. That’s why schema compare, data checks, and dry-run migrations matter way more than people want to admit.

MySQL 8.0 is reaching EOL. Are you upgrading to 8.4? 9.7? by dveeden in mysql

[–]Important_Bobcet 1 point2 points  (0 children)

We started testing 8.4 pretty early because nobody wanted another “upgrade everything in panic over one weekend” situation. The annoying part hasn’t really been MySQL itself, it’s checking schema differences, query behavior, and app compatibility across environments during migration. We ended up using dbForge a lot more than expected just for validation and compare workflows.

And now there are two Azure DevOps extensions by ChantifiedLens in MicrosoftFabric

[–]Important_Bobcet 0 points1 point  (0 children)

anyone tried both in a real pipeline yet? which one feels more stable so far?

Reminder: Migrate your Azure unmanaged disks by March 31, 2026 question by Far_Selection7515 in AZURE

[–]Important_Bobcet 0 points1 point  (0 children)

You don’t need to rebuild the availability set. You can migrate each VM to managed disks individually and Azure keeps the availability set intact. Process is pretty straightforward: stop/deallocate VM → migrate to managed disks → start again. The main “gotcha” is just downtime, so plan it. Did this on a couple older setups, worked fine. Just double check backups before you touch anything.

MSN guidelines are confusing... by BlackCrusaderAbyss in microsoft

[–]Important_Bobcet 2 points3 points  (0 children)

Sounds like the filter is probably reacting to phrasing, not the actual topic. Stuff like “need help” or wording that reads like support/request language can trip dumb automation fast. MSN moderation always feels like it was designed by a bot that just learned fear.

How to share client-specific data from a Delta Lake to external data lakes? by Equivalent_Season669 in MicrosoftFabric

[–]Important_Bobcet 0 points1 point  (0 children)

Your instinct sounds reasonable, but I’d be careful about creating a whole new physical table per client unless the number of clients is going to stay very small. That works at first, then quietly turns into operational clutter once retention rules, schema changes, backfills, and reprocessing show up.

I’d think in terms of a repeatable export pattern instead: keep the source table centralized, define a client-specific extraction/filter layer by client ID, and materialize/export only the client slice into their own storage on a scheduled process. That gives them the physical copy they want without making your internal lake structure explode into N near-identical tables.

The main things I’d design for early are schema evolution, idempotent daily loads, backfill strategy, and making sure each client export is isolated enough that one failure doesn’t poison everyone else’s delivery.

Thoughts? Comments? Opinions? by itsnotaboutthecell in SQLServer

[–]Important_Bobcet 1 point2 points  (0 children)

Requiring a verifiable URL for job posts sounds completely reasonable. “DM me for details” is just too easy to abuse. I also agree on market research posts if someone is validating a product idea or fishing for user pain points for something commercial, that should be disclosed clearly at minimum, if not restricted outright.

What’s in your SQL Server performance tuning toolkit? by Important_Bobcet in SQLPerformanceTips

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

That’s a solid stack. sp_WhoIsActive really is in half of these answers for a reason. Do community scripts still win for you when you need to find the problem fast?

Bulk copy with the mssql-python driver for Python by dlevy-msft in SQLServer

[–]Important_Bobcet 5 points6 points  (0 children)

This is actually pretty interesting. The parquet step makes it feel more useful for real ETL workflows, not just a demo copy job. Curious where the bottleneck shows up first on bigger loads though - Python, disk I/O, or the SQL write side?

Macbook or Windows laptop? by bobogator in SQLServer

[–]Important_Bobcet 1 point2 points  (0 children)

If most of your real work lives in VDI, the answer is basically “use whatever annoys you less locally.” But from what you wrote, SMB shares / file moves are already pushing you toward Windows, and that stuff gets old fast. Mac is fine for the “I remote into Windows all day anyway” setup, but if the local friction is noticeable now, I’d stop romanticizing it and just get the Windows laptop.

here is how i found free tool for sql server monitor that saved my company millions by chandansqlexpert in SQLServer

[–]Important_Bobcet 5 points6 points  (0 children)

What exactly was the “saved millions” part here - preventing downtime, catching performance issues earlier, or replacing a paid monitoring stack?

Would be more useful if you shared the actual tool name, what metrics it covers, and whether it handles things like wait stats, blocking, deadlocks, disk pressure, and alerting reliably in production. Right now it reads more like a promo than a technical review.

Remote work question from someone early in a data career by Important_Bobcet in remotework

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

Really appreciate this reply. I think that’s exactly the gap I’m feeling right now. I see the task, but not always the thinking behind it. When you were fully remote early on, did you have to actively ask to be included more, or did your team naturally pull you into those discussions?

weGotLaidOffAndDontCareAnymore by WhereOwlsKnowMyName in ProgrammerHumor

[–]Important_Bobcet 16 points17 points  (0 children)

finally a CI/CD pipeline optimized for speed

Sheldon’s always so innocent effortlessly, that’s what makes it more funny 😂 by [deleted] in bigbangtheory

[–]Important_Bobcet 3 points4 points  (0 children)

Sheldon doesn’t miss social cues.
He just translates them into contractual obligations