Martin Linkov

IT Business Analyst @erstegroup. Cyclist.

[Martin Linkov @marfuzii]

Nasdaq to Power Regulatory Reporting in Austria https://t.co/lerHuM9ipc

[bye bye, I'm not here anymore @jrosaproenca]

Test strategies are like getting a new dress... you can get a regular store size and model, but if you get it tailor made it will fit like a glove! Test strategies should be made specific to the project! @mirjanakolarov at #AgileTD

[Robin Ward @eviltrout]

They finally made an accurate horror movie about programming:

[Kelly Vaughn @kvlly]

I'd love to watch a movie where programming is accurately depicted.

A team is trying to quickly build an app that will save the world. The app won't compile. Someone keeps adding to the scope. The project manager is asking for an update every 15 minutes.

[Martin Linkov @marfuzii]

11 years of calling:

Union calls for limit on ‘all-in’ employment contracts | European Foundation for the Improvement of Living and Working Conditions https://t.co/btq9mCZJwB

[Wayra UK @WayraUK]

"The rules are not yet written!" Potent words for those #startups currently pitching during #Welcome2Wayra week!

[Martin Linkov @marfuzii]

Only @Ryanair can make 1h delay on a 1h40m flight, they were assisted by the Vienna International Airport which sent a bus for a 50 meters walk

[Martin Linkov @marfuzii]

In its baggage claim form, @Ryanair is asking for the suitcase’s or other damaged item (infant stroller in my case) original receipt - as if you travel with all your receipts (claim has to be submitted within 7 days of damage incurring) - RIDICULOUS!

[Martin Linkov @marfuzii]

Jodie Foster says generation Z can be ‘really annoying’ to work with https://t.co/thvQ3PxLyf

[Martin Linkov @marfuzii]

Just finished "#Microservices Foundations" by @fpmoles on @LI_learning and I enjoyed it very much. Nice, well structured content. Good flow and style. Recommended!

[Nulla Studio @NullaStudio]

Kukeri Toy Design Project

Learn more at: https://t.co/sdgk0xrMpR

[Martin Linkov @marfuzii]

The winner of the #WorstCustomerSupport award is definitely @TrustWallet - 5 days and counting and no response to a very sensitive and stressful issue. #scam

[Martin Linkov @marfuzii]

Well, @github surely can do better than to allow Wallet-Drainer advertisings from #Crypto scammers on their platform. I've just reported 3 such recently created accounts - no code, just spam and theft promotion

[Dr Milan Milanović @milan_milanovic]

𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀

Here is the list of the top 20 SQL query optimization techniques I found noteworthy:

1. Create an index on huge tables (>1.000.000) rows
2. Use EXIST() instead of COUNT() to find an element in the table
3. SELECT fields instead of using SELECT *
4. Avoid Subqueries in WHERE Clause
5. Avoid SELECT DISTINCT where possible
6. Use WHERE Clause instead of HAVING
7. Create joins with INNER JOIN (not WHERE)
8. Use LIMIT to sample query results
9. Use UNION ALL instead of UNION wherever possible
10. Use UNION where instead of WHERE ... or ... query.
11. Run your query during off-peak hours
12. Avoid using OR in join queries
14. Choose GROUP BY over window functions
15. Use derived and temporary tables
16. Drop the index before loading bulk data
16. Use materialized views instead of views
17. Avoid != or <> (not equal) operator
18. Minimize the number of subqueries
19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join.
20. For retrieving the same dataset, frequently try to use temporary sources.

Do you know what is 𝗤𝘂𝗲𝗿𝘆 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗿? Its primary function is to determine 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝘄𝗮𝘆 to execute a given SQL query by finding the best execution plan. The query optimizer works by taking the SQL query as input and analyzing it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query.

Next, the optimizer generates 𝗮𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻𝘀, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a 𝗰𝗼𝘀𝘁 to each execution plan based on the number of disk reads and the CPU time required to execute the query.

Finally, the optimizer 𝗰𝗵𝗼𝗼𝘀𝗲𝘀 𝘁𝗵𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻 with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query.

Check in the image the 𝗼𝗿𝗱𝗲𝗿 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗿𝘂𝗻.

#technology #softwareengineering #programming #techworldwithmilan #sql

[Elon Musk @elonmusk]

Loving my new T-shirt

[Martin Linkov @marfuzii]

Users of @TrustWallet beware! The app facilitates unsolicited chain spoofs under its NFTs section. The scams are so bad and the interface so poor that your #ETH wallet can be emptied with just one wrong click (on a totally harmless prompt) #scam. The App is as bad as the scams!

[Martin Linkov @marfuzii]

Looking for: Simple (app) way to send payment request to an address https://t.co/LzLNxUglGN #ethereum #crypto

[Martin Linkov @marfuzii]

@elonmusk you need better copy in X’s mail notifications. Change formerly in the Subject line with ex: X (ex twitter), better, shorter, no?

[HC SLOVAN Bratislava @hcslovanba]

DEŇ SO SLOVANOM už dnes od 16:00 do 19:30 h. Hráči sa na Vas tešia na verejnom tréningu (16:30), tlačovej besede (17:50), autogramiáde (18:30) a ďalších sprievodných aktivitách na Zimnom štadióne Ondreja Nepelu. Vstup voľný. #hcslovan #VerniSlovanu #Sorlomnahrudi

[Jrod Money 🇺🇸🚙 @MoneyJrod]

How to win at buying a car

1. Buy a Toyota
2. Pay it off
3. Keep up maintenance
4. Drive till the wheel fall off

Simple