Author: drweb

SQL

Performance tuning is one of the most critical skills a database professional can develop. A single poorly optimized query can bring an entire application to its knees, while a well-tuned database can handle exponentially more load with the same hardware. This comprehensive guide walks you through practical techniques for identifying and resolving performance bottlenecks in SQL Server, complete with scripts you can run in your own environment. Let us learn today in this quick guide Execution Plans and Indexing Strategies.Understanding the Performance Tuning LandscapeBefore diving into specific techniques, it’s important to understand what we’re actually measuring when we talk about…

Read More

Veracode has extended the reach of a Package Firewall that applies policies that limit what types of code can be downloaded from a repository to Azure Artifacts from Microsoft. Additionally, DevSecOps teams can now define custom policies based on package risk profiles, vulnerability thresholds, or a specific security requirement their organization has adopted. Tim Jarrett, […]

Read More

Pavlo Baron, co-founder and CEO of Platform Engineering Labs, unpacks what’s changing in platform engineering as AI reshapes who gets to build, and how infrastructure actually gets managed. Baron traces the origin story back to his time building high-scale systems at Instana (which exited to IBM in 2020), where the reality of “always-on” platforms made […]

Read More

This article explains how to integrate Spring AI with external MCP servers that provide APIs for popular tools such as GitHub and SonarQube. Spring AI provides built-in support for MCP clients and servers. In this article, we will use only the Spring MCP client. If you are interested in more details on building MCP servers, please refer to the following post on my blog. MCP has recently become very popular, and you can easily find an MCP server implementation for almost any existing technology. You can actually run MCP servers in many different ways. Ultimately, they are just ordinary applications…

Read More

The 3Cs: A Framework for AI Agent Security Every time execution models change, security frameworks need to change with them. Agents force the next shift. The Unattended Laptop Problem No developer would leave their laptop unattended and unlocked. The risk is obvious. A developer laptop has root-level access to production systems, repositories, databases, credentials, and APIs. If someone sat down and started using…

Read More