Updating SQL Server with Docker

This morning I was listening to a podcast where the new features coming out for SQL Server 2022 were being discussed. This starting me thinking about what would be involved in upgrading. Upgrading production environments is complex and there are licensing considerations to take into account. However for non production...

I use sp_send_dbmail to send results of sql queries by email to business users. Recently an issue was raised that data was being cut off after 255 characters. To fix this I added @query_no_truncate = 1, however this stopped the column headings from being included. No idea why you can’t have all the data and column...

Writing SQL queries is typically done with SQL Management Studio (SSMS). However this tool is a bit of a beast so let’s look at how you could use Visual Studio Code instead. Visual Studio Code is a free text editor but it is so much more than just a text editor. VS Code can be downloaded from...

High Charts is a javascript library that allows graphs and charts to easily be added to web pages. A chart like this can easily be added with a few lines of html and javascript. <script src="https://code.highcharts.com/highcharts.js"> <script src="https://code.highcharts.com/modules/exporting.js"> <div...

LINQ

What is LINQ? LINQ is an acronym for Language Integrated Query, which describes where it’s used and what it does. The Language Integrated part means that LINQ is part of programming language syntax. In particular, both C# and VB are languages that ship with .NET and have LINQ capabilities. How do I use LINQ in my C#...