Featured Database Articles
Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.
Deployment of cloud-based technologies introduces a wide range of challenges; however, few of them are scrutinized to the same extent as security. When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies, including authentication and authorization, network isolation, as well as data integrity and confidentiality. In this article, we will explore how these concepts apply to the Azure Cosmos DB offering.
Do all of your tables contain clustered indexes? Some say every table should have a clustered index. Greg Larsen shares a simple script to identify those tables in your database that don’t have a clustered index.
There may be some still using conventional export (exp); with Oracle 12 that may not be a good idea. Read on to see why.
The GDPR offers pseudonymization as a protection technique for personal data. Read on to see what pseudonymization is and why it can be difficult to implement.
Tables with 255 or more columns are not uncommon but Oracle introduces some interesting performance changes when dealing with them. Read on to see what can happen for such tables.
IBM's Db2 Version 12 for z/OS has many new features that focus on performance and security measures, particularly for mobile and cloud applications. Advances in cryptographic hardware and query accelerator technologies facilitate rapid development of customer-facing applications and the embedding of big data queries in operational systems.
IBM presents version 12 of its flagship database product Db2 as, "The ultimate enterprise database for business-critical transactions and analytics". What does this mean? In this slideshow we dive into the most critical changes in this version of Db2, including improvements for application enablement, DBA functions, on-line transaction performance and query performance.
What elements comprise current day disaster recovery planning, and how are large mainframe and big data applications recovered?