jrichardsz

select regex results

alt+enter

jrichardsz

The ideal vertical video dimension is made in portrait with a 9:16 aspect ratio and the ideal dimensions being 1080×1920 pixels. Understanding the ideal dimension for vertical videos is crucial to capturing your audience's attention in this ever-evolving social media landscape.

https://clipchamp.com/en/blog/best-practices-creating-vertical-videos-smartphone/

16:9 resolutions

jrichardsz

const express = require('express');
const fs = require('fs')
const path = require('path')
const app = express()
const server = require('http').Server(app)
const io = require('socket.io')(server,{maxHttpBufferSize: 1e7})

io.on('connection', function (socket) {
  console.log("headers at connection:")
  console.log(socket.handshake.headers)

jrichardsz

Select

// dotnet add package MySql.Data --version 9.0.0

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

jrichardsz

EventHubConsumerClient consumerClient = new EventHubConsumerClient(consumerGroup, connectionString, eventHubName);
string firstPartition = (await consumerClient.GetPartitionIdsAsync()).First();
PartitionProperties properties = await consumerClient.GetPartitionPropertiesAsync(firstPartition);
logger.LogInformation(""+properties.LastEnqueuedTime);
EventPosition startingPosition = EventPosition.FromSequenceNumber(properties.LastEnqueuedSequenceNumber);
logger.LogInformation($"startingPosition: {startingPosition}");

await foreach (PartitionEvent partitionEvent in consumerClient.ReadEventsFromPartitionAsync(firstPartition, startingPosition))
{
    string text = Encoding.UTF8.GetString(partitionEvent.Data.Body.ToArray());

jrichardsz

jrichardsz

jrichardsz

Errors

• https://www.sqlservercentral.com/forums/topic/cursors-are-not-supported-on-a-table-which-has-a-clustered-columnstore-index
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Error-SQL-Execute-Cursors-Not-supported-on-Clustered-Columnstore/td-p/57047/page/2
• https://stackoverflow.com/questions/55607645/matlab-database-error-cursors-are-not-supported-on-a-table-which-has-a-clustere
• https://stackoverflow.com/questions/35411122/sqlexceptionhelper-cursors-are-not-supported-on-a-table-which-has-a-clustered-c

Possible cause

The cursor is trying to read a temp table created with System-Versioned Temporal Tables using CURSOR

jrichardsz

DROP table IF EXISTS [t1];
CREATE TABLE t1 (
    id int IDENTITY(1,1) NOT NULL,
    c1 int DEFAULT 0,
    c2 int DEFAULT 0,
    c3 int DEFAULT 0
);

DROP table IF EXISTS [t1_history];

jrichardsz

https://thecodeblogger.com/2021/05/11/how-to-enable-logging-in-net-console-applications/

using var loggerFactory = LoggerFactory.Create(builder => { builder .AddFilter("Microsoft", LogLevel.Warning) .AddFilter("System", LogLevel.Warning) .AddFilter("NonHostConsoleApp.Program", LogLevel.Debug) .AddConsole(); });