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.


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.


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.


6,637 reads


Life Support 2008 – Audit Logons


Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT


This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs


Migrate Windows server to cloud

By aroojahmad

Hi Expert, I am new in Cloud technology. I know SQL Server but doesn't...

When previewing a report it doesn't change the data when I change the value

By Doctor Who 2

Got some unusual behavior. I've finished writing a SSRS report that gets data from...

SQL Query Assistance Required

By troy1w1w

Hi. I am wanting to know if there is a way to make this...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers