In this Microsoft SQL Server 2025 series: Microsoft website for SQL Server: https://www.microsoft.com/en-us/sql-server is always a good way to start. But if you would like to start more in depth documentation here is Microsoft documentation: General Youtube videos: General Github…
Blog Archives
Advent of 2025, Day 24 – SQL Server 2025 – Documentation and learning materials
Tagged with: books, documentation, education, learn, SQL, SQL Server, sql server 2025, writing
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 23 – SQL Server 2025 – T-SQL Features – String concatenation with || and compound assignment ||=
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…
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 21 – SQL Server 2025 – Change Event Streaming – part 2
In this Microsoft SQL Server 2025 series: We have looked into the settings of SQL server and generating SAS token. And now we will need to set the needed Azure services. Create Event Hub in Azure Portal In Portal create…
Tagged with: Azure, CES, cloud, database, event streaming, SQL, SQL Server, sql server 2025, technology
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 20 – SQL Server 2025 – Change Event Streaming
In this Microsoft SQL Server 2025 series: Change event streaming (CES) is data integration capability that streams SQL Server data changes directly into Azure Event hubs. It captures and publishes incremental changes of data to an Azure Event Hubs destination…
Tagged with: Azure, CES, database, event streaming, SQL, SQL Server, sql server 2025
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
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 9 – SQL Server 2025 – New T-SQL functions – REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE()
In this Microsoft SQL Server 2025 series: Last two functions in the family of new T-SQL functions that were shipped with RegEx, are REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE(). REGEXP_MATCHES() Returns a table of captured substrings that match a regular expression pattern to…
Tagged with: advent 2025, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 8 – SQL Server 2025 – New T-SQL functions – REGEXP_INSTR() and REGEXP_COUNT()
In this Microsoft SQL Server 2025 series: Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for in string and count functionalities. REGEXP_INSTR() Returns the starting or ending position of the matched string (or substring). Starting or ending depends…
Tagged with: database, programming, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server
Posted in SQL Server
TomazTsql 