Author: drweb

SQL

One of the things I’ve been experimenting with in AI is taking things other people do and seeing how well the AI works. In this case, I took a Prompt from Louis and tried to see how well it worked. This post describes the results from a few models.This is part of a series of experiments with AI systems.The Challenge Using ClaudeLouis was using an AI to generate some test data to play with the new Regex functionality in SQL Server 2025. He put this in ChatGPT: “create a set of random string data with 1000 rows for a sql…

Read More

In the age of AI-driven development, teams face a dual imperative: Harness the speed and creativity of code-generation tools while upholding the strictest standards of security, privacy and regulatory compliance. Nowhere is this more critical than in regulated environments — think banking or healthcare — where a single misstep can expose sensitive customer data or run afoul of GDPR, PSD2 and other consumer-protection mandates. How, then, can modern enterprises leverage AI to increase efficiency without increasing risk? The answer lies in a rock-solid CI/CD foundation that weaves governance into every stage of the software lifecycle. Balancing Speed Versus Control CI/CD, continuous integration and…

Read More

We’ve entered a transformative era where AI is fundamentally changing how developers build applications.  There’s a huge opportunity for developers to infuse apps with solutions powered by Generative AI and large and small language models. Today’s models are getting more advanced, and the versatility of these models can accelerate developer productivity.  However, developers need to keep in mind that context and customizations are crucial for successful enterprise adoption. Without proper context, AI models may produce generic or irrelevant outputs, negatively impacting the effectiveness and integration of AI workflows. Customizations ensure that AI tools meet the specific needs of each project…

Read More

Today, I’m going to show you a simple but effective way to automatically block suspicious IPs using a small script and tools like iptables and Fail2Ban. These tools are powerful, lightweight, and can help secure your Linux server from brute-force attacks, bots, or any malicious traffic. This guide is beginner-friendly and great for system administrators, students, or anyone who runs a VPS, web server, or even a home Linux server. What are iptables and Fail2Ban? Before we going further into the setup, let’s understand the two key tools we’re using – iptables and Fail2Ban. iptables iptables is a command-line firewall…

Read More

Amazon Web Services (AWS) has added support for the Model Context Protocol (MCP) with the Visual Studio Code and JetBrains plugins that are provided for Amazon Q Developer, a set of artificial intelligence (AI) agents that automate a range of software development tasks.Originally developed by Anthropic, MCP support with these integrated development environments (IDEs) will make it simpler to invoke external tools that invoke some type of large language model (LLM).Srini Iragavarapu, director of software development for Amazon Q Developer Coding Assistant, said this capability will make it easier to provide AI agents with additional context by providing access to…

Read More

How to Build, Run, and Package AI Models Locally with Docker Model Runner Introduction As a Senior DevOps Engineer and Docker Captain, I’ve helped build AI systems for everything from retail personalization to medical imaging. One truth stands out: AI capabilities are core to modern infrastructure. This guide will show you how to run and package local AI models with Docker Model Runner — a lightweight, developer-friendly tool…

Read More

Do you need to find the area under a curve? The function scipy.integrate.quad lets you quickly and accurately find definite integrals in Python without using any symbolic math.This is the one you use when you need the answer between two limits and you’re working with a real-world function (not a clean x^2). It doesn’t care if you can do it on paper. It simply gets the job done.This is how it works in real life and when you should use it.Start with the simplest caseLet’s say you want to integrate x² from 0 to 3. This is what the code…

Read More

Artificial intelligence (AI) has been used in several industries to automate procedures, increase efficiency, reduce errors, data analysis and improve decision-making. This helps businesses increase efficiency, innovation, productivity and customer satisfaction. AI has also been used in software development. This article talks about AI. AI-generated code, AI-powered code generators, the benefits, downsides and limitations and why human expertise is still needed to build applications that are reliable, robust and maintainable. The Role of AI in Software Development AI has just jostled its way into almost everything we touch and software engineering is no exception. The incorporation of AI in software engineering has been…

Read More

If you’ve spent any time managing Linux systems, you already know how repetitive and time-consuming some tasks can be. Whether it’s checking disk space, restarting failed services, or keeping your system updated, doing everything manually quickly becomes a headache, especially if you’re handling more than one server. Bash scripts are like tiny assistants that help you automate common tasks, reduce human error, and save valuable time. Instead of running the same commands over and over again, you can let your scripts handle it – reliably and consistently. Over the years, many system administrators have created and refined scripts to monitor…

Read More