Information Management News

Sponsors

Big Data 50: Companies Driving Innovation in 2022

Data has only become more important as organizations look ahead to what a post-pandemic world could look like. Some of the new approaches being embraced to help drive greater benefit from data are DevOps and DataOps, data quality and governance initiatives, hybrid and multi-cloud architectures, IoT and edge computing, and a range of next-gen databases. Read More

Sponsored Content: Raising the Bar for NoSQL Databases

NoSQL databases, also referred to as non-relational, continue to grow in popularity both on-premises and in the cloud. Of the 395 different database management systems tracked by site DB-engines, more than half are non-relational. These include key-value, document, graph, time series, and many more database models that fall into the NoSQL category. As more organizations modernize their applications or develop new applications from scratch, they adopt a microservices-based architecture that allows them to take advantage of the benefits of NoSQL databases Read More

Democratizing Data Starts With Establishing a Data-Centric Culture

Thanks to significant innovation and recent disruption in the data management space, organizations are achieving unprecedented value from both internal and external data. Much emphasis has been placed on the importance of achieving digital transformation, yet thanks to these rich data assets, organizations are finding new ways to serve customers across both digital and physical boundaries. Read More

Sponsored Content: Advantages of Migrating from SQL Server to Amazon Aurora PostgreSQL

Microsoft SQL Server is a relational database service that supports transactional processing and analytics. With a 30-plus year history, SQL Server has been a mainstay at many organizations. Now, however, open-source technologies like PostgreSQL, have become increasingly popular for customers. More and more customers are migrating to them from overpriced, restrictive commercial databases that lock them in. With an increasing array of choices, the same organizations are looking for lower cost options, including low-cost, cloud-native, fully managed database services like Amazon Aurora PostgreSQL-Compatible Edition, as this lowers total cost of ownership while providing the desired performance. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Only the Strong Survive In building a logical data model, some entities are considered strong, other entities are considered weak. Strong entities are the most foundational elements within a nascent Entity-Relationship Diagram (ERD) and comprise the list of objects that would likely come to mind first. Strong entities are independent in that they exist all on their own and can be created without having to meet any pre-conditions.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • The Importance of Service Level Agreements Establishing agreed upon services levels for database applications is of the utmost importance for assuring that performance meets required criteria. Without pre-determined, negotiated service level agreements in place, database and application performance can become a never-ending game of blind man's bluff, where DBAs blindly and constantly seek an unspoken goal. Instead, active service level management should be the standard.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • New Troubleshooting Capabilities in SQL Server and Azure SQL Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged Instances. This DMV consolidates and simplifies telemetry from SQL Server ring buffers, applies heuristics, and provides a result set. The DMV stores a record for each out-of-memory (OOM) event that occurs within the database, providing details about the OOM root cause, the memory consumption of database engine components at that point in time, potential sources of memory leaks, and more.
Recent articles by Kevin Kline
Guy Harrison

MongoDB Matters

Guy Harrison

  • MongoDB 6.0 Introduces New NoSQL-SQL Engine In previous columns, we've noted that the SQL language is in the ascendant. New SQL native databases such as CockroachDB and Yugabyte are showing robust adoption, while non-relational (NoSQL) databases increasingly provide SQL interfaces to their data. In light of this increasing trend, it's no surprise to see the introduction of a new SQL capability within the latest release of MongoDB—the Atlas SQL framework. 
Recent articles by Guy Harrison
  • Become Human-Centric: How Nontechnical Managers Can Run Database Teams Working with databases causes friction. On one side, nontechnical managers want data pros to skip the jargon and clearly describe their needs. On the other side, data pros wish their managers had a deeper understanding of the tech involved. Nontechnical managers may think they need to understand the technology better and get into the weeds to close this inherent trust gap. But this isn't the case—managers are busy tracking resource allocations, Gantt charts, project plans, and punch lists. They must also fill open slots, upskill employees, and keep people from falling prey to the Great Resignation.
Recent articles by  

Trends and Applications