Hey guys!
On 10/16, I had the pleasure of speaking at the 1st SQL Server Meetup, held at Microsoft headquarters, in São Paulo, at the invitation of the event organizer, Caio Amante.

There are no words to describe the satisfaction and happiness in being able to share a little about my vision of the role of the dba in today's times, personally meeting several people who I have interacted with for a while on social media and communicators and also in speaking at the same event as the legends. Fabiano Neves Amorim and Thiago Carlos de Alencar.

In my talk, I had the opportunity to comment on my view of the DBA from a few years ago, seen almost as an enemy of developers and the BI team, and the role of the DBA in current times and in the future, where he is a partner in the development/bi areas, working in the DevOps culture, automating repetitive tasks and acting more in line with the needs of the business.

I also demonstrated some tools and resources that enable the DBA to deliver more results with much less time and effort, such as monitoring tools (Redgate SQL Monitor, ApexSQL Monitor and the SQL Performance Monitor), HealthCheck tools, such as sp_Blitz, by Brent Ozar and also various tools, such as DBA Tools.

If you want to know a little more about these tools, I commented and attached some videos about them in my article SQL Server – How to identify a slow or “heavy” query in your database.

Slides from my talk

DBA Tools script used in the demonstration:

# Consulta documentação
Start-Process https://dbatools.io/commands
Get-Command -Module dbatools *history*

# Consulta de Informações
Get-DbaSqlService -ComputerName localhost | Out-GridView

"localhost\sql2017" | Get-DbaLastGoodCheckDb
"localhost\sql2017" | Get-DbaLastGoodCheckDb | Out-GridView

Get-DbaDeprecatedFeature -SqlInstance localhost\sql2017 | Out-GridView

Read-DbaTransactionLog -SqlInstance localhost\sql2017 -Database dirceuresende | Out-GridView

# Parâmetros de inicialização
Get-DbaStartupParameter -SqlInstance localhost\sql2017

# Exportação de scripts
Get-DbaAgentJob -SqlInstance localhost\sql2017 | Export-DbaScript -Path C:\Temporario\jobs.sql
Export-DbaLogin -SqlInstance localhost\sql2017 -Path C:\Temporario\logins.sql
Export-DbaUser -SqlInstance localhost\sql2017 -Path C:\Temporario\users.sql
Export-DbaSpConfigure -SqlInstance localhost\sql2017 -Path C:\temporario\

# Validações diversas
Find-DbaSimilarTable -SqlInstance localhost\sql2017 -Database dirceuresende | Out-GridView
Find-DbaOrphanedFile -SqlInstance localhost\sql2017

# Histórico de Informações
Get-DbaAgentJobHistory -SqlInstance localhost\sql2017 -StartDate '2018-01-01' -EndDate '2018-10-16 12:30:00' | Out-GridView

# Migrações
Copy-DbaDatabase -Source localhost\sql2017 -Destination localhost\sql2019 -Database dirceuresende -DetachAttach -Reattach
Copy-DbaAgentCategory -Source localhost\sql2017 -Destination localhost\sql2019
Copy-DbaAgentJob -Source localhost\sql2017 -Destination localhost\sql2019

Event Photo Gallery

Check out the photo gallery from the event, which was sensational!

This slideshow requires JavaScript.

I would like to say a huge thank you to everyone who was willing to attend the event, because without you, this event would not have been possible.
A big hug and see you next time!