Speak guys!
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 the 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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
# 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 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!
Ball Show, too bad I couldn't go
But I'll go next time
Angry, Take this talk to SQL-ES. = D