On 16 / 10, I had the pleasure of speaking at the 1º SQL Server Meetup, held at Microsoft headquarters in São Paulo, at the invitation of the event organizer, Caio Lover.
No words to describe the satisfaction and happiness of being able to share a little about my vision of the role of dba these days, to personally meet several people who had been interacting with it for a while on social networks and communicators and also to speak at the same event that the legends Fabiano Neves Amorim e Thiago Carlos de Alencar.
In my talk, I had the opportunity to comment on my view of DBA from a few years ago, seen almost as an enemy of developers and the BI team, and DBA's role in present and future times, where he is a partner in the areas. development / bi, working in the DevOps culture, automating repetitive tasks and acting more in line with business needs.
I also demonstrated some tools and features that enable DBA to deliver more results with much less time and effort, such as monitoring tools (Redgate SQL Monitor, ApexSQL Monitor and SQL Performance Monitor), HealthCheck tools such as sp_Blitz, by Brent Ozar and also various tools such as the 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 demo:
# Consulta documentação
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
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 of the event, which was amazing!
I would like to thank everyone who was willing to attend the event, because without you, this event would not be possible.
A big hug and until next time!