Developing TSQL summary reports by some variation of date is a very common requirement. Therefore having a library of date expressions is very useful. Below are a group of the common expressions I use. First and Last Day of the Previous Month SELECT CAST(GETDATE() AS DATE) AS [Today], CAST(DATEADD(dd, -(DAY(DATEADD(mm, 1, GETDATE()))-1), DATEADD(mm, -1, GETDATE())) … More TSQL Tips – Useful Date Calculations
A colleague of mine asked me what the protocol_version column represented in the DMV sys.dm_exec_connections and whether it was useful in anyway. The Microsoft documentation does not help too much. It is actually the version of the TDS Protocol used between client and server. When a client connects to SQL Server, as part of the … More SQL Server – sys.dm_exec_connections.protocol_version
I use Visual Studio Team Service (VSTS) as part of my DevOps process for end to end Continuous Integration (CI) and Continuous Delivery (CD). As the product grows so does the number of built in variables and whilst the documentation explains the variables you have available, understanding what the values are can be tricky. At … More Visual Studio Team Services – Dumping out Build and Release Variable Values
I have been helping my nephew with some Assembly Language coursework for his Masters in Computer Science at UCL in London and I decided to produce this register diagram. I am putting here for easy reference.
When creating a Linux VM in Azure we have two options for configuring authentication: Regular username and password Using an SSH public key Username and password need no introduction. The purpose of this blog is to show how we can access the VM using SSH which eliminates the need for entering a password for logging … More Accessing a Azure Linux VM using SSH on Windows