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. type Constructor<T = {}> […]
Risk Management was first made interesting by Tom DeMarco and Timothy Lister in Waltzing with Bears. If you want to know more about the subject, that’s a good place to start. But what is the difference between Risk Materialisation and Crystallisation? I will answer this question shortly, but let’s start from the beginning! Risk A […]
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 […]
Azure DevOps (previous Visual Studio Team Services, Visual Studio Online, and Team Foundation Server) has many great features. We talk about the features all the time; source control, continuous integration, release management, task boards, reports! One of my favourite features is how it helps us to pass audits. There are two ways to pass an […]
These are the three things I encourage people to look at when they aren’t getting what they need out of their software development process. Because I had started with these so many times, I sometimes imagine everyone knows all about them; but each time I start helping a software team turn things around I find […]
The following query will get you the database size and log file size for all databases on a SQL Server instance. WITH mf AS ( SELECT database_id, [type], CAST((size * 8.0 / 1024) AS INT) AS size FROM sys.master_files ) SELECT [name] AS DatabaseName, ( SELECT SUM(size) FROM mf WHERE [type] = 0 AND mf.database_id […]
For those reading this in the future, digital video recorders (DVRs) were quite prevalent in 2018. They allow you to record programs that are being broadcast and watch them later. Before DVRs there were other ways to record programs that involved writing them to magnetic tape based on a timer. Before that you just had […]
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 […]
Sometimes you need to filter and sort the records you get from sp_who2. You can’t do this directly, but you can use a temporary table to do it. — Create an intermediate table to put all the results CREATE TABLE #spootoo ( SPID INT, Status VARCHAR(1000) NULL, Login SYSNAME NULL, HostName SYSNAME NULL, BlkBy SYSNAME […]
