Data Warehousing

How to Conduct Effective Data Warehouse and Business Intelligence Software Evaluations

  • Article

Denise Rogers discusses the essential tasks in conducting effective software evaluations revolving around data warehousing and business intellegence. Each step has a dependency on the previous one, starting with establishing the framework of the evaluation and adding progressively elaborate data that facilitates a decision making process that is resolute.

2010-06-11

4,369 reads

Data Warehousing 2.0 and SQL Server: Architecture and Vision

  • Article

Architecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve. In 2008, the book on the latest evolution of data warehousing appeared – DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman). In that book the general architecture for data warehousing in its highest evolved form appeared.

2010-01-12

4,485 reads

What a Data Warehouse is Not

  • Article

Recently, I was at a conference, and I heard the following discussion about what a data warehouse was. One person suggested that a data warehouse was really all the old legacy systems connected by software that could access the data. By calling such a contraption a data warehouse, the organization could avoid having to do the hard and complex work of integration. There are so many problems with this federated approach to a data warehouse that they are almost not worth repeating here. But (once again!) here goes.

2009-11-09

6,637 reads

Blogs

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Read the latest Blogs

Forums

Multiple .ndf file in single disk

By IT researcher

I have moved some of my database to SQL server 2017 (RTM) - Standard...

Conversion failed when converting the varchar value ‘Active’ to data type int

By ahmed_elbarbary.2010

I work on sql server 2012 I face issue when make pivot for data...

Log shipping performing log backups despite its backup jobs being disabled

By alexhdavies

Hi Came across an odd issue this evening. Running a migration over the weekend...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers