giordanocardillo

The table sys.spt_values is in the ressources database (mssqlsystemresource). This database is only accessible when the SQL Service is started in single user mode..

To re-create the view to do the following steps:

1. Stop all MSSSQL Service

2. Start the SQL Service in single user mode: Open a DOS Command prompt and start the sqlservice with the -m switch

"C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -m

giordanocardillo

AWSTemplateFormatVersion: '2010-09-09'
Parameters:
  BucketName:
    Type: String
    AllowedPattern: '^[A-Za-z0-9-]*$'
    ConstraintDescription: 'Must be a valid S3 bucket name'
    Description: 'Input the bucket name you want to create'
  CloudFrontDistributionCNAME:
    Type: String
    Description: 'Input the CloudFront distribution CNAME'

giordanocardillo

Lambda helper function to remove a running POD

Lambda function to remove a running POD from EKS cluster and allow the matching deployment to run it again, updating it.

Thia allows microservice updating after a codepipeline run.

It uses the awscli because the get-token command is not available in boto3 library.

Requirements

giordanocardillo

#/bin/sh

spinner=("    " "1   " "10  " "101 " " 010" "  01" "   0")
spinner_length=${#spinner[0]}

function spin() {
  tput cuf "$spinner_length"
  while [ 1 ]; do
    for i in "${spinner[@]}"; do
      tput cub "$spinner_length"

giordanocardillo

FocusTrapper

A simple method to "trap" tabbing inside an element

Usage

const trapper = new FocusTrapper(element)
trapper.trap() // To trap focus
trapper.untrap() // To release

giordanocardillo

Installing provisioning profiles

1. Download your provisioning profile from the apple developer portal
2. Extract provisioning profile UUID

   uuid=`grep UUID -A1 -a profile.mobileprovision | grep -io "[-A-F0-9]\{36\}"

3. Rename the provisioning profile file as <uuid>.mobileprovision

   mv profile.mobileprovision $uuid.mobileprovision

giordanocardillo

function nsw() {
  if [[ -z $1 ]]; then
    echo "Usage nsw [<node version>|ls] [-q]"
    return;
  fi
  
  if [[ $1 == "ls" ]]; then
    ls /d/Spindox/nodejs | sed s/nodejs-//
    return
  fi

giordanocardillo

Installation

1. Download current gist as zip file and unzip it in any folder
2. Connect MAC to GIALLO or to internet using something else, GIALLO is fine
3. Start file install.sh
4. Disconnect from internet, to allow nexus usage and run install-offline.sh
5. Done!

Start/stop

giordanocardillo

From a connected PC download

https://nodejs.org/download/release/v12.13.1/SHASUMS256.txt

https://nodejs.org/download/release/v12.13.1/node-v12.13.1-headers.tar.gz

Put the two files in a folder, then inside the folder run

npm init -y

giordanocardillo

#!/bin/bash

function svn_branch {
  svn_info="$(svn info | egrep '^URL: ' 2> /dev/null)"
  branch_pattern="^URL: .*/(branches|tags)/([^/]+)"
  trunk_pattern="^URL: .*/trunk(/.*)?$"
  if [[ ${svn_info} =~ $branch_pattern ]]; then
    branch=${BASH_REMATCH[2]}
  elif [[ ${svn_info} =~ $trunk_pattern ]]; then
    branch='trunk'