[senthamizh]

Tableau: Select or Use most recent date from discrete date filter after data extract

Most often than not, one builds a dashboard that is rendered based on some selection of date (from filter). When it comes to data based on discrete dates, there are use cases when we want to see th…

[senthamizh]

If you ever want to know, in Oracle database, how much space you have used up so far (in terms of GB) by all of the objects in your schema, you can use the below SQL

[senthamizh]

There would be instances at work when you are querying against a big table, or creating a big table, and you have executed the SQL, and it keeps running for a long time, and status is showing nothi...

[senthamizh]

Execute SQL script using Windows Task Scheduler

Say, you have a SQL script ready, and you want that to run automatically without you kick starting it every single time. You can do this via 'adding the script to Windows Task Scheduler', and confi...

[senthamizh]

When you quit or force quit Tableau desktop in Mac, due to application "not responding" (for whatever reason may be), and then you try to open Tableau Desktop again, you might run into the below er...

[senthamizh]

When you have both versions of Python (2 and 3), and have 'pip' installed already in python, you can install the 3rd party python modules (e.g, bitstring module) with the below commands. Python 3: ...

[senthamizh]

#!/usr/bin/python3 #Script to find Fibonacci Series up to a certain maximum number (say 100 for e.g.,) in Python 3 def main(): a, b = 0, 1 print(0, end = ' ') #If you want the older style fibon...

[senthamizh]

How to configure Aptana Studio with Python3 interpreter

If you have installed Aptana Studio when you had Python 2 version, but now you have installed Python 3, here's how you need to configure or add Python 3 Interpreter to Aptana. Step 1: Find out wher...

[senthamizh]

You want to connect to Oracle databse using sqlplus utility. You can do so by, entering this command in your terminal/shell/other command line program. sqlplus username/password@servicename For th...

[senthamizh]

(by Senthamizh Samikkanu)

Python Tips and Tricks !!

Check the website to find how more on how to install pip for python.

[senthamizh]

VMware Installation Failure on Windows 7

Hey,

I ran into this issue, and when searching around, found the below instructions and it worked for me. So putting it out here as well, so it will be helpful for others.

1. Open Command prompt cmd (to be on the safe side as Administrator *lol*).

2. Extract the installation package:

<fullpath>\VMware-player-7.0.0-2305329.exe /e <yourfullpath>\VMwarePlayer7

3. Go into the folder <yourfullpath\VMwarePlayer7

4. Execute the command (otherwise the installation will not succeed)

vmwareplayer.msi EULAS_AGREED=1

:)

[senthamizh]

Empty an Unix, Linux file without removing the file

Here is the command to empty an Unix / Linux's file content, without deleting the file itself.

[user@server]$ > filename

[senthamizh]

Comcast Internet speed slow, How to fix

Is your internet speed is terribly low, even though you just got a new connection ?

And you tried everything , resetting the router, cable, restarting your computer... but nothing has worked.

then may be it's the WMM support which is, by default, enabled.

Disable WMM support, and the internet speed should be back !!

And how do you do disable it ?

Login to your router at http://192.168.1.1

Go to the tab (section/page) called 'QoS'

And 'uncheck' the check box that says 'WMM Support'

[senthamizh]

#hearstcastle

[woodendreams]

(by Henry w. L)