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

Deadlock – A quick, easy view

Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)

SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....