Information Management News

Sponsors

Trend-Setting Products in Data and Information Management for 2023

Today's data environments are highly diverse—residing on many platforms and requiring a variety of approaches to ensure data resiliency and availability. Delivering technology alone will not be enough in 2023. To help make the process of identifying useful products and services easier, each year, DBTA presents a list of Trend-Setting Products. These products, platforms, and services range from long-established offerings that are evolving to meet the needs of their loyal constituents, to breakthrough technologies that may only be in the early stages of adoption. Read More

Should Programmers Fear That AI Will Replace Them? Q&A with Erudit’s Ricardo Michel Reyes

AI is advancing at a faster clip this year with the debut of several technologies boosting its usage. Generative Pre-trained Transformer (GPT), for example, is the large-scale natural language technology that uses deep learn­ing to produce human-like text. AI expert and Erudit's chief science officer and co-founder, Ricardo Michel Reyes, discussed the growing use of AI in programming and whether or not its advance­ment is something that programmers should fear when it comes to their job security. Read More

Data Observability: Is It Data Quality Monitoring or More?

Observability by definition is a measure of how well internal states of a system can be inferred from knowledge of its external outputs. In other words, a system's behavior is determined from its outputs—information obtained by certain measures. Though observability as a term has been used for many years, the modern understanding originates in software observability, which is the ability to collect data about program execution, internal states of modules, and communication between components. Read More

Data Fabric, Data Mesh, And the Cloud: Data Management Architectures for the Future

While the emerging constellation of next-generation data architectures—fabric, mesh, and cloud—is extremely appealing, it's still full of unknowns. ­These approaches present opportunities for greater data democratization, but also increased complexity. Understanding the distinctions between data fabric and mesh are also important before moving to this architecture. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Confused About Database Dates? Many Are Across database structures, dates are ubiquitous: sales date; order date; shipment date; receipt date; created date; last updated date. You might think that with such an abundant presence, dates would be well understood. Sadly, dates hide in the shadows—and many are confused over how dates work. People run a query, get a result, and seem to expect that what one sees, is what one gets. If they see a two-digit year, they believe that is exactly how the data is stored.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • Four Database Performance Management Principles This month, I want to take a higher-level view of database performance concepts and introduce a few themes that will likely follow you throughout your career working with database systems and applications. These themes should be viewed as guiding principles to keep in mind when confronted with database performance issues.
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 Queryable Encryption A long, long time ago—in the early 90s—I first worked as a DBA with responsibility for enterprise databases. I will never forget how surprised and disappointed I was to discover that the data in the database files were completely unencrypted.  A system administrator with access to the database files could read the data in those files, even if they didn't have a database username and password.
Recent articles by Guy Harrison
  • Data in 2023: Efficiency, Scale, and the Road to Deep Learning In 2023, companies will live and die by their data strategies. Massive increases in information generation, the cloud, and innovative technologies will be top of mind for database managers, all while an uncertain economy continually threatens budgets. For companies to build and maintain exciting applications that customers love while increasing the bottom line, they need to plan, adapt, and execute effective strategies for their data and databases.
Recent articles by  

Trends and Applications