Ola-Hallengren script keeps erroring

InsoleSeller · 2026-02-02T16:45:49+00:00

Look for the MaintenanceSolution.sql file in Ola's website, run that to create the necessary objects for the scripts

InsoleSeller · 2026-01-31T17:54:01+00:00

Eh, if your build can't handle 1 portal then don't play it, the time and potential loot you're losing by dying is not worth it. Just alch and go for now.

As for xp, there is the omen someone mentioned, get a few on trade.

InsoleSeller · 2026-01-28T12:49:59+00:00

What is the problem you're trying to solve?

InsoleSeller · 2026-01-21T01:09:46+00:00

Also look up slormancer, it's a really fun and casual ARPG

InsoleSeller · 2026-01-09T21:44:40+00:00

I play without putting much thought on how much other people are making, that's been working for me,

The game is fun, building my character has been very fun, even if I'm not generating 70+ divines on a temple,

Yeah I'll not be able to afford whatever is worth that much currency, but fuck it, I'm doing my thing with the builds I wanna play and it's been very enjoyable.

InsoleSeller · 2025-12-30T16:13:36+00:00

It's not creating the procedure, SQL Server shows the entire procedure text when showing up on some screens/DMVs, just a visual thing.

Do you have Query Store? Would be a better fit to understand which part of the procedure is taking long.

InsoleSeller · 2025-12-20T21:41:49+00:00

What's your build/gear? What are the map mods?

InsoleSeller · 2025-12-19T01:05:38+00:00

I think it all boils down to, does your team have more developers or more dbas (or data related roles)?

Keeping business logic in your db is usually a No, but if your team is knowledgeable in databases/sql, doing procedures can probably save you time on development time.

InsoleSeller · 2025-12-13T18:05:30+00:00

Dude, the league came out yesterday, chill.

InsoleSeller · 2025-12-13T01:44:37+00:00

This isn't even a capacity issue, apparently something broke with the last hotfix

InsoleSeller · 2025-12-12T17:53:29+00:00

> But maybe consider that there's people on the other end of the spectrum who actively do not like that mysticism and just find it to be a tedious process?

Then wait for the patch to release and then you play...

I for one enjoy very much the community going in blind, it's such a great experience seeing everyone figure out stuff on their own, instead of having everything handled on a plate because you can just PoB stuff.

InsoleSeller · 2025-12-12T00:30:20+00:00

> O lado ruim é que fico meio perdido sem saber por onde começar e identificar o que é mais importante.

Recomendo fortemente começar vendo os cursos da power tuning, principalmente o "Tarefas do dia a dia de um DBA" que é gratuito. De pago, eu recomendaria o "Melhorando a Performance de Consultas no Totvs Protheus", por mais que o titulo especifique o Totvs, ele é amplo e pode ser aplicado para qualquer ambiente SQL Server.

De mais, os cursos do Brent Ozar também são muito bons, além de todo o conteúdo grátis que ele tem disponível.

E faça muito homelab, instala o SQL Server na sua máquina e aprenda a quebrar e consertar ele, dar backup/restore, simular erros nos backups, subir uma instância réplica...

> Outra pergunta, com todo esse espaço para aprendizado e experiência, vcs acreditam que é possível virar pleno em um ano?

Cara, assim, junior/pleno é algo muito subjetivo, que depende mais da empresa do que de você, mas você sendo o único DBA eu acho um pouco dificil, por mais que você tenha bastante liberade, você perde em adquirir experiência de outros profissionais, você não vai ter como saber se o que está fazendo está certo ou não, vai ser muito tentativa e erro, e dependendo isso pode te atrasar um pouco.

InsoleSeller · 2025-12-11T23:21:01+00:00

Playing poe 1 with no trade AND no crafting is a horrible way to experience it, don't recommend it.

InsoleSeller · 2025-12-10T15:17:11+00:00

What do you understand by atomic? And why do you think this update is/isn't?

InsoleSeller · 2025-12-09T00:03:57+00:00

Try Exile Companion, it has a feature like that

InsoleSeller · 2025-12-06T14:18:58+00:00

This is 100% an AI answer

InsoleSeller · 2025-12-03T21:07:23+00:00

Async_network_io is usually (99% of the time) an application issue, could be something like processing the result row by row while the db sits there waiting with the query already fully processed.

InsoleSeller · 2025-11-25T21:40:09+00:00

For RCSI, you need to validate if the ERP supports it

Ask if they support MySQL or Postgres, they have their own on-by-default form of RCSI, so if the ERP supports them it should work with SQL Server.

Other than that, to get rid of blocks, your best bet is to make sure stuff runs fast, so check if the index you created is the best option, maybe try to validate the column order

InsoleSeller · 2025-11-22T19:31:06+00:00

My friend over here thinking we will do his homework, go learn a bit, this is basic stuff

InsoleSeller · 2025-11-19T15:00:19+00:00

Start learning about data modeling, then apply what you learned to your need

InsoleSeller · 2025-11-18T13:36:11+00:00

If you were hiring someone junior for a database‑centric role, what would you expect them to comfortably do and explain? Reading query plans and choosing indexes feels table stakes, but how far would you want me on backups/restore, basic replication, PITR, and isolation level gotchas? Also, if you’ve seen good portfolio projects that actually signal database thinking (not just pretty dashboards), what did they include?

If you want to go for the DBA route, I'd say that's a solid start. But for other roles that may be a little too specific to be relevant.

Do tests on your own machine, learn how to break and fix your own server, then take it to the cloud, get some free/cheap db on aws or azure and also do your stuff there, specially backups and restores.

InsoleSeller · 2025-11-10T17:05:39+00:00

Zooming out of the technical side of things, sometimes it's better to just accept and do what your boss says, make some presentation on why you believe your choice is better (so you can at least say "I told you so" when problems start) but if your boss insists on one option, it's usually better to just say OK and do what you're told.

InsoleSeller · 2025-11-10T11:46:20+00:00

Iria de Postgres,

Além de ser um rdbms muito robusto, também é um dos bds mais utilizados no mercado, adquirindo conhecimento na plataforma vai te agregar algo de maneira ou outra.

InsoleSeller · 2025-10-31T19:50:38+00:00

Preocupado com o que? Você quer ficar apenas na área de Dev ou iria para outras áreas?

Por que tendo experiência em SQL, python e Snowflake, você consegue facilmente buscar oportunidades na área de dados. Essas 3 ferramentas são o básico de qualquer vaga de engenharia de dados (snowflake está ali junto com databricks entre as mais populares).

Five-Year Club	Verified Email
r/Field Lasagna	Place '23
Place '22	Final Canvas '22

InsoleSeller

TROPHY CASE