TechBubbles

Data Warehouse terms

This post describes the different useful Data Warehouse terms which are closely associated with Kimbal Data Warehousing approach.

  • Measure It is a numeric value in reporting and analysis. Example: Price,Balance or Inventory. Measures come from data sources. Measure is characterized by grain.
  • Dimension A dimension is a collection of related values called members. example: 2008 is a member of Time. It can be described as an “axis of analysis”. In a query, dimension can be part of the query result. The most fundamental dimension is Time, which is essential in any context.  Dimensions are typically master data entries.

Read more

Related Posts:

  • No Related Posts
No comments

Importance of Data Warehousing and its Design

This post explains about what Data warehousing is and why we should care about it and then speaks about importance of using in enterprises and its design. It is important to understand the what data warehousing is all about, As a database developer you are likely to be involved with Data warehousing in one way or the other.

Data Warehousing Defined:

Data warehousing is a methodological approach for organizing and managing enterprise data to provide a trustworthy,consistent, integrated data foundation for an enterprise’s data-driven applications.

Importance

Data warehousing is must for running an enterprise of any size to make intelligent decisions. It enables the competitive advantage.Data warehousing is essentially tells about data and its relationships and it is foundation for Business Intelligence(BI). It clearly draws the distinction between data and information.

Read more

Related Posts:

  • No Related Posts
No comments

PIVOT & UNPIVOT Operators in SQL Server 2008

PIVOT is a new T-SQL operator introduced in SQL Server 2008 which can be used to rotate rows into columns and can create a crosstab query. You can specify the PIVOT operator in FROM clause of your query.

Using PIVOT

Specify the desired values that you want to see in SELECT statement and FROM clause contains the PIVOT statement. Let us take an example

Read more

Related Posts:

No comments

Date & Time Data Types in SQL Server 2008

The four new data types for storing dates and times in SQL Server 2008 are

  • Date
  • Time
  • DateTime2
  • DateTimeoffset

This post discuss about new date time data types and new date time related functions introduced in SQL Server 2008.

Read more

Related Posts:

No comments

T-SQL TIP in SQL Server 2008

You love this if you write a lot of T-SQL code. This tip I can say as  T-SQL language syntax enhancement. The following are the enhancements in T-SQL

  1. Now We can declare and initialize the variables with single statement.

Read more

Related Posts:

No comments

Introducing DotnetSizzler.com

fireworks

Dear Readers,

I have come up with a new BLOG DotnetSizzler that serves as a center that offers my services and is a platform for discussion and sharing of Tips & Tricks, Design Principles, Best practices, updates and techniques pertaining to Microsoft Technologies.

Major Stress will be on code snippets on .NET Technologies. I am to share the projects that I have lead and wish to continue as a freelance programmer.

I promise you to keep both my BLOGS DotnetSizzler and Techbubbles interesting, up to date and informative. I thank you for your support and hope you will  continue the same.  

Be sure to check the DotnetSizzler and feel free to add your comments, suggestions and questions.  


Share this post :

Related Posts:

  • No Related Posts
No comments

MERGE Statement in SQL Server 2008

There has been significant T-SQL improvements in SQL Server 2008. This post explores the most notable changes in T-SQL introduced in SQL Server 2008.

The MERGE Statement

As name says, It combines Insert,Update, and Delete operations along with the Select operation which provides the source and target data for merge. In earlier versions, We need to write separate multiple statements to achieve the same.

Read more

Related Posts:

1 comment

Creating an Analysis Services Project in Visual Studio 2008

Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage and aggregate the queries from multiple subject areas. This can be achieved by creating a cube in Visual Studio 2008. This post defines and explains the terms used in creating an analysis project in VS 2008.

Read more

Related Posts:

No comments

Silverlight sample in Visual Studio 2008

This post explains the tools required to start working with the Silverlight 3 in VS 2008. Also explains the sample Silverlight application building in Visual Studio 2008 environment.

image

Read more

Related Posts:

No comments

Table Expressions in SQL server

Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and their advantages.

  • Derived tables
  • Common Table Expressions

Read more

Related Posts:

No comments

Next Page »