Workload Tuning: Finding Top Offenders in SQL Server 2012

I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...

24 Hours of PASS Streaming Available

If you missed the 24 Hours of PASS Summit 2013 Preview, you missed some excellent sessions. I watched a few,...

Using Parameters in Power Query Extracts

Introduction
By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...

SQLSaturday Numbers For Period Ending June 30, 2013

Just saw this in the PASS Connector:
The SQLSaturday numbers are in for our fiscal year, which ended June 30, with...

Presentations slides for Best Practices to Deliver BI Solutions

Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works.  The abstract for my session...

SQL Server 2012 Express installation failed issue

I got an strange error when installing SQL Server 2012 Express

Environment:Window Server 2008 R2 Enterprise + SP1Microsoft Visual Studio 2012 installed.Net...

SSRS – Download all RDL files from Report Server in one go.

Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...

Connect to SQL Server When Window account Locked Out || Sql authentication(Sa) not configured

Hello Friends,
It’s being a many days I haven’t written anything. But there was lot of stuff I was thinking to...

SSRS: Report Actions, URL Actions and SharePoint

I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report.  The child / sub-report originally had two mandatory parameters and the...

SSRS: Report Actions, URL Actions and SharePoint

I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report.  The child / sub-report originally had two mandatory parameters and the...