New-Functions-in-SQL-Server-2012

Resources

Building Durable .NET Workflows with AWS Lambda Durable ExecutionAug 12, 2026. Build resilient .NET workflows on AWS Lambda with Durable Execution. Manage state, retries, and long waits directly in C# code.
Migrating MCP C# Servers from SDK 1.x to 2.0Aug 11, 2026. Migrate MCP C# servers from SDK 1.x to 2.0 with this guide. Learn about stateless HTTP, protocol negotiation, and API changes for a smooth transition.
Benchmarking Stateless MCP Servers Behind Load BalancersAug 11, 2026. Benchmark stateless MCP servers behind load balancers to measure throughput, latency, resource consumption, and scaling behavior for optimal .NET deployments.
EF Core 11 Query Translation Changes Under Real WorkloadsAug 11, 2026. Evaluate EF Core 11 query translation changes with real workloads. Learn to benchmark, inspect SQL, and analyze execution plans for optimal performance.
SQL Server Vector Search: Benchmarking EF Core WorkloadsAug 10, 2026. Benchmark SQL Server vector search with EF Core. Explore exact vs. approximate search, performance factors, and best practices for RAG.
Full Outer Joins in LINQ: Performance and SQL TranslationAug 10, 2026. Explore .NET 11's FullJoin in LINQ for explicit full outer joins. Optimize database queries with EF Core translation and understand performance implications.
MCP HTTP Scalability with the New C# SDK 2.0Aug 10, 2026. Unlock MCP HTTP scalability with C# SDK 2.0. Embrace stateless design for easier horizontal scaling and leverage familiar ASP.NET Core infrastructure.
Complete Guide: Mapping a Custom Domain to an Azure Virtual Machine (VM)Aug 08, 2026. Map your custom domain to an Azure VM. Learn to set static IPs, configure NSG rules, update DNS, and bind your web server for seamless access.
Event-Driven AI Processing with Azure Functions Durable OrchestrationsAug 06, 2026. Build scalable, event-driven AI processing pipelines with Azure Functions Durable Orchestrations. Manage complex, multi-step workflows reliably.
How Enterprise Applications Leverage SQL Server Temporal Tables for Time-Travel Auditing and ComplianceAug 05, 2026. SQL Server Temporal Tables offer built-in time-travel auditing & compliance for enterprises, simplifying data history management.
Building an Azure SQL to Dataverse Migration Solution with the New Dataverse SDK for PythonAug 06, 2026. Build an Azure SQL to Dataverse migration solution using the new Dataverse SDK for Python. Integrate enterprise data seamlessly.
Zero-Impact Data Tracking: How SQL Server Change Data Capture Works at the Log LevelAug 05, 2026. SQL Server CDC tracks row changes asynchronously via the transaction log, offering zero-impact auditing, event streaming, and synchronization.
How to Resolve SQL Server Error 40 ("Could Not Open a Connection to SQL Server")Aug 04, 2026. Resolve SQL Server Error 40 in ASP.NET Core. Troubleshoot connection issues with Entity Framework Core, connection strings, and configuration.
Building AI-Powered Build Diagnostics with the Microsoft Binlog MCP ServerAug 04, 2026. AI-powered build diagnostics with Microsoft Binlog MCP Server. Analyze MSBuild .binlog files via natural language for faster debugging.
Securing MCP Servers Against Prompt Injection and Tool PoisoningAug 03, 2026. Secure MCP servers against prompt injection & tool poisoning. Learn AI-specific risks & implement practical production security measures.
Building MCP Servers with ASP.NET Core for Enterprise AI AgentsAug 03, 2026. Build AI-ready enterprise agents with ASP.NET Core and MCP. Standardize tool discovery, reduce integration complexity, and enhance security.
Dissect a cluster index in the SQL serverAug 01, 2026. Understand SQL Server's Clustered Index: how it physically orders data, its properties, and the performance boost it offers over heaps.
SQL Server Indexing Strategies for Large OLTP SystemsJul 31, 2026. Master SQL Server indexing for large OLTP systems. Optimize queries, reduce scans, and boost performance with practical strategies.
Quantum Key Distribution (QKD) for Secure Blockchain Networks: A New Era of Secure Key ExchangeJul 30, 2026. Explore Quantum Key Distribution (QKD) for blockchain. Discover how it secures key exchange, enhancing decentralized systems against future threats.
SQL Server Performance Troubleshooting: 10 Queries Every Developer Should KnowJul 29, 2026. Master SQL Server performance with 10 essential queries for developers. Troubleshoot bottlenecks, optimize queries, and ensure application responsiveness.
Output Caching vs Response Caching in ASP.NET Core: What's the Difference?Jul 29, 2026. ASP.NET Core: Output Caching vs. Response Caching. Understand the key differences, when to use each, and best practices for optimal performance.
10 Common SQL Interview Questions Every Developer Should KnowJul 29, 2026. Master SQL interviews with 10 essential questions on DELETE, WHERE, JOINs, UNION, keys, CHAR/VARCHAR, indexes, COUNT, stored procedures & normalization.
Beyond Chatbots and Flowcharts: Why Gate2ASI AI’s AgentFactory Is a New Enterprise Execution ModelJul 28, 2026. Gate2ASI AI's AgentFactory redefines enterprise AI execution with a governed digital workforce, moving beyond chatbots for dependable business outcomes.
Building Production-Ready MCP Servers in ASP.NET Core 10Jul 28, 2026. Build secure, scalable, and production-ready MCP servers in ASP.NET Core 10. Learn best practices for AI integration, authentication, and deployment.
How to use ShowColumns() Function in Power Apps Jul 27, 2026. Master Power Apps' ShowColumns() function to select specific data columns, streamlining your apps and improving performance. Learn syntax and examples.
How to Use RenameColumns() in Power AppsJul 27, 2026. Master RenameColumns() in Power Apps for dynamic data transformation. Rename columns temporarily for galleries & more!
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.
C# 14 New Features Explained with Practical ExamplesJul 24, 2026. Explore C# 14's new features: Extension Members, Collection Expressions, Pattern Matching, Primary Constructors, Null Safety, and .NET integration.
Building an AI Coding Assistant in ASP.NET Core Using MCP ServersJul 24, 2026. Build an AI coding assistant in ASP.NET Core using MCP servers to access project files, APIs, and tools for enhanced development workflows.
Background Processing in ASP.NET Core: Choosing the Right ApproachJul 23, 2026. Master ASP.NET Core background processing! Compare BackgroundService, Hangfire, Quartz.NET, Azure Functions & Service Bus for optimal performance.
Entity Framework Core Performance Anti-Patterns in ProductionJul 23, 2026. Master EF Core performance! Avoid common anti-patterns like N+1 queries, over-fetching, and client-side evaluation for faster, scalable .NET apps.
Understanding EXPLAIN FORMATTED in Databricks SQLJul 23, 2026. Master Databricks SQL query optimization with EXPLAIN FORMATTED. Uncover Spark's execution plans, identify bottlenecks, and tune performance.
SQL Server Query Performance Troubleshooting Guide for .NET DevelopersJul 23, 2026. Master SQL Server query performance for .NET apps. Learn to troubleshoot, optimize indexes, and write efficient queries for faster responsiveness.
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.
.NET 11 Preview 6 New FeaturesJul 22, 2026. .NET 11 Preview 6 boosts performance, productivity, and cloud-native dev with JIT, Native AOT, ASP.NET Core, and SDK enhancements.
React 20 Hooks: New Patterns and Performance ImprovementsJul 21, 2026. Master React 20 Hooks: Explore new patterns, performance boosts, and best practices for efficient, maintainable React apps.
Building AI Chat Applications with ASP.NET Core and Server-Sent EventsJul 21, 2026. Build real-time AI chat apps with ASP.NET Core and Server-Sent Events (SSE). Stream AI responses for a faster, interactive user experience.
What's New in C# 14: Features Every .NET Developer Should KnowJul 21, 2026. Discover C# 14's key features: enhanced collection expressions, pattern matching, null safety, and compiler optimizations for .NET developers.
Building AI-Powered Search with SQL Server and Vector IndexesJul 21, 2026. Unlock AI-powered search in SQL Server 2026 with vector indexes. Discover semantic search, natural language queries, and enhanced relevance for modern applications.
Understanding SHOWPLAN_ALL in SQL Server and Microsoft FabricJul 21, 2026. In this article, you'll learn hoe to master SQL Server's SHOWPLAN_ALL for query optimization. Understand execution plans, avoid pitfalls, and tune for peak performance.
SQL Server Query Store: Monitoring and Fixing Slow QueriesJul 21, 2026. SQL Server Query Store: Monitor, diagnose, and fix slow queries with historical data, execution plans, and performance metrics.
.NET 11 Preview 6: New Features, Performance Improvements, and Breaking ChangesJul 20, 2026. .NET 11 Preview 6: Discover new features, performance boosts, and critical breaking changes for faster, more efficient app development.
Next.js 16 Server Components: Performance Best PracticesJul 20, 2026. Master Next.js 16 Server Components for peak performance. Learn best practices for faster loads, smaller bundles, and improved SEO.
Entity Framework Core 11: New Features and Performance EnhancementsJul 20, 2026. Discover EF Core 11's performance boosts, new features, and best practices for faster .NET data access and efficient database management.
C# Union Types Explained: What's New in .NET 11 and When to Use ThemJul 20, 2026. Explore C# Union Types in .NET 11! Learn how they simplify handling multiple outcomes, improve type safety, and lead to cleaner, more maintainable code.
Azure Functions vs Azure Container Apps: Choosing the Right Serverless PlatformJul 20, 2026. Compare Azure Functions vs. Azure Container Apps for serverless. Choose the right platform based on workload, scalability, and deployment needs.
Blazor Web Apps in .NET 11: What's New for Full-Stack DevelopmentJul 20, 2026. Explore Blazor Web Apps in .NET 11: new features for faster performance, enhanced developer productivity, and seamless full-stack C# development.
SQL Server Query Performance Tuning Using Execution PlansJul 20, 2026. Master SQL Server query performance tuning with execution plans. Identify bottlenecks, optimize indexes, and improve database speed.
JWT Session 11: Replace Hardcoded Login with EF Core Database Authentication in ASP.NET Core Web APIJul 19, 2026. Replace hardcoded login with EF Core database authentication in ASP.NET Core Web API for secure user management and JWT generation.
Understanding __new__ vs __init__ in Python: Allocation, Initialization, and Object PoolingJul 18, 2026. Demystify Python's __new__ vs __init__: understand object creation, subclassing immutables, and implementing powerful patterns like Object Pooling.
.NET 11 Preview 8: New Features and Breaking Changes ExplainedJul 16, 2026. .NET 11 Preview 8: Explore new features like runtime performance, Native AOT, and JSON serialization. Prepare for breaking changes.
Next.js 16 Performance Optimization Guide for Production ApplicationsJul 16, 2026. Unlock Next.js 16 production performance! Master Server Components, ISR, image optimization, caching, and more for faster apps.
Caddy vs Nginx: Choosing the Right Web Server for Modern ApplicationsJul 16, 2026. Compare Caddy and Nginx web servers, including performance, HTTPS management, security, configuration, and deployment considerations for modern applications.
Model Context Protocol Registries Explained: Managing Enterprise MCP EcosystemsJul 16, 2026. Learn what Model Context Protocol (MCP) Registries are, how they work, and how enterprises use them to manage, secure, and scale AI tool ecosystems.
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.
HTMX vs React: Choosing the Right Approach for Modern Web DevelopmentJul 16, 2026. Compare HTMX and React across architecture, performance, SEO, state management, and development complexity to choose the right web development approach.
SurrealDB Tutorial: Combining Relational, Document, and Graph DatabasesJul 16, 2026. Learn how SurrealDB combines relational, document, graph, and real-time database capabilities into a single platform for modern application development.
WebAssembly on the Server: Understanding WASI and Modern Runtime ModelsJul 15, 2026. Learn how WebAssembly and WASI enable secure, portable, and efficient server-side applications with modern runtime models for cloud-native and edge computing.
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.
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.
How to Use AddColumns() Function in Power AppsJul 14, 2026. Master Power Apps' AddColumns() to create dynamic, calculated columns without altering your data source. Enhance efficiency and readability.
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.
MCP Servers in Practice: Building Secure Tool Integrations for AI AgentsJul 13, 2026. Discover MCP Servers for secure AI agent tool integrations. Standardize, simplify, and enhance security for dynamic external system access.
.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.
Building Realtime Multiplayer Systems with Nakama ServerJul 09, 2026. Build scalable multiplayer games faster with Nakama Server. Explore its features for authentication, matchmaking, real-time sync, and more.
HTMX Tutorial: Building Modern Web Applications Without Heavy JavaScript FrameworksJul 09, 2026. Learn HTMX: build modern, interactive web apps with HTML attributes, reducing JavaScript complexity and improving performance.
Installing and Using Windows Admin Center on Windows ServerJul 08, 2026. Master Windows Server management with Windows Admin Center. Install, configure, and use this free tool for efficient server monitoring and administration.
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.
Caddy vs Nginx: Which Web Server Should Developers Choose in 2026?Jul 08, 2026. Caddy vs Nginx: Compare web servers for developers in 2026. Discover which is best for simplicity, automation, or advanced control.
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.
ARM vs x86 Servers: Performance and Cost Comparison for Cloud ApplicationsJul 06, 2026. Compare ARM vs x86 servers for cloud apps: explore performance, cost, power efficiency, and compatibility to optimize your infrastructure.
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.
Running Production Workloads on ARM Servers: Benefits and ChallengesJul 03, 2026. Explore ARM servers for production workloads: benefits like cost savings & efficiency, challenges like compatibility, and migration strategies.
.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.
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.
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!
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
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.
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.
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.
Event Driven Architecture backdrop or workflow orchestrationJun 16, 2026. This article explains workflow orchestration, a technology prior to Event Driven Architecture.. if you understand this, you will easily understand event driven architecture
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.
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.
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.

Tags