Author Archives: rpillai

About rpillai

I am a technology enthusiasts and love to work with databases and other technology. Learning new things everyday and don't think the path ever ends ...

SQL Server Replication status

Few days back I had to query to my production sql replication server to find what all publications are running and what is the status for each of those. A search on the web found me this (unfortunately I don’t … Continue reading

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

Find SSRS reports that are run

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

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

Big Data distribution downloads

I have been working on evaluating different big data solutions for the past few months.  If you want to give them a show, here are few of major big data solutions, these links are quick start VM images : Cloudera IBM … Continue reading

Posted in BigData, database, internet | Tagged , , , , , , | Leave a comment