MSSQL: Index Heatmaps in TreeView Format
Would you like to know which indexes are used frequently or rarely? Which ones aren't used at all? Which tables and indexes are the largest? It's very easy to create visualizations for this. They're both visually appealing and practically useful: https://u.habr.com/HWNFA
Would you like to know which indexes are used frequently or rarely? Which ones aren't used at all? Which tables and indexes are the largest? It's very easy to create visualizations for this. They're both visually appealing and practically useful: https://u.habr.com/HWNFA
What's New in the Angie 1.9 Web Server (an nginx fork) and What to Expect from 1.10?
You may have already read in the news that on the eve of Cosmonautics Day, a new stable release of Angie 1.9.0 was released, an nginx fork that continues to be developed by the team of former nginx developers. Approximately every quarter, we try to release new stable versions and delight users with numerous improvements. This release is no exception, but it's one thing to read a dry changelog and quite another to get to know the functionality in more detail, to learn how and in which cases it can be applied: https://u.habr.com/RJiZ5
You may have already read in the news that on the eve of Cosmonautics Day, a new stable release of Angie 1.9.0 was released, an nginx fork that continues to be developed by the team of former nginx developers. Approximately every quarter, we try to release new stable versions and delight users with numerous improvements. This release is no exception, but it's one thing to read a dry changelog and quite another to get to know the functionality in more detail, to learn how and in which cases it can be applied: https://u.habr.com/RJiZ5
Why you love bad products?
Users don’t fear changes. They fear wasting time. Why users reject “best” products — and how to win them over.
Users don’t fear changes. They fear wasting time. Why users reject “best” products — and how to win them over.
"In this post, I’ll show you EXACTLY how to run Telegram ads in 2025.
In fact, this is the exact process I use to grow my Telegram channels and get quality subscribers for just 0.01 TON ($0.03 as of May 15, 2025)"
How to Run Telegram Ads in 2025: Secrets to High-Converting Telegram Ads
In fact, this is the exact process I use to grow my Telegram channels and get quality subscribers for just 0.01 TON ($0.03 as of May 15, 2025)"
How to Run Telegram Ads in 2025: Secrets to High-Converting Telegram Ads
Captcha Solver Extension – Which to Choose: AI-Powered or Human-Powered? Difference Free and Paid CAPTCHA Extension
Imagine a developer automating routine tasks — for example, testing a web application or writing a data scraping script. Everything runs smoothly until a CAPTCHA appears on the path. In the browser, a familiar window pops up: "I am not a robot," or a grid of images where you need to find traffic lights or pedestrian crossings. The automatic script halts, tests fail, and an inexperienced developer might not even realize the problem for a long time — after all, they set everything up and started it, but didn’t account for the presence of CAPTCHAs (Completely Automated Public Turing test to tell Computers and Humans Apart), designed precisely to stop bots.
Imagine a developer automating routine tasks — for example, testing a web application or writing a data scraping script. Everything runs smoothly until a CAPTCHA appears on the path. In the browser, a familiar window pops up: "I am not a robot," or a grid of images where you need to find traffic lights or pedestrian crossings. The automatic script halts, tests fail, and an inexperienced developer might not even realize the problem for a long time — after all, they set everything up and started it, but didn’t account for the presence of CAPTCHAs (Completely Automated Public Turing test to tell Computers and Humans Apart), designed precisely to stop bots.
"My own path began in full-stack engineering, but almost a decade of shipping production code drew me ever deeper into application security. In this article I’m explaining key approaches on what SAML actually is and how we detect it in Bright using DAST"
DASTing SAML: Breaking Trust, One Assertion at a Time
DASTing SAML: Breaking Trust, One Assertion at a Time
cgroups: how to eliminate the “noisy neighbor” effect in PostgreSQL
If you've ever run multiple instances of PostgreSQL or other software on a single machine (whether virtual or physical), you've probably encountered the "noisy neighbor" effect — when instances disrupted each other. So, how do you make them get along? We’ve got the answer!
If you've ever run multiple instances of PostgreSQL or other software on a single machine (whether virtual or physical), you've probably encountered the "noisy neighbor" effect — when instances disrupted each other. So, how do you make them get along? We’ve got the answer!
Want to rank higher on Google? Use these 6 backlink techniques
Want Higher Google Rankings? Try These 6 Backlink Strategies That Actually Work. In the end, you’ll get tips to help you build a strong backlink strategy.
Want Higher Google Rankings? Try These 6 Backlink Strategies That Actually Work. In the end, you’ll get tips to help you build a strong backlink strategy.
Designing profitable software: architecture principles for business success
This article presents a business-driven approach to software architecture, focusing on maximizing profitability through technical decisions. It advocates for 1) distributed, stateless services with immutable models for scalability, 2) isolated third-party integrations without disrupting core logic, 3) simple, modular design.
This article presents a business-driven approach to software architecture, focusing on maximizing profitability through technical decisions. It advocates for 1) distributed, stateless services with immutable models for scalability, 2) isolated third-party integrations without disrupting core logic, 3) simple, modular design.
Postgres Pro OpenTelemetry сollector
pgpro-otel-collector is an OpenTelemetry collector (aka monitoring agent) tailored for gathering Postgres metrics and logs — brought to you by PostgresPro.
pgpro-otel-collector is an OpenTelemetry collector (aka monitoring agent) tailored for gathering Postgres metrics and logs — brought to you by PostgresPro.
How an AI CAPTCHA Solver Works: From OCR to Deep Learning
Can a program be taught to solve CAPTCHAs the way a human does—quickly and reliably? In this article, we will try to figure out how AI CAPTCHA solvers are built, from classical OCR methods to modern neural networks.
Can a program be taught to solve CAPTCHAs the way a human does—quickly and reliably? In this article, we will try to figure out how AI CAPTCHA solvers are built, from classical OCR methods to modern neural networks.
"In this tutorial, I’ll walk you through everything I’ve learned about using Google Jules — an asynchronous coding agent. I’ve kept the explanations clear and simple, so whether you're an experienced developer or a beginner, you’ll be able to follow along"
Google Jules: An Asynchronous Coding Agent Explained
Google Jules: An Asynchronous Coding Agent Explained
Neat defer macro for C++17
Manual resource management in low level C-style C++ code might be annoying. It's not practical to create good enough RAII wrappers for every single C API you use, but approaches with goto cleanup or loads of nested if (success) hurt readability.
A defer macro to the rescue! The deferred lambda will be executed on scope exit, no matter how it happens: you can return from any point, throw an exception (if allowed), or even use a goto to an outer scope. It is truly zero-cost and doesn't rely on C runtime or standard library, so it can be used even in kernel development.
Manual resource management in low level C-style C++ code might be annoying. It's not practical to create good enough RAII wrappers for every single C API you use, but approaches with goto cleanup or loads of nested if (success) hurt readability.
A defer macro to the rescue! The deferred lambda will be executed on scope exit, no matter how it happens: you can return from any point, throw an exception (if allowed), or even use a goto to an outer scope. It is truly zero-cost and doesn't rely on C runtime or standard library, so it can be used even in kernel development.
We append the following metrics to the T-SQL procedure statements:
— Execution count (x)
— CPU time in milliseconds (c)
— Duration in microseconds (d)
— Number of reads (r)
— Number of writes (w)
—
You can display these as absolute values or percentages
— Execution count (x)
— CPU time in milliseconds (c)
— Duration in microseconds (d)
— Number of reads (r)
— Number of writes (w)
—
@@rowcount
value (n)You can display these as absolute values or percentages
"A few weeks ago, OpenAI announced that Codex is available for Plus users, and I didn’t miss a chance to try it. And today, I’m excited to share a guide to OpenAI’s Codex. As a developer, I’ve found it to be a powerful and practical tool"
OpenAI Codex. A Software Engineering Agent
OpenAI Codex. A Software Engineering Agent
The Billiard Fractals
Complex systems often appear chaotic or incomprehensible, yet closer examination reveals that such complexity can frequently be reduced to a simple underlying mechanism. By systematically removing layers of emergent behavior, one can uncover a fundamental rule or equation from which the entire system originates.
Complex systems often appear chaotic or incomprehensible, yet closer examination reveals that such complexity can frequently be reduced to a simple underlying mechanism. By systematically removing layers of emergent behavior, one can uncover a fundamental rule or equation from which the entire system originates.
Whose feature is better, or how to compare the efficiency of SQL query plans
How to compare the efficiency of SQL query plans? “Measure the execution time, of course!” — an experienced reader would say. And they would be absolutely right: from a practical perspective, the more efficient DBMS is the one that delivers higher TPS. However, sometimes we need to design a system that doesn't exist yet or predict behavior under loads that haven't occurred yet. In such cases, we need a characteristic that allows us to perform a qualitative analysis of a plan or compare two plans. This post is dedicated to one such characteristic — the number of data pages read.
How to compare the efficiency of SQL query plans? “Measure the execution time, of course!” — an experienced reader would say. And they would be absolutely right: from a practical perspective, the more efficient DBMS is the one that delivers higher TPS. However, sometimes we need to design a system that doesn't exist yet or predict behavior under loads that haven't occurred yet. In such cases, we need a characteristic that allows us to perform a qualitative analysis of a plan or compare two plans. This post is dedicated to one such characteristic — the number of data pages read.
The Journey from Developer to Lead: Lessons Learned About Responsibility
Becoming a lead isn’t just another line in your resume, it’s a mental shift. It’s the moment you go from being a developer to someone responsible for your code and the entire team. Next, you’re also listening, mentoring, negotiating, motivating, and knowing how to find common ground even in challenging situations.
Becoming a lead isn’t just another line in your resume, it’s a mental shift. It’s the moment you go from being a developer to someone responsible for your code and the entire team. Next, you’re also listening, mentoring, negotiating, motivating, and knowing how to find common ground even in challenging situations.
"These days, it seems like everyone is talking about AI. AI here, AI there — AI will replace us all, and so on. I started to wonder: how exactly is AI going to replace us? I decided to dig into this question and examine the technical foundations, mainly to understand it for myself — how exactly is AI supposed to replace us all? Spoiler: it isn’t planning to just yet, but what’s already available today is impressive"
AI Agents in Modern IT Solutions
AI Agents in Modern IT Solutions
How to provide effective training for a UX design team
Training is one of the most essential factors for growth, evolution and effective collaboration for any UX design team. Design is an ever-changing industry, and there is always something new to learn even for the most experienced professionals. The reality is, not all companies take training seriously, whether the reason is a low budget, lack of time or just not realising its necessity. Meanwhile, investing in training not only boosts the quality of work, but also helps find ways to find easier solutions, work faster and optimize the whole process.
Let’s discuss some tips that might help you provide effective and fruitful training for your design team without spending extra budget or wasting time on some questionable training methods.
Training is one of the most essential factors for growth, evolution and effective collaboration for any UX design team. Design is an ever-changing industry, and there is always something new to learn even for the most experienced professionals. The reality is, not all companies take training seriously, whether the reason is a low budget, lack of time or just not realising its necessity. Meanwhile, investing in training not only boosts the quality of work, but also helps find ways to find easier solutions, work faster and optimize the whole process.
Let’s discuss some tips that might help you provide effective and fruitful training for your design team without spending extra budget or wasting time on some questionable training methods.