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(); });

jrichardsz

docker run -it  --entrypoint /bin/sh -v .:/workspace  alpine/openssl

source: https://github.com/Azure/azure-xplat-cli/wiki/Getting-Self-Signed-SSL-Certificates-(.pem-and-.pfx)

• Generating a private key:

openssl genrsa 2048 > private.pem

jrichardsz

Using this repository https://api.github.com/repos/pdf2htmlEX/pdf2htmlEX/releases/latest

With an asset name of pdf2htmlEX-0.18.8.rc1-master-20200630-Ubuntu-bionic-x86_64.deb

{
  "url": "https://api.github.com/repos/pdf2htmlEX/pdf2htmlEX/releases/assets/22311467",
  "id": 22311467,
  "node_id": "MDEyOlJlbGVhc2VBc3NldDIyMzExNDY3",
  "name": "pdf2htmlEX-0.18.8.rc1-master-20200630-Ubuntu-bionic-x86_64.deb",

jrichardsz

http://www.chromakinetics.com/ebooks/searchGoogleMP3

Searching Google for Music - Advanced Guide

This How-To will teach you how to use google to find mp3s. This How-To will be highly pragmatic and will focus on the hows and not the wherefores of the various search strings. Index

0. Key
1. Directories

jrichardsz

Create database, user able to login using [SQL Server Authentication mode]

USE [master]
CREATE DATABASE UmbrellaEnterprises
GO
USE [UmbrellaEnterprises]
CREATE LOGIN support_team_login WITH PASSWORD = 'P@ssW0rd';
CREATE USER support_team_usr FOR LOGIN support_team_login;
EXEC sp_addrolemember N'db_owner', N'support_team_usr'

jrichardsz

Hello world (very simple)

exports.handler = async (event, context) => {
    return {
        statusCode: 200,
        body: {
            code: 200,
 message: "Deployment has started. Check your mail."