Information Management News

Sponsors

2020 DBTA Readers' Choice Awards: Vote NOW!

Voting has opened for the annual Database Trends and Applications Readers' Choice Awards Program in which the winning information management solutions, products, and services are chosen by you—the people who actually use them. The competition will end on Wednesday, May 8, so be sure to cast your votes for your favorite products now. Read More

Best Practices to Ensure SAP High Availability

One of the primary objectives of any high-availability architecture is to ensure that any single points of failure are eliminated, such as cluster nodes connecting to a single SAN. If you are running SAP in the cloud, you can take advantage of your cloud provider's availability zones, which may exist in different geographic regions. Although a high-availability cluster can be deployed within a single zone, the zone itself is a single-point-of-failure. If the zone becomes unavailable, end users may lose access to the entire cluster. Read More

Why You Shouldn’t Pass on PaaS/DBaaS

Organizations have progressively pushed more infrastructure from on-premise data centers into cloud data centers. Some of this is driven by the desire to reduce costs, but more often than not, organi­zations are realizing that the infrastruc­ture required for the level of connectiv­ity, data growth, and analytics needed for success in a modern organization is well beyond the reach of homegrown infrastructure. Read More

DBTA Announces the 2020 Database DevOps Innovation Award Winners

Today, organizations must deliver new applications, as well as application updates and patches, at a faster rate than ever before. DevOps principles address this challenge by focusing on a combination of tools, processes, and collaboration among development and operations teams to enable more agile and integrated workflows for development, test, and deployment. It sounds great. The problem is that this streamlined approach often does not incorporate the database. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Hierarchies Often Require Multiple Perspectives From CEO to presidents, VPs, directors, to any number of mid-to-low level managers, the concept of hierarchies is pervasive in organizations. But, if one is dealing with a relational DBMS, a hierarchy remains an awkward concept.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • The Importance of Database-Enforced Integrity Ensuring the integrity of the organization's databases is a key component of the DBA's job. A database is of little use if the data it contains is inaccurate or if it cannot be accessed due to integrity problems. The DBA has many tools at his disposal to ensure data integrity. At a high-level, there are two aspects to data integrity.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • Azure Arc and the Rising Tide of Kubernetes What's so special about Azure Arc? The private preview of Azure Arc currently includes support for Azure SQL Database and Azure Database for PostgreSQL Hyperscale. But it's not hard to imagine a scenario where you might have a single management system that cov­ers a disparate a selection of computing resources such as on-premise physical servers, Hyper-V and VMware virtual machines, a few old Oracle databases running on Linux, some open source software built on PostgreSQL, a selection of external clusters running on AWS and Google Cloud Platform, and a new installation of Azure Stack.
Recent articles by Kevin Kline
Guy Harrison

MongoDB Matters

Guy Harrison

  • Mongoose Accelerates MongoDB Development Applications written in NodeJS are particularly synergistic with MongoDB since JavaScript objects (JSON) are native to MongoDB and to Node. So, it might seem strange at first that an ORM-like layer—Mongoose—has emerged. Why would we want a mapping layer between JSON objects and a JSON database?
Recent articles by Guy Harrison
  • The Top Five Index-Tuning Recommendations As with everything, there are trade-offs when it comes to indexes. A sign of a good database performance tuning and optimization solution is that it will analyze every query per database instance, look at all the tables used with each query, and then make a recommenda­tion for table tuning if there's a positive impact.
Recent articles by  

Trends and Applications