Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Tag: ETL

SQL

SQL Server: Fix TRY_CONVERT Returning NULL Instead of Throwing on a Clearly Invalid Value Because a Silent Conversion Failure Looks Identical Downstream to a Genuinely NULL Source Column

- 11.11.26 - ErcanOPAK comment on SQL Server: Fix TRY_CONVERT Returning NULL Instead of Throwing on a Clearly Invalid Value Because a Silent Conversion Failure Looks Identical Downstream to a Genuinely NULL Source Column

🗄️ SQL Server: Fix TRY_CONVERT Returning NULL Instead of Throwing on a Clearly Invalid Value Because a Silent Conversion Failure Looks Identical Downstream to a Genuinely NULL Source Column TRY_CONVERT is deliberately designed to return NULL instead of raising a conversion error whenever the conversion would fail, which is genuinely useful when you expect some […]

Read More
C#

C#: Build ETL Pipelines with LINQ

- 26.07.26 - ErcanOPAK comment on C#: Build ETL Pipelines with LINQ

📊 ETL Pipelines = Data Transformation Data integration needs to be efficient. LINQ-powered ETL pipelines transform, clean, and load data with elegance and performance. 📝 ETL Pipeline Implementation public class ETLPipeline { private readonly ILogger _logger; public async Task<IEnumerable<CleanSalesData>> ProcessAsync( IEnumerable<RawSalesData> rawData) { // EXTRACT – Validate var extracted = rawData .Select((data, index) => new […]

Read More
C#

C#: Build ETL Pipelines with LINQ

- 25.07.26 | 25.07.26 - ErcanOPAK comment on C#: Build ETL Pipelines with LINQ

📊 ETL Pipelines = Data Transformation Data integration needs to be efficient. LINQ-powered ETL pipelines transform, clean, and load data with elegance and performance. 📝 Complete ETL Pipeline Implementation // Data Models public class RawSalesData { public string SalesId { get; set; } public DateTime SaleDate { get; set; } public string ProductCode { get; […]

Read More
SQL

SQL: Use MERGE to Upsert (Insert or Update) in One Statement

- 03.02.26 - ErcanOPAK comment on SQL: Use MERGE to Upsert (Insert or Update) in One Statement

Inserting if row doesn’t exist, updating if it does? MERGE statement does both in one atomic operation without race conditions. The Problem – Separate Insert/Update: — Check if exists IF EXISTS (SELECT 1 FROM Products WHERE ProductId = @Id) BEGIN — Update UPDATE Products SET ProductName = @Name, Price = @Price WHERE ProductId = @Id; […]

Read More
November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com