Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • Reply To: Designing SQL Server ETL Pipelines That Don't Break at Scale

    I am glad the article is adding value

    Ankush Rastogi

    "Turning data into insights, one query at a time."

      [*] Database Enthusiast
      [*] SQL Server Specialist
      [*] Performance Tuning Expert

    LinkedIn | GitHub

    Got a SQL question? Feel free to ask!SELECT 'Have a great day!' AS Greeting;
  • Reply To: Designing SQL Server ETL Pipelines That Don't Break at Scale

    Really appreciate this; the hash-based change detection plus pre-filter deserves its own section in the article. A few thoughts:

    Where I've seen this shine brightest is when the source sends full...

    Ankush Rastogi

    "Turning data into insights, one query at a time."

      [*] Database Enthusiast
      [*] SQL Server Specialist
      [*] Performance Tuning Expert

    LinkedIn | GitHub

    Got a SQL question? Feel free to ask!SELECT 'Have a great day!' AS Greeting;
  • Reply To: JSON in Microsoft SQL Server: A Comprehensive Guide

    Thank you, Phil, I really appreciate the feedback.

    You are absolutely right. Simply selecting the error information inside the CATCH block is not ideal for production scenarios, as it does not...

    Ankush Rastogi

    "Turning data into insights, one query at a time."

      [*] Database Enthusiast
      [*] SQL Server Specialist
      [*] Performance Tuning Expert

    LinkedIn | GitHub

    Got a SQL question? Feel free to ask!SELECT 'Have a great day!' AS Greeting;
  • Reply To: Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

    andre.quitta , I appreciate the thoughtful perspective.

    You’re absolutely right that temporal tables can replace traditional audit tables when the requirement is purely row-level version tracking. In many modernized systems, that’s...

    Ankush Rastogi

    "Turning data into insights, one query at a time."

      [*] Database Enthusiast
      [*] SQL Server Specialist
      [*] Performance Tuning Expert

    LinkedIn | GitHub

    Got a SQL question? Feel free to ask!SELECT 'Have a great day!' AS Greeting;

Viewing 4 posts - 1 through 5 (of 5 total)