Guyand Maro Chu Zod Modar (Гуянд маро чу зод модар)

Гуянд маро чу зод модар, пистон ба дахон гирифтан омухт,
Шабхо бари гохвораи ман, бедор нишасту хуфтан омухт.
Як харф ду харф бар забонам ,алфоз ниходу гуфтан омухт,
Дастам бигирифту по ба по бурд, то шеваи рох рафтан омухт.
Пас хастии ман зи хастии уст, то хастаму хаст, дорамаш дуст…

                                                                             Эрадж Мирзо

Tajik Poem by Abuabdulloh Rudaki

Гар бар сари нафси худ амири марди,
Бар куру карар нукта нагири марди.
Марди набувад фитодаро пои задан,
Гар дасти фитодае бигири марди.
                       Абуабдуллох Рудаки

Ayajoni Man (Аячони ман)

Аячони ман,
Мехрубони ман.
Дилам ташна монд,
Сони гушна монд.
Ба дег алав кунед,
Оши палав кунед.
Дастамро шушта,
Якчо нишаста.
Гирифта кошук,
Накарда тук тук.
Ман ош мехурам,
Ман ош мехурам.
Сони рафта боз,
Бе чангу ароз.
Бози мекунам,
Бози мекунам. 

Thanksgiving Venn Diagram

Thanksgiving Venn Diagram explains the complete picture.

LifeHack: Use a binder clip to air out your sponges

SQL to Hive Cheat Sheet

Retrieving Information

Function	MySQL	Hive
Retrieving Information (General)	SELECT from_columns FROM table WHERE conditions;	SELECT from_columns FROM table WHERE conditions;
Retrieving All Values	SELECT * FROM table;	SELECT * FROM table;
Retrieving Some Values	SELECT * FROM table WHERE rec_name = "value";	SELECT * FROM table WHERE rec_name = "value";
Retrieving With Multiple Criteria	SELECT * FROM TABLE WHERE rec1 = "value1" AND rec2 = "value2";	SELECT * FROM TABLE WHERE rec1 = "value1" AND rec2 = "value2";
Retrieving Specific Columns	SELECT column_name FROM table;	SELECT column_name FROM table;
Retrieving Unique Output	SELECT DISTINCT column_name FROM table;	SELECT DISTINCT column_name FROM table;
Sorting	SELECT col1, col2 FROM table ORDER BY col2;	SELECT col1, col2 FROM table ORDER BY col2;
Sorting Reverse	SELECT col1, col2 FROM table ORDER BY col2 DESC;	SELECT col1, col2 FROM table ORDER BY col2 DESC;
Counting Rows	SELECT COUNT(*) FROM table;	SELECT COUNT(*) FROM table;
Grouping With Counting	SELECT owner, COUNT(*) FROM table GROUP BY owner;	SELECT owner, COUNT(*) FROM table GROUP BY owner;
Maximum Value	SELECT MAX(col_name) AS label FROM table;	SELECT MAX(col_name) AS label FROM table;
Selecting from multiple tables (Join same table using alias w/”AS”)	SELECT pet.name, comment FROM pet, event WHERE pet.name = event.name;	SELECT pet.name, comment FROM pet JOIN event ON (pet.name = event.name)

Metadata

Function	MySQL	Hive
Selecting a database	USE database;	USE database;
Listing databases	SHOW DATABASES;	SHOW DATABASES;
Listing tables in a database	SHOW TABLES;	SHOW TABLES;
Describing the format of a table	DESCRIBE table;	DESCRIBE (FORMATTED|EXTENDED) table;
Creating a database	CREATE DATABASE db_name;	CREATE DATABASE db_name;
Dropping a database	DROP DATABASE db_name;	DROP DATABASE db_name (CASCADE);

Current SQL Compatibility

Command Line

Function	Hive
Run Query	hive -e 'select a.col from tab1 a'
Run Query Silent Mode	hive -S -e 'select a.col from tab1 a'
Set Hive Config Variables	hive -e 'select a.col from tab1 a' -hiveconf hive.root.logger=DEBUG,console
Use Initialization Script	hive -i initialize.sql
Run Non-Interactive Script Source	hive -f script.sql

Best of the Web in One Picture

Visualization Periodic Table

A Period Table of Visualization Methods

http://www.visual-literacy.org/periodic_table/periodic_table.html

Funny: What's wrong with this picture?

What's wrong with this picture?

Funny: SQL Joke

Q: Why do you never ask SQL developers to help you move your furniture?
A: They sometimes drop tables.

Funny: How to spot a Burglar

An Oak Hill community couple discovered a thief in their home Saturday after a man told a joke and heard a laugh upstairs :).

Amazing Graphics Show How Much Fruits Have Changed Since Humans Started Growing Them

Visual: Selecting the Right Chart Type Infographics

Select the right chart type and never make a mistake ever again!

SQL: Joins Explained - Visually

Squirt - Become a faster reader

Bookmark this site: http://www.squirt.io

Better Graph, Chart

Better Table

Microsoft Outlook: Auto Archive in Outlook 2010

Step 1: From the main screen of Outlook, Choose File/Options.

Step 2: From the Outlook Options screen, choose Advanced.

  

Step 3: From the Outlook Options screen, choose AutoArchive Settings button from the right hand pane.

Step 4: Configure the following key parameters: Run AutoArchive every and Clean out items older than. Note: Only select the button Apply these settings to all folders now if you want every folder on your mailbox to be set to auto archive. If you do not, you will need to set the auto archive configuration manually on each folder. Click OK

    

Step 5: From the Outlook Options screen, click OK.

  

Step 6: If any new folders are created after applying the default settings, modify the folder properties on the AutoArchive tab of the new folder. Select the radial button to the left of “Archive items in this folder using the default settings”, then click OK.

Microsoft Excel: How to select all objects (pictures and charts) easily in Excel?

Select all objects in active worksheet
You can apply the Go To command to select all objects easily. You can do it with following steps:
Step 1: Press the F5 key to open the Go To dialog box.
Step 2: Click the Special button at the bottom to open the Go To Special dialog box.
Step 3: In the Go To Special dialog box, check the Objects option.

Step 4: Click OK. Then it selects all kinds of objects in active worksheet, including all pictures, all charts, all shapes, and so on.

Select all pictures in active worksheet

It seems no easy way to select all pictures except manually selecting each one. Actually, VB macro can help you to select all pictures in active worksheet quickly.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module Window.

Public Sub SelectAllPics()
ActiveSheet.Pictures.Select
End Sub

Step 3: Press the F5 key to run this macro. Then it selects all pictures in active worksheet immediately.

Select all charts in active worksheet

VB macro can also help you to select all charts in active worksheet too.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module Window.

Public Sub SelectAllCharts()
ActiveSheet.ChartObjects.Select
End Sub

Step 3: Press the F5 key to run this macro. This macro will select all kinds of charts in active worksheet in a blink of eyes.

HTML: Mailto Body Formatting

If you would like to embed your desired Subject line and sample message body from mailto/hyperlink, see a sample below:

mailto:someone@domain.com?subject=Subject%20Line&body=Sample%20message%0D%0ANext%20line

• %20 - space
• %0D%0A - enter/next line

Hope this helped!

OBIEE: Browser Compatibility Matrix

We are currently running 10g software and are alpha testing 11g.

OBIEE Browser Compatibility Matrix		PC		MAC		IOS		Android
		10g	11g	10g	11g	10g	11g	10g	11g
	Firefox
	Safari
	Chrome
	IE8
	IE9
	IE10
	Opera

    - Browser not available on this platform

   - Fully Compatible

   - Partially Compatible (see notes below)

  - Not Compatible

Source