ETL vs ELT comes down to when you transform: before the load on a separate engine, or after it inside the platform. This post compares the two and runs a small ELT pipeline in T-SQL on JSON orders.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Storing JSON in SQL Server
Storing JSON in SQL Server can use validated nvarchar or the native 2025 json type, with indexed paths and relational columns for stable facts.
Table Variables Survive ROLLBACK: Logging Errors in a Transaction
See how table variables survive rollback to retain error details, then write a permanent error log after a failed SQL Server transaction.
Trigram Matching: Finding Similar Words With an N-Gram Table
Build trigram matching with GENERATE_SERIES and an indexed n-gram table, rank shared pieces, and compare spelling similarity with SOUNDEX.
SQL SERVER – Select Columns from Stored Procedure Resultset
Need only some columns from a stored procedure resultset? Store it in a temp table with INSERT INTO and EXEC, then select what you need.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
Part 4 on reading the previous row and next row value in a SELECT statement. My friend Szymon Wojcik shows how a numbers table can make the query even faster.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3
My part 2 solution used ROW_NUMBER, which SQL Server 2000 does not have. Here is how to access the previous row and next row in SQL Server 2000.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.