Archive for 2019

Home » Archive for 2019

row count

http://www.techsapphire.in/index/generate_row_number_in_ssis/0-159

ssis tutor techbrother

http://www.techbrothersit.com/2014/12/ssis-videos.html

Catat_tampil 05.08 Add Comment DBA SQL server, SQL SERVER issue Edit

DBA sql server

http://www.techbrothersit.com/search/label/SQL%20SERVER%20DBA%20Video%20Tutorial

Catat_tampil 03.17 Add Comment SQL SERVER, T-SQL Edit

T-SQL Example

begin print'hello world'; end begin declare @var int; --OR declare @var1 int = 200; set @var = 100 print @var; pri...

Catat_tampil 21.08 1 Comment Edit

T-SQL sql server

T-SQL 1 Tutorials Point (India) Pvt. Ltd. https://www.youtube.com/watch?v=f93sYcdhg8Y 2 https://www.youtube.com/watch?v=V4hTLj...

Catat_tampil 20.39 Add Comment Oracle Edit

sql deveoper oracle

https://winapujiblog.wordpress.com/2018/01/16/belajar-oracle-11g-dan-sql-developer/

Catat_tampil 20.37 Add Comment SSIS Edit

conditional split / if then else

simple conditional split / if then else https://www.youtube.com/watch?v=skrEGUzQ0eg https://www.youtube.com/watch?v=dbqEsM0Ehx...

Catat_tampil 00.14 Add Comment SSIS Edit

lookup ssis

https://www.red-gate.com/simple-talk/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

Catat_tampil 21.11 Add Comment SSIS Edit

learning url SSIS

1 row count https://www.tutorialgateway.org/row-count-transformation-in-ssis/#targetText=Row%20Count%20Transformation%20in%20SSIS&tar...

Catat_tampil 10.25 Add Comment SQL SERVER, SQL SERVER issue Edit

url bageshkumarbagi mssqltips

http://bageshkumarbagi-msbi.blogspot.com/2019/09/maximum-insert-commit-size-option-in.html https://www.mssqltips.com/sqlservertip/1070/si...

Catat_tampil 10.02 Add Comment SQL SERVER, SQL SERVER issue Edit

eksport all databases sql server

https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ DECLARE @name VARCHAR ( 50 ) -- databas...

Catat_tampil 02.53 Add Comment SSIS Edit

import-and-export-packages-ssis, dan ssis services

https://docs.microsoft.com/en-us/sql/integration-services/import-and-export-packages-ssis-service?view=sql-server-2014 https://stackoverf...

Catat_tampil 02.33 Add Comment SSIS Edit

increase maximumerrorcoun ssis sql server

https://blogs.msdn.microsoft.com/sqlblog/2010/12/31/have-you-checked-the-maximumerrorcount-in-your-ssis-package/ klik di tasknya --> ga...

Catat_tampil 02.30 Add Comment SQL SERVER Edit

copy database attach-detach

https://dewadewonah.wordpress.com/2017/04/19/cara-copy-database-dari-sql-server-attach-detach/

Catat_tampil 02.29 Add Comment SQL SERVER Edit

delete primary key sql server

https://stackoverflow.com/questions/737152/how-to-disable-primary-key-constraint-programmatically ALTER TABLE mytable DROP CONSTRAINT...

Catat_tampil 20.55 Add Comment SSIS Edit

SSIS, SSAS, SSRS

http://bageshkumarbagi-msbi.blogspot.com/2016/02/remove-duplicate-records-in-ssis-package.html

Catat_tampil 03.18 Add Comment random Edit

get sid

https://www.windows-commandline.com/get-sid-of-user/

Catat_tampil 15.11 Add Comment Edit

ssdt tools

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation?view=sql-server-2017

Catat_tampil 21.29 Add Comment SQL SERVER Edit

peletakan group by having count

select city, COUNT(city) as jumlah FROM sales.customers group by city having count(city) > 3 ORDER BY jumlah ASC

Catat_tampil 21.02 Add Comment SQL SERVER Edit

belajar SQL SERVER

http://www.sqlservertutorial.net/sql-server-sample-database/ https://www.quackit.com/sql_server/sql_server_2014/tutorial/query_designer.cf...

Catat_tampil 03.41 Add Comment SQL SERVER Edit

query catat nilai max dari setiap kolom seri

SELECT TOP 1000 [id] ,[Seri1] ,[Seri2] ,[Seri3] FROM [TES].[dbo].[SeriesData] ------------------------ GO SEL...

Catat_tampil 03.13 Add Comment SQL SERVER Edit

case when case-transact-sql

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-2017

Catat_tampil 02.49 Add Comment DataStage Edit

dataStage

https://github.com/jdelvign/datastage2docker docker db2 https://www.ibm.com/support/knowledgecenter/en/SSZLC2_9.0.0/com.ibm.commerce.ins...

Catat_tampil 21.41 Add Comment ETL Edit

ETL TESTING

https://www.tutorialspoint.com/etl_testing/etl_testing_quick_guide.htm ETL Testing – Categories ETL Testing – Challenges ETL – Tester...

Catat_tampil 09.20 Add Comment SQL SERVER Edit

begin di dalam begin sql server

https://stackoverflow.com/questions/45317170/how-to-use-begin-transaction-with-while-loop-in-sql-server

Catat_tampil 07.42 Add Comment SQL SERVER Edit

perulangan sql server , while, nested while (loop)

http://working-log.blogspot.com/2013/06/cara-membuat-looping-pada-sql-server.html http://www.blackwasp.co.uk/SQLWhile.aspx nested h...

Catat_tampil 00.57 Add Comment SQL SERVER Edit

Collate collation sql server

MSDN collate sql server --------------------------------------------------------------------- https://docs.microsoft.com/en-us/sql/t-sql...

Catat_tampil 21.04 Add Comment SQL SERVER Edit

function trigger sql server

function https://ndereklangkung.wordpress.com/2009/12/23/sql-membuat-functions-sederhana-di-sql-server/ https://belajarquery.wordpress....

Catat_tampil 03.25 Add Comment POSTGRES Edit

sum balance per month postgres

with a AS ( SELECT * FROM (VALUES('Jan',100), ('Jan',150),('Jan',50),('Feb',70),('Feb',80) ) temp_ta...

Catat_tampil 02.31 Add Comment Pentaho Edit

use regex pentaho

Catat_tampil 23.07 Add Comment Tab Edit

a whole new world tab : disney

https://www.songsterr.com/a/wsa/disney-a-whole-new-world-tab-s81541t0

Catat_tampil 21.44 Add Comment Pentaho Edit

Pakek regex pentaho use regex

Catat_tampil 20.51 Add Comment POSTGRES, SQL SERVER Edit

Reading zero postgres, sql server, bss strategic

postgres --------------------------------------------------------------------------- https://w3resource.com/PostgreSQL/lpad-function.php ...

Catat_tampil 21.17 Add Comment POSTGRES Edit

query postgres kumpulan

https://www.holistics.io/blog/postgresql-queries-usage-monitoring/ https://gist.github.com/rgreenjr/3637525

Catat_tampil 02.28 Add Comment POSTGRES Edit

command postgres di linux

https://ambilgratis.com/tag/melihat-kolom-tabel-postgre/

Catat_tampil 05.06 Add Comment LINUX Edit

catat linux pid session

https://servernesia.com/1422/mendapatkan-pid-proses-linux/ https://ketikbagi.blogspot.com/2016/06/perintah-dasar-linux-part-2-manajemen.ht...

Catat_tampil 02.45 Add Comment LINUX Edit

ssh linux ke server

contoh ssh ke server

Catat_tampil 23.57 Add Comment seo serupa konten Edit

serupa konten wacana website

http://www.seoblank.com/strategi-seo.html https://teknologi.id/insight/kuasai-halaman-pertama-google-begini-8-tips-trik-seo-terbaru-2019/

Catat_tampil 23.38 Add Comment Guitar Edit

Fusion Guitar

https://guitar4fly.blogspot.com/2013/06/pemahaman-fusion-gitar.html http://www.slashkygitaris.com/2015/04/belajar-5-fusionrock-fusion-lick...

Catat_tampil 03.16 Add Comment cbr Edit

Pengertian pd di bank PROBABILITY OF DEFAULT (PD)

https://chinmi.wordpress.com/2010/08/11/istilah-istilah-dalam-manajemen-risiko/

Catat_tampil 02.52 Add Comment QUERY SQL Edit

Query query misian

--------------------------- isi data nya : source_time 3/17/2019 kurang 1 bulan SELECT to_char(source_time,'yyyyMM') as...

Catat_tampil 03.59 Add Comment LINUX Edit

kill pid ubuntu

Supposing that ps -u whoami returned something like PID TTY TIME CMD 4333 pts/1 00:00:00 fish 4335 ? 00:00:00 fis...

Catat_tampil 03.37 Add Comment LINUX, Pentaho Edit

setting java di linux di spoon

contoh isi setting tergantung java yg di instal contohnya : _PENTAHO_JAVA_HOME=/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.141....

Catat_tampil 02.38 Add Comment LINUX Edit

cek versi linux mint ubuntu dan debian

https://sobmint.blogspot.com/2017/08/cek-versi-linux-mint-ubuntu-dan-debian.html https://vpswp.blogspot.com/2015/06/cara-mengecek-versi-l...

Catat_tampil 06.19 Add Comment wondershare filgomora Edit

wondershare filgomora windows download

https://www.youtube.com/watch?v=QTfylKRikIg https://drive.google.com/file/d/1KKDyEZ_p8_Vf2UNiL7ZLrExIbyp7zNqn/view

Catat_tampil 19.57 Add Comment Regex Edit

catat regex

https://www.okedroid.com/2017/10/belajar-menggunakan-regex-di-program-java.html https://www.ntu.edu.sg/home/ehchua/programming/howto/Rege...

Catat_tampil 09.17 Add Comment LINUX Edit

instal linux mint

https://www.nesabamedia.com/cara-menginstall-linux-mint/

Catat_tampil 22.44 Add Comment Pentaho Edit

link download java_home

https://downlinko.com/download-install-jdk-8-windows.html https://www.itzgeek.com/how-tos/linux/ubuntu-how-tos/how-to-install-oracle-ja...

Catat_tampil 08.05 Add Comment troubleshooting Edit

hirenBootcd

https://inwepo.co/cara-mudah-membuat-hirens-boot-cd-di-flashdisk/ https://komputerkampus.com/artikel/4/cara-installmembuat-hiren-boot-cd-...

Catat_tampil 19.58 Add Comment LINUX Edit

install lamp

https://blog.storagecraft.com/install-lamp-server-linux-mint-18-command/ https://masrud.com/post/install-apache-mysql-php-di-linux

Catat_tampil 02.01 Add Comment LINUX Edit

Ganti default java version linux

http://ask.xmodulo.com/change-default-java-version-linux.html https://tecadmin.net/install-oracle-java-8-ubuntu-via-ppa/

Catat_tampil 01.38 Add Comment LINUX Edit

link java jre jdk

https://wiki.debian.org/Java/

Catat_tampil 00.43 Add Comment LINUX Edit

instal java versi 7

https://kuntimas.wordpress.com/2013/04/19/install-oracle-java-7-di-ubuntu-12-1012-0411-10-linux-mint-dan-distro-ubuntu-based-lainnya/

Catat_tampil 00.23 Add Comment LINUX Edit

Linux Command

Cek Versi linux mint uname -a uname -r uname -v uname -o cat /proc/version cat /proc/sys/kernel/{ostype,osrelease,version} Keterangan ...