Featured Database Articles
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later. Read on to learn more.
Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.
When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.
With the explosion of cloud-based applications and database services, it might be wise to consider backing up local databases to the Oracle cloud. Read on to see how to configure and execute such backups.
When upgrading an Oracle database to version 188.8.131.52 you may find that scripts that scan the alert log stop working. Read on to see why and how to address the issue.
Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task. Read on to see how DBMS_PROFILER can make that job easier.
What elements comprise current day disaster recovery planning, and how are large mainframe and big data applications recovered?
There has always been a need for some IT users to access data from multiple operational systems across the enterprise. In a process called data integration, companies developed a centralized IT solution that presented data from across the enterprise in a single application. However, with the advent of big data applications, there is now too much data across the enterprise to transport and store in a single place. Data integration had to be re-defined in order to access separate data stores in-place with available access in real-time.
Lockwood Lyon explores the aspects of data modelling that are essential during application development in order to make the application data valuable to an organization.