Database Management & Programming News, Articles & Tutorials for Database Administrators

Addressing the Drop Column Bug in Oracle 18c and 19c 02/24/2020

The latest two versions of Oracle can throw an error when columns are set as unused and then dropped. Learn about this issue and how to address it.

Introduction to Azure SQL Database Auto-Failover Groups 02/17/2020

Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. Read on to learn more!

How do OODBMS and ORDBMS Differ from RDBMS? 02/10/2020

Get a high-level understanding of how object-relational and object-oriented database management systems differ from traditional relational database management systems.

The New SQL Server Approximate Count Distinct Function 02/03/2020

With the introduction of SQL Server 2019, Microsoft introduced a new method to count distinct values that can be faster and uses less resources. Read on to learn more!

Understanding Query Execution in Relational Database System Architecture 01/27/2020

What happens behind the scene in a modern relational database management system when a user submits a query until the result is obtained from the database? Read on to learn more!

Running Database Console Commands (DBCCs) on Azure SQL Database 01/20/2020

Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL Database and explore their role in Database-as-a-Service scenarios.

Using Oracle EXPAND_SQL_TEXT 01/13/2020

Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures.  Read on to see how Oracle's expand_sql_text can help solve such issues.

Suspending and Resuming Transparent Data Encryption (TDE) 01/08/2020

Running Transparent Data Encryption (TDE) in the SQL Server database engine asynchronously might take a while to encrypt the entire database. Read on to learn how to suspend and resume TDE to keep your system performant.

Creating a Data-centric Mobile App 01/03/2020

See step-by-step how to create a data-centric mobile app using common tools including SQLite and C#. To learn about these tools and how to create a simple mobile app, read on!

Overview of Azure SQL Database Serverless 12/30/2019

Azure SQL Database allows for stateful services in the cloud.  Read on to learn about the characteristics and use cases of the Azure SQL Database serverless tier.