By Cornell Emile on March 26th, 2013 // 2 Comments
Very Large Databases (VLDBs) have presented several major challenges for both Business Intelligence (BI) and database professionals that are responsible for designing and maintaining efficient mechanisms for extracting data from Online Transactional Processing (OLTP) systems. These challenges (in particular database contention) result in less than desirable performance within the OLTP that negatively impacts the businesses’ operations and increases the data latency within the BI solution.
...
Continue Reading
By Cynthia Jiang on March 5th, 2013 // No Comments
Establishing a reliable database backup and restore strategy is critical to the success of managing a SQL Server environment. The data captured within your systems over the years is a precious resource that needs to be carefully preserved and protected. In this post we will delve into the various technical aspects of implementing a comprehensive backup and restore strategy.
The backup part of the strategy defines the type and frequency of backups, the nature and speed of the hardware that is ...
Continue Reading
By Rich Cargile on February 5th, 2013 // No Comments
Hadoop is a new database technology that allows organizations to store massive amounts of unstructured data. It also allows for the creation of distributed applications that run in parallel across nodes against this unstructured data. Hadoop is an open source framework licensed by Apache, and was pioneered by large “Data” companies such as Facebook, Google, and Yahoo.
The Hadoop platform consists of two key technologies:
Hadoop Distributed File System (HDFS)
HDFS is a distributed file...
Continue Reading
By Emily Kizer on January 29th, 2013 // 1 Comment
When it comes to building and maintaining an effective website, a substantial amount of information regarding the return on investment can be gained by tracking information about who is visiting the site, how they found the site, how long they stayed, and what content they interacted with while on the site. Unfortunately, implementing an enterprise web analytics solution can be costly and time-consuming to maintain.
For sites that operate within a certain set of usage constraints, Google offe...
Continue Reading
By Ahmed Gadir on January 22nd, 2013 // No Comments
Many companies and departments look for ways to deliver information quickly to their executives, sales force, or end users. With many of the reporting projects I have worked on, the idea starts with an Excel spreadsheet, finds its way to Access or SQL Server, then becomes a major reporting project. In reporting, time-to-market is very important; the users need their information quickly. SQL Azure Reporting provides organizations with that quick time-to-market, at a low cost, and with instant...
Continue Reading
Subscribe to our RSS feed
