Computer Science

This category contains pragmatic information and solutions to some complex issues I have worked out by gluing bits of information gleaned from technical sites like Stack Overflow.

C# – Uniform Time

A simple process to update an application to use a single time source.

SQL – Compute Last Day of Month

Let SQL calculate the last day of the month.

SQL – Identify Poorly Performing Queries

Let SQL Server identify the cause of queries that never complete or perform poorly.

SQL – Procedure and Function Callee Hierarchy

Hierarchical relationships of stored procedures, functions and tables.

SQL – Procedure and Function Caller Hierarchy

Hierarchical relationships of stored procedures, functions and tables.

SQL – Query when NetBackup Last Ran

Query SQL Server when NetBackup last backed up the database.

SQL – Recursive CTE

How to create a recursive CTE to get hierarchical data from a table.