This file contains hidden or 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 ([email protected])" | |
ARG DEBIAN_FRONTEND=noninteractive | |
# UPDATE PACKAGES | |
RUN apt-get update | |
# INSTALL SYSTEM UTILITIES |
This file contains hidden or 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 hidden or 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 ([email protected])" | |
ARG DEBIAN_FRONTEND=noninteractive | |
# UPDATE PACKAGES | |
RUN apt-get update | |
# INSTALL SYSTEM UTILITIES |
This file contains hidden or 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 ([email protected])" | |
ARG DEBIAN_FRONTEND=noninteractive | |
# UPDATE PACKAGES | |
RUN apt-get update | |
# INSTALL SYSTEM UTILITIES |
This file contains hidden or 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 hidden or 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 ([email protected])" | |
ARG DEBIAN_FRONTEND=noninteractive | |
# UPDATE PACKAGES | |
RUN apt-get update | |
# INSTALL SYSTEM UTILITIES |
This file contains hidden or 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 hidden or 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) |
This file contains hidden or 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
package com.radityopw.simpledb; | |
public class CommandResult{ | |
public static final int OK = 1; | |
public static final int ERROR = 2; | |
public static final int EXIT = 3; | |
public int status = CommandResult.OK; | |
public String message = ""; |
This file contains hidden or 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
# Swap | |
[._]*.s[a-v][a-z] | |
!*.svg # comment out if you don't need vector files | |
[._]*.sw[a-p] | |
[._]s[a-rt-v][a-z] | |
[._]ss[a-gi-z] | |
[._]sw[a-p] | |
# Session | |
Session.vim |