SQL-New-Logical-Function

Resources

Apache DataFusion Tutorial: Building High-Performance Query Engines in RustJul 16, 2026. Learn Apache DataFusion fundamentals, architecture, and query execution. Build high-performance analytical applications and custom query engines in Rust.
DuckDB Tutorial: Building Analytics Applications Without a Data WarehouseJul 15, 2026. Learn how DuckDB enables fast analytics without a traditional data warehouse. Explore architecture, use cases, benefits, and implementation tips.
Cloudflare Workers Tutorial: Building Applications at the EdgeJul 15, 2026. Learn how to build and deploy edge applications with Cloudflare Workers, enabling low-latency APIs, serverless computing, and globally distributed applications.
Semantic Kernel Plugins Explained: Extending AI Applications with .NETJul 13, 2026. Unlock AI potential with Semantic Kernel Plugins! Extend .NET apps to interact with databases, APIs, and real-world systems for powerful AI agents.
.NET 11 Preview 6: New Features Every C# Developer Should KnowJul 10, 2026. .NET 11 Preview 6: Discover key C# enhancements in performance, cloud-native, AI, and developer productivity. Prepare for the future!
SurrealDB Explained: Combining SQL, Graph, and Document DatabasesJul 09, 2026. SurrealDB unifies SQL, graph, and document databases for modern apps. Simplify architecture with a single, multi-model solution.
Avoid Delegation Warnings When Using If() Inside Filter() in Power AppsJul 09, 2026. Avoid If() inside Power Apps Filter() to prevent delegation issues. Learn how to optimize your formulas for large datasets.
The New Security Boundary: Containing Autonomous Intelligence with AgentFactoryJul 08, 2026. Securely contain autonomous AI with AgentFactory. Govern digital labor, enforce boundaries, and ensure auditable, reversible execution.
PostgreSQL Logical Replication Explained for High Availability SystemsJul 07, 2026. Master PostgreSQL Logical Replication for high availability. Learn its architecture, benefits, and use cases for scalable, resilient data systems.
DuckDB Tutorial: Getting Started with the Fastest Analytics DatabaseJul 06, 2026. Master DuckDB! Learn to install and use this lightning-fast, serverless analytics database for efficient data analysis and reporting.
How to Use the GroupBy Function in Power Apps Jul 06, 2026. Master Power Apps GroupBy() for efficient data organization, hierarchical galleries, and powerful summary reports. Elevate your app development!
HTTP QUERY: The New HTTP Method That Makes Complex Searches CleanerJul 04, 2026. HTTP QUERY is a new method for cleaner, complex searches, combining POST's body flexibility with GET's safety and cacheability.
HTTP QUERY: The Missing Piece Between GET and POST, 16 Years in the MakingJul 05, 2026. Introducing HTTP QUERY: the new standard method solving API search limitations. It combines GET's safety with POST's payload capacity, fixing a 16-year-old design gap.
USERPRINCIPALNAME DAX FunctionJul 02, 2026. Unlock Power BI dynamic security with USERPRINCIPALNAME(). Securely filter data by user email for personalized, scalable reports in the Power BI Service.
.NET 11 and AI: What's New for Enterprise Developers in 2026Jul 02, 2026. .NET 11 empowers enterprise developers with AI integration, enhanced performance, cloud-native features, and improved productivity for 2026.
Graph Databases vs Relational Databases: Choosing the Right ModelJul 03, 2026. Graph vs. Relational Databases: Understand strengths, weaknesses, and use cases to choose the right data model for your application.
What's New in .NET 11: Features, Performance Improvements, and Migration GuideJul 02, 2026. .NET 11 boosts performance, productivity & cloud-native dev with Native AOT, faster ASP.NET Core, smarter GC & improved tooling. Migrate easily!
PostgreSQL vs SQL Server for Modern .NET ApplicationsJul 02, 2026. Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.
AI Isn't Replacing Technical Product Managers—It's Creating a New Generation of Super PMsJun 30, 2026. Learn how AI is transforming the role of Technical Product Managers across the entire product lifecycle. Discover practical AI use cases for research, prioritization, roadmap planning, user story generation, analytics, release management, and stakeholder communication—while understanding why strategic thinking and customer empathy remain uniquely human.
How to Convert Text into Currency ($) Format in Power AppsJul 01, 2026. Learn to format numbers as currency in Power Apps using the Text() function for professional and readable financial data display.
Building AI-Powered Database Query Optimization Tools with SQL Server and .NETJun 30, 2026. Build AI-powered SQL Server query optimization tools with .NET. Automate performance analysis, detect bottlenecks, and get intelligent recommendations.
Building an AI-Driven Database Query Performance Analyzer with .NET and SQL ServerJun 30, 2026. Build an AI-driven .NET and SQL Server analyzer to boost database query performance, reduce troubleshooting time, and enhance application responsiveness.
Microsoft Fabric Update: You Can Now Adjust Column Width in the SQL Analytics Endpoint User InterfaceJun 26, 2026. This article is about the new feature in Microsoft Fabric that allows you to adjust column width
Building AI-Powered SQL Query Performance Advisors with Entity Framework CoreJun 26, 2026. Build AI-powered SQL query advisors with Entity Framework Core to automatically detect bottlenecks, optimize performance, and boost application responsiveness.
Intelligent Database Index Optimization Using AI and SQL ServerJun 26, 2026. Leverage AI and SQL Server DMVs with .NET to build intelligent index optimization, boosting performance and reducing manual tuning.
Why Every Databricks Data Engineer Should Audit Their Query HistoryJun 24, 2026. Audit Databricks query history to identify and optimize costly, long-running queries, ensuring financial governance and platform performance.
📖 Mastering .NET Interviews – Part 8: Azure & Cloud IntegrationJun 20, 2026. Master .NET interviews: Dive into Azure & Cloud Integration, covering App Services, Functions, Cosmos DB, and deployment best practices.
Selecting the Right Embedding Model for a New DomainJun 20, 2026. Empirically select the best embedding model for specialized domains using LangGraph. Optimize RAG performance beyond general knowledge.
Building an Inventory & Order Management System in ASP.NET Core (Setup & Core Features) Part 1Jun 19, 2026. Build an ASP.NET Core Inventory & Order Management System. Part 1 covers project setup, core features like Product, Category, Supplier, and Customer CRUD.
📖 Building a Web-Based Timesheet Management System in ASP.NET CoreJun 19, 2026. Build a robust ASP.NET Core MVC timesheet system with SQL Server. Features include entry, allocation, approvals, auth, reporting & deployment.
Designing AI Workflows with Durable Functions and Azure OpenAIJun 16, 2026. Design scalable AI workflows with Durable Functions & Azure OpenAI. Orchestrate complex tasks, manage state, and integrate AI for enterprise solutions.
Assigning Microsoft Graph API Application Permissions to a Managed Identity Using Azure CLIJun 15, 2026. Securely assign Microsoft Graph API application permissions to Azure Managed Identities using Azure CLI. Learn to retrieve App Role IDs and understand required Entra roles.
Building AI-Powered SQL Assistants with Semantic Kernel and .NETJun 16, 2026. Build AI-powered SQL assistants with Semantic Kernel and .NET to unlock data insights. Empower users with natural language queries and secure data access.
Complete Practical Guide to Design, Build, Test, and Maintain End to End Solutions in Microsoft AzureJun 15, 2026. Complete Practical Guide to Design, Build, Test, and Maintain End to End Solutions in Microsoft Azure
Kiro as AI Partner for MS SQL Server Optimization on .NET Core: What Used to Take Days Now Takes HoursJun 14, 2026. Kiro optimizes MS SQL Server for .NET Core by analyzing code & queries, transforming days of work into hours. Learn how AI partners with developers.
Proof of Skills: The New Currency of CredibilityJun 12, 2026. Proof of skills is the new credibility currency. Build, ship, and share your work to stand out in the AI era.
WSL Containers Explained: A New Alternative to Docker Desktop for Windows DevelopersJun 11, 2026. WSL Containers offer Windows developers a faster, more efficient alternative to Docker Desktop for running Linux containers locally.
C# 15 New Features Explained with Practical ExamplesJun 09, 2026. Explore C# 15's new features: enhanced collections, pattern matching, primary constructors, and more for cleaner, productive development.
Building AI-Powered Applications with .NET Aspire 10: New Features and Best PracticesJun 09, 2026. Unlock AI app development with .NET Aspire 10. Explore new features for orchestration, observability, and cloud-native deployment.
Event-Driven AI Agents with Azure Functions and Semantic KernelJun 08, 2026. Learn how to build event-driven AI agents using Azure Functions and Semantic Kernel. Discover serverless AI architectures, event processing patterns, and best practices for enterprise .NET applications.
Building a Natural Language API Gateway Using ASP.NET Core and AIJun 08, 2026. Learn how to build a Natural Language API Gateway using ASP.NET Core and AI. Discover intent detection, API orchestration, structured outputs, security controls, and enterprise implementation patterns.
Entity Framework Core Interceptors: Real-World Use Cases and ExamplesJun 05, 2026. Learn Entity Framework Core Interceptors with real-world examples. Implement auditing, soft deletes, SQL logging, and performance monitoring in EF Core applications.
SQL Server Performance Tuning Techniques for Modern ApplicationsJun 05, 2026. Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.
SQL Server Performance Tuning Techniques for Modern ApplicationsJun 05, 2026. Learn how to build scalable background services using .NET Worker Services. Process queues, run scheduled jobs, and create reliable cloud-native applications.
Implementing Row-Level Security in SQL ServerJun 03, 2026. Learn how to implement Row-Level Security in SQL Server. Secure data access, restrict rows by user, and simplify multi-tenant application security.
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.
Database Connection Pooling Explained with ExamplesJun 03, 2026. Learn Database Connection Pooling with practical examples. Understand how connection pools improve performance, scalability, and database efficiency.
Azure Managed Identity Explained with Real-World ExamplesJun 03, 2026. Learn Azure Managed Identity with real-world examples. Discover how to securely access Azure resources without storing passwords, secrets, or connection strings.
Using the COPY INTO Command to Load Data from Fabric Lakehouse to Fabric WarehouseJun 01, 2026. In this article, I demonstrated how to use the COPY INTO Command to Load Data from Microsoft Fabric Lakehouse to Fabric Warehouse
Why Copilot Is Becoming the New Developer InterfaceJun 01, 2026. Explore how GitHub Copilot is transforming software development into a natural language interface. Learn about AI-assisted coding, automation, and the future of developer workflows.
How Context Windows Are Becoming the New Scalability Problem in AI ApplicationsMay 29, 2026. Context windows are AI's new scalability bottleneck. Learn how large context impacts cost, latency, & accuracy, and how engineers are optimizing for efficiency.
Context Poisoning Attacks: The New Security Threat in AI SystemsMay 29, 2026. Context Poisoning is a critical AI security threat. Attackers manipulate AI context to cause false outputs and malicious actions. Learn how to protect your AI systems.
SQL Injection: Complete Guide with Examples and Proper SolutionsMay 21, 2026. Master SQL Injection: Understand attack types, real-world examples, and robust solutions. Learn to protect your applications with best practices and secure code.
Complete Guide to ASP.NET Core API SecurityMay 21, 2026. Comprehensive guide to ASP.NET Core API security, covering authentication, authorization, encryption, and best practices from beginner to advanced levels. Protect your APIs!
Becoming AI-Native in Enterprise Architecture: From Documentation Function to Intelligent Operating LayerMay 19, 2026. Explore AI-native enterprise architecture: Transform from documentation to an intelligent operating layer. Enhance decision-making, governance, and speed with AI. Human oversight remains key.
C# 14 New Features Explained with Real-World ExamplesMay 18, 2026. Explore C# 14's powerful new features with real-world examples! Boost productivity, reduce boilerplate, and enhance performance in your .NET applications.
What Developers Should Learn From the New AI Infrastructure RaceMay 19, 2026. The AI infrastructure race is reshaping software development. Developers must learn cloud, scalability, and AI integration for future success. Explore key skills!
What’s New in .NET 11? Complete Guide for C# DevelopersMay 18, 2026. .NET 11: A complete guide for C# developers! Explore performance boosts, AI integration, cloud-native enhancements, and improved developer productivity. Modernize your apps!
AI Context Engineering: The New Skill Developers NeedMay 15, 2026. Master AI Context Engineering! Learn how to build smarter AI apps with retrieval systems, memory management, and dynamic context. Essential skills for developers!
The New Stack: AI Agents + MCP + RAG + Vector Databases ExplainedMay 15, 2026. Unlock the power of AI! Explore AI Agents, MCP, RAG & Vector Databases. Build intelligent apps for reasoning, automation & real-world tasks. #AIStack
Count of repeating character patterns in a string using MySQLMay 13, 2026. Discover how to count repeating character patterns in strings using MySQL. This tutorial provides a step-by-step guide with code examples for text analysis and pattern recognition.
.NET 11 Preview 4 Explained: New Features Every C# Developer Should KnowMay 13, 2026. .NET 11 Preview 4 unveils performance boosts, enhanced ASP.NET Core, Native AOT improvements, and AI-ready features. C# developers, upgrade your skills now!
C# 15 New Features and Improvements Developers Need to ExploreMay 13, 2026. Explore C# 15's new features: primary constructors, collection expressions, pattern matching, async enhancements, and more. Boost productivity and code quality!
The Death of the "Vibe Coding": Why Agentic Engineering is the New StandardMay 09, 2026. Explore the shift from chaotic "Vibe Coding" to structured "Agentic Engineering" in AI-driven software development. Discover the future of robust, governed systems.
Azure App Service vs Azure Functions: When to Use What in Real ProjectsMay 06, 2026. Unlock the power of Azure! Choose App Service for web apps & APIs needing continuous availability. Opt for Functions for event-driven, serverless tasks. Hybrid is key!
Understanding Lookup() and Filter() function in PowerAppsMay 06, 2026. Understand the difference between Lookup() and Filter() in PowerApps. Learn when to use each function to retrieve single or multiple records from your data source.
Sort() vs SortByColumns() function in PowerAppsMay 05, 2026. Understand the difference between Sort() and SortByColumns() in PowerApps for efficient data sorting. Learn when to use each function with practical examples and improve your app's performance. Discover the best approach for your sorting needs!
What is Query Execution Plan in SQL Server and How to Analyze It?May 04, 2026. Unlock SQL Server query performance! Learn to analyze execution plans, identify bottlenecks like table scans, and optimize queries with indexes for faster, scalable databases.
How to Implement Soft Delete in SQL Server Using Flag ColumnsMay 04, 2026. Implement soft delete in SQL Server using flag columns for data preservation, audit trails, and recovery. Learn best practices, advantages, and real-world use cases.
Lovable Mobile App Builder: A New Era of Low-Code DevelopmentMay 01, 2026. Lovable: Revolutionizing app development with low-code! Build mobile apps faster using AI-powered tools and visual interfaces. Perfect for startups and enterprises.
Build Mobile Apps Anywhere with Lovable’s New PlatformMay 01, 2026. Build mobile apps anywhere with Lovable! This platform simplifies app development with AI & no-code tools. Ideal for startups, businesses, & personal projects.
How to Check If a Stored Procedure Exists in SQL ServerApr 29, 2026. A comprehensive guide explaining how to check whether a stored procedure exists in SQL Server using multiple methods such as INFORMATION_SCHEMA, sys.procedures, OBJECT_ID, and SSMS UI. The article also highlights practical use cases, best practices, and common issues developers face while validating stored procedures across different environments like development and production.
SQL Optimization TechniquesApr 28, 2026. SQL Optimization Techniques
Claude.md: The New Standard for AI Native Software Development DocumentationApr 28, 2026. Learn what Claude.md is, why it matters in AI native software development, and how AI coding agents use structured context to build better software faster.
Bitcoin’s Next Evolution: Can New Forks Bring Ethereum and Solana Level Utility to Bitcoin?Apr 28, 2026. Bitcoin dominates crypto in security and trust, but lacks the utility ecosystem that made Ethereum and Solana innovation leaders. New Bitcoin forks and sidechain initiatives may finally change that.
ASP.NET Core & .NET 8 What’s New and Why It MattersApr 23, 2026. The release of .NET 8 marks a major milestone in the evolution of ASP.NET Core. As a Long-Term Support (LTS) release, it focuses heavily on performance, cloud-native development, and developer productivity—making it one of the most impactful updates in recent years. In this article, we’ll explore the hottest features in ASP.NET Core with .NET 8 and understand why they matter for modern application development.
How to Connect SQL Server with C# Using Entity Framework CoreApr 23, 2026. Learn how to connect SQL Server to your C# application using Entity Framework Core. This tutorial covers setup, migrations, CRUD operations, and common pitfalls.
How to Fix SQL Server Allocation Errors and Recover Corrupted DatabasesApr 23, 2026. Fix SQL Server allocation errors and recover corrupted databases using DBCC CHECKDB or a professional SQL repair tool. Learn to detect and prevent these errors.
TypeScript 7.0 Beta: Why the New Compiler Changes EverythingApr 23, 2026.
What is database indexing strategy for large-scale applications?Apr 22, 2026. Optimize large-scale apps with database indexing! Boost performance, reduce query time, and improve user experience. Learn strategies for efficient data retrieval.
How to implement full-text search in SQL Server with exampleApr 22, 2026. Step-by-Step Implementation with Example
How to Set Default Value in PowerApps People PickerApr 22, 2026. Solve the PowerApps People Picker default value issue! This guide provides a simple solution using Coalesce to auto-populate with the current user in new forms. Improve user experience and streamline data entry for SharePoint and Dataverse.
SQL Server Performance Tuning: A Guide for .NET DevelopersApr 21, 2026. SQL Server Performance Tuning: A Guide for .NET Developers
What is Database Denormalization and When Should You Use It?Apr 21, 2026. Learn what database denormalization is, how it works, and when to use it with real-world examples, advantages, and best practices for performance optimization.
How to Implement Optimistic Concurrency Control in SQL Server?Apr 21, 2026. Learn how to implement optimistic concurrency control in SQL Server step by step using RowVersion with examples, conflict handling, and best practices.
Stop Hunting Bugs: Meet the New Visual Studio Debugger AgentApr 20, 2026. Explore the new Visual Studio Debugger Agent—an AI-powered debugging workflow that analyzes bugs, runs code, and identifies root causes automatically.
How to Implement Database Triggers in SQL Server with ExampleApr 20, 2026. Learn how to implement SQL Server database triggers step-by-step with real-world examples. Automate tasks like logging, validation, and auditing. Improve data consistency and enforce business rules efficiently. Discover best practices and avoid common pitfalls.
What is Clustered vs Non-Clustered Index in SQL Server?Apr 20, 2026. Unlock SQL Server performance! Master clustered vs. non-clustered indexes. Learn how they work, their differences, and when to use each for optimal database efficiency.
How to Handle Duplicate Records in SQL Queries EfficientlyApr 20, 2026. Master SQL duplicate record handling! Learn to identify, remove, and prevent duplicates for improved data integrity and performance. Essential for robust database management.
How to Implement Database Partitioning in SQL Server Step by Step?Apr 17, 2026. Boost SQL Server performance! Learn database partitioning step-by-step: filegroups, functions, schemes, and tables. Handle large datasets efficiently and scale easily.
What is Deadlock in SQL Server and How to Prevent It?Apr 16, 2026. Unlock SQL Server deadlock prevention! Learn causes, detection, and step-by-step techniques for optimized database performance and improved user experience.
What is Stored Procedure vs Function in SQL with Examples?Apr 17, 2026. Unlock the power of SQL! Learn the key differences between Stored Procedures and Functions with examples. Optimize database operations and boost performance. Discover when to use each for efficient, scalable applications.
How to Handle NULL Values Efficiently in SQL Queries?Apr 17, 2026. Master SQL NULL handling! Learn to use IS NULL, COALESCE, and more to avoid errors, improve data quality, and ensure accurate query results. Essential techniques for robust databases.
How to Design Database Indexes for High Performance QueriesApr 16, 2026. Boost database performance! Learn to design effective indexes for faster queries. Optimize SQL, MySQL, & PostgreSQL. Avoid common mistakes and scale efficiently.
How to Handle Concurrency in SQL Server with Locking Mechanisms?Apr 13, 2026. Master SQL Server concurrency! Learn locking, row versioning, isolation levels, and performance tuning to prevent deadlocks and ensure data integrity. Optimize your database!
What is Database Indexing and How Does It Improve Query Performance?Apr 13, 2026. Boost database speed! Learn database indexing: types, benefits, and best practices for faster queries in MySQL, SQL Server, and PostgreSQL. Optimize your database now!
Mastering URI & Data Conversion Functions in Power Automate (Step-by-Step Guide)Apr 13, 2026. Master Power Automate's URI & data conversion functions! Learn to use dataUri(), encodeUriComponent(), and more with practical examples for seamless API integration.
What Is New in Entity Framework Core 10 and Migration StepsApr 09, 2026. Explore the enhanced performance and features of Entity Framework Core 10! This guide provides a step-by-step migration from EF Core 8, covering improvements and best practices.
How to Use the New Field Keyword in C# 14 for PropertiesApr 09, 2026. Simplify C# property implementation with the 'field' keyword in C# 14! Reduce boilerplate, enhance readability, and maintain custom validation effortlessly. Boost productivity!
What are the new features in C# 14 for developer productivity?Apr 09, 2026. Explore C# 14's productivity boosters! Discover streamlined pattern matching, primary constructors, collection expressions, and more for efficient .NET development.

Tags