Search Results

grep is cool; it allows us to search for text in various text files, including log files. However, grep has lots of little nuances and subtleties that need to be understood in order to maximize its utility as a program. grep basics Every grep search has the ...

There are several ways to truncate a text file using bash: : > 'FILE' From StackOverflow: : is a no-op in bash, so this essentially just opens the file for writing (which of course truncates the file) and then immediately closes it. >  'FILE' From StackOve...

https://patricia.no/2025/05/30/why_lean_software_dev_is_wrong.html Generalized understanding of programs as factories is how we port the notion of "pipes and filters" around: what any given program produces as output can be used as another program's input. W...

https://pscanf.com/s/341/ TS's type system is gradual: when you describe JS in TS, you can create types that are more or less accurate (strongly typed to any). In pursuit of type safety, TS types will occasionally get so complex they're extremely difficult t...

Select all tables with <x> column SELECT     c.name as 'ColumnName',     t.name as 'TableName' FROM     sys.columns c JOIN     sys.tables t ON c.object_id = t.object_id WHERE     c.name LIKE '%DSActionTypeID%' ORDER BY     TableName, ColumnName Upd...

I'm not a DBA but I've been grilled on various SQL and database questions during interviews as shibboleths. I've tried to come up with satisfactory answers for both my own knowledge and to deal with these shibboleths. What is an index? An index is a data str...

Use case: there's a field or multiple fields that just need some simple adornment saying that the input provided isn't accepted. The gist: On the base ViewModel class, implement the interface. Errors are tracked per property on a given ViewModel, and there's ...

I haven't had to deploy a desktop app "normally" as an installer for WPF, while Python has packages for this. Some links I collected for MSIX packaging and DevOps for desktop apps: https://learn.microsoft.com/en-us/windows/apps/desktop/modernize/modernize-w...