Information Management News

Sponsors

DBTA 100 2022: The Companies That Matter Most in Data

Today, data-driven benefits abound. However, the ability to seize new business opportunities, create new products, and deal effectively with competitive issues requires strong data management and analytics capabilities. To help bring new resources and innovation to light, each year, Database Trends and Applications magazine presents the DBTA 100, a list of forward-thinking companies seeking to expand what's possible with data for their customers. Spanning the wide range of established to cutting edge, this year's DBTA 100 is a list of hardware, software, and service providers working to enable their customers' data-driven future. Read More

Sponsored Content: How To Make Running Complex Database Environments Easier

Your database environment is getting more complex. If that sounds like old hat, that's because it is.For years, articles like this have warned of the dangers of increasingly convoluted database environments. They've discussed how Database Administrators (DBAs) are now tasked with managing thousands of databases and supporting technologies. They've lamented over increasing fragmentation and workflow-stymying bottlenecks, which have, among a whole list of things, significantly hampered developer velocity. And they've explained that opting for specialized databases and tools for every need can quickly spiral into vendor lock-in, swelling support contracts, and surrendered control over your data. Read More

Sponsored Content: Amazon Aurora Serverless: Changing the DBaaS Landscape

Serverless databases are here, and there is no going back. We first saw the emergence of serverless technology in the application layer, with fixed capacity for relational databases. Now, with serverless databases, both the application and database layers can scale automatically with no performance bottleneck. Data and modern databases are critical to an organization's data strategy and digital transformation initiatives. With serverless databases, IT teams have the ability to drive more of these initiatives. Read More

Microservices Are Back in the Driver’s Seat—With Event-Driven Architecture By Their Side

Microservices architecture is increasingly the technical strategy businesses are using as part of their current transformation projects—breaking down existing monolithic applications into self-contained, independently developed and deployed services. In fact, in a recent O'Reilly study of software engineers and technical professionals, more than three-fifths (61%) of respondents have been using microservices for a year or more. The same report found finance and banking lead the way in using microservices—but many other industries are following suit, including retail/ecommerce, telecom, manufacturing, transportation and logistics, and more. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Modeling Data Is a Many-Splendored Thing Data modeling is the process of defining datapoints and struc­tures at a detailed or abstract level to communicate information about the data shape, content, and relationships to target audiences. Data models can be focused on a very specific universe of discourse or an entire enterprise's informational concerns. The final product for a data modeling exercise varies from a list of critical subject areas, an entity-relationship diagram (ERD) with or without details about attributes, or even a data definition language (DDL) script contain­ing all the SQL commands to build a set of physical structures within some chosen database management system (DBMS).
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • Why You Must Integrate Database Archiving and Recovery Data archiving is an important aspect of data governance and data management. Not only does archiving help to reduce hardware and storage costs, but it is also an important aspect of long-term data retention and a key participant in regu­latory compliance efforts. When long-term data retention is imposed on your data—anything more than a couple of years—then archiving it can be the most optimal solution.
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

Emerging Technologies

Guy Harrison

  • SQL Survives and Thrives in the Post-NoSQL Era The SQL language served as a universal language for data­base manipulation from the mid-1980s until NoSQL data­bases started gaining strength about 12 years ago. However, after a short period in the wilderness, SQL is back and possibly more vital than ever.
Recent articles by Guy Harrison
  • The Cost-Benefit Analysis of Database Backup Strategies Data plays a vital role in any successful business. Protect­ing this data is mission-critical, and it falls to database administrators (DBAs) to organize, maintain, and secure it. The most effective way for DBAs to protect data is through database backups, a process designed to copy the data and schema from an existing database and save it else­where for future retrieval. Like any process in IT, however, there are a few factors to consider when devising a database backup strategy to ensure it meets your business needs.
Recent articles by  

Trends and Applications