Author: drweb

SQL

Have you ever added a visual to a Power BI report page and published the updated report only to realize you forgot to adjust a related bookmark? It’s very easy to do. The Power BI user interface doesn’t allow you to determine which visuals are included in a bookmark that includes only selected visuals. And it takes at least 4 clicks to open the Bookmarks and Selection tabs, and then select a bookmark to see which visuals are visible or hidden when the bookmark is selected. If you’d rather not have to click around and guess, you can parse the…

Read More
SQL

 Database migrations are where great product ideas go to die—unless you plan for SQL Server’s quirks and the realities of production load. Below are the most common mistakes I see, plus concise patterns to avoid them. Every item has a tiny, copy-pasteable example.1) “Online” index changes that still block (and can’t be paused)Even online operations need brief S/Sch-M locks; without guardrails they can block or be blocked.BadBetter — wait politely, bail out if needed, and make it resumable2) Auto-created / auto-dropped indexes (Azure automatic tuning surprises)If you use Automatic Tuning in Azure SQL Database, it may create and drop indexes.…

Read More

Debian offers several tools for managing software packages, each serving a specific purpose in the package management ecosystem, and understanding when and how to use each tool will help you maintain your system effectively. Understanding the Package Management Hierarchy In Debian, package management works in layers, and each tool plays a different role: dpkg is the core tool that is used to install, remove, and inspect .deb package files directly, but it does not handle downloading packages or figuring out dependencies. apt and aptitude operate on top of dpkg and they retrieve packages from online repositories and automatically handle dependencies,…

Read More
PHP

PhpStorm comes with a ton of built-in features, and you can add even more with plugins. They bring new languages, tools, and small improvements that make everyday coding smoother. Many of the best ones come from independent developers. One of them is Dmitrii Derepko, who built several handy tools for working with web projects and PHP. Below are a few of his creations worth checking out. If you’re curious about plugin development, don’t miss the JetBrains Plugin Developer Conference 2025  – free online conference. Dmitrii will be speaking there and will walk you through plugin creation basics: from the initial…

Read More