Allow many NULLs while enforcing unique non-NULL values with a filtered SQL Server index, required SET options, and tested queries.
CLR Integration in SQL Server: When It Still Makes Sense
Review CLR integration uses, inventory existing assemblies, preserve strict security, and compare SQL Server 2025 built-in alternatives.
Filtering on a Window Function Without QUALIFY in SQL Server
Filter window results without QUALIFY using CTEs and derived tables, compare TOP WITH TIES, and preserve partition and tie rules.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
Snowflake JavaScript Procedure: A Stored Procedure Template
A Snowflake JavaScript procedure wraps SQL statements in JavaScript code. This post gives a clean template, shows how to call it, read a result, pass an argument and catch an error. The code follows Snowflake’s documented API and was not run on a Snowflake account.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.