InfoQ Homepage Data Warehousing Content on InfoQ
-
Database Virtualization - Is it worth it?
Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.
-
New Compression Features in SQL Server 2008
SQL Server 2008, code name Katmai, is expected to be released in May. It brings with it a whole host of new features, including several new compression options.
-
Michael Stonebraker: Major RDBMSes are legacy technology
Michael Stonebraker, co-founder of the Ingres and Postgres relational database management systems (RDBMS) and CTO of Vertica Systems, laid the framework for a debate in the database community by declaring that most major databases should be considered legacy technology.
-
Using SSIS in a Team Setting
Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.
-
Article: Bridging the gap between BI and SOA
Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. "Bridging the gap between BI & SOA" demonstrates how to reconcile the differences
-
SQL Server Best Practices Analyzer No Longer Tied to Service Packs
According to Paul Mestemaker, the SQL Server Best Practices Analyzer is no longer being tied to SQL Server Service Pack releases. This announcement is being made in conjunction with the first production release of the tool.
-
Sparse Columns Added to SQL Server 2008
SQL Server 2008 has lifted the limit of 1024 columns per table with a new option called "sparse columns". While this seems like its excessive, some developers have been running up against this limit.
-
ActiveWarehouse, a New Step for Enterprise Ruby
ActiveWarehouse, is a significant new plugin that makes it easier to build data warehouses in Rails.