Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
Peter Whyte DBA Blog
Tag

SQL Server ETL


November 30, 2020
SQL Server
Find String in Tables in SQL Server

Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.

Read More
November 27, 2020
SQL Server
Show Only the Domain of an Email Address in SQL Server

When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.

Read More

Blog Menu

  • Homepage
  • Projects
  • Notes
  • Archives

Categories

  • AWS (3)
  • Linux (21)
  • MySQL (5)
  • PostgreSQL (7)
  • PowerShell (32)
  • RedShift (6)
  • Scripts (1)
  • SQL Server (54)
  • Windows (40)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (35) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (7) Importing Data (1) Installing SQL Server (8) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (4) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) SQL Tips (2) Windows Admin (9) WordPress Tutorials (2) WSL (10)