Author: drweb

SQL

We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from customers, from usage data, from market research, and more to justify a decision.I think Google and quite a few other companies have called this being “data-driven.”The text on the next page continues the sentence:not on people’s opinions, the volume of their voices or who they are. When the evidence changes, we are prepared to change our minds. We will thank, and never shoot, the messenger.I will say that this has skewed…

Read More

Linux command line has a lot of fun around itself and many tedious task can be performed very easily yet with perfection. Playing with words and characters, their frequency in a text file, etc is what we are going to see in this article. Almost every word-frequency one-liner floating around the web has the same bug in it. It reports blank lines as the single most common “word” in your file, and poorly designed pipelines can split accented characters into meaningless bytes before counting them. The top of the list still looks plausible, which is exactly why nobody catches it.…

Read More

TL;DR — Key Takeaways AI test generators often produce too many tests while still missing important boundary, business-logic and cross-field scenarios. Better prompting improves results, but tends to plateau because the hardest testing problems require judgment rather than more instructions. The stronger architecture separates judgment from mechanics: Fine-tuned models decide what deserves testing, while frontier models generate executable payloads and code. RAG supplies missing information, while fine-tuning calibrates QA behavior such as prioritization, redundancy reduction and assertion quality. Execution feedback turns test generation into an improving system by feeding accepted, rejected, edited and flaky tests back into the judgment layer.…

Read More
SQL

The AI bubble I hope will pop is the one I am standing inside, holding a book, a consulting practice, and the survival instincts of a cartoon coyote who has just looked down.The AI bubble argument is stuck on the wrong question. Whether it is a bubble matters far less than what a correction would reveal, which is precisely why so many people are working so hard to prevent one.First, my interests, declared with the solemnity of a witness who has just noticed the prosecutor holding a printed email.I have written a book about AI. I take consulting work that…

Read More

TL;DR — Key Takeaways npm v12 blocks dependency lifecycle scripts by default unless they are explicitly allowed, closing off a common software supply chain attack path. Checkmarx warns attackers may respond by shifting malicious behavior from install-time scripts to code that executes when compromised packages run. Approval fatigue could weaken the protection if developers routinely allow scripts without sufficiently reviewing them. For years, one of the easiest ways to sneak malware onto a developer’s machine has been to hide in plain sight. Install a package from npm, and any lifecycle script bundled with it runs automatically — no review, no…

Read More

Aug 18, 2026 17,600 Actions: Agent Security Is a Systems Problem The OpenAI/Hugging Face incident exposed a new challenge for AI agent security. 17,600 attacker actions show why AI agent security can’t rely on human review. Explore the controls needed to constrain, observe, and govern agents at speed. Read now

Read More

TL;DR — Key Takeaways Outdated screenshots, diagrams and console captures can create implementation errors, inconsistencies and longer troubleshooting cycles. Predictive AI can automatically evaluate visual documentation and identify quality problems before assets are published. AI validation can detect cropped or outdated screenshots, missing diagram labels, inconsistent annotations and unreadable console output. Documentation quality gates can be integrated directly into CI/CD and Git workflows so visual assets are checked alongside code. Every release changes documentation alongside the code. Developers depend on that documentation during implementation, maintenance and troubleshooting. A diagram becomes misleading once services are renamed or integrations change without a…

Read More

Linux has long been the operating system of choice for servers, databases, containers, and cloud workloads. For some time, it existed without much scrutiny from attackers. However, this has changed over the years. When threat actors want to cause maximum damage, they go after the infrastructure layer. Increasingly, that means going after Linux because each of these computing resources runs on Linux, making it a single point of failure that attackers know how to exploit. A compromised Linux server is rarely an isolated incident and, in many environments, it is enough to take down the network around it. There is…

Read More

TL;DR — Key Takeaways DevOps teams risk repeating the mistakes of the “automate everything” era by trying to implement AI everywhere without a clear business need. AI productivity claims can be misleading: Research cited in the article found experienced developers were actually 19% slower despite expecting AI to make them faster. Poorly planned AI adoption can increase architectural errors, infrastructure costs, inconsistent engineering practices and operational complexity. Teams should assess their AI SDLC maturity, establish clear objectives and success metrics, and build internal AI expertise before expanding adoption. The most effective strategy is to start small, measure results and scale…

Read More
SQL

These eleven SQL Server interview questions look far too easy, and every one of them has stopped somebody senior. I ran all eleven on a real instance, so the results below were observed rather than reconstructed from memory.Most interview question lists are useless, and they are useless for a specific reason. They ask things that can be memorised. What is the difference between DELETE and TRUNCATE. Explain normalisation. Name the isolation levels. Describe a clustered index in your own words.A candidate can answer all of that perfectly and still not notice the query in front of them is going to…

Read More