SQL Server: Data Warehouse 2.0

home » blogs » Raunak Jhawar » SQL Server: Data Warehouse 2.0

SQL Server: Data Warehouse 2.0

change text size: A A A

Comments (0)
Print
Rating: 0/5 0 Votes

posted 9/30/2011 6:27:37 AM by Raunak Jhawar - Views: [34555]

Data warehouse - A recession proof technology is now moving towards a whole new spectrum and with the advent of newer data architectures and better proposed solution engineering the mentioned references below aims to impart awareness about major facts for DW 2.0.

URL: http://www.acs.org.au/nsw/sigs/bi/BI_SIG_20081126_Master_Copy.pdf

AND

URL: http://www.devgear.co.kr/pdf/bill-inmon-data-warehousing-2-0-whitepaper.pdf

Thanks,

Raunak Jhawar

Rate This Blog Entry: register or login

Author

Raunak Jhawar (Member since: 7/12/2011 6:42:24 AM)
Specilaist for Intensive Data Computing.

View Raunak Jhawar 's profile

Comments (no comments yet)

Email Subscriptions

Get the Most Recent Blogs in your inbox

Raunak Jhawar's latest blog posts

SQL Server Integration Service – File Properties Task

3/22/2012 10:10:39 AM by Raunak Jhawar - Views: 11645 - Comments: 0

SQL Server Integration Service – File Properties Task Hi. Let’s try to explore more Integration Services, again, and this time I am going to walk you through a custom task. The name of the...
SQL Server Integration Services – Missing Package Configuration Option

2/7/2012 7:01:57 AM by Raunak Jhawar - Views: 5656 - Comments: 1

SQL Server Integration Services – Missing Package Configuration Option Hi, Let’s dig more into SQL Server Integration Service and this time it is the package deployment model. With the ple...
SQL SERVER INTEGRATION SERVICES – FLAT FILE DATA LOAD, POTENTIAL ISSUES AND WORK AROUNDS PART 1

1/25/2012 1:39:54 PM by Raunak Jhawar - Views: 8532 - Comments: 0

SQL SERVER INTEGRATION SERVICES – FLAT FILE DATA LOAD, POTENTIAL ISSUES AND WORK AROUNDS Hi, ETL projects are usually classified on the basis of the complexity of designing the packages used for...
SQL SERVER 2012 BI SEMANTIC MODEL – LIMIT AMOUNT OF DATA ON FIRST IMPORT

1/10/2012 8:24:47 AM by Raunak Jhawar - Views: 16113 - Comments: 2

SQL SERVER 2012 BI SEMANTIC MODEL – LIMIT AMOUNT OF DATA ON FIRST IMPORT Hello! This blog is on BI Semantic Model and I assume that you are aware what BI Semantic model is. I plan to take you th...
SQL Server Integration Services - Delay Validation Property

1/6/2012 6:01:18 AM by Raunak Jhawar - Views: 3886 - Comments: 0

SQL Server Integration Services – Delay Validation Property Hello! ETL can be very time consuming and also complicated process. In order that the business does not stands at cross roads when any...
SQL Server 2012 SSIS: Sending files using FTP Task

12/21/2011 9:45:26 AM by Raunak Jhawar - Views: 18004 - Comments: 2

SQL Server 2012 Denali CTP3 SSIS – Sending files using FTP Task Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released S...
SQL Server 2012 Denali CTP3 SSIS – Project Connection Bug and Resolution

12/19/2011 9:41:00 AM by Raunak Jhawar - Views: 4876 - Comments: 0

SQL Server 2012 Denali CTP3 SSIS – Project Connection Bug and Resolution Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly r...
SQL Server: SFTP with SSIS Execute Process Task

12/15/2011 6:20:28 AM by Raunak Jhawar - Views: 56191 - Comments: 1

SFTP with SSIS Execute Process Task Hello, SFTP, or secure FTP, is a program that uses SSH to transfer files. Unlike standard FTP, it encrypts both commands and data, preventing passwords and sensitiv...
SQL Server 2012 Denali CTP3 Known Bug and Resolution

12/12/2011 6:46:06 AM by Raunak Jhawar - Views: 24083 - Comments: 0

SQL Server 2012 Denali CTP3 Known Bug and Resolution Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CT...
SQL Server: BI Semantic Model and Reporting Part 2

12/8/2011 9:16:43 AM by Raunak Jhawar - Views: 17624 - Comments: 0

BI Semantic Model and Reporting Part 2 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release co...
SQL Server 2012 - Create BI Reports from Tabular Project

12/7/2011 9:01:02 AM by Raunak Jhawar - Views: 14181 - Comments: 0

BI Semantic Model and Reporting Part 1 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release co...
SQL Server 2012 - Generate, Filter and Sumx DAX Functions in BISM

12/5/2011 5:22:27 AM by Raunak Jhawar - Views: 10419 - Comments: 0

DAX Query for BISM Tabular Model Part 2 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release c...
SQL Server: Understanding DAX for BI Semantic Model

11/29/2011 9:17:20 AM by Raunak Jhawar - Views: 5581 - Comments: 0

DAX Query Part 1 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali...
SQL Server 2012 - COUNT Functions in DAX for BI Semantic Model

11/28/2011 9:16:19 AM by Raunak Jhawar - Views: 15127 - Comments: 0

COUNT Function in BISM Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “...
SQL Server 2012 - Perspectives In Tabular Data Model

11/25/2011 9:18:02 AM by Raunak Jhawar - Views: 3357 - Comments: 0

SSAS Tabular Project Part 2 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named &l...
SQL Server: EOMONTH() function in SQL Server 2012 and in DAX

11/24/2011 12:08:14 PM by Raunak Jhawar - Views: 15262 - Comments: 0

EOMONTH() and BOMONTH? Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “...
SQL Server: Understanding the RELATED function in DAX

11/24/2011 10:12:55 AM by Raunak Jhawar - Views: 10273 - Comments: 0

DAX Functions for Querying BISM tabular models Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 re...
Creating your first project in BI Semantic Model for SQL Server 2012

11/24/2011 5:55:50 AM by Raunak Jhawar - Views: 15332 - Comments: 0

SSAS Tabular Project Part 1 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named &l...
Configuring SQL Server 2012 Denali SSAS Engine in tabular mode

11/22/2011 10:00:02 AM by Raunak Jhawar - Views: 37403 - Comments: 0

Configuring SQL Server 2012 Denali SSAS Engine in tabular mode Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Serv...
SQL Server 2012 - Denali SSIS Enhancement Part 2

11/21/2011 10:01:28 AM by Raunak Jhawar - Views: 66169 - Comments: 0

SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release...
SQL Server 2012 Denali SSIS Enhancement - Group and Connection Managers

11/18/2011 4:56:31 AM by Raunak Jhawar - Views: 43144 - Comments: 7

SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release...
SQL Server 2012 DENALI T-SQL Enhancements: FETCH & OFFSET

11/14/2011 12:35:07 PM by Raunak Jhawar - Views: 29071 - Comments: 7

T-SQL New feature for OFFSET and FETCH Please note the table is completely fictitious and all data is just for presentation purpose Consider a scenario below: English Product Name Reorder Point Dealer...
SQL Server: Find 4,5 and 6 ranked entity

10/19/2011 12:58:34 PM by Raunak Jhawar - Views: 3244 - Comments: 0

Find 4 th , 5 th and 6 th ranked entity Let me first confess. This blog was never a planned effort. It just happened. How it happened…that’s equally interesting. Most of the time you migh...
SQL Server: Role Playing Dimension

10/8/2011 9:56:34 AM by Raunak Jhawar - Views: 1159 - Comments: 5

Role Playing Dimension Yet another very important and rather very interesting feature of any successful implementation of an enterprise DW. As a matter of fact, the decision of using should be ideally...
SQL Server: Analytic database market segmentation

10/4/2011 6:31:07 AM by Raunak Jhawar - Views: 982 - Comments: 0

Of late I was asked to prepare a case study for 'Vertica' and therein the picture for ' analytic database ' and ' Big Data ' made me do more and even more study and explore opportunities. Perhaps, if ...

Latest community blog posts

SQL Server Analysis Services - Setting the Default Measure for the cube

5/17/2012 9:38:28 AM by Amit Bansal - Views: 372 - Comments: 0

Hi Friends, This is indeed so basic and simple and I got surprised when I observed during one of my assignments that the customer has not set a default measure for the cube; they just did not know abo...

SQLServerGeeks.com bi-weekly webcast – 16 May 2012 at 11:30 a.m. IST

5/14/2012 5:27:36 AM by Admin Admin - Views: 86 - Comments: 0

Dear SQL Geek, Hope you are doing well. Continuing the success, here is the next bi - weekly webcast, absolutely free for the SQL Server community. It is your opportunity to hear a specialist and this...

SQL Server 2012 - Determining the size of a Columnstore index

5/11/2012 9:41:45 AM by Amit Bansal - Views: 943 - Comments: 0

Hi Friends, By this time, many of you already know about columnstore indexes, a column store architecture that groups and stores data for each column on separate pages and then joins all the columns t...

SQL Server - My experience as a SPEAKER - SQLBits 10 March 2012

5/11/2012 9:37:12 AM by Amit Bansal - Views: 496 - Comments: 0

Hi Friends, Speaking at SQL Server conferences is something that I cherish a lot, even more when it is outside my home country, India. It is indeed a privilege to interact with global audience and sha...

SQL Server : Clustered Index Physically Orders a Table Revisited

5/8/2012 9:46:47 AM by Ahmad Osama - Views: 4051 - Comments: 6

Hi Friends, Continuing on from my last blog post “SQL Server: Clustered Index Physically Orders a table”, this post demystifies the myth “Clustered index physically a table”. T...

Installing SQL Server 32 bit on 64 bit Operating System

5/7/2012 9:14:49 AM by Amit Bansal - Views: 975 - Comments: 3

Hi Friends, Today I got a question on “can you install SQL Server 32 bit on 64 bit OS?” Answer: Yes, you can ! During setup, click on the Options link and select the architecture (64 bit o...

Analysis Services IgnoreUnrelatedDimensions property in Dimensions Usage Tab

5/2/2012 5:20:04 AM by Amit Bansal - Views: 606 - Comments: 0

Hi Friends, Look at this scenario: When I try to slice Reseller Sales measure group by Geography dimension, I get the following output: Rightly so, because the Geography dimension is not related to th...

SQL Server Day in Gurgaon in May 05’ 2012

4/30/2012 5:05:54 AM by Admin Admin - Views: 280 - Comments: 0

Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata & Mumbai, we a...

Completed-Advanced SQL Server Database Administration & Performance Tuning - October 2011

4/28/2012 9:37:27 AM by Amit Bansal - Views: 352 - Comments: 0

Hi Friends, Today, while I write this blog, I am preparing to travel to Hyderabad for another assignment with Microsoft India Development Center. My last training blog post was here: http://www.sqlser...

Restoring a SQL Server Database: A Practical Example – An effective approach used to set up LogShipping.

4/26/2012 10:40:00 AM by Satnam Singh - Views: 1308 - Comments: 2

Scenario : A couple of days back, I was asked to setup a Disaster Recovery Strategy for one of the database located on my Production Server which was using SQL Server 2005 and Service Pack 3. This was...

SQLServerGeeks.com bi-weekly webcast – 27th April 2012 at 3 p.m. IST

4/26/2012 5:00:54 AM by Admin Admin - Views: 214 - Comments: 1

Hi SQL Geek, Continuing the success, here is the next bi - weekly webcast, absolutely free for the SQL Server community. It is your opportunity to hear a specialist and this time it is Amit Bansal pre...

Super Hit SQL Server Sessions in Bangalore, Mumbai and Kolkata

4/24/2012 7:29:03 AM by Sarabpreet Anand - Views: 338 - Comments: 1

Hi Friends, Attending SQL Server sessions in India was never been so easy and accessible at- least not for free, but now anyone can attend these sessions for free and easily while being in their own c...

SQL Server 2008 R2 (sp1) & SQL Server 2008 (sp3) Feature Packs

4/23/2012 9:30:33 AM by Did You Know Did You Know - Views: 212 - Comments: 0

Hi SQL Geeks, if you are looking for SQL Server 2012 feature pack; we blogged about it here: http://www.sqlservergeeks.com/blogs/QuickTip/sql-server-bi/523/sql-server-2012-feature-pack But if you are ...

SQL Server 2012 Feature Pack

4/23/2012 9:24:41 AM by Quick Tip - Views: 241 - Comments: 0

Hi SQL Geeks, The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. You can download the ...

SQL Server QUOTENAME function

4/23/2012 9:09:51 AM by Amit Bansal - Views: 1160 - Comments: 4

Hi Friends, Here is an interesting function: QUOTENAME() which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. (from Books Online) ...

SQL Server – Are Inline Table-Valued Functions better than a View?

4/20/2012 6:41:09 PM by Piyush Bajaj - Views: 321 - Comments: 1

Hello Folks, You would be very much aware of the View in SQL Server. But do you really know about Inline Table-Valued Functions? Well you don’t have to worry further more on this, because I will...

SQL Server Index Internals Part 3 – Index union operations

4/18/2012 5:15:08 AM by Amit Bansal - Views: 994 - Comments: 4

Hi Friends, I am writing this blog on my way back from Great Indian Developer Summit where I presented 2 sessions and received great feedback on my session. I had started the Index Internals series so...

SQL Server Analysis Services - another known bugissue in 2008 R2 64 bit – function library showing blank

4/16/2012 8:13:41 AM by Amit Bansal - Views: 748 - Comments: 0

Hi Friends, Last week while working on an assignment in Analysis Services, I came across a strange behavior that trace output was not showing. One of the readers of my blog, Tejal, pointed out that it...

SQL Server 2012 - Speaking at Great Indian Developer Summit (GIDS) - April 2012

4/16/2012 7:58:39 AM by Amit Bansal - Views: 1056 - Comments: 0

Hi Friends, This is turning out to be a fantastic year of conferences and speaking engagements. And God & my well-wishers continue to bless & wish… I haven’t been luckier before. ...

SQL Server 2008 R2 Express Database size limit

4/12/2012 8:20:10 AM by Ravi Kumar - Views: 926 - Comments: 0

Hi All, It is a great news to all those who use SQL Server Express editions. Microsoft has increased the database size limit of SQL Server 2008 R2 Express edition from 4GB to 10GB. Previous versions o...

SQL Server Analysis Services - Trace output not showing while processing the cube

4/11/2012 9:49:14 AM by Amit Bansal - Views: 3969 - Comments: 2

Hi Friends, I got a query from one of our blog readers that while he was processing the cube, the trace output was not showing up in the ‘Process Progress’ window. Something like this: If ...

SQL Server – What is Scalar Function?

4/11/2012 7:04:48 AM by Piyush Bajaj - Views: 3239 - Comments: 2

Hello Friends, It’s been a while that I have posted any blog. So here it is- Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF). So the...

SQL Server 2012 Released to Manufacturing

4/9/2012 11:41:31 AM by SQLnews SQLnews - Views: 325 - Comments: 0

Exciting news! SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1. Microsoft ...

Winners Announcement – Webcast Quiz - 15March 2012 Thurs-Index Tuning by Amit Bansal

4/7/2012 5:45:58 AM by Admin Admin - Views: 233 - Comments: 0

Hi Geeks, We thank all the attendees who participated in the webcast quiz - 15March 2012 Thurs–Amit Bansal by Amit Bansal. The quiz was hosted here: http://www.sqlservergeeks.com/forums/sqlserve...

SQL Server 2012 SEQUENCE Feature RTM restrictions and update

4/7/2012 4:40:14 AM by Amit Bansal - Views: 4085 - Comments: 0

Hi Friends, I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/346/sql...