I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As a SQLNewBlogger FYI, that type of post shows poor communication and a lack of communication. I see that a lot and it’s a challenge in the modern world. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.A Quick SetupThis was what the user posted:declare @t table ( id int identity , i int ); insert @t select null; insert…
Author: drweb
Atlanta, GA, August 4th, 2026, CyberNewswireAirlock Digital announces Agentic AI Control & Governance, extending its preventative endpoint security solution with visibility into trusted AI agent behavior and governance over what trusted agents are allowed to do on endpoints. Atlanta, GA—August 4, 2026—Airlock Digital, a leader in preventative endpoint security, today announced Agentic AI Control & Governance at Black Hat USA 2026. The new capabilities build on application control by providing command- and session-level visibility into trusted AI agent behavior, centralized policy management for trusted applications and AI agents, and real-time governance over what trusted AI agents are allowed to do…
You’ve probably run df -h, waited a few seconds, and run it again while a file copy or backup was in progress. Instead of repeating the command yourself, watch can do it automatically. It reruns the command at a fixed interval and even highlights what changed, so it’s easy to spot updates. Linux administrators and everyday Linux users often need to run the same command repeatedly while waiting for something to change. You might be checking disk space during a file copy, waiting for a service to start, or watching network connections while troubleshooting. Running the same command every few…
Many MCP projects begin with an existing API and a simple request: expose one backend capability to an LLM client. The quickest route is to wrap an endpoint as a tool and connect it to Claude or another MCP host. Users can then ask for data in natural language instead of navigating a fixed interface. This creates a production boundary because the model, rather than application code, chooses which operation to call.At Fullinfo, more than 1 million company profiles are served through a GraphQL backend on AWS AppSync. Users previously searched a portal and worked with the results using deterministic…
SQL Server sa Account Security: Rename, Disable & Best PracticesIn the Windows administration world, it’s pretty much a standard practice to rename the local administrator account (BUILTINAdministrator) to something else.In the SQL Server world, it’s not as common to rename the sa account. In fact, some DBAs may not be even aware this is possible, mainly because the recommended security best practice is to avoid running your SQL Server instance in Mixed Mode Authentication in the first place, and under Windows Authentication mode, the sa account is disabled by default.Now there’s some debate over whether renaming the sa login is…
Everyone is waiting for AI training at work. It took me a hundred conversations to understand what they are actually waiting for, and it is not a course.AI training at work is the most requested thing I hear about now, and almost nobody I meet has actually had any. I finished a session last month and a man waited until the room emptied before he came up to ask me something. That usually means the question is not about indexes.He asked when his company was going to train them on AI.Not whether. When.A quick note. The people in this piece are…
RapidFort today at the Black Hat USA conference announced it has extended its ability to secure open source software to the runtimes that DevOps teams deploy in production environments.Michael Wood, chief marketing officer for RapidFort, said the RapidFort Runtime platform makes it possible to now monitor open source software deployed within a container image to detect unauthorized or unexpected changes, and proactively assess the impact any report of a newly discovered Common Vulnerabilities and Exposures (CVE) might have.The overall goal is to make it simpler for DevOps teams to run the curated open source software packages that RapidFort already provides…
Aug 3, 2026 Docker AI Governance: Audit Logs, Now Where Your Security Team Already Works Now in Docker AI Governance: a single searchable record of every policy decision your agents trigger, streamed to the SIEM your security team already runs, so you can show what your agents did and what your policy stopped. Today, Docker AI Governance now streams every policy decision in your organization into the SIEM your security… Srini Sekaran and Julie Gray Read now
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different workloads, hardware, data distribution, application behavior, and configuration. Even if you reproduce an issue in a test environment, there’s no guarantee the same solution will produce identical results in production.So, probably instead of establishing a rigid step-by-step process, putting together a repeatable methodology can lead you to a resolution. This will eliminate blind guesses and at least bring you to an educated guess if the issue is too complicated.A common workflow…
Most Linux users come across the ! symbol in only two situations: when they learn the sudo !! shortcut, or when a password containing an exclamation mark inside double quotes causes the event not found error. Everything else that ! can do often goes unnoticed for years. The reason is that ! actually has two completely different purposes in Bash. In an interactive terminal, it is used for history expansion, which lets you quickly recall, reuse, and edit commands you’ve already run. In tests, patterns, and parameter expansion, ! is used for logical negation, and this works in both interactive…