Resources   No resource found

• How to Use DropColumns in Power Apps: Remove Unwanted Columns from DataJul 24, 2026. Master Power Apps' DropColumns() to efficiently remove unwanted columns from tables, collections, and data sources, simplifying your data.
• Building Local AI Applications with ONNX, Phi Models, and .NET 10Jul 24, 2026. Build fast, private local AI apps with ONNX, Phi models, and .NET. Achieve low latency, offline capabilities, and data control.
• SQL Server Temporal Tables ExplainedJul 22, 2026. Master SQL Server Temporal Tables for automatic data history tracking, point-in-time recovery, and simplified auditing. Learn creation, querying, and best practices.
• PostgreSQL Table Partitioning GuideJul 22, 2026. Master PostgreSQL table partitioning for efficient data management. Learn range, list, and hash strategies to boost query performance and scalability.
• ONNX Runtime in .NET: Running AI Models Without Cloud APIsJul 21, 2026. Run AI models locally in .NET with ONNX Runtime. Achieve faster inference, better privacy, and lower costs without cloud APIs.
• Local AI in .NET MAUI: Running On-Device Models with ONNX RuntimeJul 20, 2026. Unlock Local AI in .NET MAUI! Run ONNX models on-device for faster, private, offline AI experiences across platforms.
• Local LLMs with Ollama: Complete Setup and Integration GuideJul 16, 2026. Master local LLMs with Ollama! Setup, run, and integrate AI models like Llama and Mistral for privacy, cost savings, and offline access.
• How to Build an AI Coding Assistant with ASP.NET Core and Local LLMsJul 14, 2026. Build an AI coding assistant with ASP.NET Core and local LLMs for enhanced privacy, security, and cost control in your development workflow.
• How to Build Local-First AI Applications Using ONNX Runtime and .NETJul 13, 2026. Build private, fast, offline AI apps with ONNX Runtime & .NET. Run models locally for enhanced privacy, reduced latency, and lower costs.
• How to Build a Local AI Stack Using Ollama, Open WebUI, and DockerJul 10, 2026. Build a local AI stack with Ollama, Open WebUI, & Docker for private, secure, and cost-effective AI model deployment. Control your data and costs.
• Understanding Browser AI APIs: Running AI Models Directly in the BrowserJul 07, 2026. Run AI models directly in the browser with Browser AI APIs. Enhance privacy, reduce latency, and lower costs with local AI processing.
• What Is Apache Iceberg? Architecture, Benefits, and Use Cases ExplainedJul 06, 2026. Apache Iceberg: Revolutionize your data lake with ACID, schema evolution, time travel, and enhanced performance for massive analytics workloads.
• How to Perform a Complete Clean Installation of Rancher Desktop on macOS (Apple Silicon & Intel)Jul 01, 2026. Follow this step-by-step guide by Ziggy Rafiq to perform a complete clean installation of Rancher Desktop on macOS (Apple Silicon and Intel). Create a stable Kubernetes development environment using Rancher Desktop, k9s, containerd, and Homebrew following enterprise DevOps best practices by removing old Lima virtual machines, Kubernetes configurations, container runtimes, and cached files.
• How to Build a Multi-Model AI Strategy in .NET Using Azure OpenAI, Ollama, and Foundry LocalJun 30, 2026. Build flexible .NET AI apps with Azure OpenAI, Ollama, and Foundry Local. Optimize for performance, privacy, and cost with a multi-model strategy.
• Implementing Hybrid Local and Cloud AI Workflows in .NET ApplicationsJun 30, 2026. Implement hybrid local & cloud AI in .NET apps. Balance privacy, cost, and performance with intelligent request routing.
• How to Use Foundry Local for Privacy-First AI Development in C#Jun 30, 2026. Build privacy-first AI apps in C# with Foundry Local. Keep sensitive data secure and under control, reducing compliance risks and external dependencies.
• Implementing Local LLM Inference in .NET Applications Using ONNX RuntimeJun 30, 2026. Unlock local LLM inference in .NET with ONNX Runtime for faster, private, and cost-effective AI applications. Learn integration & best practices.
• Loading Files into an Existing Fabric Lakehouse Table Using the Graphical User Interface (GUI)Jun 26, 2026. In this article, you will learn how to load files to Fabric Lakehouse tables using existing table append behaviour of the graphical user interface
• Building Self-Hosted AI Development Environments with Foundry LocalJun 26, 2026. Build secure, self-hosted AI dev environments with Foundry Local for .NET apps. Maintain data control, boost productivity, and ensure compliance.
• Building Offline-First AI Applications with Foundry Local and .NET 11Jun 25, 2026. Build offline-first AI apps with .NET 11 and Foundry Local. Enhance privacy, reduce latency, and ensure reliability for intelligent applications.
• Why Databricks Catalog Commits is a Game-Changer for Lakehouse Governance and TransactionsJun 17, 2026. Databricks Catalog Commits revolutionize Lakehouse governance with multi-table ACID transactions, enhanced security, and improved performance.
• Building Production-Ready Local AI Solutions with Windows AI FoundryJun 12, 2026. Unlock production-ready local AI on Windows with Windows AI Foundry. Enhance privacy, reduce costs, and boost performance.
• Local-First AI Development: Running Enterprise Models on Windows PCsJun 11, 2026. Explore Local-First AI Development: run enterprise models on Windows PCs for enhanced privacy, reduced costs, and lower latency.
• Local AI Inference in .NET: Running Models on Windows Without Cloud APIsJun 10, 2026. Run AI models locally on Windows with .NET. Explore ONNX Runtime, Ollama, and hardware acceleration for private, fast, and cost-effective AI.
• Building Offline-First Enterprise Applications with .NET MAUI and Local AIJun 10, 2026. Build resilient enterprise apps with .NET MAUI & local AI. Ensure offline functionality, boost productivity, and enhance user experience.
• Local AI Development with Phi Models and .NET: Step-by-Step TutorialJun 09, 2026. Build local AI apps with .NET & Phi models! Learn step-by-step integration for privacy, speed, and cost savings. Unlock AI power locally.
• How to Build Offline AI Applications in .NET Without Cloud DependenciesJun 09, 2026. Build offline AI apps in .NET without cloud. Leverage local models like Phi & tools like Ollama for privacy, cost savings, and faster responses.
• Azure Cosmos DB Linux Emulator: What Developers Need to KnowJun 09, 2026. Unlock efficient local development for Azure Cosmos DB on Linux with the emulator. Test queries, data models, and CI/CD workflows.
• What Is Gemma 4 12B? Complete Beginner’s GuideJun 04, 2026. Learn what Gemma 4 12B is, how it works, benchmarks, use cases, performance, and how it compares with GPT-4 in this beginner-friendly guide.
• Flutter Hive Database Tutorial for Local StorageJun 03, 2026. Learn Flutter Hive Database with step-by-step examples. Store local data, user preferences, and offline content efficiently using Hive in Flutter apps.
• SQL Join Optimization: Improve Query Performance on Large TablesJun 03, 2026. Learn SQL Join Optimization techniques to improve query performance on large tables using indexes, execution plans, filtering, and SQL Server best practices.
• Build Local AI Agents with Nvidia RTX SparkJun 02, 2026. Build Local AI Agents with Nvidia RTX Spark
• Surface Laptop Ultra: Local LLM Performance TestJun 02, 2026. Surface Laptop Ultra: Local LLM Performance Test
• On-Device AI: Tuning Model Weights for Local PCsJun 02, 2026. On-Device AI: Tuning Model Weights for Local PCs
• Why AI PCs Could Become the Biggest Shift Since Cloud ComputingJun 01, 2026. AI PCs are revolutionizing computing by bringing AI processing to local devices. This shift promises faster performance, enhanced privacy, and reduced cloud reliance.
• Why AI PCs Could Become the Biggest Shift Since Cloud ComputingJun 01, 2026. AI PCs are revolutionizing computing! Discover how they're transforming software, boosting productivity, and reducing cloud reliance. The future is local AI!
• How On-Device AI Will Transform Desktop and Enterprise ApplicationsJun 01, 2026. Discover how on-device AI revolutionizes desktop & enterprise apps! Faster performance, enhanced privacy, and real-time automation are reshaping software development.
• Why Developers Should Prepare for the AI PC RevolutionJun 01, 2026. Prepare for the AI PC revolution! Discover how AI-powered computers are transforming software development, enabling faster workflows, and enhancing privacy. Learn key technologies!
• The Future of Windows Development in an AI-First WorldJun 01, 2026. AI is transforming Windows development! Learn how AI-first approaches, local AI processing, and intelligent automation are shaping the future of Windows apps.
• WWDC 2026: How Apple's AI Strategy Differs From OpenAI, Microsoft, and GoogleJun 01, 2026. WWDC 2026 unveils Apple's unique AI strategy: on-device processing, privacy, and seamless integration across its ecosystem, differentiating it from cloud-focused competitors.
• How Developers Are Using Local AI Models on Their Own MachinesMay 15, 2026. Explore how developers are leveraging local AI models on their machines for enhanced privacy, customization, and offline capabilities. A deep dive into tools and trends.
• How Voice AI Could Transform Healthcare Using Models Like Microsoft’s VibeVoice-ASRApr 29, 2026. Discover the key benefits of Microsoft’s VibeVoice-ASR 7B model, including long context transcription, speaker recognition, multilingual support, and AI agent memory capabilities. Learn whether VibeVoice-ASR can run locally, hardware requirements, and how developers can use it for enterprise AI, healthcare, video platforms, and conversational AI systems.
• How to Implement Dark Mode Toggle in ReactApr 16, 2026. Implement a dark mode toggle in your React app! This guide covers state management, CSS variables, local storage, and system preference detection for a seamless user experience.
• Running Local AI with LlamaSharp in .NET: A Developer's GuideApr 13, 2026. Run powerful AI models locally in .NET with LlamaSharp! This guide covers setup, model selection (Llama 3, Phi-4), GPU acceleration, and integration with Semantic Kernel.
• Install Ollama & Run Your First Local AI Model: Complete Hands-On GuideApr 06, 2026. Install Ollama & Run Your First Local AI Model: Complete Hands-On Guide From downloading Ollama to making your first live API call — every command, every config file, every error fix, every model explained. Windows and Linux. GPU and CPU. This is your complete Day 1 local AI setup guide.
• Why Are Iceberg Tables Becoming the Default for Data Lakehouses Over Delta Lake?Mar 30, 2026. Discover why Apache Iceberg is overtaking Delta Lake as the preferred table format for data lakehouses. Explore its multi-engine support, scalability, and vendor neutrality.
• High-Performance Bulk CRUD Operations in ASP.NET Core with Oracle Mar 26, 2026. Boost ASP.NET Core performance with Oracle! Learn bulk CRUD using Global Temporary Tables, stored procedures, and Dapper for efficient handling of 100K+ records.
• How to Build a Local AI Chatbot Using Open Source LLMs Without OpenAI APIMar 24, 2026. Build your own local AI chatbot using open-source LLMs! This guide provides a step-by-step approach, covering setup with Ollama, LangChain, and Streamlit. Enjoy privacy and cost savings!
• How to Create AI Chatbot with Memory Using LangChain and Local DatabaseMar 24, 2026. Build an AI chatbot with memory using LangChain, local LLMs, and databases. Create personalized, private, and cost-effective AI solutions locally. Learn how!
• How to Use Ollama to Run Large Language Models Locally on Your SystemMar 24, 2026. Run LLMs locally with Ollama! This guide simplifies installation, model usage, and integration for private, cost-effective AI development. Build chatbots and more!
• How to Improve PostgreSQL Performance Using Table Partitioning in CQRS SystemsMar 23, 2026. Improve PostgreSQL performance by partitioning large tables! This guide covers range partitioning with pg_partman, addressing common pitfalls and maintenance.
• Intelligent Tiering for Amazon S3 TablesMar 20, 2026. Optimize Amazon S3 costs for Apache Iceberg tables with intelligent tiering. Learn how to analyze access patterns, implement lifecycle policies, and reduce storage expenses without sacrificing performance.
• Git Commands to Push a Local Project to an Azure DevOps RepositoryMar 16, 2026. Learn how to push your local Git project to an Azure DevOps repository! This guide covers essential commands for initializing, staging, committing, and pushing code, enabling version control and collaboration. Streamline your workflow with Git and Azure DevOps.
• How to Optimize PostgreSQL Queries for Large Datasets?Mar 16, 2026. Optimize PostgreSQL queries for large datasets! Learn indexing, EXPLAIN analysis, partitioning, caching, and more to boost speed and efficiency. #PostgreSQL
• Running Claude Locally on Your Mac Using DockerMar 13, 2026. Learn how to run a Claude-compatible AI model locally on your MacBook using Docker Model Runner and Claude Code. A beginner-friendly, step-by-step guide for developers who want local, private AI without any cloud dependency.
• Ingesting Tables from Fabric Lakehouse to Fabric Warehouse using Copy JobMar 04, 2026. In this article, you'll learn how to efficiently transfer curated tables from a Fabric Lakehouse to a Fabric Warehouse using Copy Jobs. Optimize your data architecture for high-performance SQL queries and reporting.
• How Variables Work in Power Apps - Set vs UpdateContext vs Collections Feb 27, 2026. Master Power Apps variables! Learn when to use Set(), UpdateContext(), and ClearCollect() for efficient data management, global states, and screen-specific logic. Build cleaner, more professional apps. Variables are essential for managing data and state in Power Apps, but understanding the difference between Set, UpdateContext, and Collections can be confusing for beginners. This article clearly explains when and why to use each type of variable. Learn the scope, behavior, and real-world usage scenarios with simple examples. A beginner-friendly guide to help you write cleaner and more efficient Power Fx formulas.
• How to Use the Index Function in Power AppsFeb 27, 2026. Master the Power Apps Index function! Learn how to retrieve specific items from collections and tables by position, enhancing app interactivity and efficiency. Dynamic data selection made easy!
• Creating a Table Manually in Power BIFeb 25, 2026. Learn how to create tables manually in Power BI using 'Enter Data', DAX, and visuals. Perfect for reference data, parameters, and testing. Boost your Power BI skills!
• Nanobots: What They Are and How They Work in Medicine and AI AssistantsFeb 19, 2026. Learn what nanobots are and how they work, from real-world nanoscale science to a lightweight “Nanobot” AI assistant you can run locally.
• Building A Habit Tracker App In Flutter: Part 4 - Advanced Tracking & NotificationsFeb 14, 2026. Elevate your Flutter habit tracker! Learn advanced tracking with streaks, history, & local notifications using flutter_local_notifications. Boost user engagement now!
• Why Does MySQL Lock Tables During Heavy Traffic?Feb 13, 2026. Unlock MySQL performance! Discover why table locking occurs during heavy traffic, impacting speed. Learn to optimize InnoDB, indexing, and transactions for scalability.
• Using OpenClaw with Windows SandboxFeb 12, 2026. Learn what it means to run OpenClaw in Windows Sandbox and how to use it safely for testing. Includes when to use it, when not to, and simple safety rules anyone can follow.
• Connecting Lakehouses to Fabric Notebooks and Reading Delta TablesFeb 10, 2026. In this article, you will discover how to seamlessly connect Lakehouses to Fabric Notebooks for effortless data access and transformation. Simplify data workflows and boost productivity!
• How to Upload an Image to the Dataverse Table Using Web API in Power PagesFeb 10, 2026. Learn how to upload images to Dataverse tables from Power Pages using Web API! This tutorial covers configuration, UI design, and JavaScript code for image uploads.
• What Is OpenClaw? Everything You Need To Know Feb 06, 2026. OpenClaw is an autonomous open source AI agent that runs locally and performs real world tasks. Learn what OpenClaw is, how it works, use cases, risks, and why developers are paying attention.
• Local LLMs Explained: How to Run Powerful AI on Your Laptop Without InternetJan 27, 2026. Discover Local LLMs: Run powerful AI models like LLaMA and Mistral directly on your laptop, offline, and privately. Unlock data privacy and cost savings!
• Integrating Ollama with LangChain: Building Fully Local LLM ApplicationsJan 26, 2026. Build fully local LLM applications with Ollama and LangChain! This guide covers setup, text generation, chat models, agents, and model customization for private, cost-free AI.
• Using Enter Data in Power BI: The Most Underrated Feature You’re Probably IgnoringJan 24, 2026. I n this article, I demonstrated how to use Power BI's hidden gem: Enter Data! Quickly create lookup tables, mock data, and KPIs directly within Power BI, bypassing Excel and external sources. Perfect for prototyping and small datasets.
• What Ollama Launch Is and How to Use It for Local and Cloud Coding ToolsJan 25, 2026. Learn what Ollama Launch is and how to use it to configure and run coding tools with local or cloud AI models using a single command.
• Auto‑Sync Azure AD Users to a Dataverse Table Using a Scheduled Power Automate FlowJan 22, 2026. Automate Azure AD user synchronization to Dataverse! This guide provides a Power Automate flow to read users from Microsoft Graph and upsert them into a Dataverse table. Streamline user management and ensure data consistency.
• Cache, Local Storage, and Modern Caching TechniquesJan 19, 2026. Boost web app performance! Learn the differences between cache, local storage, session storage, and cookies. Explore caching techniques like Write-Through, Write-Behind, and eviction strategies for optimal efficiency.
• UNDROP in Azure Databricks: Recover Dropped Tables Like a ProJan 20, 2026. In this article, I covered how to use the UNDROP command in Azure Databricks with Unity Catalog to recover accidentally dropped tables and materialized views. A data engineer's lifesaver! Discover syntax, permissions, and limitations for effective data recovery.
• Building Smarter Galleries in PowerApps with Table & Record FunctionsJan 06, 2026. Learn to build dynamic PowerApps galleries using Table & Record functions! Master AddColumns, DropColumns, RenameColumns, and ShowColumns for optimized data display.
• How to Restrict Dataverse Table Records to Logged-in Users in Power PagesJan 01, 2026. Learn how to restrict Dataverse table records to logged-in users, ensuring they only see their data. Implement contact-based access control for improved security.
• Import Large Data Sets into Dataverse table Using DataflowsDec 21, 2025. Learn how to efficiently import large datasets into Dataverse using dataflows. This guide provides step-by-step instructions, including filtering and connection tips. Track import history and verify data in your tables.
• Getting Started with Foundry Local: Run AI Models on Your Own DeviceDec 17, 2025. Running AI models on your own laptop or PC is now easy with Foundry Local, a small tool you install and use from the command line. It lets you download, run, and manage modern AI models locally so you can experiment, build apps, or work offline.?
• n8n Native Data Tables - Built-in Structured Data Storage for Smarter AutomationsDec 17, 2025. Unlock smarter automations with n8n Native Data Tables, a built-in data storage feature that allows you to persist structured data directly within your workflows. By eliminating the need for external databases, spreadsheets, or third-party tools, n8n simplifies data management while keeping automations fast and reliable. In this article, you’ll learn how n8n Native Data Tables work, explore real-world use cases, understand their benefits and limitations, and see practical automation examples you can apply immediately.
• Entity Framework Core – Code First ApproachDec 14, 2025. This article provides a complete and descriptive explanation of the Entity Framework Core Code First approach. It explains how databases are created and managed using C# classes, how DbContext and entities work together, how migrations handle schema changes, and how relationships, configuration, and change tracking are managed in Code First development. Written in simple language, this guide is ideal for beginners and professional .NET developers building modern, scalable applications using Entity Framework Core and SQL Server.
• How to Reduce Lock Contention in SQL Server Financial Ledger TablesDec 02, 2025. Reduce SQL Server lock contention in financial ledger tables! Implement practical techniques like RCSI, insert-only patterns, and optimized indexing for high-concurrency.
• Memory-Optimized Table Variables vs Temp Tables in SQL ServerDec 01, 2025. Unlock peak SQL Server performance! This guide compares memory-optimized table variables and temp tables, offering benchmarks and best practices for optimal use.
• Partition-wise Parallelism Optimization for Very Large TablesNov 27, 2025. Unlock peak SQL Server performance! Learn partition-wise parallelism for massive tables: design, tuning, and real-world examples for faster queries and ETL.
• Improving Slow Scalar Functions Using Inline Table-Valued FunctionsNov 27, 2025. Boost SQL Server performance by replacing slow scalar UDFs with inline table-valued functions (iTVFs). Eliminate row-by-row processing and enable set-based optimization.
• 🚀 Building a Local Document RAG System Using Node.js, Supabase, and OpenAINov 25, 2025. Build a local RAG system with Node.js, Supabase, and OpenAI! Index PDFs, ask questions in natural language, and get accurate answers. Secure & scalable!
• SQL Server Basics: Tables, Primary Keys, Foreign Keys — Explained SimplyNov 24, 2025. Master SQL Server basics! Learn about tables, primary keys, foreign keys, and normalization with clear examples. Build robust, reliable databases. Improve data integrity.
• Creating a SQL Rule Engine Table (Validation Conditions Executed Dynamically)Nov 20, 2025. Build a dynamic SQL rule engine for validation. Define rules as data, not code, enabling rapid changes without deployments. Ideal for ERP, CRM, and more!
• SQL Server Data Federation (Split Big Tables Across Databases but Query as One)Nov 21, 2025. Scale SQL Server databases by splitting large tables across multiple physical databases while querying them as one. Improve performance, isolation, and flexibility.
• Building an Enterprise-Ready Angular Application with Local Machine Learning, Web Workers, and SignalsNov 19, 2025. This article explains a practical architecture for building AI-assisted Angular applications that perform local inference using ONNX Runtime Web or WebDNN. The focus is on real-world requirements: smooth UI, offline capability, strong modularity, and support for multiple ML pipelines.
• Building an API Activity Log Table (Who Accessed What, When, and What Changed)Nov 17, 2025. Build a complete API activity logging system in ASP.NET Core with SQL Server and Angular. Track API access, data changes, and ensure audit compliance.
• Designing a Data Versioning System — store history of every record (SQL Server + .NET)Nov 17, 2025. Implement data versioning in SQL Server and .NET to track record changes. Essential for audit, compliance, and features like time travel and record revert.
• Building a Custom Merge Replication for Selected Tables Only (SQL Server + .NET)Nov 17, 2025. Build a custom merge replication system in SQL Server with .NET for selective table syncing, conflict resolution, and incremental updates. Control, version, and monitor your data!
• Creating a SQL-Based Notification System (Trigger + Queue Table)Nov 18, 2025. Build a robust SQL notification system using triggers and a queue table. Centralize data event tracking, enabling real-time alerts and asynchronous workflows. Includes practical scripts and architecture.
• Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of RecordsNov 15, 2025. Master SQL Server data partitioning! This guide provides a step-by-step approach to efficiently manage large tables, boost query speed, and simplify maintenance.
• Build and Run Local AI Models Using Ollama and LangChainNov 11, 2025. Learn how to build a private, high-performance local AI assistant using Ollama and LangChain. This guide covers installation, setup, prompt orchestration, and integration with local data.
• Step-by-Step Guide to Configure Power Pages Web API for Dataverse IntegrationNov 10, 2025. Learn how to configure Power Pages Web API for seamless Dataverse integration. This step-by-step guide covers site settings, table permissions, and web roles to enable CRUD operations. Master add, view, update, and delete functionalities with ease. Boost your Power Pages development!
• Data Versioning and Auditing in SQL Server with Temporal TablesNov 05, 2025. SQL Server Temporal Tables offer built-in data versioning and auditing, simplifying history tracking and compliance. Restore data, query past states easily!
• Multiplication table generator in JavaScriptNov 06, 2025. Create dynamic multiplication tables in JavaScript! This tutorial provides a simple, interactive code snippet for generating tables in real-time. Perfect for learning!
• WCF Service for Local Device Integration and Cloud API Interaction in C#Oct 31, 2025. Integrate local devices with cloud APIs using WCF in C#. Learn to build a secure, reliable middleware for seamless data exchange between Windows devices and cloud services.
• Mastering host.json and local.settings.json in Enterprise Serverless ArchitecturesOct 17, 2025. Unlock the secrets of Azure Functions configuration! This article dives deep into host.json and local.settings.json, crucial for building robust serverless applications. Learn how to properly configure these files for optimal performance, security, and scalability, drawing from real-world healthcare pipeline examples. Master configuration as code and avoid common pitfalls that can lead to fragile, insecure deployments. Elevate your serverless architecture today!
• Azure Functions: Hosting, Local Development, and Trigger ConfigurationOct 17, 2025. Unlock the power of Azure Functions for enterprise-grade applications! This guide dives into hosting plans (Consumption, Premium, App Service), local development best practices using Core Tools, and the crucial role of function.json in trigger/binding configuration. Learn how to build a real-time fraud detection system in fintech, ensuring low latency and scalability. Avoid common pitfalls like cold starts and misconfigured bindings with our expert insights. Master serverless architecture for robust, event-driven systems.