From The Blog...

PARSENAME Function – SQL SERVER

Selecting from the VALUES Table Value Constructor – SQL SERVER

SQL Server 2016 Temporal Tables

Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

Date Of Birth – SQL – Best Method

SQL Server / T-SQL Execute Powershell Scripts inside a Stored Procedure

Crystal Reports First and Last Day of Previous Month

Script to create batch queries in SQL Server

WhereScape RED Check Zero Hub Keys in Satellite Table and Send Email

WhereScape RED Physical Delete Custom Stored Proc

SQL UPDATE using a JOIN

Display XML in PHP

Clustered vs Nonclustered Index

Disabling or Dropping Indexes

InvoicePlane GST Enabled Template

T-SQL – RIGHT, LEFT, SUBSTRING and CHARINDEX

CSV Merge Batch Script (.bat)

Convert INT to DATETIME SQL

Split Strings Function T-SQL

Check Queries Run in the Past MS SQL