HOME

Introduction to Firebase

If you are doing a mobile or web-based app that need scalable access to a scalable, …

Verifying Object Exists and Dropping Object with One Statement

Discover how to do both in one SQL Server statement: Verify that a SQL Server object …

Addressing the Drop Column Bug in Oracle 18c and 19c

The latest two versions of Oracle can throw an error when columns are set as unused and …

Introduction to Azure SQL Database Auto-Failover Groups

Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. …

How do OODBMS and ORDBMS Differ from RDBMS?

Get a high-level understanding of how object-relational and object-oriented database …

The New SQL Server Approximate Count Distinct Function

With the introduction of SQL Server 2019, Microsoft introduced a new method to count …

Understanding Query Execution in Relational Database System Architecture

What happens behind the scene in a modern relational database management system when a …

Running Database Console Commands (DBCCs) on Azure SQL Database

Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL …

Using Oracle EXPAND_SQL_TEXT

Database tables are not static entities and sometimes changes can wreak havoc on …

Suspending and Resuming Transparent Data Encryption (TDE)

Running Transparent Data Encryption (TDE) in the SQL Server database engine …

Creating a Data-centric Mobile App

See step-by-step how to create a data-centric mobile app using common tools including …

Overview of Azure SQL Database Serverless

Azure SQL Database allows for stateful services in the cloud.  Read on to learn …

Monitoring Table Change in Oracle

Learn of possible scenarios to monitor changes when replicating Oracle. Read on to …

A Quick Look at SQL Server Numeric Functions

If you are wanting to manipulate numeric data with mathematically, then you will wan …

Turning off Parameter Sniffing for a SQL Server Database by Default

Sniffing could be beneficial to your SQL Queries. Learn about parameter sniffing as …