Author: drweb

SQL

I’ve worked quite a bit with Microsoft’s unified analytics platform “Fabric” in Azure and I’ll say it definitely helped make things easier to integrate all the different tools like python notebooks, Data Factory (ADF), Power BI and more. This is because Fabric is a unified tool that combines all these components making authentication seamless using the managed identity from Fabric itself. Is Fabric really necessary? It integrates data integration, data engineering, data warehousing, data science, real-time analytics, and business intelligence into a single SaaS offering with a unified storage layer called OneLake. Sounds amazing right? Let’s say you aren’t familiar…

Read More

We’re now in the fifth wave of computing. If that sounds dramatic, that’s because it is—and probably also because someone in marketing really wants to make “agentic AI” stick. For those keeping track at home, the first four waves were mainframes (your granddad’s computer), web (when we were all hopeful), cloud (when we were still kind of hopeful), and mobile (where that hope became a subscription to your attention span).And now? Agentic AI.Let’s get the buzzwords out of the way: Agentic AI is a fancy term for giving large language models (LLMs) persistent memory, looping logic, and callbacks to reach…

Read More

The Extensible Markup Language (XML) is a markup format originally for XML. Some companies use XML as a data serialization format or for configuration. Recently, I needed to learn how to uncomment some lines in an XML file to enable some settings that were defined in the XML. Fortunately, Python’s xml module provides a way to do this. Let’s find out how! AI Answers Might Not Work When I used Google to search for an answer to this question: “How to edit comments in XML with Python”, Google Gemini piped up with this answer: import xml.etree.ElementTree as ET xml_file…

Read More

Postman today revealed it has developed artificial intelligence (AI) agents for its platform for designing and building application programming interfaces (APIs).Announced at the POST/CON 2025 event, the Agent Mode enables developers to, via a natural language interface, automate entire multi-step workflows spanning the designing, testing, documenting and monitoring of a single API or a logical group of APIs, known as collections.Postman CEO Abhinav Asthana said unlike an AI copilot, Agent Mode natively executes tasks in a way that understands the actual intent of an API developer.The overall goal is to reduce the amount of time required to build and deploy…

Read More
SQL

At the moment there are two activities in Fabric pipelines that allow you to execute a “child” pipeline. They are both named “Invoke Pipeline” but are differentiated by the labels “Legacy” and “Preview” in parentheses.The activities menu showing both the legacy and preview Invoke Pipeline activities.With either activity, you choose the pipeline you want to execute and whether or not to wait until the pipeline has completed.You might think you want to go with the preview activity since it is newer, but it’s important to understand the limitations of each. The legacy activity can only be used to call another…

Read More
SQL

 मिशन विज़नIndiaAI पहल का उद्देश्य आर्टिफिशियल इंटेलिजेंस की शक्ति का उपयोग करके नवाचार को बढ़ावा देना, पहुंच को बेहतर बनाना और देशभर में सामाजिक-आर्थिक विकास को गति देना है।  सरकारी निवेशकेंद्रीय मंत्रिमंडल ने इस परिवर्तनकारी मिशन को लागू करने के लिए ₹10,371.92 करोड़ के बड़े बजट को मंजूरी दी है। IndiaAI के मुख्य स्तंभ … Continue reading → The post IndiaAI मिशन: भारत को AI की ताकत से बदलने की तैयारी! appeared first on SQLServerCentral.

Read More
SQL

I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so I’ve written a few posts on triggers that can be useful. This one looks at detecting a change to a column in a trigger.Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.The SetupI’ve got a Customer table that I want to use, which doesn’t have any triggers on it. Here is the schema.CREATE TABLE [dbo].[Customer](     [CustomerID] [int] NOT NULL,    …

Read More

A survey of 100 security professionals finds nearly half (48%) of security professionals admit their organizations are falling behind on meeting software bill material (SBOM) requirements as specified by the U.S. Office of Management and Budget (OMB) Memo M-22-18, Executive Order 14028, and the European Union (EU) Cyber Resilience Act.Conducted during the recent RSAC conference by Lineaje, a provider of tools and services for securing software supply chains, the survey also finds a nearly equal percentage (47%) have either not started SBOM integration or are still evaluating tools and practices.Additionally, just over a third conceded their organization still has difficulty…

Read More
SQL

Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one thing is always true:When SQL Server slows down, everything slows down!Reports take forever. Blocking brings processes to a halt. Deadlocks frustrate both users and developers. The CPU is maxed out, I/O is saturated – and nobody really knows why. This is when I usually get the call: “Klaus, we’ve got a problem. Can you take a look?”The Real Problem: Too much delay, not enough clarityWhat frustrates people the most isn’t just the…

Read More

Today, we’ll show you how to build a fully functional Generative AI chatbot using Docker Model Runner and powerful observability tools, including Prometheus, Grafana, and Jaeger. We’ll walk you through the common challenges developers face when building AI-powered applications, demonstrate how Docker Model Runner solves these pain points, and then guide you step-by-step through building a production-ready chatbot with comprehensive monitoring and metrics. By the end of this guide, you’ll know how to make an AI chatbot and run it locally. You’ll also learn how to set up real-time monitoring insights, streaming responses, and a modern React interface — all…

Read More