TSQL Tips – Useful Date Calculations

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

SQL Server – sys.dm_exec_connections.protocol_version

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