Tomaž Kaštrun is a BI and data developer specializing in T-SQL, SQL Server, and data analytics. With 15+ years of experience, he shares expertise in query optimization, machine learning with R, data mining, and business intelligence development.
8 articles from this blog
Overview of official documentation, learning resources, and training materials for Microsoft SQL Server 2025.
Explores new SQL Server 2025 T-SQL features: the || string concatenation operator and the ||= compound assignment operator.
Explains the new UNISTR() T-SQL function in SQL Server 2025 for handling Unicode strings, emojis, and escape sequences.
Part 2 of a tutorial on setting up Change Event Streaming in SQL Server 2025, focusing on Azure Event Hub configuration and database setup.
Explores SQL Server 2025's Change Event Streaming (CES), a feature for real-time data change streaming to Azure Event Hubs.
Explains the new Optimized Locking feature in SQL Server 2025, detailing how it reduces lock memory and improves concurrency.
Explores the new ABORT_QUERY_EXECUTION query hint in SQL Server 2025 for blocking problematic queries via Query Store.
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
