.NET Hawa

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 »