In this Microsoft SQL Server 2025 series: Two new features are available in SQL Server 2025 for string operations; both for string concatenation. || Operator The string operator || concatenates two (or more) strings into a single expression. This operator…
Blog Archives
Advent of 2025, Day 23 – SQL Server 2025 – T-SQL Features – String concatenation with || and compound assignment ||=
Tagged with: books, database, function, SQL, SQL Server, sql server 2025, string manipulation, T-SQL
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 22 – SQL Server 2025 – T-SQL Features – UNISTR()
n this Microsoft SQL Server 2025 series: UNISTR() function is a new T-SQL function in SQL Server 2025. It will help you with unicode string literals (e.g.: special characters, emoji, special language alphabets and others) by letting you specify the…
Advent of 2025, Day 19 – SQL Server 2025 – New T-SQL functions – CURRENT_DATE
In this Microsoft SQL Server 2025 series: This function returns the current database system date as a date value, without the database time and time zone offset. CURRENT_DATE derives this value from the underlying operating system on the Database Engine…
Advent of 2025, Day 18 – SQL Server 2025 – Optimized locking
In this Microsoft SQL Server 2025 series: Optimized locking is a new feature in SQL Server 2025. It helps to reduce lock memory as very few locks are held even for large transactions. In addition, optimized locking avoids lock escalations…
Tagged with: concurrent sessions, database, locking, SQL, SQL Server, sql server 2025, T-SQL, technology
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 17 – SQL Server 2025 – Query hint ABORT_QUERY_EXECUTION
In this Microsoft SQL Server 2025 series: New query hint, ABORT_QUERY_EXECUTION is intended to be used as a Query Store hint to letadministrators block future execution of known problematic queries, for example non-essential queries causing high resource consumption and affecting…
Tagged with: database, hint, optimization, performance, query hints, query store, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 16 – SQL Server 2025 – Optional parameter plan optimization (OPPO)
In this Microsoft SQL Server 2025 series: Part of new features in IQP (Intelligent query processing) is also OPPO – Optional parameter plan optimization – which refers to a specific variation of the parameter-sensitive plan (PSP) or Parameter Sensitive Plan…
Tagged with: cardinality estimator, database, execution plan, IQP, parameter sniffing, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 13 – SQL Server 2025 – Vector functions
In this Microsoft SQL Server 2025 series: Yesterday we looked into Vector data type and how to create table, insert the vector and read it. With SQL Server 2025, vector data type comes equipped also with couple of functions: Let’s…
Tagged with: cosine distance, JSON, SQL Server, sql server 2025, T-SQL, vector, vector database, vector distance, vector search
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 12 – SQL Server 2025 – New vector data type and Vector functions
In this Microsoft SQL Server 2025 series: The vector data type is designed to store vector data optimized for operations such as similarity search and machine learning applications. Vectors are stored in an optimized binary format but are exposed as…
 | laresbernardo on LazyMouse – R package fo… |
| laresbernardo on LazyMouse – R package fo… |
| Randomly Moving the… on LazyMouse – R package fo… | |
| Advent of 2025, Day… on Advent of 2025, Day 23 – SQL S… | |
| Advent of 2025, Day… on Advent of 2025, Day 22 – SQL S… |
TomazTsql 