📅 Week 24
Unique Indexes And NULLs in PostgreSQL, MySQL & MariaDB
[Database, SQL Server, PostgreSQL, MySQL, MariaDB]
Yesterday’s post, “Creating A Unique Index That Allows NULL In SQL Server”, looked at how Microsoft SQL Server treats NULL values on columns with unique constraints, and how to get it to ignore NULLs for that purpose.
📅 Week 23
Creating A Unique Index That Allows NULL In SQL Server
[SQL Server, Database]
A uniqe index is a fairly simple construct.
Modifying JSON With JsonNode In C# & .NET
[C#, .NET, Json]
Over the years we have extensively discussed the use of the native .NET json parser, System.Text.Json.
Posting A Message to Microsoft Teams Via WebHook In C# & .NET
[C#, .NET, Microsoft Teams]
In a previous post, “Posting Messages To Microsoft Teams With Code”, we looked at how to post a message to Microsoft Teams in C#.
UI Fail - Visual Studio Sometimes Has Difficulty Counting
[UI Fail, Fail, SQL Server, Visual Studio]
Quick, what’s wrong with this?
Beware - NULL Values Can Trip You Up When Using Dapper
[C#, .NET, Database, StarLibrary, Dapper, Beware]
I have extensively discussed the use of the excellent library Dapper for database access with most database engines.
Tip - Changing To The Home Directory In The Terminal
[Tips, Terminal]
Frequently, when in your terminal you will want to go to your home directory.
Tip - Use Constants For MIME Types
[C#, .NET, Tips]
Quick, what’s wrong with this code?
📅 Week 22
Displaying Large TimeSpans In C# & .NET
[C#, NET, StarLibrary]
In a post last year, “Displaying User-Friendly TimeSpans In C# & .NET”, we looked at how to display TimeSpans in a user friendly way using the Humanizer nuget package.
Logging Off A Windows PC In Visual Basic .NET
[VB.NET, Visual Basic, .NET, Windows]
In our previous post, “Logging Off A Windows PC In C# & .NET”, we looked at how to log off a Windows PC using C# invoking the Windows API.
Logging Off A Windows PC In C# & .NET
[C#, .NET, Windows]
In an earlier post, “Locking A Windows PC In C# & .NET”, we looked at how to invoke the Windows API to lock the screen.
Getting Docker Disk Usage
[Docker]
Docker is now an essential tool for software developers, as it allows you to spin up almost any infrastructure you may need.
You Cannot Search For Bullet Numbers In Chrome & Edge
[Chrome, Edge, HTML, Firefox]
The archives for this blog look like this:
Configuring Microsoft Teams Webhooks for Channels
[Microsoft 365, Office 365, Teams]
In a previous post, some 6 years ago, “Posting Messages To Microsoft Teams With Code”, we looked at how to configure a Microsoft Teams channel to receive and process webhooks, typically for posting messages from third-party applications or a script.
Tip - DevExpress XtraReport Parameters - Visible vs Enabled
[Tips, DevExpress, XtraReports]
When creating a parameter object for a DevExpress XtraReport, the screen for creating parameters looks like this:
📅 Archives ...