Visual Studio – Synchronize a Version Number across Multiple Assemblies

If you have a multi-layered application you may want to keep the file and assembly version numbers of all the assemblies the same. This would entail editing each AssemblyInfo.cs file. An alternative is to create a single file holding the versions and referencing it from each projects. Let me show you how. Imagine the following … More Visual Studio – Synchronize a Version Number across Multiple Assemblies

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

Visual Studio Team Services – Dumping out Build and Release Variable Values

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

ES6 – Classes

Javascript ES6 has come a long way to look like regular OOP languages and move away from looking functional or prototypical. This probably upsets quite a few dev’s but not me. I don’t particularly like Javascript so anytime I can get my classes looking like the classes in C# for example is all good to … More ES6 – Classes