Llm — Articles & Guides | Developers Voice | The Software Architects Hub

Enterprise Text-to-SQL Analytics: Python, Haystack, and SQL Server for Natural Language BI Queries

1 Introduction: The “Sidecar” Strategy for Modern BI Most enterprise BI platforms were designed for repeatable reporting, not for open-ended questions asked in the middle of a business conversatio

On-Device AI for Mobile: Tiny LLMs, Vision Models, and Private Inference

Sudhir Mangla
Mobile Development , AI & Machine Learning
06 Dec, 2025

1 The Strategic Foundation: The Hybrid Compute Spectrum Mobile AI systems now have three realistic places where computation can run: the cloud, the edge (MEC), and directly on the device. Each tie

The Ultimate Guide to AI Code Generation: Vibe Coding, Prompt Engineering, and Mastering the New SDLC

Sudhir Mangla
AI & Machine Learning , Design Principles
13 Nov, 2025

1 The New Era of AI-Driven Development AI has moved from novelty to necessity in modern software engineering. Frameworks like ASP.NET Core 8, Entity Framework Core, and frontend stacks suc

The AI Test Engineer: Automating Test Case Generation and Documentation with LLMs

1 Introduction: The New Frontier of Quality Assurance Quality assurance has always been the backbone of reliable software delivery. Yet, despite decades of progress in automation, a stubborn bottl

The Agent-Driven Spec: From Product Requirement Document to Production-Ready Tech Specifications in Days, Not Weeks

1 Introduction: The End of Ambiguity Product development in software has always carried a paradox: the more detail you add to requirements, the more room there seems to be for misinterpretation. E

TempDB Under Pressure: The Architect's Guide to Diagnosing and Fixing SQL Server's Hidden Bottleneck

Sudhir mangla
AI & Machine Learning , Data Engineering
31 Aug, 2025

Executive Summary Data governance is no longer a passive, manual process of rule-making. In the era of petabyte-scale data lakes and stringent privacy regulations, it must be an active, automated

From Data to Docs: A Blueprint for Using GenAI to Automatically Document Datasets and Analytics

1 The Documentation Dilemma: Why Your Best Data is Your Most Obscure Asset Every senior developer, data architect, or tech lead has felt the sting of missing or outdated documentation. The databas

The Self-Writing Report: Architecting Automated Business Insights with Azure OpenAI and Power BI

Executive Summary / Abstract For decades, business intelligence (BI) has been dominated by static dashboards and manual interpretation. While these dashboards excel at visualizing what happened,

Running AI On-Prem: A Practical Guide to Using Local LLMs (like Phi-3 & Llama 3) in .NET

Running AI On-Prem: A Practical Guide to Using Local LLMs (like Phi-3 & Llama 3) in .NET Abstract The rapid progress in Large Language Models (LLMs) has ushered in an era where AI is no longer

Architecting LLM-Powered Applications: A Comprehensive Guide for .NET Architects

Abstract This guide offers .NET architects a comprehensive framework for designing, building, and deploying robust applications powered by Large Language Models (LLMs). Moving beyond theoretical d

Fine-Tuning LLMs with C#: A Practical Guide to Customizing Models with ML.NET

Abstract As artificial intelligence continues to shape the modern enterprise, Large Language Models (LLMs) like GPT, Llama, and Mistral are increasingly integrated into business solutions. While t

Unlocking GenAI Magic: Mastering Embeddings Patterns with C# (for Microsoft Software Architects)

Hey there, fellow Software Architect! Ever tried explaining complex concepts to someone who doesn't speak your language? It's painful, right? Computers feel the same when they try understanding our nu