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

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.

Monitoring Table Change in Oracle 12/23/2019

Learn of possible scenarios to monitor changes when replicating Oracle. Read on to discover the best course of action for moving forward!

A Quick Look at SQL Server Numeric Functions 12/19/2019

If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions

Hands-on SQL in PostgreSQL 12/16/2019

Learn how SQL commands are typically entered using the PostgreSQL interactive terminal - psql. Get hands-on information for using SQL to deal with CRUD, viewing data, and more by using some of the basic SQL commands in PostgreSQL.

Turning off Parameter Sniffing for a SQL Server Database by Default 12/09/2019

Sniffing could be beneficial to your SQL Queries. Learn about parameter sniffing as well a how to turn it on by default.

Query Performance Optimization in MySQL 12/02/2019

Discover a few optimization points to ponder upon while designing a better query in MySQL.

Overview of Azure SQL Database Networking 11/25/2019

Learn about the range of connectivity options available for Azure SQL Database deployments.