radityopw

FROM alpine:3.18

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

RUN apk update
RUN apk add apache2 nano
RUN apk add php81 php81-apache2 php81-common php81-curl php81-mysqli php81-sqlite3 php81-ffi

RUN rm -rf /var/cache/apk/*

radityopw

FROM alpine:3.18

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

RUN apk update
RUN apk add apache2 sqlite mysql-client nano curl build-base unixodbc-dev freetds-dev linux-headers
RUN apk add php81 php81-apache2 php81-bcmath php81-bz2 php81-calendar php81-common php81-ctype php81-curl php81-dba php81-dev php81-doc php81-dom php81-embed php81-enchant php81-exif php81-ffi php81-fileinfo php81-fpm php81-ftp php81-gd php81-gettext php81-gmp php81-iconv php81-imap php81-intl php81-ldap php81-litespeed php81-mbstring php81-mysqli php81-mysqlnd php81-odbc php81-opcache php81-openssl php81-pcntl php81-pdo php81-pdo_dblib php81-pdo_mysql php81-pdo_odbc php81-pdo_pgsql php81-pdo_sqlite php81-pear php81-pgsql php81-phar php81-phpdbg php81-posix php81-pspell php81-session php81-shmop php81-simplexml php81-snmp php81-soap php81-sockets php81-sodium php81-sqlite3 php81-sysvmsg php81-sysvsem php81-sysvshm php81-tidy php81-tokenizer php81-xml php81-xmlreader php81-xmlwriter php81-xsl php81-zip php81-pecl-redis php81-pec

radityopw

FROM ubuntu:20.04

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

ARG DEBIAN_FRONTEND=noninteractive

# UPDATE PACKAGES
RUN apt-get update

# INSTALL SYSTEM UTILITIES

radityopw

-- pilih database dan cek apakah ada perbedaan user dengan login
USE [nama database];
EXEC sp_change_users_login 'Report';
 
-- jika user dan login memiliki nama yang sama, gunakan autofix
 
EXEC sp_change_users_login 'Auto_Fix', '<nama user>';
 
-- jika user dan login memiliki nama yang berbeda, lakukan penyematan ulang
 

radityopw

FROM ubuntu:20.04

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

ARG DEBIAN_FRONTEND=noninteractive

# UPDATE PACKAGES
RUN apt-get update

# INSTALL SYSTEM UTILITIES

radityopw

FROM ubuntu:20.04

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

ARG DEBIAN_FRONTEND=noninteractive

# UPDATE PACKAGES
RUN apt-get update

# INSTALL SYSTEM UTILITIES

radityopw

DECLARE @dbname VARCHAR(50)
DECLARE @statement NVARCHAR(max)
DECLARE db_cursor CURSOR

LOCAL FAST_FORWARD
FOR SELECT name FROM MASTER.dbo.sysdatabases OPEN db_cursor
    FETCH NEXT FROM db_cursor INTO @dbname 
WHILE @@FETCH_STATUS = 0
BEGIN
    SELECT @statement = 'use ['+@dbname+']; '+'CREATE USER [monitoring] FOR LOGIN [monitoring];';

radityopw

FROM ubuntu:18.04

LABEL author="Radityo P W (radityo.p.w@gmail.com)"

ARG DEBIAN_FRONTEND=noninteractive

# UPDATE PACKAGES
RUN apt-get update

# INSTALL SYSTEM UTILITIES

radityopw

<?php
require_once 'vendor/autoload.php';
use Google\Cloud\Storage\StorageClient;

class MySessionHandler implements SessionHandlerInterface{
  private $savePath;
	private $storage;
	private $bucket;
	
	public function __construct(){

radityopw

declare @table nvarchar(255)
declare @sql nvarchar(max)

-- setting table name 

set @table = 'dbo.test'

-- melepas sistem versioning
set @sql = 'ALTER TABLE '+@table+' SET (SYSTEM_VERSIONING = OFF);'
print(@sql)