Database Management & Programming News, Articles & Tutorials for Database Administrators
Digital Intelligence Transcends BI for The Dynamic Online Businesses 02/20/2017
Business intelligence has evolved significantly, but the challenge of bringing it to the masses as a powerful and simple solution remains. One of the major challenges is in handling and managing the big data and unifying the different data sources into a steady steam that can be easily analyzed to tell a story.
DB2 V12 Features Supporting Large Databases 02/16/2017
Big data applications were once limited to hybrid hardware/software platforms. Now, recent advances are allowing applications like these to be integrated with and federated into operational systems. In particular, IBM's DB2 for z/OS Version 12 delivers new features and functions that allow the DBAs to design, define and implement very large databases and business intelligence query platforms that fulfill some big data expectations.
Using Index-Organized Tables in Oracle 02/13/2017
Index-organized tables can provide great benefits if used properly. Read on to see how to use them and what you might run into if conditions aren't ideal.
Pivot Aggregate Counts on Months in MySQL 02/09/2017
A cross tabulation query is used to display the result of an aggregation on two or more fields. The trick to this type of query is the transformation of rows of data to columns. Follow along with Rob Gravelle as he creates a crosstab query for the Sakila sample database that counts the number of movie rentals for each customer aggregated by month.
Managing Azure SQL Database Recovery 02/06/2017
Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region. Read on to learn more.
How to Programmatically Determine Which Edition of SQL Server is Installed 02/02/2017
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
Microsoft's SQL Server Database Is Heading to Linux 03/08/2016
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.
More Database News...