MarshalOfficial

create PROCEDURE BackupDB
@path nvarchar(300)	= '/var/opt/mssql/data'
AS
BEGIN
	declare @time nvarchar(30)  = format(getdate(),'yyyyMMdd_HHmmss')	
	declare @dbName nvarchar(150) = DB_NAME()

	declare @sql nvarchar(max)
	select @sql = ' BACKUP DATABASE '+@dbName+' TO DISK = '''+@path+'/'+@dbName+'_'+@time+'.bak'' WITH COMPRESSION '

MarshalOfficial

#ِDockerfile content
FROM ubuntu:latest

RUN apt update -y
RUN apt install -y openjdk-11-jdk
RUN apt install -y dotnet6


#build then push to any registry
#> docker build -t dotnet6-openjdk11 .

MarshalOfficial

SELECT [Database Name] = DB_NAME(database_id),

       [Type] = CASE WHEN Type_Desc = 'ROWS' THEN 'Data File(s)'

                     WHEN Type_Desc = 'LOG'  THEN 'Log File(s)'

                     ELSE Type_Desc END,

       [Size in MB] = CAST( ((SUM(cast(Size as bigint))* 8) / 1024.0) AS DECIMAL(20,0) )

MarshalOfficial

CREATE TRIGGER user_changes AFTER INSERT OR UPDATE OR DELETE ON public.users FOR EACH ROW EXECUTE PROCEDURE change_trigger();

MarshalOfficial

CREATE SCHEMA logging;
CREATE TABLE logging.table_history (
        id             serial,
        tstamp         timestamp DEFAULT now(),
        schemaname     text,
        tabname        text,
        operation      text,
        who            text DEFAULT current_user,
        new_val        json,
        old_val        json

MarshalOfficial

1: Create a .pgpass file in the home directory of the account that pg_dump will run as.

hostname:port:database:username:password

chmod 600 ~/.pgpass


2: sudo -u postgres -i

3: pg_dump -a -t table_to_copy source_db | psql target_db

MarshalOfficial

netsh interface portproxy add v4tov4 listenport=8085 listenaddress=0.0.0.0 connectport=8085 connectaddress=172.30.32.1

MarshalOfficial

--select top 10 JSON_QUERY((select [value] from OPENJSON(rabbit_message) where Id=Id),'$.MessageId') AS test,* 
--from [dbo].[message_logs] (nolock)
--where 1=1


--select top 10 (select [value] from OPENJSON(rabbit_message)) AS test,* 
--from [dbo].[message_logs] (nolock)
--where 1=1

MarshalOfficial

import http from 'k6/http';
import {
    check
} from 'k6';
import { htmlReport } from "https://raw.githubusercontent.com/benc-uk/k6-reporter/main/dist/bundle.js";


export default function () {
    try {
        let str = 'https://google.com'

MarshalOfficial

public class AtomicLong
    {
        private long _long;
       
        public long Get()
        {
            return Interlocked.Read(ref _long);
        }
       
        public void LazySet(long newValue)