A comprehensive logging solution for SQL Server stored procedures that provides structured logging with different severity levels, automatic caller detection, and detailed error tracking. Features Installation — Create Logger schema CREATE SCHEMA Logger; GO — Create logging table and procedures — [Copy the full installation script here] Basic Usage Simple Logging — Info logging EXEC … Read more
Since .NET 9 the compiler warns “Frame” is obsolete: “Frame is obsolete as of .NET 9. Please use Border instead.”.Well, unfortunately, it is not possible to simply replace Frame with Border. Frame was somehow a little easier to use. Simply make a frame with rounded corners.That’s not “out-of-the-box” with Border.So let’s take a look at … Read more
As a little finger exercise, I thought that a Visual Studio extension that explains the code would be good – thanks to OpenAI, that shouldn’t be a problem. And it wasn’t. First, I installed the Extensibilty Template Pack 2022 for Visual Studio 2022.Then I could get started: Firstly, I added a tool window. A tool … Read more
Unfortunately, this is not so easy. But there is a way. First create the new schema: Now you can use SCHEMA TRANSFER to transfer the tables from the old to the new schema.
The question is how can I compile C# code on ‘the fly’ in .NET 9.0 As a demo, we will make a small programme that compiles any file with C# code and creates a DLL. The basic framework of the programme is relatively simple. Basically, we don’t need much to integrate a C’ compiler into … Read more