This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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/* |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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];'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require_once 'vendor/autoload.php'; | |
use Google\Cloud\Storage\StorageClient; | |
class MySessionHandler implements SessionHandlerInterface{ | |
private $savePath; | |
private $storage; | |
private $bucket; | |
public function __construct(){ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
NewerOlder