Category Archives: how to

Find SSRS reports that are run

Posted on March 3, 2016 by rpillai

WITH RankedReports AS (SELECT ReportID, TimeStart, UserName, RANK() OVER (PARTITION BY ReportID ORDER BY TimeStart DESC) AS iRank FROM dbo.ExecutionLog t1 JOIN dbo.Catalog t2 ON t1.ReportID = t2.ItemID ) SELECT t2.Name AS ReportName, t1.TimeStart, t1.UserName, t2.Path, t1.ReportID FROM RankedReports t1 … Continue reading →

Posted in database, how to, sql server | Tagged , | Leave a comment

Drill your data on hadoop cluster using Apache Drill

Posted on December 19, 2015 by rpillai

I have been working on MapR and Cloudera big data distribution for the past year.  I have been fascinated by its capability.  One of my favorite is Apache Drill, a schema on read SQL interface to HDFS file system.  Its … Continue reading →

Posted in BigData, hadoop, how to | Leave a comment

How to setup ssh keys

Posted on April 4, 2015 by rpillai

I was trying to setup ssh keys on my linux servers and found this link to be very useful https://www.digitalocean.com/community/tutorials/how-to-set-up-ssh-keys–2 Credit goes to:  Etel Sverdlov of digital ocean on explaining

Posted in how to, linux | Tagged , , | Leave a comment

Adding CentOS repository to RedHat Enterprise Linux

Posted on April 4, 2015 by rpillai

Don’t have an active Red Hat subscription, but you want to use YUM ??? No problem, you can always add CentOS repository to the yum repos directory to have your red hat linux download and install from CentOS repository. So … Continue reading →

Posted in db2, how to, internet, linux, Misc | Tagged , , , | Leave a comment