SQL SERVER GYAN

This portal is to share my acquired knowledge related to Sql Server. I hope will be helpful for novice and professionals.

Sunday, September 15, 2013

ALTER computed column

There is no special command in SQL Server to ALTER any computed column. But we can do by using below two ways: 1. Drop computed column a...

Tuesday, September 3, 2013

List All Objects Using Linked Server

While deployment a project on Production server I got an requirement to update my all LINKED Server references which is a very boring tas...

Friday, July 26, 2013

All About BIG Data

I have found many articles on Big Data but below are few selected and categories. Hope you will like . What is Big Data http...

Friday, May 17, 2013

Open Report Manager without Run As Administrator option

Below are steps to avoid "Run As Administrator" option while opening Report Manager Open a browser window with Run as administ...

Sunday, November 4, 2012

Type column description of ReportServer Database

Here is the Type column description of ReportServer.Dbo.Catalog Table : 1 = Folder 2 = Report 3 = Resources 4 = Linked Report 5 = D...

Usefull queries of ReportServer Database

http://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c Thanks, Randhir

Date Source's Dependent Report

Use ReportServer GO SELECT C2 . Name AS DataSourceName , C . Name AS DependentItemName , C . Path AS DependentItem...

View web version

About Me

Randhir: Gurgaon, Haryana, India; Working as a Team Lead(BI) in a Soft company. I have been working with Microsoft Technologies for the past 6 years. I am Microsoft Certified Professional(MCTS Sql Server 2005) and MCITP(Sql Server 2008 BI). Highly interested in SSRS, SSIS, SSAS.

View my complete profile

Powered by Blogger.