Como conseguir o primeiro emprego como DBA Júnior (A verdade que quase ninguém explica)
Todos os dias eu recebo mensagens de alunos dizendo algo parecido com isto: "Sandro, eu…
Career
SQL Server
O que 15 anos trabalhando com SQL Server me ensinaram sobre Cluster, Always On e Log Shipping
Se você trabalha com banco de dados em produção, uma coisa fica clara muito rápido:…
SQL Server
Essential SQL Server Scripts Every DBA Should Know
If you work as a SQL Server DBA, sooner or later you will face complex…
SQL Server
When SSIS Packages Can’t Access Windows Folders in SQL Server — Why PROXY Is Often the Real Solution
A Very Common Problem in SQL Server Environments If you have worked with SSIS packages…
Devs
SQL Server
Why Isolation Levels Matter More Than Most Developers Think (SQL Server, Oracle, PostgreSQL and MySQL)
One of the Most Misunderstood Topics in Databases After more than 25 years working with…
SQL Server
Why Every Serious DBA Must Understand Wait Statistics in SQL Server (Lessons I Learned the Hard Way)
The Moment Every DBA Eventually Faces After 25 years working with databases — SQL Server,…
SQL Server
The SQL Server Log Most DBAs Ignore… Until It’s Too Late
Why Every Serious DBA Must Master SQL Server Error Logs One of the Most Important…
SQL Server
The Hidden SQL Server Command That Lets You Simulate Hardware: Mastering DBCC OPTIMIZER_WHATIF
Introduction One of the most fascinating — and often overlooked — capabilities inside SQL Server…
BI Analyst
Data Analyst
Devs
MySQL
Oracle
Postgres
SQL Server
Data Modeling Is Not Optional: Why a Strong Data Model Defines the Success — or Failure — of Any System
If there’s one mistake I’ve seen repeatedly in my career, it’s this: Teams rushing to…
SQL Server
What Is a Deadlock in SQL Server (And in Any Serious Relational Database)?
If you’ve worked long enough with relational databases in real production environments, you’ve encountered it.…