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...
115 comments:
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...
2 comments:
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...
1 comment:

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...
›
Home
View web version

About Me

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