skip to main content

Label: SQL

Posts related to SQL (Structured Query Language). These are predominantly specific to SQL Server, unless mentioned explicitly.

Posts

  1. Use PATINDEX to match data from another table

    PATINDEX and JOIN

  2. Get the relative path of a file in SQLCMD Mode in SSMS

    SQLCMD stuff

  3. ORIGINAL_LOGIN vs SYSTEM_USER for audit purposes in SQL Server

    sql server login audit

  4. Monitor SQL Server backup jobs with PowerShell

    Know backup status with PowerShell


Show all labels