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 ...

Creating a new file system in Linux

Here how you would create a new file system : First create a new partition using fdisk. eg: fdisk /dev/sdb     –> Options (m , n,p,1,  ,t,8e,w) Create volume group vgcreate myvg /dev/sdb1 Create a logical volume lvcreate -L … Continue reading

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

Drill your data with Apache Drill !

Feeling the Drill I have been using Apache Drill to explore data for a while now. Apache Drill is a low latency distributed query engine for large-scale datasets, including structured and semi-structured/nested data. Drill supports a variety of NoSQL databases and … Continue reading

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

Script check the index fragmentation in SQL Server

Today I had a need to find the index fragmentation on one of my sql server database and I found this script buried on my computer, thought I will share it here: DECLARE @DatabaseID int SET @DatabaseID = DB_ID() SELECT … Continue reading

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

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