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.
13 articles from this blog
An R tutorial using OpenStreetMap to verify distances on geographical signposts, finding the true location via circle intersections.
R function solving water jug problem using Bezout's Identity and BFS, with a beer-themed example.
R function to generate Ulam Prime Spiral, a visualization of prime numbers in a spiral grid.
A fun R programming tutorial for creating a desk plant simulator game with ASCII art and daily care mechanics.
An R function to find palindrome dates across multiple international date formats within a specified range.
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.
