Database Management & Programming News, Articles & Tutorials for Database Administrators
Rounding Down, Bankers Rounding, and Random Rounding in MySQL 12/02/2013
Over time, applying the same rounding algorithm to many numbers can lead to a condition known as rounding bias. Rob Gravelle presents some rounding implementations in MySQL that attempt to eliminate (or at least reduce) rounding bias.
Getting Started with Microsoft Power Query for Excel 11/25/2013
Power Query, provided as part of the Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Read on to learn how to install and get started using it.
Getting Ready for Big Data: Prepping the Data Warehouse 11/21/2013
Using advanced analytics to analyze business data is common, especially in large companies with many customer-facing systems. As more and more data is made available the enterprise stages large data stores into the enterprise data warehouse. These Big Data implementations bring their own problems and issues, and will require database administrators and support staff to redesign the data warehouse architecture.
Understanding Microsoft Power BI – Self Service Solutions 11/18/2013
Microsoft Power BI is a cloud based self-service Business Intelligence solution that you can use in Excel for all your data needs. It includes different tools for data discovery, analysis and visualization. Read on to learn more about Microsoft Power BI, the different tools under the Microsoft Power BI umbrella, and when each of them can be used.
Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues 11/14/2013
Continuing a discussion focused on implementing data services in Windows Azure, we turn our attention to the remediation of incompatibilities, resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, that need to be addressed as part of the migration process.
Compression and Advanced Compression in Oracle 11.2 11/11/2013
Compression can be an excellent tool to save database storage, but you need to be aware that the compression levels can change for updated tables when running Exadata and using any of the Hybrid Columnar Compression (HCC) compression types. Read on to learn more.
MongoDB Offers Certifications for Developers and DBAs 10/30/2013
MongoDB has announced a new certification program for developers and database analysts that work with the MongoDB NoSQL database.
Why Graph Search Is Moving Databases to a New Level 10/16/2013
NEWS ANALYSIS: Open-source database features the most far-reaching search IT since Google started ranking Websites more than a decade ago.
MongoDB's $150M Funding Signals 'Tectonic Shift' in Database Market 10/07/2013
MongoDB lands $150 million in venture funding in a move that indicates the NoSQL database is taking a toll on the big data world.
Oracle Options DB to Cloud, but Beware of the Fine Print 09/25/2013
NEWS ANALYSIS: Subscribing to an Oracle database in the cloud isn't as easy as swiping a credit card and paying by the drink.
Oracle MySQL 5.7 Moves Open Source Database Forward Faster 09/23/2013
A new development milestone release for open source MySQL 5.7 database offers improved performance and manageability.
Oracle Unveils Big Memory Machine to Support In-Memory Databases 09/23/2013
Oracle CEO Larry Ellison kicks off OpenWorld with new hardware and software releases.
Hybrid Databases Gaining Favor for Enterprise Big Data Analytics 09/15/2013
NEWS ANALYSIS: Enterprise data architects are turning their attention to developing hybrid databases that can process structured and unstructured inputs for big data analytics.
Couchbase Brings Open-Source NoSQL Database to the Mobile Form Factor 09/13/2013
NoSQL isn't just for big servers anymore, as Couchbase Lite brings open-source database technology to the mobile form factor.
Open-Source PostgreSQL 9.3 Wraps Up Data 09/09/2013
New developer features and enhanced stability take root in the latest PostgreSQL database release.
Couchbase Scores $25 Million for NoSQL Database 08/28/2013
Couchbase raises new funds, but loses a key technical contributor as it moves forward toward a new database release.
More Database News...