T-SQL in SQL Server 2025: Substring Changes
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
2025-11-07
9,761 reads
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
2025-11-07
9,761 reads
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
2025-10-31
17,862 reads
2025-10-08
378 reads
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.
2025-10-06
Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to ask questions in simple English and receive answers without knowing any code. Still, the majority of NLP-to-SQL solutions are cloud-based, which raises issues with cost and privacy.
2025-10-03
2025-10-01
350 reads
2025-09-29
729 reads
Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025
2025-12-01 (first published: 2025-09-19)
2,923 reads
Introduced in SQL Server 2025 CTP 1.3, the PRODUCT() function acts similarly to SUM(), but multiplies values rather than adds them. It is an aggregate function in SQL Server and therefore operates on a data set, rather than on scalar values.
2025-09-08
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has improved in every version of SQL Server since their inception over ten years ago, and SQL Server 2025 is no exception!
2025-08-25
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers