Notepad++ is a completely free source code editor created as a replacement for Notepad on Windows – is written based on Scintilla in C++ and implements Win32 API and STL to ensure program sizes are small with high execution speed – features that have since made it become a family name among developers. Sadly, there isn’t a version available for Linux users. Here’s a list of the best Notepadd++ alternatives that you can run on your Linux distribution and be satisfied. 1. Vim Editor Vim is a powerful, completely configurable text editor for creating or editing any type of text,…
Author: drweb
I recently had a new pipeline fail. It was actually a copy of an old pipeline where I had made some adjustments into as part of a database migration. When triggered during an execution run, it failed saying some expression could not be parsed. When I went into the pipeline and triggered a debug, it immediately failed with the following helpful error message:Right. Not the same error from the monitoring pane. I went into a copy data activity, and found the following expressions:The parsing error was from the expression @item.Query. I changed this to @item().Query, but the debug still failed…
AI is quickly becoming a core part of modern applications, but running large language models (LLMs) locally can still be a pain. Between picking the right model, navigating hardware quirks, and optimizing for performance, it’s easy to get stuck before you even start building. At the same time, more and more developers want the flexibility to run LLMs locally for development, testing, or even offline use cases. That’s where Docker Model Runner comes in. Now available in Beta with Docker Desktop 4.40 for macOS on Apple silicon, Model Runner makes it easy to pull, run, and experiment with LLMs on…
The convergence of artificial intelligence (AI) and DevSecOps redefines how organizations build, secure and deploy software. As businesses strive to accelerate feature releases, they face increasing pressure to manage security risks and maintain compliance without slowing development. AI-driven solutions offer a compelling way to proactively identify vulnerabilities, streamline processes and enable more robust decision-making in real-time. This blog dives into the reasons why DevSecOps is a critical discipline in the AI era, explores the benefits and challenges of integrating AI into DevSecOps pipelines and provides a framework for successfully adopting these emerging technologies. The Evolution of DevSecOps DevSecOps extends traditional DevOps by weaving…
In the world of Linux system administration and development, comparing files is an essential task when you are updating configuration files, reviewing code changes, or troubleshooting issues, the ability to compare two text files and quickly spot the differences can save you time and help you avoid costly errors. In this guide, we’ll walk you through various methods to compare text files in Linux, from basic command-line tools to advanced visual diff tools. Each method has its own strengths, and we’ll explain when to use which one. A Quick Scenario Imagine you have two versions of a config file: file1.txt…
Traditional observability tools hook into your infrastructure, grabbing logs, traces and metrics. In theory, if you collect enough data, you will know what is happening in your system. Except that is not really how it works. The problem is that these tools only monitor a small subset of what is a large, complex and connected system. They tend to ignore critical signals like application behavior, system configurations or interactions between internal tools. This creates blind spots that make debugging slow, tedious and ultimately harder than it needs to be. In the short term, it puts significant strain on the engineering…
Deadlocks can feel like a mystery, but they don’t have to be! In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.What Are Deadlocks?Deadlocks occur when two or more processes are waiting for resources held by each other, creating a circular wait. SQL Server resolves this by picking a “victim” process to terminate so the other transactions can continue.Capturing Deadlocks in SQL ServerTo analyze deadlocks effectively, we need to enable the right tools:Enable Trace FlagsSQL Server logs deadlock details in the error log when you enable trace flags 1204 and…
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills. This post explores why this happens, how to identify it, and some quick tips to optimize your queries.What Causes TempDB Spills?Tempdb spills occur when SQL Server does not allocate enough memory for operations like sorting. The spill results in SQL Server writing intermediate data to tempdb, which introduces additional I/O overhead. Here’s an example scenario:The sort operator processes over 121,317 rows, but SQL Server grants only 6,000 KB of memory.Insufficient memory causes the operation to spill, leading to:460 pages written to tempdb.Approximately 10…
Hey there, fellow developers and DevOps champions! I’m excited to share a workflow that has transformed my teams’ development experience time and time again: pairing Docker and Visual Studio Code (VS Code). If you’re looking to speed up local development, minimize those “it works on my machine” excuses, and streamline your entire workflow, you’re in the right place. I’ve personally encountered countless environment mismatches during my career, and every time, Docker plus VS Code saved the day — no more wasted hours debugging bizarre OS/library issues on a teammate’s machine. In this post, I’ll walk you through how to get…
Execution timeout in SSMS are a small but important feature that can help you manage query performance. By default, SSMS allows queries to run indefinitely, but there are times when limiting execution time can prevent issues in both testing and production environments. In this post, we’ll explore why and how to adjust execution timeouts and their practical use cases.Why Adjust Execution Timeouts?Testing QueriesWhen testing or troubleshooting, you may not want queries to run longer than necessary. A timeout ensures they don’t consume resources endlessly.Production SystemsOn live systems, long-running queries can block other operations and degrade performance. Limiting execution time protects…