Voting is Now Open for the 2023 DBTA Readers' Choice Awards

It's time to vote for the annual Database Trends and Applications Readers' Choice Awards, a competition in which the winning information management solutions, products, and services are selected by you, the readers. The voting period will be open through Wednesday, May 10. 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 learning 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 advancement is something that programmers should fear when it comes to their job security. Read More

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

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

Webinars

More Webinars

Columnists

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.

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.

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 Managed 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.

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.

Next-Gen Data Management

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.