Deisbel (Sr. Software Developer) @deisbel Twitter profile | Pikagi

Pikagi

Deisbel (Sr. Software Developer)

@deisbel

5,687

Followers

195

Following

248

Media

5,533

Statuses

Sr. Full-Stack Developer for 20+ years. Cloud, DB, AI, and learning new things are my passions. Every week I share experiences, tips, and how-to-do

FL, USA

https://t.co/Xpq0xy4Tur

Joined June 2009

Don't wanna be here? Send us removal request.

Pinned Tweet

@deisbel

Deisbel (Sr. Software Developer)

1 year

I don’t want to be a front-end developer only. I don’t want to be a Backend developer only. I don’t want to be a DevOps or Cloud developer only. I don’t want to be a Data engineer only. I've been, I am, and I'll be a Full-Stack developer, working in parallel or switching

20

8

144

Last Seen Profiles

@Vinu331001

@mushroomsandivy

@HIIT

@stars4l4ni

@priewwix

@beefdaddy4

@CukiPep89782505

@bokeplokalmalam

@stw_pdg

@bokeplokalmalam

@Vagner55512641

@VaunTheSeer

@MAD_Vrsner_NT

@pedromtobias

@USASARegion4

@AethirEdge

@AlanFlower91154

@murphytrueman

@stw_pdg

@perez_main35837

@stwmaniax

@ng_regl

@waanu_buur

@_drekgz

@bokeplokalmalam

@killeards

@stw_pdg

@MsGollygee7

@aaronluvsutah

@bokeplokalmalam

@regbourke

@VicNachos

@sopnendu

@stwmaniax

@stwmaniax

@NGPUKgp

@deisbel

Deisbel (Sr. Software Developer)

10 months

This is one of the best books you can read. Clean Code. Even bad code can function. But if code isn't clean, it can bring a development organization to its knees. This book is a must for any developer, software engineer, project manager, team lead, or systems analyst

Tweet media one

32

107

781

@deisbel

Deisbel (Sr. Software Developer)

9 months

Database design and data skills will never become obsolete. Spend time on these two skills, and you will never regret it.

23

73

591

@deisbel

Deisbel (Sr. Software Developer)

10 months

I’ve been designing databases for +20 years. With time, I learned the best DB design is the fastest and that I can’t get it just by following all design ‘rules.’ These are the 8 design rules you must learn to break. Sometimes: 1- You can have some data redundancy and

20

68

433

@deisbel

Deisbel (Sr. Software Developer)

8 months

My 9-year-old son asked me: “What is Dependency Injection?” He understood the concept from my very first explanation. This is how I did it: Imagine a Home Service company frequently having this situation: A client has a Plumbing appointment, and they send a Plumber to his

15

62

403

@deisbel

Deisbel (Sr. Software Developer)

9 months

In my last 3 job interviews, a database question has been constant: What is a Clustered Index? This knowledge is critical for performance. If you fail this question, you are out for sure. But, I disagree with rejecting a candidate for this reason. Let me explain why. First,

12

59

383

@deisbel

Deisbel (Sr. Software Developer)

1 year

When you start a project I recommend you follow this strategy: Create high-level code covering your functionality as much as possible. High-level code here means just naming the classes and methods you will fill out later. Then, start linking your pieces, creating your

17

48

333

@deisbel

Deisbel (Sr. Software Developer)

1 year

My friend built an app, but it became a nightmare. He did not anticipate that his users frequently needed to recover deleted information. He came to me for help. I asked him only one question: What Deletion strategy did you implement in your Database? When users delete data

34

41

334

@deisbel

Deisbel (Sr. Software Developer)

1 year

Databases are not intended for storing data but for storing relationships. Relationships are what make Entities worthy. Your main goal in designing databases is to identify Entities and Relationships between them. I show here the types of Relationships and how to store them.

15

56

313

@deisbel

Deisbel (Sr. Software Developer)

6 months

Imagine a customer doing a bank transfer: She extracts money from one account and deposits it into another. Imagine the transfer failed, then she checks her accounts, and the money is not in any of them. Imagine you were the developer, and you got fired! A simple TRANSACTION

Tweet media one

19

56

298

@deisbel

Deisbel (Sr. Software Developer)

7 months

A follower asked me: Why are Relational databases (RDBMS) not a good fit for horizontal scaling? Why are NoSQL databases a good fit? I will explain it like talking to a 5-year-old kid. You can translate or understand “Horizontal Scaling” like moving your stuff from one

17

59

299

@deisbel

Deisbel (Sr. Software Developer)

8 months

My friend built an app, but it became a nightmare. He did not anticipate that the users frequently needed to recover the last deleted information. He came to me for help. I asked him only one question: What Deletion strategy did you implement in your Database? When users

15

34

277

@deisbel

Deisbel (Sr. Software Developer)

8 months

Scrum is a process hated by many people. Scrum evokes strong feelings and fierce debates. I propose 5 improvements to save it: 1- No more mandatory daily meetings for all members. By default, if you need to coordinate with someone else, you put a message on the general chat.

26

21

271

@deisbel

Deisbel (Sr. Software Developer)

9 months

A software developer career is hard, overwhelming, and sometimes discouraging. The list of languages, frameworks, databases, patterns, tools, and clouds is endless. For 20+ years, I have given 6 tips to developers to learn faster, And, ... they did! 1- Do not put too much

15

49

266

@deisbel

Deisbel (Sr. Software Developer)

11 months

Imagine a client doing a bank transfer: She extracts money from one account and deposits it into another. Imagine the transfer failed, then she checks her accounts, and the money is not in any of them. Imagine you were the developer, and you got fired! A simple TRANSACTION

Tweet media one

6

58

273

@deisbel

Deisbel (Sr. Software Developer)

1 year

Poor Database performance is a death sentence for your Service or Application. Many tutorials give you tips to improve your performance using only single-column Indexes. Here, I’ll go further than 99% of them. I will present 4 examples and give you 3 new lessons. Example 1:

9

45

261

@deisbel

Deisbel (Sr. Software Developer)

5 months

I’ve been designing databases for +20 years. With time, I learned that the best DB design is the fastest, but we can’t always achieve it by following all the “rules” These are the 7 design rules you must learn to break: ** Sometimes ** 1- You can have data redundancy and

11

45

252

@deisbel

Deisbel (Sr. Software Developer)

9 months

One of my friends lost a great job opportunity in 2023. He failed a simple question during his interview: What is a Surrogate Key in databases? He didn’t know, even when many of his previous projects had Surrogate keys. Let’s explain Surrogate keys in 5 points: 1- A

10

38

238

@deisbel

Deisbel (Sr. Software Developer)

5 months

CI/CD Pipelines and DevOps sound obscure and scary. But after reading this post, you will be ready to build your first pipeline. You only need to respond to 4 simple questions and create steps or actions for them: 1- What Code repository and branch contains your project's

Tweet media one

5

29

242

@deisbel

Deisbel (Sr. Software Developer)

11 months

@TheJackForge MacBook Pro to code??? I thought it was only for content creators who believe they are developers! 😂

9

4

235

@deisbel

Deisbel (Sr. Software Developer)

9 months

Here is the process to design the perfect database: 1- Design your database following the rules you learned at school. 2- Make sure you normalize every table. 3- Write a simple script that generates millions of fake rows. 4- Identify the most important queries that your

9

43

232

@deisbel

Deisbel (Sr. Software Developer)

8 months

If you want to be promoted or get a raise, focus your energy on these 6 skills: - Be proactive; be part of the solution. - Learn to identify risks and failures quickly. - Respect others' opinions but question everything. - Identify improvements and propose how to implement

8

34

219

@deisbel

Deisbel (Sr. Software Developer)

9 months

To design a good Relational Database, you must follow some rules. To achieve exceptional performance, you could need to break them. Using an eCommerce website example, I will show you how introducing data redundancy and denormalization could be a game-changer. Let’s go through

Tweet media one

Tweet media two

Tweet media three

Tweet media four

12

31

209

@deisbel

Deisbel (Sr. Software Developer)

1 year

Stop implementing complex strategies to improve performance. Dockers, Scaling, Load Balancer, Cache: every single one of them will only succeed if you put the focus on your Database Indexes first. This is the best guide about database indexes you’ll read this year. Here is

9

22

197

@deisbel

Deisbel (Sr. Software Developer)

11 months

The 10 most essential concepts in relational databases: 1- Entity 2- Key 3- Index 4- Relationship 5- Relationship Cardinality 6- Foreign key 7- Data integrity 8- Normalization and Data redundancy 10- View Every week, I post about them, using real-life examples. If you want to

2

33

194

@deisbel

Deisbel (Sr. Software Developer)

1 year

@Lauramaywendel Please, tell him about things called Virtual Machines and Docker. 😁

11

2

190

@deisbel

Deisbel (Sr. Software Developer)

2 years

I asked ChatGPT to generate a DB model with this information: "Design a DB model for managing a parking lot where I need to know the number of days each car has been parked and also the total charge for each month based on the hourly cost" The second iteration was impressive!

7

20

184

@deisbel

Deisbel (Sr. Software Developer)

3 months

@svpino 99% of the issues my coworkers face in work happens because they are running Linux and Mac. Windows users have no idea how hard is the life of a Azure and Visual Studio developer in Mac and Linux. 😜

9

0

173

@deisbel

Deisbel (Sr. Software Developer)

5 months

"Clean Code" is one of the best books you can read. Even bad code can function. But if code isn't clean, it can bring a development organization to its knees. This book is necessary for any developer, software engineer, project manager, team lead, or systems analyst interested

Tweet media one

3

33

177

@deisbel

Deisbel (Sr. Software Developer)

7 months

Here is how you can make your database queries perform 10x faster: Using indexes. But, it is more complicated than it looks: - No clear rules exists. - Different queries on the same data model will require different indexes. I’ll show you two key techniques for creating the

7

19

174

@deisbel

Deisbel (Sr. Software Developer)

10 months

One year ago, I passed many rounds of Interviews. One frequent question was: How do you protect your services against DoS attacks? A Denial-of-Service (DoS) attack is meant to shut down a machine or network by flooding the target with traffic or information that triggers a

4

18

164

@deisbel

Deisbel (Sr. Software Developer)

5 months

Deploying your websites using Pipelines is no longer a privilege for the backend people! This is an example of a CI/CD pipeline deploying an Angular Website, explained step by step. In this case, I'm using an Azure Static Website (at the end, an App Service) designed for

Tweet media one

7

19

169

@deisbel

Deisbel (Sr. Software Developer)

9 months

If you want to become a Sr. Developer, you need a process to deliver consistent results. After 20+ years, I develop faster by splitting my work into 4 groups. Here is how I organize my full-stack work. 1- Spyke and POC. - I read the basic documentation, looking for what I

6

29

168

@deisbel

Deisbel (Sr. Software Developer)

9 months

When designing databases, your decisions must be oriented to performance and simplicity. Common practices are common until you decide the opposite, which is not wrong. These are 2 of my favorite uncommon design decisions: 1- Skip CRUD operations. 2- Skip small tables in favor

9

23

160

@deisbel

Deisbel (Sr. Software Developer)

10 months

CD-CI, Pipelines, and DevOps sound obscure and scary. But no longer! After reading this post, you could build your first pipeline and answer more questions in Interviews. You only need to respond to these 4 questions and create steps or actions for them while creating a

Tweet media one

5

40

156

@deisbel

Deisbel (Sr. Software Developer)

7 months

Building software based on a messy database will become a disaster. Using a unified strategy for naming database resources is crucial. This is the naming convention I have used with all the teams I’ve worked with for 20+ years. Table names Always the name of the Entity or

7

26

152

@deisbel

Deisbel (Sr. Software Developer)

9 months

Logs can be your best ally but also your worst enemy! I learned this the hard way after one of my services handling millions of requests crashed. That day, I learned 5 lessons about Logs I will never forget. I spent hours looking at weird error messages with no luck until I

5

22

147

@deisbel

Deisbel (Sr. Software Developer)

8 months

SQL is the most used language to query data. It was created for Relational databases and later ported to NoSQL DBs. Use these 7 steps in order if you want to start mastering SQL. 1- Learn Data Query and Manipulation language (SELECT, INSERT, DELETE, UPDATE) 2- Learn Data

3

17

126

@deisbel

Deisbel (Sr. Software Developer)

8 months

Stop implementing complex strategies to improve performance. Dockers, Scaling, Load Balancer, or Cache will fail if you do not put the focus on your Database Indexes first. This is the best 2-minute guide you can read about Indexes. Why Indexes? Lack or poorly designed

5

21

119

@deisbel

Deisbel (Sr. Software Developer)

1 year

Scrum is doomed. It can't survive so many detractors. I propose 3 improvements to save it: 1- No more mandatories standup meetings. By default, if you need to coordinate with someone else, you put a message on the general chat. 2- No more abstract Story Points. Simply hours

27

4

120

@deisbel

Deisbel (Sr. Software Developer)

10 months

Front-End + Back-End = Full-Stack Full-Stack + DevOps = Perfect-Pack

7

10

113

@deisbel

Deisbel (Sr. Software Developer)

10 months

Lazy to learn SQL? This is your minimal guide. You will solve 90% of the SQL use cases with these 10 statements: 1- CREATE TABLE t1 (c1 INT NULL) 2- ALTER TABLE t1 ADD c2 INT NULL 3- ALTER TABLE t1 ALTER COLUMN c1 VARCHAR(10) 4- INSERT INTO t1 VALUES ('c1value', 10) 5-

6

24

117

@deisbel

Deisbel (Sr. Software Developer)

10 months

This is the introduction to the book Clean Code, which I shared last week. This is really funny, but I can't agree more. Code quality's best measurement is WTFs by minute.

Tweet media one

8

22

114

@deisbel

Deisbel (Sr. Software Developer)

6 months

A naming convention for Database assets is crucial, but more is needed. Following consistent SQL script style and format is essential as well. I have shared this 10-point style convention with every team I’ve worked with for over 20 years. Let me describe each point based on

Tweet media one

5

10

112

@deisbel

Deisbel (Sr. Software Developer)

7 months

10 most essential concepts in relational databases: 1- Entity 2- Key 3- Index 4- Relationship 5- Relationship Cardinality 6- Foreign key 7- Data integrity 8- Normalization and Data redundancy 10- View I post about these concepts every week using real-life examples.

6

15

112

@deisbel

Deisbel (Sr. Software Developer)

1 year

The 5 biggest lies in Scrum. 1⃣ Scrum is Agile. But you can only introduce urgent tasks into the Sprint after meetings and negotiations. 2⃣ Standups are the most important meetings and will last only 10-15 minutes. But they last more than 15 min and used to be boring and

13

11

109

@deisbel

Deisbel (Sr. Software Developer)

7 months

The 7 essential concepts in SQL you need to master: 1- Views 2- Stored Procedures and Triggers 3- Filtering and Joining data 4- Grouping data and Aggregate functions 5- Subqueries and Recursive queries 6- Query Execution Plan and Optimization 7- Transactions and Error Handling

9

17

104

@deisbel

Deisbel (Sr. Software Developer)

7 months

Imagine buying a plane ticket and arriving at the airport, but the flight does not exist. Then, you open your app, click on the ticket, and get the message "Flight not found." How can you explain it? Simple: with an incorrect or incomplete Database Design; one with no

7

22

100

@deisbel

Deisbel (Sr. Software Developer)

1 year

@catalinmpit I past my 40 and still coding like the first day. I can't imagine my life without coding yet.

3

0

98

@deisbel

Deisbel (Sr. Software Developer)

8 months

Being a full-stack developer is a blessing. Do not get stuck in only one side of the equation. This is why you must try hard: Yesterday, I changed my API data model (DTOs) and endpoint definitions twice. - I didn't need to negotiate the scope/changes between Front-End and

10

7

92

@deisbel

Deisbel (Sr. Software Developer)

1 year

Here is how you can make your database queries and performance 4x faster: Use indexes. But, it is more complicated than it looks: - No clear rules exist. - Different queries on the same data model will require different indexes. Here is how you can do it. Imagine you have

4

12

92

@deisbel

Deisbel (Sr. Software Developer)

7 months

Databases are not intended for storing data but for storing relationships. Relationships are what make Entities worthy. Your main goal in designing databases is to identify Entities and Relationships between them. I show here the types of Relationships and how to store them.

5

18

92

@deisbel

Deisbel (Sr. Software Developer)

10 months

Going to a Tech Interview is hard. How to secure Web APIs? This question looks easy and obvious, driving us to omit important details. Never omit any of these: - Keep your platform up to date - Secure folder permissions - Use Firewalls - Use HTTPS - Use secure access and

5

14

89

@deisbel

Deisbel (Sr. Software Developer)

8 months

@svpino For issues StackOverflow is still my go to platform, via Google. When I google is because the issue is something weird and unexpected. ChatGPT is not good with the unexpected.

2

2

86

@deisbel

Deisbel (Sr. Software Developer)

6 months

Normalization in Relational Database Design means splitting data into multiple tables to avoid repeated information. Consequently, the most common task in queries is JOINING them back. Let’s elaborate on some examples to show you the available options using SQL: The basic

5

12

86

@deisbel

Deisbel (Sr. Software Developer)

1 year

@TheJackForge @catalinmpit I prefer to start looking while having employment. Honestly, the feeling to get laid off is not pleasant at all. And the pressure to get the new work (income) could guide you to make wrong decisions, or in the best scenario, not the best ones.

4

0

85

@deisbel

Deisbel (Sr. Software Developer)

1 year

Weeks ago, I asked ChatGPT 3 to generate a DB model for a Parking lot. The result was pretty good. Today, I made the same request to ChatGPT 4. The results were mind-blowing! I'm now really scared about the future of developers. See below; you won't regret it. 💥👇💥

5

10

83

@deisbel

Deisbel (Sr. Software Developer)

8 months

What is next after learning Relational databases and SQL? 1- NoSQL 2- Getting extra expertise in DB. Below, you can find my 4 suggestions for each one. NoSQL in 4 steps. 1- Get familiar with JSON files first. Accepted data types, nested properties, arrays of values, and how

4

12

82

@deisbel

Deisbel (Sr. Software Developer)

7 months

Creating a recursive function in a high-level language is a classic request in developer interviews; 20% will fail (not a disaster) But 99% will fail if they ask to implement the recursive function in SQL! Do you want to be part of the 1%? Here are the principles for creating

Tweet media one

Tweet media two

3

13

80

@deisbel

Deisbel (Sr. Software Developer)

1 year

@iammemeloper First, 2 or 3 should be replaced by a constant, for example: const MAX_OCCUPANCY = 2; The nature or meaning of that variable will make the difference between using < or <=, and it no longer will be matter of 'programming styles'

7

1

75

@deisbel

Deisbel (Sr. Software Developer)

9 months

Today is Sunday, a day for relaxing and enjoying the family. But if you would like to learn something new today, then try “Database Design and SQL” They are long-term, probably whole-life skills, no matter your tech stack.

6

7

75

@deisbel

Deisbel (Sr. Software Developer)

7 months

Many tutorials give you tips to improve your Database performance using only single-column Indexes. I’ll go further than 99% of them here: Using 4 examples, I’ll teach you 3 new tips to create great Composite Indexes. Example 1: Imagine showing the average number of goals

4

13

76

@deisbel

Deisbel (Sr. Software Developer)

11 months

There is only one secret to growing in your career as a Developer: Accept challenging projects. If they involve a new tech stack, do not lose that opportunity. Realize that you are getting paid for learning.

7

10

73

@deisbel

Deisbel (Sr. Software Developer)

11 months

Tech expertise is a long path. You must learn languages, databases, patterns, APIs, FE, BE, and Clouds. These are my 5 tips to learn better and faster: 1- Do not put too much pressure on yourself, one day at a time. 2- Pay attention to the general concepts more than to the

7

8

73

@deisbel

Deisbel (Sr. Software Developer)

5 months

Starting with SQL could be easier if you follow the proper guidelines. With these 10 statements, you will solve 90% of the database problems. 1- Create a simple table with a column: CREATE TABLE t1 (c1 INT NULL) 2- Add and Modify a column: ALTER TABLE t1 ADD c2 INT NULL ALTER

2

13

73

@deisbel

Deisbel (Sr. Software Developer)

8 months

Enforcing constraints involving multiple columns and rows in a table is challenging. Imagine you have an eCommerce website, and you need to enforce this rule: An order Discount can’t exceed 30% of its total Amount. Maybe you haven’t tried them yet, but the most direct way to

Tweet media one

8

10

72

@deisbel

Deisbel (Sr. Software Developer)

7 months

Creating database queries accepting many optional parameters can become a nightmare or, at least, a big mess. I will show you one common and inefficient solution and the trick to do it faster and simpler. Imagine Amazon. You can Search for Products and optionally apply filters

9

7

71

@deisbel

Deisbel (Sr. Software Developer)

1 year

@svpino Ok, now I know who will participate in my Zoom and Teams meetings at the company. Even I will train it to talk and listen to my wife for me, haha.

4

0

69

@deisbel

Deisbel (Sr. Software Developer)

1 year

@catalinmpit Sometimes I have used those companies to practice for my other serious interviews. That's it. They deserve it. However, this is still a common practice. My previous company (I spent only three months there, the first time I did quit) made me a short code test using only

3

0

70

@deisbel

Deisbel (Sr. Software Developer)

8 months

Any project will have a design and database creation phase. Relational databases are the most common go-to. Use these 7 steps to start mastering them and make yourself a key player in your team. 1- Study what an Entity-Relationship model (ER) is. 2- Learn about the Relational

5

8

66

@deisbel

Deisbel (Sr. Software Developer)

6 months

Three false myths about Databases: 1- NoSQL databases do not support SQL. Many NoSQL DBs do, like CosmosDB and Couchbase. 2- Relational databases do not support NoSQL features. You can create tables containing only two columns and use them as key-value or key-document rows.

6

9

66

@deisbel

Deisbel (Sr. Software Developer)

11 months

@svpino Looks like 50 ones are too much, right? Do not get discouraged. Probably all of them are already implemented in packages and libraries We don't need to go super deeper on them. Getting the main idea of each one will be good enough.

1

3

65

@deisbel

Deisbel (Sr. Software Developer)

6 months

Developers hate the final phase of projects. Me too! You need to polish your application and prepare it for the final delivery. There are my final 7 steps to guarantee success. 1- Checking each TODO or technical debt. - If you no longer need it, then remove it. - If you can

3

12

65

@deisbel

Deisbel (Sr. Software Developer)

11 months

Better Databases are better than better Servers.

8

9

63

@deisbel

Deisbel (Sr. Software Developer)

1 year

@svpino The Azure AI platform, powered by OpenAI, has even more powerful 'calling functions' because you can give them a list of Restful endpoints, the description of them, and the platform is able to use them as part of its processing data source. It is mind-blowing.

6

6

63

@deisbel

Deisbel (Sr. Software Developer)

10 months

Everybody wants to build awesome software and architectures. But how? The unique answer is ‘Easy’ Make them: - Easy to Develop (Always go simple) - Easy to Change (Agility) - Easy to Test (Testable) - Easy to Deploy - Easy to Scale Making Software ‘Easy’ will automatically

4

14

64

@deisbel

Deisbel (Sr. Software Developer)

11 months

5 critical rules to design a good database. 1- Focus only on what you need right now. Do not over-design thinking about the future. You can always update your model later. 2- Make sure you have and understand all the business rules. They will guide the most critical design

14

6

63

@deisbel

Deisbel (Sr. Software Developer)

6 months

When we design a database, we split related data into many tables to avoid duplication (called Normalization). The most common task in Queries is joining them back. There are 2 ways to join data: Vertical and Horizontal. Let’s start with Vertical, which is the simplest but not

1

8

61

@deisbel

Deisbel (Sr. Software Developer)

11 months

The 3 biggest lies we should learn about databases: 1- NoSQL databases do not support SQL queries Many NoSQL DBs do, like CosmosDB and Couchbase. 2- Relational databases do not support NoSQL features. You can create tables containing only two columns and use them as

3

5

58

@deisbel

Deisbel (Sr. Software Developer)

7 months

Every day, we deal with hierarchical structures like Manager-Employees, Family, and Binary Trees. If you don’t know how to store them in Relational Databases, you are in a serious problem. Here, I show you how to design a suitable data model and elaborate on some practical

2

12

59

@deisbel

Deisbel (Sr. Software Developer)

4 months

Here you go, a 5-step process for designing exceptional-performance databases: 1- Design your database following the rules you learned at school. Make sure you normalize every table. 2- Write a simple script that generates millions of fake rows. 3- Identify the most critical

2

5

60

@deisbel

Deisbel (Sr. Software Developer)

9 months

Using Object-Relational Mapping to work with databases can turn against us. They usually perform worse than working directly with DBs. These are the 7 things that can go wrong: 1- Unique indexes, default values, and other indexes are usually forgotten. 2- Data validation

8

12

55

@deisbel

Deisbel (Sr. Software Developer)

10 months

Deploying your websites from a Git repository using Pipelines is no longer a privilege of the few. Front-end and back-end developers can do it without too much effort. Here, you have a real pipeline to deploy a Website developed with Angular (SPA). - - The red arrows link

Tweet media one

2

11

56

@deisbel

Deisbel (Sr. Software Developer)

10 months

I can only mention two things in software development that: - Were created more than 30 years ago - They haven't evolved - They are used as much as when created. - They are used in 70+ percent of existing Services and Solutions. Guessing? They are Relational Databases

11

5

56

@deisbel

Deisbel (Sr. Software Developer)

1 year

@KevinNaughtonJr Why store them? It is better if you accept any entered password, and you will save data storage costs. No need even for password recovery! 😂

6

2

56

@deisbel

Deisbel (Sr. Software Developer)

3 months

After 20+ years, I develop software much faster by splitting my full-stack work into 4 groups. 1- Spyke and POC. - I read the basic documentation looking for what I need to work with. - I try to create credentials for Dev and Live environments if integrating external APIs or

1

5

56

@deisbel

Deisbel (Sr. Software Developer)

11 months

You will not find this advice in any tutorial or book. Before creating your first table, from day one: "Decide and adopt a database migration strategy." Your database design will change frequently and not only during the development phases. - You will have many developers on

4

6

55

@deisbel

Deisbel (Sr. Software Developer)

9 months

Smart decisions will make you the best database designer on your team. Making reading and writing operations faster is one of the best strategies. One way is to replace a simple table with a column storing a list of comma-separated values. I show you here when and how to do

Tweet media one

Tweet media two

8

4

52

@deisbel

Deisbel (Sr. Software Developer)

8 months

In 20 years, I can’t remember a project without a guy trying to over-design. You can read 20 books about Software Design Patterns, but none will teach you about this one: Money-driven Development (MDD) It is the only pattern applicable to every single project. How does it

Tweet media one

8

10

52

@deisbel

Deisbel (Sr. Software Developer)

1 year

@anothercohen And BTW, people out there, this is not serious, this was "sarcasm". haha. "the use of irony to mock or convey contempt."

1

2

48

@deisbel

Deisbel (Sr. Software Developer)

11 months

@catalinmpit In an interview many factors intervene: generating Empathy is critical. But the most common cause of failures is that those open positions are not really 'open'. They have the candidate to fill it out! Companies make the position public to meet legal requirements.

0

3

51

@deisbel

Deisbel (Sr. Software Developer)

1 year

Creating database queries accepting many optional parameters can become a nightmare or, at least, a big mess. I will show you one usual solution to this problem and a trick to do it faster and simpler. Imagine Amazon. You can Search for Products and optionally apply filters by

5

6

48

@deisbel

Deisbel (Sr. Software Developer)

11 months

More than 80% of your Tech's interviews will fail. These are the 7 best tricks to improve your acceptance rate by 50% or more: 1- Research the company History, What they do, Tech-stack they use, Reviews, average salary, and the questions they ask in Interviews. 2- Research

7

10

49

@deisbel

Deisbel (Sr. Software Developer)

6 months

Everybody wants to build fantastic software and architectures. But how? The unique answer is: Making sure to meet the Five Easy To: Easy to Develop (Always go simple) Easy to Change (Agility) Easy to Test (Testable) Easy to Deploy Easy to Scale You only need to ask yourself:

3

8

50

@deisbel

Deisbel (Sr. Software Developer)

1 year

90% of developers hate the final step of the projects. The fun in coding is done. You need to polish your application and prepare it for the final delivery. No medium terms here: you do it, or you will fail. Here you go, my checklist, with seven steps you can’t omit. 1-

Tweet media one

Tweet media two

Tweet media three

7

8

47

@deisbel

Deisbel (Sr. Software Developer)

9 months

Databases growing fast is a leading cause of unresponsive services, poor performance, and cost increases. We want to keep as much data as possible, but keeping size under control is crucial. These 2 techniques will control the size of your DB without losing relevant

4

4

45

@deisbel

Deisbel (Sr. Software Developer)

5 months

Big companies, producing millions of data records daily, must break traditional rules. The Relational databases paradigm, once upon a time the champion, is no longer an option. Imagine Amazon creating a report about the Best Seller products each month in the last two years.

3

13

46

@deisbel

Deisbel (Sr. Software Developer)

11 months

Building software based on a messy database will become a disaster. Using a unified strategy for naming database resources is crucial. This is the naming convention I have used with all the teams I’ve worked with for 20+ years. Table names Always the name of the Entity or

7

6

47

@deisbel

Deisbel (Sr. Software Developer)

10 months

You may be overwhelmed by so many statements in SQL. Let me give you the 10 most used combinations. You will solve 90% of the problems with them. 1- Create a simple table with a column CREATE TABLE t1 (c1 INT NULL) 2- Add or Modify a column ALTER TABLE t1 ADD c2 INT NULL

Tweet media one

5

10

46

@deisbel

Deisbel (Sr. Software Developer)

5 months

This is one of the most common but underrated questions in Tech interviews. How to secure Web APIs? Never omit these 7 details in your answer: 1- Keep your platform up to date. 2- Secure folder permissions. 3- Use Firewalls. 4- Use HTTPS. 5- Use secure access and enforce

5

6

44