ridercz

ridercz

ridercz

ridercz

ridercz

SET NOCOUNT ON 
              
CREATE TABLE #SparseTypes (
	[DataType]		nvarchar(20),
	[Percentage]	int
)
-- Values from https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns
INSERT INTO #SparseTypes VALUES('bit', 98)
INSERT INTO #SparseTypes VALUES('tinyint', 86)
INSERT INTO #SparseTypes VALUES('smallint', 76)

ridercz

-------------------------------------------------------------------------------
-- Using linked IDs
-------------------------------------------------------------------------------

-- Create table
CREATE TABLE Categories (
	[Id]		int	IDENTITY	NOT NULL,
	[ParentId]	int				NULL,
	[Name]		nvarchar(100)	NOT NULL,

ridercz

// Video: https://youtu.be/cdTu27j6dn8

using System.Diagnostics;
using System.Text;

// Verify there are exactly 2 arguments and get source and destination folders
if (args.Length != 2) {
    Console.WriteLine("Usage: mirror <source folder> <destination folder>");
    return;
}

ridercz

#include "M5CoreS3.h"
#include "M5UnitENV.h"

SHT3X sht3x;
QMP6988 qmp;

void setup()
{
  auto cfg = M5.config();
  CoreS3.begin(cfg);

ridercz

public class RoundedTimeProvider : TimeProvider {

    // Private constructor to prevent direct instantiation
    private RoundedTimeProvider() { }

    // Factory methods for different precisions

    public static RoundedTimeProvider NativePrecision(string? localTimeZoneName = null) => new() {
        LocalTimeZoneInternal = localTimeZoneName == null ? TimeZoneInfo.Local : TimeZoneInfo.FindSystemTimeZoneById(localTimeZoneName),
        RoundingFunction = x => x,

ridercz

/* This is sample code for the following video: https://youtu.be/36p2-gr_iYk
 * The following NuGet packages are needed:
 *   Hangfire
 *   Hangfire.AspNetCore
 *   Hangfire.SqlServer
*/

using Hangfire;

var builder = WebApplication.CreateBuilder(args);