yet another In Memory DataBase - MemSQL
Atul Singh
June 22, 2018
Writing this post after so many days, yet another IN-MEMORY database is in market which tag line promised with "The DataBase for Real-...
Showing posts with label Administration. Show all posts
Showing posts with label Administration. Show all posts
Friday, 22 June 2018
Saturday, 13 January 2018
Mongo DB - Installation and Configuration
Atul Singh
January 13, 2018
MongoDB is an open-source document database, and the leading NoSQL database. Written in C++. MongoDB features: Document-Oriente...
Sunday, 5 March 2017
How to get DataStage Project Settings
Atul Singh
March 05, 2017
DSListProjectSettings.bat is used to report all available settings of existing projects. USAGE: DSListProjectSettings <SERVER> <...
Monday, 20 February 2017
PDF Split & Merge with Perl
Atul Singh
February 20, 2017
Sharing two utility scripts (Perl), which can be used for extracting only few pages from a PDF file and also for combining different pdf fi...
Tuesday, 6 December 2016
Import the jobs from DS windows client #iLoveScripting
Atul Singh
December 06, 2016
As we have discussed a script which can export the datastage jobs from your client system ( http://bit.ly/2frNPKj ) likewise we can write a...
Wednesday, 12 October 2016
Script to Auto Compress the System Log Files
Atul Singh
October 12, 2016
This Script is originally written by " Andy Welter " to compress the linux system log files. I have modified it to work better. Y...
Wednesday, 3 August 2016
#3 How to Copy DataSet from One Server to Another Server
Atul Singh
August 03, 2016
This post is third and last of How to Copy DataSet from One Server to Another Server Series We have generated a populated a dataset and i...
Monday, 1 August 2016
#2 How to Copy DataSet from One Server to Another Server
Atul Singh
August 01, 2016
This post is second part of How to Copy DataSet from One Server to Another Server Continue....... After generating the dummy dataset,...
Saturday, 30 July 2016
#1 How to Copy DataSet from One Server to Another Server
Atul Singh
July 30, 2016
Hi Guys... I've been asked so many times that how can we move/copy one dataset from one server to another So here is the way which I ...
Tuesday, 7 June 2016
Tuning SQL Statement #4
Atul Singh
June 07, 2016
Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...
Sunday, 22 May 2016
Tuning SQL Statement #3
Atul Singh
May 22, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Tuesday, 26 April 2016
Tuning SQL Statement #2
Atul Singh
April 26, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...
Monday, 25 April 2016
Tuning SQL Statement #1
Atul Singh
April 25, 2016
• Try to use explicit columns and try to read columns in index orders if possible, even to the point of reading indexes and not tables....
Tuesday, 1 March 2016
ETL Development Standards
Atul Singh
March 01, 2016
These development standards provide consistency in the artifacts the ETL developers create. This consistency improves testing, operationa...
