Hey guys!!
Last post of 2019 and it can't be any different: Retrospective. This year was an EXCELLENT year from a professional and technical point of view, although it was not good on a personal level. So I'm going to summarize everything that happened this year and let's go!
Coldly analyzing just the numbers, I can say that 2019 was a sensational year:
General Numbers
Students in my Security training: 143
Events I helped organize: 6
People at the events I helped organize: 2.470
Lectures held: 15
People who attended my lectures: 960
Lives/Webcasts I participated in: 12
Views of the Lives/Webcasts I participated in: 11.122
Published videos: 10
Views of my videos on Planilheiros: 28.714
Blog Views: 503.416
TOTAL PEOPLE IMPACTED 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)
Users: 234,616 (30% more than 2018)
Blog numbers in 2019
January
January is a very top month! The month when people are on vacation.. enjoying the beach.. And it's also the month of my honor's birthday.. But even with many commitments this month, I still managed to write some articles and participate in lives 🙂
In January, I wrote the following articles:
- SQL Server – NOLOCK vs READPAST: Do you know the difference between the two?
- SQL Server 2014 – How to estimate progress and how long it takes to create an index
- SQL Server – How to identify and change the default schema of database users
- SQL Server – How to use auditing to map actual required permissions to a user
- SQL Server – How to identify instance startup parameters using T-SQL
- SQL Server – What is the difference between @@ERROR and ERROR_NUMBER()?
And I also participated in two lives:
February
February.. hot and the month of Carnival! Still, there's time left to create quality content for the technical community 🙂
In February, I wrote the following articles:
- SQL Server – Performance Tuning Tips: Implicit Conversion? NEVER AGAIN!
- SQL Server – Performance Tuning Tips: What is the difference between Seek Predicate and Predicate?
- SQL Server – How to avoid brute force attacks on your database
- VMware Player – Using independent nonpersistent disk mode
- SQL Server – How to avoid and protect yourself from Ransomware attacks, such as WannaCry, on your database server
- SQL Server – Using calculated columns (or computed columns) for Performance Tuning
- SQL Server – How to identify and collect information from long-running queries using Extended Events (XE)
- SQL Server – How to avoid SQL Injection? Stop using Dynamic Query like EXEC(@Query). Now.
- SQL Server – Understanding the risks of the TRUSTWORTHY property enabled in a database
- SQL Server – When should you use ORDER BY in the query and when should you not use it at all!
And I also participated in two lives:
March
In March 2019, I had the pleasure of having some articles published in iMasters, one of the oldest and largest development portals in Brazil. It is truly a great honor and satisfaction to be part of this portal, which only brings together leading professionals in their respective areas.
Also this month, I participated in the organization of the 11th Meetup of the PASS local group “SQL Server ES”, where I gave the talk “Security in SQL Server – Are you leaving the key under the carpet?”, which was a preview of what was shown at the MVPConf Latin America 2019 event and speaker Tiago Neves presented the talk “Starting a tuning job”, which was a preview of what he presented at the SQL Saturday #819 Brasília event
It was also this month that we inaugurated the #TeamFabricioLima online training platform, a subject that I kept “pounding” on Fabrício's head until he decided to put this project to work. The first course available was from Tuning master Fabiano Amorim, the biggest name in Tuning in Brazil and one of the biggest in the WORLD.
In March, I wrote the article General Personal Data Protection Law (LGPDP or LGPD) applied to SQL Server databases and participated in two lives:
April
Another month that I really like is April. Birthday month of one of the people I love most in life, my daughter Letícia. In terms of contributions, it was a very weak month for me, where my only two contributions were speaking at the Global Azure Bootcamp 2019 – Vitória and at MVPConf, the largest Microsoft specialist event in the world.
This month, I launched my first training on the #TeamFabricioLima online platform, which is the Security in SQL Server – Module 1, and I had more than 120 students in this module 1 alone.
May
My birthday month, 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 11th, I had the honor of participating in the organization of the 12th SQL Server ES Meeting, where we had talks focused on Power BI with MVP Ruy Lacerda and MCSE Thais Mafra.
I participated in a live for the DevelopersBR channel, where I was able to explain in detail various aspects of the SQL Server security area.
I spoke at SQL Saturday #844 – Belo Horizonte, with the theme “Security in SQL Server: Are you leaving the key under the carpet?”, where I demonstrated the various risks and security breaches that we can have on a daily basis and not even realize, with some practical examples of this.
On May 17th, I participated in a Live on Canal Planilheiros, the largest Power BI channel in the world, where we officially joined the Planilheiros team, together with Rafael Mendonça. From this moment on, we became part of the channel and posted videos as well.
In May, I wrote the following articles:
- SQL Server – Security Checklist – An SP with more than 70 security items to validate your database
- SQL Server – How to connect using the DAC connection (Dedicated Admin Connection) without the SQL Browser
- SQL Server – Permissions to use OLE Automation (Yes, the documentation is wrong)
And I posted the following videos on Planilheiros’ YouTube:
- [Basic Course] Power BI Report Server – Class 1
- [Basic Course] Power BI Report Server – Class 2
- [Basic Course] Power BI Report Server – Class 3
June
June was the month of lectures and travel. At the beginning of the 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 Brasília to speak at the Power BI Roadshow 2019, organized by Ruy Lacerda and Fernando Garcia (Planilheiros).
And a very remarkable fact for me was the fact that Brent Ozar, one of the biggest references in SQL Server in the world, shared my post about the Security Checklist and sent it along with the Newsletter on his website to all his followers.
On June 16th, I participated in the live “Round Table #26: End-to-end security – Dev, Infra and BD”, on the channel “Coding Night”
In June, I wrote the following articles:
- stpSecurity_Checklist – Best practices and security checklist for SQL Server
- SQL Server – What is bitwise operation and how to store multiple values in the same column
And I posted the following videos on Planilheiros’ YouTube:
July
In July, I once again had the pleasure of organize the 13th PASS Local Group Meetup, “SQL Server ES”, where we had as a speaker, the myth Rodrigo Ribeiro, specialist in SQL Server, Operating Systems, Troubleshooting, etc..
Another very notable event this month for me was participating in the Mito Fabiano Amorim Podcast, “DELETE SEM WHERE”, where I had the honor of being the first guest of this Fabiano initiative:
I also participated in Live “Quinta com Açaí e dados”, for the SQL Norte channel. In this live, I was able to share the best tools that can help DBAs in their daily lives and I was able to test unusual or well-known tools that can facilitate and optimize a DBA's productivity in their 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:
- SQL Server – Statement(s) could not be prepared. Case expressions may only be nested to level 10
- SQL Server – Preventing queries on certain columns with Column Level Security (CLS)
- SQL Server – Useful day-to-day DBA queries that you always have to look for on the Internet
- How to use Whatsapp and Telegram SAFELY and avoid hacking or conversation leaks
August
Around the world, August has already become synonymous with SQL Saturday Vitória (lol) and with this excellent event (the biggest data event in the history of Espírito Santo), the month of August was very special. A LOT of work organizing the event, a lot to prepare, organize and in the end, everything worked out!
On August 2nd, I joined the MCT (Microsoft Certified Trainer) program
On August 16th I reached the incredible milestone of 1,000,000 (1 million) views on the blog!
And on August 24th, I participated in the organization of the SQL Saturday #900 – Vitória/ES, which had 823 people registered and, on the day of the event, more than 300 people were 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 months on a personal level in recent years.. My dog Brucy, who had been with us for almost 14 years (almost the same length of time as I have had a relationship with Paty) became ill and, unfortunately, passed away.. It was a very sad month here at home because of that and to this day, it still hasn't sunk in.. 🙁
On September 18th, I went to Rio de Janeiro to talk about Power BI Report Server at 3rd Petrobras productivity conference 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 – São Paulo with the theme “Security in SQL Server – Are you leaving the key under the carpet?”, where I was able to talk about the LGPD, security, data privacy and demonstrate SQL injection attacks, improper access due to elevation of privileges, represent attacks and several common security flaws that we see daily and how the DBA can protect itself against these attacks.
On September 30th, I participated in the live “Programming with SQL Server – Integrations with files, XML, JSON, APIs and Excel”, for the 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... lol
On October 3rd, I published the video “Power BI Reports on TV, in Full Screen and Switching Tabs” on the Planilheiros channel, where I demonstrated the browsers officially supported by Power BI and gave you tips on how to show Power BI reports on a TV without having a headache or wasting money.
On October 11th, I participated in the Live “Round Table #31: Performance in data access in .NET and Azure”, from the channel Coding Night:
On October 13th, I published 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 in which I celebrated 15 years of relationship with Paty and that's why I couldn't do much... lol
On November 18th, 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 topics of my talks 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:
- SQL Server – Power BI Gateway problem when using external IP or hostname to access the database
- How to use PowerShell and API with Agent or SSIS to automate updating a Power BI dataset
- SQL Server – charindexada: A different function for breaking delimited strings (split)
- Home Office without Guesses – Experiences of those who have worked remotely for more than 1 year
December
Last month of the year, the month in which people tend to slow down, right? Well, it was the opposite for me... December I managed to produce a lot of content to share with you!
On December 7th, I went to Belém do Pará, to speak at “Data Tech Day 4”, organized by Wiluey Sousa and other members of SQL Norte. It was an epic and very well organized event, where I had the pleasure of giving 2 lectures:
- Programming with SQL Server
- Power BI + Analysis Services – Analyzing large volumes of data
On December 12th and 13th, I was in São Paulo, to participate in Microsoft Ignite – The Tour, an official Microsoft event about new technologies and tools that are coming to the market, where I was able to do a lot of networking
On the 13th, after Ignite, MVPs from all over Brazil were invited to a Happy Hour at XP Investimentos headquarters. It was really cool to see friends again and talk about business, community, technical tips and also about life beyond IT and work... lol
On December 14th, the MVP's were once again invited to Microsoft's headquarters to participate in an event focused on communities, innovation and technology. We attended incredible lectures with the leader of the innovation area at XP Investimentos and also by Tania Cosentino, president of Microsoft Brazil, among 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 spoke about “Power BI + Analysis Services – Analyzing large volumes of data”, together with my friend and teammate, Leandro Lima.
In December, I wrote the following articles:
- SQL Server – How to send messages to Whatsapp contacts, groups and broadcast lists
- SQL Server – String or binary data would be truncated: What it is, how to identify the root cause and how to fix it
- SQL Server – TCP Dynamic Ports vs TCP Port (Dynamic x Static Port)
- SQL Server – I changed the Max Server Memory to 0 and now I can't connect to the instance
- SQL Server Configuration Manager disappeared? Find out how to recover the shortcut
- SQL Server – Encrypting passwords with the symmetric encryption functions ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE
That's it, folks!
I wish you a happy new year, and may 2020 be an incredible year in all aspects!
See you next year!
Comentários (0)
Carregando comentários…