Sebastiao Pereira hearkens back to linear algebra courses:
Is there a way to perform matrix operations or calculations directly within the database, eliminating the need for an external matrix calculator in SQL Server?
Click through for a large number of functions. Sebastiao went all-out in this one.