Various types of SQL Databases

Data Engineers work with numerous types of SQL databases. Today, I'd like to give some information about the various categories and their real-world uses.

Types of Databases

Relational Databases (RDBMS):

They excel in structured data management, which makes them an excellent choice for transactional systems such as e-commerce platforms. Examples are SQL Server, MySQL, PostgreSQL, OracleDB.

NoSQL Databases:

They are used in power applications such as social media platforms and IoT systems, and are ideal for managing enormous volumes of unstructured or semi-structured data. Examples are MongoDB, Cassandra, DynamoDB

Columnar Databases:

Columnar databases expertise is in performing analytical queries on massive datasets. They are an essential component of data warehousing for analytics-driven organisations. Examples are Amazon Redshift, Google BigQuery

Graph Databases:

Ideal for complicated relationship scenarios such as social networks, recommendation engines, and fraud detection systems. Examples are Neo4j, Amazon Neptune

Remember that SQL is the foundation of data-driven decision-making, and comprehending these database types offers up a world of data possibilities.

SQL Query to find if Full-Text Indexing is enabled in SQL Server

Please find the SQL Query to find if Full-Text Indexing is enabled in SQL Server

SELECT
    CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
    THEN 
        'INSTALLED'
    ELSE 
        'NOT INSTALLED'
END IsFullTextInstalled;

Please find an alternated SQL query as follows:

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
Print 'INSTALLED'
Else
Print 'NOT INSTALLED';

Reference: FULLTEXTSERVICEPROPERTY (Transact-SQL)

Other MS Article:
 Enable a Database for Full-Text Indexing (SQL Server Management Studio)