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

Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...

SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans

Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...

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

SQL Training – Introduction to SQL Server Data Tools

Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...

SQL Training – Introduction to SQL Server Data Tools

Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...

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

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

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