databasejournal.com databasejournal.com

How do OODBMS and ORDBMS Differ from RDBMS?

Relational databases catered to the need of backend database in application development arena for quite a long time, but there are other types of databases that have the potential to do the same. We should not overlook their merit while dealing with a RDBMS as they can serve similar purposes equally well, and possibly in a better way. These database models are related to the relational concepts in doing what they do best. This article...

databasejournal.com databasejournal.com

The New SQL Server Approximate Count Distinct Function

With the introduction of SQL Server 2019, Microsoft introduced a new method to count distinct values. This new method of counting is to use the new function called APPROX_COUNT_DISTINCT(). As the name suggests, this new function doesn’t return the actual count of distinct values, but instead returns an approximate count of the distinct values. By using this new function, you might find your big analytic queries, that count...

databasejournal.com databasejournal.com

Suspending and Resuming Transparent Data Encryption (TDE)

When you turn on Transparent Data Encryption (TDE), the SQL Server database engine asynchronously starts encrypting data pages. For a large database, it may take a while to encrypt the entire database. Encrypting a database is an IO intensive process. Therefore you may find when you turn on TDE your system becomes IO bound and query performance starts to suffer. Well don't fret if you have this problem, because in SQL Server 2019 you...

databasejournal.com databasejournal.com

Overview of Azure SQL Database Serverless

Public cloud offers a wide range of benefits, including scalability, agility, and on-demand resource provisioning. While these benefits apply to majority of cloud services, they are most apparent in the context of serverless computing. Traditionally, this type of functionality was applicable to stateless workloads, but there is a growing number of scenarios that involve stateful services. Azure SQL Database is one of more recent...

databasejournal.com databasejournal.com

Query Performance Optimization in MySQL

Experts know how to write performance efficient queries. Although experience ripens wisdom, there are certain things that one must understand at least to begin with. For example, you must understand key considerations of query design; how a query performs internally, where it fails, optimization patterns, etc. In this article, I’ll provide a few optimization points to ponder upon while designing a query in MySQL. Why Are Some...

databasejournal.com databasejournal.com

Overview of Azure SQL Database Networking

The networking capabilities of Azure SQL Database have been evolving since its inception, as the service offering became more diverse and the underlying infrastructure platform matured. The initial constraints that limited connectivity to an external, publicly accessible endpoint have been eliminated with the introduction of such technologies as Service Endpoints and Azure Private Link. In this article, you will learn about the range...

databasejournal.com databasejournal.com

A Beginner’s Guide to SQL String Functions

There are quite a few string functions in the SQL language, and today I will present most of them. To be more specific, SQL has the following string functions: SQL has the following string functions: ASCII CHAR CHARINDEX CONCAT CONCAT_WS DATALENGTH DIFFERENCE FORMAT LEFT LEN LOWER LTRIM NCHAR PATINDEX QUOTENAME REPLACE REPLICATE REVERSE RIGHT RTRIM SOUNDEX SPACE STR STUFF SUBSTRING TRANSLATE TRIM UNICODE UPPER To help you know what...