⚠️😱⚠️AWS suffered a massive outage today, causing some of the most famous websites being unreachable and sending half the internet into chaos 😱
What happened ❓
A glitch in AWS’s US-East-1 region broke core DNS and database systems - reminding everyone that when Amazon sneezes, the web catches a cold.
Here is the list of all services that were not available today:
Snapchat
Ring
Robblox
My Fitness Pal
Life360
Clash Royale
Amazon
Xero
Signal
Blink Security
Wordle
HMRC
Asana
Coinbase
Duolingo
Square
Smartsheet
Jira Software
Epic Games Store
Vodafone
Atlassian
Pokémon GO
Hay Day
Amazon Alexa
Playstation Network
Peloton
Ancestry
Zoom
Brawl Stars
Dread by Daylight
Amazon Prime
IMDb
Eventbrite
Flickr
Amazon Music
Tidal
Perplexity
Rocket League
Slack
Trello
Xbox Network
EA
Ubisoft Connect
GOV UK
What happened ❓
A glitch in AWS’s US-East-1 region broke core DNS and database systems - reminding everyone that when Amazon sneezes, the web catches a cold.
Here is the list of all services that were not available today:
Snapchat
Ring
Robblox
My Fitness Pal
Life360
Clash Royale
Amazon
Xero
Signal
Blink Security
Wordle
HMRC
Asana
Coinbase
Duolingo
Square
Smartsheet
Jira Software
Epic Games Store
Vodafone
Atlassian
Pokémon GO
Hay Day
Amazon Alexa
Playstation Network
Peloton
Ancestry
Zoom
Brawl Stars
Dread by Daylight
Amazon Prime
IMDb
Eventbrite
Flickr
Amazon Music
Tidal
Perplexity
Rocket League
Slack
Trello
Xbox Network
EA
Ubisoft Connect
GOV UK
❤6
Here are some tricky🧩 SQL interview questions!
1. Find the second-highest salary in a table without using LIMIT or TOP.
2. Write a SQL query to find all employees who earn more than their managers.
3. Find the duplicate rows in a table without using GROUP BY.
4. Write a SQL query to find the top 10% of earners in a table.
5. Find the cumulative sum of a column in a table.
6. Write a SQL query to find all employees who have never taken a leave.
7. Find the difference between the current row and the next row in a table.
8. Write a SQL query to find all departments with more than one employee.
9. Find the maximum value of a column for each group without using GROUP BY.
10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.
These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.
Here are the answers to these questions:
1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)
2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary
3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)
4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)
5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table
6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)
7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table
8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1
9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)
1. Find the second-highest salary in a table without using LIMIT or TOP.
2. Write a SQL query to find all employees who earn more than their managers.
3. Find the duplicate rows in a table without using GROUP BY.
4. Write a SQL query to find the top 10% of earners in a table.
5. Find the cumulative sum of a column in a table.
6. Write a SQL query to find all employees who have never taken a leave.
7. Find the difference between the current row and the next row in a table.
8. Write a SQL query to find all departments with more than one employee.
9. Find the maximum value of a column for each group without using GROUP BY.
10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.
These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.
Here are the answers to these questions:
1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)
2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary
3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)
4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)
5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table
6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)
7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table
8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1
9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)
❤3
⌨️ JavaScript Code Security
JavaScript security requires proactive measures: sanitize inputs, avoid risky functions like eval(), use HTTPS, and keep dependencies updated. Implement these practices to protect your apps from common threats.
JavaScript security requires proactive measures: sanitize inputs, avoid risky functions like eval(), use HTTPS, and keep dependencies updated. Implement these practices to protect your apps from common threats.
❤3🔥2
🔰 Keep your multi-tab web apps in sync.
lets you send messages between tabs instantly, avoiding inconsistent state and improving user experience.
❤6
❤5
📉 Global layoffs signal the end of stable employment
Mass job cuts are sweeping across industries, marking a shift away from long-term, stable employment. The global labor market has entered a period of deep uncertainty, with some companies downsizing aggressively and others freezing new hires altogether.
Over the past year, major corporations have announced significant reductions:
• UPS — 48,000 jobs
• Meta — up to 25,000 by year-end
• Intel — 24,000
• Nestlé — 16,000
• Microsoft — 15,000
• Amazon — 14,000
• Accenture — 11,000
• Novo Nordisk — 9,000
• Procter & Gamble — 7,000
• PwC — 5,600
• Salesforce — 4,000
• Target — 1,800
• Applied Materials — 1,400
• Paramount — 1,000
• Ford — 1,000
No sector has been spared, from tech to manufacturing and consumer goods. While companies officially describe these moves as “restructuring,” analysts point to rising investment in AI and automation as the real catalyst.
The transition has begun and the future of work may never look the same.
Mass job cuts are sweeping across industries, marking a shift away from long-term, stable employment. The global labor market has entered a period of deep uncertainty, with some companies downsizing aggressively and others freezing new hires altogether.
Over the past year, major corporations have announced significant reductions:
• UPS — 48,000 jobs
• Meta — up to 25,000 by year-end
• Intel — 24,000
• Nestlé — 16,000
• Microsoft — 15,000
• Amazon — 14,000
• Accenture — 11,000
• Novo Nordisk — 9,000
• Procter & Gamble — 7,000
• PwC — 5,600
• Salesforce — 4,000
• Target — 1,800
• Applied Materials — 1,400
• Paramount — 1,000
• Ford — 1,000
No sector has been spared, from tech to manufacturing and consumer goods. While companies officially describe these moves as “restructuring,” analysts point to rising investment in AI and automation as the real catalyst.
The transition has begun and the future of work may never look the same.
❤1
🔰 Flexbox in CSS
Flexbox simplifies responsive design by allowing flexible, efficient alignment and distribution of elements without relying on floats or complex CSS hacks.
Flexbox simplifies responsive design by allowing flexible, efficient alignment and distribution of elements without relying on floats or complex CSS hacks.
❤6