InCodeXbySergio Govoni·Aug 10AI where business data lives — Part 2Generating embeddings with Azure OpenAI and T-SQL
InCodeXbySergio Govoni·Jul 28AI where business data lives — Part 1Preparing data for semantic search with SQL Server 2025 and Azure SQLA response icon1A response icon1
InCodeXbySergio Govoni·Jun 12Azure SQL Database and Private EndpointA practical note on Azure SQL Database, Private Endpoint, and regional constraints in virtual network selection
InCodeXbySergio Govoni·Dec 5, 2025SQL Server 2025 Optimized Locking: Transaction ID (TID) internalsHow to retrieve and interpret the Transaction ID stored in row data pages
InCodeXbySergio Govoni·Nov 9, 2025How Optimized Locking in SQL Server 2025 handles concurrent updatesA practical look at how the new locking model manages concurrent updates using Transaction ID (TID) locks
Sergio Govoni·Oct 3, 2025Delphi 12 — How to debug runtime packages when breakpoints are ignoredA workaround to make the debugger work again until an official fix is released
Sergio Govoni·Sep 16, 2025Handling SQL Server SSL issues in Delphi applications using FireDACA practical approach to troubleshooting database connection security in Delphi with FireDAC
InCodeXbySergio Govoni·Sep 7, 2025Better plans with Optional Parameter Plan Optimization in SQL Server 2025Discover how SQL Server 2025 leverages Optional Parameter Plan Optimization to improve parameter-sensitive queries execution plans!
InCodeXbySergio Govoni·Aug 3, 2025SQL Server 2025: Are your applications still using deprecated features?Using sys.dm_os_performance_counters to detect deprecated feature usage in SQL Server