Retrospective and Numbers 2019

Views: 286
Reading Time: 12 minutes

Hey guys!!
Last post of 2019 and can be no different: Retrospective. This year was an EXCELLENT year from a professional and technical point of view, although it was not good at a personal level. So I'll make a summary of everything that happened this year and come on!

Looking coldly at just the numbers, I can say that 2019 was a sensational year:

General Numbers

Students in my safety training: 143
Events that I helped to organize: 6
People at the events I helped to organize: 2.470
Lectures given: 15
People who attended my lectures: 960
Lives / Webcasts I attended: 12
Lives / Webcasts views I attended: 11.122
Posted Videos: 10
Views of my videos in Spreadsheets: 28.714
Blog Views: 503.416
TOTAL IMPACTED PEOPLE IN 2019: 275.412 (Lectures + Lives + Videos + Blog Users)

Blog Numbers

Published articles: 62
Total words: 80.833
Average words per post: 1.304
Blog Views: 503.416 (50% more than 2018)
Usuarios: 234.616 (30% more than 2018)

2019 Blog Numbers

January

January is a very top month! Month that people are on vacation .. enjoying the beach .. And it's also the month of my most dignified birthday .. But even with many appointments this month, I could still write some articles and participate in lives 🙂

In January, I wrote the following articles:

I also participated in two lives:

Fevereiro

February .. heat and month of Carnival! Still, time left to create quality content for the technical community 🙂

In February, I wrote the following articles:

I also participated in two lives:

March

In March 2019, I was pleased to have some articles published on iMasters, one of the oldest and largest development portals in Brazil. It is really a great honor and satisfaction to be part of this portal, which only gathers professional references in their respective areas.

Also this month, I participated in the organization of 11th PASS Local Group Meetup “SQL Server ES”, where I gave the lecture “Security in SQL Server - Are you leaving the key under the rug?”, which was a preview of what was shown at the event MVPConf Latin America 2019 and the speaker Tiago Neves presented the lecture “Starting a tuning work” , which was a preview of what he presented at the event SQL Saturday # 819 Brasilia

It was also this month that we inaugurated #TeamFabricioLima's online training platform, which I kept hammering at Fabrício's head until I decided to put this project to work. The first course available was from Tuning Master Fabiano Amorim, Tuning's biggest name in Brazil and one of the biggest in the WORLD.

In March, I wrote the article General Personal Data Protection Act (LGPDP or LGPD) applied to SQL Server databases and participated in two lives:

April

Another month that I like a lot is April. Month of the birthday of one of the people I love the most, who is my daughter Leticia. In terms of contribution, it was a very weak month for me, where my only two contributions were speaking at Global Azure Bootcamp 2019 - Victoria and MVPConf, the world's largest event of Microsoft experts.

This month I launched my first training on the #TeamFabricioLima online platform, which is the SQL Server Security - 1 Module, and I had over 120 students in this module alone 1.

May

Month of my birthday, May was an excellent month. I traveled to Belo Horizonte and Fortaleza for lectures .. I wrote articles, posted videos .. I will explain in more detail below.

On May 11, I had the honor of participating in the organization of the 12th SQL Server ES Meetingwhere we had Power BI talks with MVP Ruy Lacerda and MCSE Thais Mafra.

I participated in a live to DevelopersBR channelwhere I was able to explain in detail various aspects of SQL Server security.

Speaker at SQL Saturday # 844 - Belo Horizonte, with the theme “Security in SQL Server: Are You Leaving the Key Under the Rug?”, where I demonstrated the various security risks and loopholes we may have on a daily basis and don't even notice, with some practical examples of this.

On May 17th, I participated in a Live at Canal Planilheiros, the largest Power BI channel in the world, where we officialized my entry in the Planilheiros team, along with Rafael Mendonça. From this moment on, we become part of the channel and posting videos as well.

In May, I wrote the following articles:

And I posted the following videos on Planilheiros Youtube:

June

June was the month of lectures and travels. Earlier this month, I went to Fortaleza to speak at GPDI Data and Tech 2019, organized by Rafael Mendonça, and at the end of the month, I went to Brasilia to speak at Power BI Roadshow 2019, organized by Ruy Lacerda and Fernando Garcia (Planilheiros).

And a very striking fact for me, was the fact that Brent Ozar, one of the biggest SQL Server references in the world, shared my post on the Security Checklist and sent it along with his website newsletter to all his followers.

On June 16th I participated in the live “Round Table # 26: End-to-End Security - Dev, Infra and BD”, in the channel Coding Night

In June, I wrote the following articles:

And I posted the following videos on Planilheiros Youtube:

July

In July, I was again pleased to host the 13th PASS Local Group Meetup, “SQL Server ES”, where we had as speaker, the myth Rodrigo Ribeiro, expert in SQL Server, Operating Systems, Troubleshooting, etc ..

Another very remarkable fact for me this month was the participation in the Mito Fabiano Amorim Podcast, “DELETE WITHOUT”, where I had the honor of being the first guest of this Fabiano initiative:

I also participated in Live “Quinta with Acai and Data”, for the SQL North channel. In this live, I was able to share what are the best tools that can help DBA in your daily life and I was able to test unusual or familiar tools that can facilitate and optimize the productivity of a DBA in your work environment.

In July too, I had my MVP title renewed for another year and it is a great satisfaction and honor to be part of this select team of great professionals, influencers, content creators and speakers:

In July, I wrote the following articles:

August

Worldwide, August has become synonymous with SQL Saturday Victory (kkkkkk) and with this excellent event (the largest data event in the history of Espírito Santo), August was a very special month. A lot of work in organizing the event, a lot to prepare, organize and in the end, everything worked out!

On August 02nd, I joined the Microsoft Certified Trainer (MCT) program

On August 16th I reached the incredible mark of 1.000.000 (1 million) blog views!

And on August 24th, I participated in the organization of SQL Saturday # 900 - Victoria / ES, which had 823 people registered and, on the day of the event, more than 300 people present!

In August, I wrote the following articles:

And I posted the following videos on Planilheiros Youtube:

September

September, for me, was one of the worst personal months in recent years. My little dog Brucy, who has been with us for almost 14 years (almost the same time I have with Paty) got sick and unfortunately passed away .. It was a very sad month here at home because of this and until today, the record has not yet dropped .. 🙁

On September 18th, I went to Rio de Janeiro to talk about the Power BI Report Server at 3rd Petrobras congress on productivity with Power BI at the invitation of Ruy Lacerda and Fernando Garcia, from the Planilheiros channel.

On September 28th, I went to São Paulo to speak at the SQL Saturday # 906 - Sao Paulo with the theme “SQL Server Security - Are You Leaving the Key Under the Rug?” where I was able to talk about LGPD, security, data privacy and demonstrating SQL injection attacks, elevation of privilege access, representing attacks and several common security holes we see daily and how the DBA can protect against these attacks.

On September 30th, I participated in the live “Programming with SQL Server - File, XML, JSON, APIs, and Excel Integrations”, For DotNET channel.

October

The month of October was an atypical month .. It was the first month since 2014 that I didn't make any blog posts. However, content production cannot stop .. rs

On October 03rd, I posted the video “Power BI Reports on TV, Full Screen and Switching Tabs” on the Planilheiros channel, where I demonstrated the Power BI-supported browsers and give you tips on how to show Power BI reports. on a TV without having a headache or spending money for nothing.

On October 11th, I participated in Live “Round Table # 31: Performance in Data Access in .NET and Azure” from the channel Coding Night:

On Oct. 13, I posted the video “How to Create Custom Visuals in Power BI with D3.js” on the Planilheiros channel:

On October 20th, I published the video “Power BI - Filtering the columns of a dataset (dynamic columns)” on the Planilheiros channel:

November

November is the month I celebrated 15 years of relationship with Paty and so, I couldn't do so much .. lol

On November 18, I went to São Paulo to participate in the “Power Platform World Tour - SP”, where I had the opportunity to give 3 lectures at this, which is the largest Power Platform event in the world. The themes of my lectures were:

  • Power BI Report Server - The Ultimate BI and Data Visualization Solution for Your Business
  • Monitoring Your SQL Server Environment with Power BI
  • Power BI: DirectQuery, Live Connection, and Import

In November, I wrote the following articles:

December

Last month of the year, month when people usually slow down, right? Well, with me it was the opposite .. December I was able to produce a lot of content to share with you!

On December 07th, I went to Belém do Pará to lecture on “Data Tech Day 4”, organized by Wiluey Sousa and other members of SQL North. It was an epic event and very well organized, where I had the pleasure of giving 2 lectures:

  • Programming with SQL Server
  • Power BI + Analysis Services - Analyzing Big Data

On December 12th and 13th, I was in São Paulo to attend Microsoft Ignite - The Tour, an official Microsoft event about new technologies and tools coming to the market, where I could do a lot of networking.

On the 13th, after Ignite, MVP's from all over Brazil were invited to a Happy Hour at XP Investimentos headquarters. It was really cool to see friends and also talk about business, community, technical tips and also, about life beyond IT and work .. rs

On December 14, MVP's were again invited to Microsoft headquarters to attend an event focused on communities, innovation and technology. We attended amazing lectures with the innovation leader of XP Investimentos and also Tania Cosentino, president of Microsoft Brasil, in other lectures organized by other MVP's.

On December 19th, I participated in the Organization of “14th PASS Local Group SQL Server ES Meetup”where I also lectured on “Power BI + Analysis Services - Analyzing Big Data” with my friend and teammate, Leandro Lima.

In December, I wrote the following articles:

That's it folks!
I wish you a happy new year, and may 2020 be an amazing year in every way!

See you next year!