Backing up Aurora MySQL
AWS Aurora MySQL doesn’t allow us to take backup of individual tables or database other than doing a regular mysqldump...
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...
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...
SQL Server Replication status
Few days back I had to query to my production sql replication server to find what all publications are running...
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...
Big Data distribution downloads
I have been working on evaluating different big data solutions for the past few months. Â If you want to give...