Configure SQL Server Database Mirroring: Step By Step

Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...

SQL Server Community Activities under Surat User Group

I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...

Blog Roll - List of blog post and script contribution

Greetings of the day!!

I am getting frequent emails with questions why I do not write as often I used to...

SQL Server GEEKS Annual summit 2015

Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...

SSAS– Resolving target machine actively refused

I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....

SQL Server–Security Risk Assessment PMP Way

Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project...

MSDB– cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...

Not so good news for MCM Aspirants

Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification,...

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

How to collect cluster Information using TSQL

Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...