Tag: todayilearned · Just Some Code

© 2024. All rights reserved.

#todayilearned

2024

2024-09-30 TIL: How to Use the Specification Pattern in C# to Simplify Repositories

2023

2023-11-27 TIL: How to color a website based on its URL. A visual aid and time saver
2023-11-13 TIL: How to declutter sites with uBlock Origin filters
2023-10-30 TIL: Five lessons while working with OrmLite
2023-10-16 TIL: How to join to subqueries with OrmLite
2023-06-26 TIL: How to pass a DataTable as a parameter with OrmLite

2022

2022-12-13 TIL: Five or more lessons I learned after working with Hangfire and OrmLite
2022-12-11 TIL: How to automatically insert and update audit fields with OrmLite
2022-12-10 TIL: How to replace keywords in a file name and content with Bash
2022-12-09 TIL: How to rename Visual Studio projects and folders with Git
2022-12-03 TIL: How to test an ASP.NET Authorization Filter
2022-12-02 TIL: Always check for missing configuration values inside constructors
2022-04-04 TIL: T-SQL doesn't have constants and variables aren't a good idea
2022-03-21 SQL Server Index recommendations: Just listen to them
2022-03-07 TIL: How to optimize Group by queries in SQL Server
2022-02-21 TIL: How to do a case-sensitive search in SQL Server

2021

2021-12-06 It's not what you read, it's what you ignore
2021-10-25 TIL: Dictionary keys are converted to lowercase too on serialization
2021-02-24 TIL: How to convert 2-digit year to 4-digit year in C#
2021-01-25 TIL: Livable Code. Living with your mess
2021-01-04 TIL: Three differences between TRUNCATE and DELETE

2020

2020-12-04 TIL: Always Use a Culture When Parsing Numeric Strings in C#
2020-12-03 TIL: Three Tricks to Debug Your Dynamic SQL Queries
2020-11-17 TIL: LINQ DefaultIfEmpty method in C#
2020-11-13 TIL: SQL Server uses all available memory
2020-10-20 TIL: NULL isn't LIKE anything else in SQL Server
2020-10-08 TIL: EXISTS SELECT 1 vs EXISTS SELECT * in SQL Server
2020-10-05 TIL: How to compare DateTime without the time part in SQL Server
2020-10-01 TIL: How to add gzip compression to ASP.NET Core API responses