.NET Hawa

Problem With SSRS MultiValued Parameter

In SSRS 2008, some times multi – valued parameter drop down will fire selection event at “Select All”.  Solution is,  first please check the drop down first how many records it is handling if they are < 970, it is your data set fault. Your drop down is handling greater that 970 records it is a rule give by Microsoft guys to handle only 1000 records by default, as asp.net http requests.  Solution for this is, please add below tag to <appsettings> in your report manager web config file.

<add key=”aspnet:MaxHttpCollectionKeys” value=”[yourno.]” />

you can find report manager in sql server instance installation directory

Leave a comment »

Schema Modeling Techniques

A Schema is a collection of Database objects such as Tables, views, Indexes, stored procedures etc.

Querying historical data from databases we use Dimensional Modeling Schema Design.  Dimensional Modeling can be done from both physical and logical levels.  A Dimensional Schema may be logical or physical Schema.  Dimensional Schema can take data from any table or view because it only contains facts and dimensions that have in different columns of the table.   They are 4 – types of Data Modeling Schemas:

  1. Star Schema Read the rest of this entry »
Leave a comment »

Unified Dimensional Model (UDM)

To deal with users who want to retrieve data directly from data source, Microsoft introduced Unified Dimensional Model (UDM) with SSAS 2005 as a part.  SSAS separates the physical layer and modeling part using UDM which supposed to have advantages both of OLTP and OLAP.  UDM will use both Relation Model and Dimensional Model of Data. Read the rest of this entry »

Leave a comment »

Understanding Sql Server Configuration Manager

Sql Server Configuration Manager is a tool to configure the network protocols used by the Sql Server, and to manage network connectivity.

We will find SQL Server Configuration Manager API in below path

 Start -> Microsoft Sql Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.

Sql Server Configuration Manager gets information for WMI (Windows Management Instrumentation) Provider which takes information for “SQLServerManager10.msc” which is located in “C:\Windows\System32\” path.  Generally Sql Server Configuration Manager will use to Start, Stop, resume and Configure services of Sql Server.

sql server configuration manager

Left pane has list of configurations we can do for Sql Server. Read the rest of this entry »

Leave a comment »