radityopw

FROM ubuntu:20.04

LABEL author="Radityo P W ([email protected])"

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 ([email protected])"

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)

radityopw

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 = "";

radityopw

# 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

radityopw

CREATE TRIGGER <schema>.<table_name>_read_only_events ON <schema>.<table_name>
    INSTEAD OF INSERT,
               UPDATE,
               DELETE
AS
BEGIN
    RAISERROR( 'table is read only.', 16, 1 )
    ROLLBACK TRANSACTION
END

radityopw

;WITH CTE_Dev
AS (
    SELECT C.column_id
        ,ColumnName = C.NAME
        ,C.max_length
        ,C.user_type_id
        ,C.precision
        ,C.scale
        ,DataTypeName = T.NAME
    FROM sys.columns C

radityopw

# install library
pip install pywin32

# import komponen

import win32com.client

# untuk membuka excel 
xl = win32com.client.Dispatch('Excel.Application')