SQL and Matrix math

Have you ever needed to do matrix multiplication in SQL, or multiply a matrix by a scalar? Here's an excellent article by Robyn Page and Phil Factor over at Simple-Talk about doing matrix math in SQL. It's surprisingly simple (relatively speaking, of course).

SQL Server Matrix Workbench