SQLYARD

SQL Server 2025: REGEXP_LIKE() – Native Regular Expressions Arrive** Introduction SQL Server has never had true regular expression support built into the engine. Developers relied on: • CLR functions• LIKE hacks• CHARINDEX• XML PATH tricks• External tools That changes in SQL Server 2025 with the introduction of REGEXP_LIKE(), the first native RegEx function. It finally

SQL Server 2025: BASE64_ENCODE() and BASE64_DECODE()** Introduction SQL Server has always required custom functions, CLR code, or external tools to handle Base64 encoding. That changes with SQL Server 2025, which introduces two native functions: • BASE64_ENCODE()• BASE64_DECODE() These simplify secure data transport, token handling, API payload encoding, and binary-to-text conversion. They are useful across authentication

SQL Server 2025: The New PRODUCT() Aggregate Function** Introduction SQL Server 2025 introduces a small but surprisingly powerful new aggregate function: PRODUCT(). At first glance, it seems simple. SUM adds values, AVG averages them, COUNT counts them, and now PRODUCT multiplies them. But this addition opens doors to analytical patterns that were impossible or overly

SQL Server 2025: JSON Index Deep Dive** Introduction One of the most important features in SQL Server 2025 is the new JSON index, built specifically for the native JSON type introduced in Day 2. This is the first time SQL Server provides an engine-level index designed to accelerate document-style workloads. If you’ve ever filtered JSON

SQL Server 2025: Native JSON Data Type and New JSON Functions** Introduction For years, SQL Server developers and DBAs have been storing JSON as NVARCHAR columns. It worked, but it never felt like a real solution. SQL Server 2025 finally closes the gap with a fully native JSON data type, along with new JSON functions