From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this second example I am going to show you how I … More Using JSON inside SQL Server – Use Case 2
From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this example I am going to show you how I implemented … More Using JSON inside SQL Server – Use Case 1
I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and is not a complete exhaustive list. The following code consists of three different CTES. Here … More TSQL Tips – Window Functions
There are occasions when testing TSQL that we only need a small amount of input data and do not want to go through the hassle of creating, populating and then deleting tables. A nice quick solution is generating dynamic data through a Common Table Expression (CTE). Take a look at the following code. WITH CTE … More TSQL Tips – VALUES in FROM Clause
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
Denham Coder 