I have been working out how to create a TypeScript NotFunction type for a while, in response to a Stack Overflow question. With the arrival of conditional types, I think there may be a way. It’s not perfect – but it does work. The type works by taking all possible types and converting the type […]
The C# 8.0 announcement included a note on default implementations of interface members. If you’ve been programming for long enough, this might make you a little nervous at first thanks to the hangovers of multiple inheritance. Before you chuck out this idea, though, let’s look at it from a different perspective. I’m going to talk […]
Here is a quick disambiguation between Traits vs Mixins for programmers. Mixins are now fairly well known. You can use mixins to add shared methods to your classes without inheriting from the class they live in. It’s an increasingly popular technique for sharing and extending code. Instead of inheriting from a single parent, you can […]
This is one of those cases where a question keeps cropping up, so lots of people are trying to do something that the TypeScript Compiler doesn’t like very much. Yes, it’s time to talk about the TypeScript Dictarray! What’s a Dictarrary? It’s a dictionary that’s also an array. You know… one of these: const dictarray […]
One of the new features in C# 8.0 is Recursive Patterns, or Power If Statements. The easiest way to explain this new feature is to unpack the example from the Building C# 8.0 article. IEnumerable<string> GetEnrollees() { foreach (var p in People) { if (p is Student { Graduated: false, Name: string name }) { […]
Don’t worry, the mechanism for creating TypeScript mixins hasn’t changed, but I just wanted to demonstrate that the technique described in TypeScript Mixins Part Two is valid for use with static properties. Reusing the original example, let’s see what happens if we add static properties to our Flies and Climbs mixins. Not only does this […]
I had a question from Bruce about ECMAScript modules following on from my post on not mixing namespaces and modules in TypeScript. The question was: How can a module create something that can be used in browser without creating a variable on the global scope? This is a great question, so here is a quick […]
Want to know who deleted rows from your SQL database? The script below joins up delete transactions with users in order to find out who just deleted something. Because this comes from the transaction log, you’ll only find stuff that is still available in there. This means it will be affected by retention/recovery modes. If […]
The following query will get you the database size and log file size for all databases on a SQL Server instance.
If you have a blocking query, you probably follow a set of manual steps a bit like this… Run sp_who2. Follow the “blocked by” SPIDs until you find a root-SPID (one that is blocking, but not blocked). Run DBCC INPUTBUFFER with the SPID to see what query is being run After doing this twice in […]