Monitoring Azure SQL Database CPU Usage

Sometimes there is a need to monitor Microsoft’s Azure SQL database usage, but your after the raw figures rather than an impressive looking graph. Running the following SQL against the master database will give you the recent information: DECLARE @DatabaseName nvarchar(50); SET @DatabaseName = '*databasename*'; SELECT getdate() AS [Current Server…

Remote Vulnerability in BASH

There’s been a report of a new code injection attack in Linux, using environment variables. In order to test to see if your system is vulnerable, run the following code from SSH: env x='() { :;}; echo vulnerable' bash -c "echo this is a test" If your OK, you should…

Common SQL Queries

Frequently I use SQL with the work I do with Orbis Taskcentre. There’s some queries which I use quite a lot and have to always look up on the internet or work out how to do, so to save time, here’s my list: Date Part of Date Time DATEADD(dd, 0,…