The latest in my vague series of posts about using LinqPad to query the schema of a database, and extract information about the database as a whole. In this case, it was finding the number of rows in each table, and whether any were empty.
Dot Net What Not Posts
How to create a simple (but effective) busy indicator component in Blazor to show your users that their data is being loaded
Inspired by a long-defunct billboard advert, I coded up a Linq expression to find the first 10-digit prime found in consecutive digits of e. This turned out to be disappointingly easy
Ever wondered what the prime factors of your telephone number are? No, nor had I until I read Humble Pi. A throwaway comment there led me to contemplate how to do this in a single Linq statement.
Why? Why not?
The “with” keyword is a crucial part of a functional programmer’s toolbox, but is sadly lacking in C#. In this blog post, I document the development of a template that will automatically generate a With() method for C# classes.
I recently switched to Windows 10, and have found that one really annoying habit it has is that it will randomly switch focus without warning. I can be typing an email, scrolling down through the errors in the event viewer to see what vital parts of Windows crashed today and so on, and suddenly I find that my words are not entered into the email, the events aren’t scrolling, etc.
A quick bit of searching revealed that a lot of people have had the same problem, and very few have managed to solve it. The main problem is finding out what gets the focus.
This post explains how I found out.
Whilst I’m getting increasingly frustrated with Windows 10, the number of errors that seem to crop up, and the number of basic features that seem to stop working for no good reason, it has produced more than its fair share of amusements.
Today’s suggests that Microsoft have an amazing level of confidence in the staying power of Windows 10.
I was just looking in the Event Viewer, and saw the following… You can’t make this stuff up you know!
I just lurve clients sometimes!
Our main client has the (probably not uncommon) habit of labelling every ticket as urgent. The problem with this is that when something really urgent comes along, they have no way of making it stand out above the other urgent jobs. This predictably led to the creation of a “Very urgent” rating.
Today they outdid themselves…
This led to a lively debate as to what would come next. How about “-1. Life threatening”?
Faced with the task of modifying every varchar(n) column of every table in a database to be varchar(max), whilst avoiding default constraint errors, I came up with a script to generate the SQL for me.