Business intelligence and data warehousing tips and trends for database administrators

SQL etc

The Silent Problem of Data 04/25

There is a silent problem in many organizations and that problem is data, or more specifically, the lack of governance over data. The penalty for lack of data governance is permanent and pervasive; the negative consequences can vary from merely annoying to facilitating the downfall of an organization. Read on to learn more.

The Hidden Cost of Scaling with NoSQL 03/30

Many companies that host applications are intrigued by the web scale capabilities of NoSQL but for ISVs there is a better way.

Cloud Database Buying Guide 10/11

Cloud databases can save you time and money, but use them carefully.

Five Things Relational Database Administrators Need to Know About NoSQL Databases 02/23
NoSQL databases offer a number of advantages over relational databases, such as scalability, redundancy and rapid development.

BI Datasources - The Great Mash-up 02/08
Data mash-up within Business Intelligence (BI) applications is one of the latest must have requirements. Considering the growth of NoSQL use within the BI area, the mash-up can be another useful tool to be added to the BI application - but it must not be utilized to the detriment of the core principles of any BI solution.

Check Your Database Configurations 02/04
Today, there are a myriad of database configuration options – many of which are either direct security settings, or that impact security. When a new database is installed, DBAs need to address many configuration options to enhance database security. Let’s look at a few database configurations that should be followed.

EMC Greenplum Offers Free 'Big Data' Tools 02/03
EMC is now offering a free community edition of the EMC Greenplum Database, along with analytic algorithms and data mining tools.

IBM Launches Cognos Express Planner 02/01
IBM's new offering, Cognos Express Planner, joins the Cognos Express line of business intelligence (BI) and analytics software.

Mobile Business Intelligence: 10 Hot Apps You Don't Want to Miss 01/31
Drew Robb looks at some of the coolest mobile business intelligence apps, in preparation for the mobile BI explosion that's sure to come soon.

DW/BI Administration Without Process or Procedures Can be Catastrophic 01/25
DW/BI applications are a huge investment. So much time, effort and cost goes into the implementation of the ETL solution, the staging area, the actual data warehouse, the data marts and the BI solution, so why do organizations not follow or have procedures in place to manage communication, enhancements and /or troubleshooting?

ANSI SQL Can Combine Advantages and Principles of Relational and Hierarchical Data Processing 01/20
Michael M. David describes how relational and hierarchical data processing can be seamlessly combined in a way that supports and preserves both hierarchical and relational processing advantages while avoiding their disadvantages.

Apache Cassandra 0.7 Advances Open Source NoSQL 01/14
NoSQL database used by major web 2.0 sites gets a major update for database scalability.

Business Intelligence - SQL or NoSQL - Which is better 01/11

NoSql is being promoted by many as the next big thing within BI. Does this mean that we have seen the end of the SQL style RDBMS system within the BI area?

Ten Techniques to Guarantee a Successful DW/BI Solution 12/29
The ingredients to a successful Data Warehouse / Business Intelligence deployment include good project management, effective communication and using DW/BI tools to their full potential. Denise Rogers presents her top 10 techniques to guarantee a successful DW/BI deployment.

Moving towards Pervasive Business Intelligence 12/14
Pervasive Business Intelligence, which is the ability to enable a company to see their data as an asset that can be exploited in real time, has been the aim of many vendors and consultants in the BI industry for some time.