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:
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)
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 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:
- SQL Server - NOLOCK vs READPAST: Do you know the difference between the two?
- SQL Server 2014 - How to Estimate Progress and How Much Time Is Left to Create an Index
- SQL Server - How to identify how to change the default schema for database users
- SQL Server - How to use auditing to map actual required permissions on a user
- SQL Server - How to Identify Instance Initialization Parameters Using T-SQL
- SQL Server - What is the difference between @@ ERROR and ERROR_NUMBER ()?
February .. heat and month of Carnival! Still, 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!
- 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 Against Ransomware Attacks Like WannaCry on Your Database Server
- SQL Server - Using Calculated Columns (or Computed Columns) for Performance Tuning
- SQL Server - How to identify and collect time consuming query information using Extended Events (XE)
- SQL Server - How to Avoid SQL Injection? Stop using Dynamic Query as EXEC (@Query). Now.
- SQL Server - Understanding the Risks of TRUSTWORTHY Property Enabled in a Database
- SQL Server - When you should use ORDER BY in the query and when you should not use it at all!
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:
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.
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:
- SQL Server Security Checklist - An SP with more than 70 security items to validate your database.
- SQL Server - How to Connect Using Dedicated Admin Connection (DAC) Connection Without SQL Browser
- SQL Server - Permissions for Using OLE Automation (Yes, Documentation is Wrong)
And I posted the following videos on Planilheiros Youtube:
- [Core Course] Power BI Report Server - Class 1
- [Core Course] Power BI Report Server - Class 2
- [Core Course] Power BI Report Server - Class 3
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:
- 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:
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, I wrote the following articles:
- SQL Server - Statement (s) could not be prepared. Case expressions may only be nested to level 10
- SQL Server - Avoiding Queries on Certain Columns with Column Level Security (CLS)
- SQL Server - Useful DBA Queries You Always Have to Look for on the Internet
- Using Whatsapp and Telegram Safely and Avoiding Chat Intrusion or Leakage
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, 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.
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 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:
- SQL Server - Power BI Gateway issue using external IP or hostname to access database
- Using PowerShell and the API with Agent or SSIS to Automate Updating a Power BI Data Set
- SQL Server - Charindex: A Different Function to Break Split Strings
- Home Office without Achisms - Experiences of remote workers for over 1 year
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:
- SQL Server - How to Send Messages to Whatsapp Contacts, Groups, and Mailing Lists
- SQL Server - String or binary data would be truncated: What is, how to identify root cause and how to fix
- SQL Server - TCP Dynamic Ports vs TCP Port (Dynamic vs. Static Port)
- SQL Server - I changed Max Server Memory to 0 and now I can't connect to the instance
- Is SQL Server Configuration Manager gone? Learn 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 amazing year in every way!
See you next year!