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


SQL in the City Back in London


It’s just a couple weeks until the SQL in the City Summit comes back...

Azure Fundamentals 12th December


Certified Microsoft Azure Fundamentals  - AZ-900  1 day Web based Course - 12th December 2019 Its...

"Think Like a Certification Exam" at the PASS Marathon!


Thanks to the 56 of you who joined and actively answered my nerdy sample...

Read the latest Blogs


A User-Defined Function returns more rows

By aveek22

Comments posted to this topic are about the item A User-Defined Function returns more...

Another Typo

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Another Typo

Aging in Technology

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Aging in Technology

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Another Typo

See possible answers