Category Archives: database

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

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

How to find total number of read/write on sql server databases

The following SQL will tell you  how many reads and writes the databases on your sql server instances has serviced : SELECT d.Name AS DatabaseName, COUNT(c.connection_id) AS NumberOfConnections, ISNULL(SUM(c.num_reads), 0) AS NumberOfReads, ISNULL(SUM(c.num_writes), 0) AS NumberOfWrites FROM sys.databases d LEFT … Continue reading

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

SQL Server recovery using differential backup

One of my DBAs said while trying to restore differential backup he was getting  : Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward … Continue reading

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