DEV Community: Leonardo Gasparini Romão

A great feature in C# 9.0 (Simplified Parameter Null Validation)

Leonardo Gasparini Romão — Fri, 10 Jul 2020 15:11:40 +0000

Well, as C# advances, some features are been more simplified inside the language. One common problem that beginners programmers have is how to deal with nullable variables.

In the first versions of C# language, validate null values were very explicity when I was coding, eg...

public static void Main()
    {
        string Name = null;
        if(Name == null)
            throw new NullReferenceException
            ("Error, the name is null");
    }

After version 4.0 of .Net Framework, C# has gain some other interesting options to use. eg...


public static void Main()
    {
        //Using ?? Operator
        string Name = null ?? "Undefined";
        Console.WriteLine(Name);

        Name = null;

        //Using String Extension Mehtods
        if(String.IsNullOrEmpty(Name))
            throw new NullReferenceException
            ("Error, the name is null or Empty");

    }

But now with C# 9.0, I can simplify all of this with the !! Operator like:


public static void Main()
    {
        string Name = null;
        ManipulateString(Name);
        OtherManipulateString(Name)
    }

    //Using new ! Operator to throw exception
    public static string ManipulateString(string s!)
    {
        return s + " is a Valid string";
    }

    //Using new !! Operator to substitute null to other things like "" (probably)
    public static string OtherManipulateString(string s!!)
    {
        return s + " is a Valid string";
    }

although it is too early to validate whether it will be interesting to use this operator, in fact, it seems an interesting option to consider, despite not making it so explicit in the code, the economy of lines of code may be surprising.

Useful links:
http://www.macoratti.net/20/02/c_versao9.htm
https://www.infoq.com/news/2020/06/CSharp-9-Null/
https://www.c-sharpcorner.com/article/null-value-and-null-reference-handling-c-sharp6-to-c-sharp-9-new-features-day-1/

SQL vs NoSQL vs both options for Web projects?

Leonardo Gasparini Romão — Tue, 26 May 2020 18:47:43 +0000

I have a question involving the choice of database technology in a specific case.

SQL vs NoSQL is a common discussion about what Database suits better for developing web projects, and we already have a lot of articles explaining the differences, advantages/disadvantages of each type of Database like the articles below.

Database: SQL or NoSQL

Pankaj Thakare ・ Mar 11 '20

#sql #nosql #database #cap

Article No Longer Available

So, in the last years, I have seen people choosing NoSQL by default, just considering the scalability as the main precaution to use that type of Databases, but they disregard all the complexity to use an unstructured schema or disregard the other use cases that NoSQL is built for like support large teams with a lot of services (and the team choice NoSQL having only 5 members).

Recently, I saw an architecture diagram for a web project using both technologies in this link and I really liked to see both technologies being used to get the best of the two worlds.

My question is, is really necessary to use NoSQL as default choice only considering scalability issues rather than use SQL or a Hybrid Solution?

How to migrate SQL Databases to a new version

Leonardo Gasparini Romão — Wed, 18 Mar 2020 03:33:24 +0000

This post was part of a series talking about How to create a good architecture for SQL Databases:

How to versioning SQL databases architecture using GitHub and Visual Studio
How to organize SQL legacy Databases
How to debug SQL Databases
How to migrate SQL Databases to a new version server

It's common when we have legacy databases, to maintain not only the database as all infrastructure that supports it, like OS version or MSSQL version. But with time, new features are including in new versions of MSSQL, and these features can simplify some internal jobs that can be hard to do.

An example that I have, was when I working with a BulkInsert with different sources of CSV files that have different encodings like UTF-8, UTF-16, ASCII, etc...And my problem was to know that my version of MSSQL doesn't support UTF-8, and I didn't have the tools to upgrade the version. So I will show a good strategy to make these changes without problems. Other features are created with the years like:

Accepting JSON besides XML
Support to more encodings
Improve their Query Intelligence
Native BigData or BI software integration like Spark or PowerBI

So, we have some items that we need to be careful about when we make a migration...

1- Always have a support machine

It's impossible to change SQL version in the production server, impossible maybe it is not the best word but is impracticable to do this, so creating a new machine to put this new Data is the best option, besides, we can make tests before changing the machines.

2- Check all app that uses your Databases

If you need to migrate a database that is used to many applications, remember to copy not only data and Schema but:

Logs
Users (Username and Password)
Permissions
Jobs and Procedures
Folders
Files generated by procedures

This need to be precisely done, probably, you will have some issues in the first weeks after the migration.

3- Try to use SQL copy database wizard

Probably, Microsoft has to know what is the better strategy to migrate the database, so the SQL Management Studio does have a wizard to Copy the database to another server. This is interesting because we don't have to worry about some features that we can be forgotten when we make a migration. Microsoft has links to help with this, either by migrating to Azure or by another SQL server.

Migrate database it's not a trivial job, to make this we have to take proper precautions.

Useful links:
https://docs.microsoft.com/pt-br/sql/dma/dma-overview?view=sql-server-ver15
https://datamigration.microsoft.com/scenario/sql-to-azuresqldb?step=1
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15
https://stackoverflow.com/questions/31483452/store-nosql-data-on-sql-server

Speed up web scraping using C#

Leonardo Gasparini Romão — Tue, 17 Mar 2020 18:40:29 +0000

This article is a part of web scrapping series using c#:

How to web scrapping using C#
Speed up web scrapping using C#

Now we use parallels to up speed our web scrapping code. It's common to want multiple pages when we getting data from the web, and in the last article I use one page to test web scrapping but, if we need to get a large set of information, we need a better solution.

Use a single process looping all the pages will take so much time to get all data, so another option is use parallels. This is an example to use multiple processes to take data from the web:


var links = new string[] { "https://www.rottentomatoes.com/m/the_lord_of_the_rings_the_fellowship_of_the_ring",
            "https://www.rottentomatoes.com/m/the_lord_of_the_rings_the_two_towers",
            "https://www.rottentomatoes.com/m/the_lord_of_the_rings_the_return_of_the_king",
            "https://www.rottentomatoes.com/m/the_hobbit_an_unexpected_journey",
            "https://www.rottentomatoes.com/m/the_hobbit_the_desolation_of_smaug",
            "https://www.rottentomatoes.com/m/the_hobbit_the_battle_of_the_five_armies"
            };

Console.WriteLine("Gettting page from movie...");
Parallel.ForEach(links, new ParallelOptions { MaxDegreeOfParallelism = 4 }, link =>
    {
        using var Client = new WebClient();

        //Download Html from a Url:
        var HtmlRequestResult = Client.DownloadString(link);

        //Load HtmlString to AgilityPack Document
        var Document = new HtmlDocument();
        Document.LoadHtml(HtmlRequestResult);

        //Get movie title, critic score and user score
        var MovieTitle = Document.DocumentNode.Descendants("h1").FirstOrDefault()?.InnerText.Trim();
        var CriticScore = Document.GetElementbyId("tomato_meter_link")?.InnerText.Trim();
        var UserScore = Document.DocumentNode.Descendants("a")
            .FirstOrDefault(x => x.GetAttributeValue("href", "") == "#audience_reviews")?.InnerText.Trim();

        Console.WriteLine(string.Format(" Title:{0} \r\n Critic Score:{1} \r\n User Score:{2}", MovieTitle, CriticScore, UserScore));
    });

Console.WriteLine("Press any key to close the program...");
Console.ReadKey();

The console now prints all the movies, unordered because we are using multiprocess and with this, we have an different behavior for every link that we get.

Well, like any other multiprocess application, we now need to care about how to manage and control our parallelism level, because we can make the code use so much memory or CPU and slow down all our infrastructure, so be careful, besides, we need to have attention to the website that we visit, using multiple processes can be confused as a DDOS attack and block our code, so, don't push links so harder.

Useful sources:

How to web scraping using C#

Leonardo Gasparini Romão — Sat, 14 Mar 2020 20:20:18 +0000

This article is a part of web scrapping series using c#:

How to web scrapping using C#
Speed up web scrapping using C#

Web scraping is a useful skill to learn for getting data. We can get data from the web, to use for Data Analysis, Data Science or even to Learn some features of Web. So what is necessary to get data from Web?

HtmlAgilityPack

HtmlAgilityPack is a library to help getting information from Html pages. With this library, we can transform Html pages into strings and get some part of the entire text, using string methods or Xpath to search specific CSS classes. Here is an example to get page info using then.


Console.WriteLine("Getting page from Lord of the rings...");

//Download Html from a Url:
var HtmlRequestResult = Client.DownloadString("https://www.rottentomatoes.com/m/the_lord_of_the_rings_the_return_of_the_king");

//Load HtmlString to AgilityPack Document
var Document = new HtmlDocument();
Document.LoadHtml(HtmlRequestResult);
Console.WriteLine("Gettting data from page...");

//Get movie title, critic score and user score
var MovieTitle = Document.DocumentNode.Descendants("h1").FirstOrDefault()?
    .InnerText.Trim();
var CriticScore = Document.GetElementbyId("tomato_meter_link")?
    .InnerText.Trim();
var UserScore = Document.DocumentNode.Descendants("a")
    .FirstOrDefault(x => x.GetAttributeValue("href", "") == "#audience_reviews")?
    .InnerText.Trim();

//Show the results
Console.WriteLine(string.Format(" Title:{0} \r\n Critic Score:{1} \r\n User Score:{2}", MovieTitle, CriticScore, UserScore));

Console.WriteLine("Press any key to close the program...");
Console.ReadKey();

This is a simple example to get data from rotten tomatoes. It's common to see in the internet other examples, generally in Python using Beaultiful Soup to get data. Here, the strategy is the same as Python. The results are showed bellow and you can see the original page in this link...

So.. after this, you can improve your strategy to web scrapping, but this is a good start point if you want to learn how to get data from the web.

What languages I choose to learn and why?

Leonardo Gasparini Romão — Sat, 14 Mar 2020 19:18:05 +0000

The choice of the programming language can be the most important choice when you are starting to learn to program, and in most cases, is the main question in all debates involving software development. Well, I think that's interesting to show my decisions about my programming language choices and why...

1. Csharp

C# was not my first language but was the first language that I could make my first professional project in my career. I was started programming with C# in 2012, when WebForms was, unfortunately, the main web framework used in that time to develop web projects.
But C# has improved to be an excellent option now. With the creation of .NET Core, the framework is now independent of windows, and with this, erasing the Microsoft past when the company was avoiding OpenSource initiatives. bellow is why I choose C# as my principal programming language...

1.1 StackOverflow

In 2012, C# was the main language of questions inside Stackoverflow, and this helps me a lot because I had a unique source of information to ask questions and understand how I could make some code. Nowadays, I can't even think how my life will be without StackOverflow rs

1.2 Visual Studio

An IDE is an important thing to help any programmer to make the job quickly and the right way. In 2012 we have Java with NetBeans or Eclipse to develop some software, and I thought it was horrible to use then, Eclipse IDE was slow, heavy and always have an unknown problem. Visual Studio was an impressive choice comparing with others IDE because Microsoft always knew to make a good UX in theirs softwares.
Nowadays we have VS Code considered the most used text editor to write code, and the VS Community is a good option to have a complete IDE.

I'm still using C# as my main language, also, the language extended to other worlds beyond enterprise software such games with Unity, Machine Learning with ML.NET, and Mobile Apps with Xamarin, so I can honestly say that I'm very glad to have chosen C# many years ago 😄 .

1.3. Jobs

A few years ago, here in Brazil, Java and C# still were the most used languages in companies, probably, this is changing with mobile apps and the popularization of Python for DataScience/MachineLearning projects and JS with Node, but we still don't have changed at all so, we still have great jobs with the "traditional" languages. And I'm unconsidered some old languages like VisualBasic or COBOL because learn then was probably a BAD choice, and when I'm checking the data about what is the most programming languages hated, I'm certain that these languages were really not good options. Next, my other chosen language

2. Python

I started to learn Python in 2017 as an option to learn Data Science, Python was growing absurdly in the last few years and this is incredible, we have so many questions in StackOverflow involving Python, but there are more points involving why I choose Python as my second language.

2.1 Jupyter Notebooks

As I said about Visual Studio, Jupyter Notebooks for me was an incredible software to build projects involving Data Science, Jupyter was a different way to put value in our code merging with text like a word document. The possibilities to use Jupyter are so great that big companies and software was putting notebooks in their environment like Microsoft in VS Code, Amazon with AWS or even IBM with Watson Machine Learning Studio.

I'm glad to choose those languages, they were useful to learn some skills that turn me a developer. Even some other languages have their advantages like JS with React Framework or Swift to make Great apps in IOS, C# and Python have some others features that I prefer, so, even this languages was not in your options, that's OK, but if you considering learning a new programming language, this options can be a great choice. And you, what languages you choose and why? \o

Class vs Dynamic vs Tuple in C#

Leonardo Gasparini Romão — Thu, 05 Mar 2020 18:01:23 +0000

Nowadays, with c# 8.0 we have a lot of options to make code, with all these options, it is hard for the first time to know-how is the best option to use when we create complex objects.

With a functional approach inserting more and more in .NET framework, some people use less code thinking in class and object or using an Object-Oriented approach (when all is an object or a Class).

This is more evident with the new data structure "Tuple", inserted in c# 7.0.

But how and when I choose between Class, Dynamic or Tuple? Well, we have some options here...

1. Class

Real classes are very useful when we use a DDD approach to architect our systems, creating a class is very simple, just create a new file in your project and we can create our class to make instances of then after

public class Person
{
    public string FirstName {get;set;}
    public string LastName {get;set;}
    public int Age {get;set;}
}

Classes are very useful to prevent duplicates in your code, besides, we have a lot of documentation of software architecture, design patterns, SOLID teaching how we can organize classes to reduce the complexity of our code. Real classes are evident when a new programmer is analyzing our code.

2. Anonymous Type Object

Anonymous is a feature introduced in c# 3.0 to create complex structures in real-time, with a name and a value, eg...

var Person = new 
{
   FirstName = "Leonardo",
   LastName = "Gasparini",
   Age = 26
}

Anonymous types are useful when we deal with Linq operations to select some properties in our program we did not reuse that code in other parts eg...

var PersonCompleteNameList = Persons.Select(Person => new{CompleteName = Person .FirstName + " " + Person.LastName})

Anonymous types have a lighter structure comparing with classes because we don't have many options to create constructors or functions inside dynamic. I like to use dynamic when I working on with JSON objects that change all the time and I work on it in a few methods

3. Tuple

A tuple is a data structure introduced as a feature in c# 7.0. Tuples are common in other languages like Python to manage complex types without a class. here an example of a tuple

//Unamed tuple
var Person = ("Leonardo", "Gasparini", 26);

//Named tuple
Person = (FirstName: "Leonardo", LastName:"Gasparini", Age:26);

Tuples are not very different a dynamic when we use a named type, but tuples can be lighter than dynamic because we don't need to name properties of the tuple, besides, comparison of tuples are more easily to do comparing to dynamic and are useful when we need a return a value inside a method.

Which of this I choose to my next project?

And the answer is...depends. this is an example that code does not have a single way to learn and use, c# have all these options to make easier any type of programmer to feel comfortable with the language. Even with some differences and advantages among then, is possible to assume that all these options are a good suit to programming...

Some useful links:
When to use: Tuple vs Class c# 7.0
Value Tuples Vs Anonymous Types Performance
What are the advantages of declaring anonymous type Object ?

Forget Agile if you don't think about CULTURE

Leonardo Gasparini Romão — Thu, 05 Sep 2019 03:34:40 +0000

Nowadays, with Agile being sold as a product with many different versions of Agile or important Software Engineering people talking about leaving Agile, I thought that you need to look at an interesting point within organizations, which if your company doesn't is willing to Changing the way you act and behave in the face of a project's adversity is no use trying to implement any Agile model.. In other words, make sure your company culture has no problems before you think of Agile.

The importance of Organization Culture

Jeremy Andrus, Traeger CEO, Source: Pintrest

The Company Culture, is one of the most important points for a good functioning of the organization, after all, are the practices, behaviors, principles and mindsets that make up this culture, which will give the guidelines on how the company should follow to obtain the desired results.

But a few months ago, reading a Jeremy Andrus HBR article about his challenge to remove an entire toxic Traeger culture, and starting one from scratch by becoming CIO, made me think that by trying to use modern development models, To improve our software development results, we don't realize that the real problem may simply be the company's culture.

It's no use trying to bring Scrum to the company if the culture within your company behaves like a Manufacturing, with stiffened products, no direct customer tracking, and no planning on how to evolve your product, iteration by iteration. It's no use trying to use the benefits of XP, if your business doesn't bother to make the lives of its employees simpler while delivering acceptable results to its customers it conceives the idea of iterations.

Sometimes development models considered abominable today, such as the Cascade Model, will be the least conflicting within your company, and if that's your case, then it's definitely not the Agile that will save you.

What changes can we then make?

Running a business is not easy, especially if we have a problematic culture within it, organizational cultures, as well as cultures of a country, are almost unchanged unless good ideas, time and resources are really invested for such a challenge. But at least I can propose some actions that may be beneficial in this process:

1 - We need to abandon the traditional manufacturing model

Source: Google

Many companies still follow a pattern of behavior inherited from the big factories of the industrial revolution, but this model is terrible when we try to apply it to software development. Software is not like cars where if something goes wrong, you have to stop the entire factory, recall the products, and review the project from the start.

A good analogy I've heard is treating software like cooking in a restaurant. Your challenge is to deliver a plate (software), even with minor errors, or some delay, is better than delivering no plate, or returning it to the kitchen if the customer does not like it. And as you see how the customer reacts and opines about this dish, deliver a more robust dish.

2 - Your Culture needs to understand that agile methods are designed to make the programmer's work less complicated and stressful.

Applying Scrum consequently brings a better result to the customer, but it is not a direct benefit to him. As in the restaurant analogy, Agile would be like cooking and improving the process doesn't change the customer's perception of your product, so the programmer gets the benefit.

But that's great, changing a culture that understands and behaves to help the developer's work is a great way to not cause demotivation or stress, things that are not lacking in the market today.

3 - Your client needs to be actively with your team.

Source: Dibble, Artist: DeeKay

This is a principle widely used by Scrum. Being around to help get the development team on track helps reduce the stumbling blocks that can occur midway.

Modern applications like Netflix, Ebay or PokemonGo. They are nothing more than ideas that have been transposed into an application to generate value for your customers, be it money or entertainment. It does not have to be perfect on first delivery, with all of its functions being delivered at once.

These changes go directly to the principles that the agile manifesto proposed, simplicity, evolution, and engagement. If these things are within your company culture then you can be more relaxed, you're on the right track.

Sources:
Agile is cooking, Scrum is just a recipe, and the team is a restaurant.
Traeger’s CEO on Cleaning Up a Toxic Culture
Agile Manifesto

*This article is in Portugesese in "Esquece AGILE, se você antes não se preocupar com Cultura." on http://encaixandoblocos.com

Forget that AI is future, AI is NOW!

Leonardo Gasparini Romão — Mon, 15 Jul 2019 23:36:17 +0000

This article is in Portuguese here

After a few months learning about Machine Learning and participating in the Behind The Code development marathon offered by IBM here in Brazil, in the course of the challenges I was amazed at how big companies are creating AI solutions that are so simple to implement that we do not need them any more. a line of code for it!

Taking AI from gods and giving to humans

"He was a defender of humanity, known for his clever intelligence, responsible for stealing the fire of Hestia and giving it to mortals."

Wikipedia Brazil about the Greek Mythology of Prometheus

Python, R, Julia, hours and hours of reading posts, books, articles, watching the most diverse videos and watching classes until I understand a little of this incredible universe that is AI. But now and then I wondered if it would be possible for AI to become something simpler, because it now seemed that it was necessary to be an extremely skilled professional, almost a "God" of mathematics and programming, so that one could work with AI, but it seems that this is already changing and like the Promethean legend, the AI is coming out of "Olympus", and being delivered to "mortals."

While True: Learn was the first idea that showed me how AI could be simpler, the game teaches you through streams like creating classifiers. In it, you are a freelance programmer who performs the most varied work of ML.

The works are very similar to real-world problems, in addition to the game provide content to learn how it works in real-life game models, if you want to see more about the game it is for sale on Steam here.

Life imitates art

IBM Watson Studio with Machine Learning

IBM with Watson, Microsoft with Azure ML Studio, Jupyter with Jupyter Labs, several platforms are creating ways to make AI no longer a complex thing to do.

Instead of hours writing lines of code to assemble a predictive model, use flowcharts to assemble your model. When working with Watson Studio, and realizing that without a line of code I could create an excellent classifier of image recognition was something amazing.

With this, you realize that now, AI is now for all . Over time, more and more areas will benefit from this, these platforms are taking away the need to have a highly skilled Data Science professional and providing resources for practitioners from other areas such as medicine, economics, biology to be able to use AI to their pleasure . And that breakthrough was in a matter of a few years, which surprised me most in this process.

Watson Creating as classes for training from images in .zip files recognizing each type of dog.

The challenge of AI is not so simple either

"Making simple the complicated is easy, making the complicated in simple, this is creativity"
Charles mingus

Of course, those who possess a theoretical ML bag can create better predictive models as needed. We can not forget that these platforms are abstracting complications so that people who are not IT area can take advantage of AI, but they are platforms of support.

Asking the right questions about what your data can show is a challenge that will still require of our heads, in being creative and innovative so that we can extract intelligence from the data that we have, in the end, the work is still ours.

But now the competition is changing, now it's no longer the best Data Scientist or ML Engineer, but whoever collects, organizes the best data and asks the best questions on these data. Now the important thing is guidelines and data sources that will be used.

But seeing all this, I see how Data Science has evolved in such a short time, the future looks bright, and it ends up making me very excited, as they always say, technology has come to stay haha.

Sources:

https://luden.io/wtl/
https://www.ibm.com/watson/br-pt/
https://en.wikipedia.org/wiki/Prometheus

If you wanna learn data Science before coding, try this book.

Leonardo Gasparini Romão — Mon, 24 Jun 2019 23:33:08 +0000

As clumsy as I am, I have lost count of the books I read, I believe I am between the seventh and eighth at the time I am writing this publication, but I am happy to have finished one of the books that may be the most painful on the head this year, I'm talking about the
Data Science for Business Tom Fawcet's book, which although I liked much of the experience of having read this book was not as much fun as I thought it would be.

1. Putting the pieces together

Well, before my analysis makes you change your mind about getting this book or not, I'll say for my experience as a programmer,, this one book was worth buying.

"Success in today's business environment, requires the ability to think about how these fundamental concepts apply to certain business problems - think analytically in data ".

- Data Science for Business

Like other people I've heard of this book, I've understood it to be great for managers, directors, or leaders who need to understand how to evaluate a Data Science professional and how to hire them. You end the book by understanding how various Data Science concepts work, and at the same time you apply them to those who already work in that area, the book may present some Insights interesting.

2. The other hand

However, as the book itself says, it's not a technical book, not that it's a problem, on the contrary, maybe that's the best thing about this book. What might have given me some discomfort to read it, was that the book is not as educational as I thought it would be.

The examples presented in this book are great, they are based on real events and it goes very well to explain them, but perhaps the lack of visualizations and metaphors made me have to think hard about what I was reading. there are other books that are very good at bringing the reader with metaphors, such as Understanding Algorithms by Aditya Y. Bhargava.

Perhaps this has happened to me, because Machine Learning and Data Science are not at all trivial matters, which require a certain commitment from any professional who wishes to learn about it. It is possible that with other books that have a more didactic proposal make me understand and enjoy the book much more. Or it has been a loss of my expectation.

Another problem of this book is perhaps the size, not that it could be different, after all it has a fair size to explain so many concepts, though I believe that if he separated the book into 3 parts, explaining to the reader that he should perfectly understand each part to go on, it would feel better when I was reading.

3. In the end, all be alright

I was pleased to finish this book, it took me a long time but it was not a complete waste, unfortunately I may have to revise it when it is more used to the Data Science universe. The good thing about this book is that for an already savvy professional, it's objective and accurate in all its applications, so a statistician or a more experienced programmer with this area of data analysis will probably love this approach.

My recommendation: If you are new to the area of statistics and Big Data, I suggest you read only the chapters pertaining to the work of Data Science, then read other more didactic books on mathematics for Data Science and after much practice re-read it. If you start with this book, there's a good chance you'll get frustrated. Keep this book fondly, but speaking of analogy, treat this book as the Nemesis of RE3, you will have to face it several times, but only after a while will you be ready to defeat it.

Developer, do you want more satisfaction: be social and earn time

Leonardo Gasparini Romão — Sun, 14 Apr 2019 20:55:51 +0000

Reading this month's edition of the HRB, if you have a topic that is being discussed today is emotional intelligence, companies and professionals increasingly seek answers to the confusion of our mind, How can we have more satisfaction with ourselves and in companies? How can we have our healthy mind amid so many conflicts that we have nowadays? How to stop us from having Burnout? These are just small questions that companies try to solve so that we have less dissatisfaction and unhappiness with our routines, after all, nowadays the main phrase of the movie "Fight Club" has never been as present as today:

"We are the middle children of history, without purpose or place. We had no great War, we had no Great Depression. Our Great War is the spiritual war, our Great Depression is our life. We Were created by television to believe that one day we would be rich, movie stars and the globe. But we won't be. And we're gradually learning that. And we are very, very angry. "

Well, at least we learned a few things to solve our dissatisfaction, and by putting it in the T. I scenario, there are two things that we developers usually have a little bit of disability:

Be Sociable

We Have to admit, we are very sociable animals, we need to reserve time to see our friends, family, even strangers so that our day-to-day looks better. Volunteer Work, group activities, even a book club. At the end of the day, we need people, after all, some articles even say that loneliness can do us more harm than sedentarism and poor nourishment.

Sociability is not our strong

If There is one thing that really is not our forte is sociability, a study of the professional personality of the T. I area shows that our strong is not sociability, but we need this challenge, we need to learn to have more sociability in our routine, with Our co-workers, with the people in our neighbourhood, and people we barely know.

Learn to earn more time than money

Our area has the privilege of currently having lots of demand and having excellent wages, if we analyze, our area is excellent for those who want to have a solid career and with fast results, but if there is one thing our area does not learn, it is to gain time, after all, many of We have already gone through the need to stay later to deliver a project on time, a feature, a new component. Although we have a good financial return with overtime, the most recent studies seem to not compensate to spend our time.

We can save time out of office

We Have many activities we do not like to do even out of office, well people who hate shopping in the market or ironing clothes or dust from the house, or cooking. To save our time outsourcing activities like these, while we can use this time for our leisure, socialize or even have the fullness to do nothing can give us a much better financial return than a few extra hours.

[Conclusion]: It Seems that we are now learning about how our emotions shape us, and as developers, we need to find solutions to control them just as we find solutions to develop new systems. At least now we have a north, so give value to your time, because once spent, we can't recover it .

Sources:

https://hbrbr.uol.com.br/vale-a-pena-trocar-dinheiro-por-tempo/
https://www.cnn.com/2017/09/11/health/sitting-increases-risk-of-death-study/index.html
https://www.amazon.com.br/Managing-Yourself-Measure-Clayton-Christensen/dp/1422157997?tag=goog0ef-20&smid=A1ZZFT5FULY4LN&ascsubtag=go_1494986073_58431735035_285514469186_aud-519888259198:pla-485032980911_c_

How to debug SQL Databases

Leonardo Gasparini Romão — Sat, 06 Apr 2019 12:29:33 +0000

This post was part of a series talking about How to create a good architecture for SQL Databases:

How to versioning SQL databases architecture using GitHub and Visual Studio
How to organize SQL legacy Databases
How to debug SQL Databases
How to migrate SQL databases to a new version

First, we set up an environment for database version control, then we work on creating a new framework to organize the code we created on the server, now let's talk about another feature that we can use in our databases to us Help, debugging.

Debugging in Database

That part was weird to me because I've never seen anyone debug in a database for the obvious reason: The debug mode is much less performative. But, debug is a tool that most programmers do not live without now, and I think I could not solve 90% of problems with programming if I had not debug. A Microsoft article explains very well the walkthrough to have this feature on your SQL servers.

So, how to bring such an important resource to databases without compromising performance?

Strategy: Prepare multiple environments

Separate development environments when we talk about systems, companies already adopt the idea of having development, homologation and production environments. These environments allow us to make a transition from new functionalities in a less problematic way, even though the deliveries are somewhat bureaucratizing. With the development environment, we can work freely in the debug of apology currencies and jobs quietly, only this will already help a lot the work of scheduling new features and doing maintenance on possible bugs. An article in
Medium explains this process very well.

Synchronize production data with the development

It Is important to remember that we need the data updated with the development environment if we always want to have the best real proof of new functionality or the errors our base may be experiencing. This synchronization can be instantaneous or scheduled but if possible have it prepared.

Adding another database to my infrastructure can be very expensive

Nowadays, robust databases do not have a few bytes of information, on the contrary, the largest technology companies are playing with PETA bytes of data, making transfers and analyses in real-time and massively. With our current scenario, having disk space in a robust infrastructure to develop software, it can be very expensive, even more, if we want to have environments as close to production as possible. But the local infrastructure to work with the database is becoming something much cheaper as it spends the years. Open-source infrastructure, storage, and data processing Solutions are increasingly appearing in the world. Database-specific cloud computing Solutions then dropping to the public's liking so enabling you to work with more resources. So spend some time analyzing how to align the cost of your infrastructure so you have multiple environments.

These suggestions, plus the other parts of this article, you will have a much more robust and prepared environment for the organization routine, less prone to failure and more organized.