database

SQLServerCentral Editorial

Formatting Dates and Times: The SQL Dialect Divide

  • Editorial

If you’ve ever had to format dates and times in SQL, you’ve probably come across one of the most jarring realities of working across platforms: every major RDBMS does it differently and sometimes confusingly.  What’s a TO_CHAR() in Oracle becomes FORMAT() or CONVERT() in SQL Server, and its sort of the same in PostgreSQL… but […]

(3)

You rated this post out of 5. Change rating

2025-07-11

219 reads

SQLServerCentral Article

Forget the Models, Your Data is the Secret Sauce for Generative AI

  • Article

Generative AI holds immense potential for businesses, but its success depends on the quality of your data. High-quality, strategically managed data is essential for building trustworthy, unique, and competitive AI applications. This article explores how AI leverages your data through embeddings, outlines best practices for data management, and emphasizes the importance of responsible AI development. By prioritizing data quality and effective management, you'll position your business to reap the full benefits of Generative AI and drive innovation.

(4)

You rated this post out of 5. Change rating

2024-02-21

2,996 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

(3)

You rated this post out of 5. Change rating

2023-12-11

10,649 reads

SQLServerCentral Article

Different Ways to Populate the List of Tables

  • Article

This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.

(1)

You rated this post out of 5. Change rating

2023-10-06

1,951 reads

External Article

The SELECT Statement in Oracle

  • Article

The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.

2023-06-21

Blogs

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

By

Both SQL Server and PostgreSQL are moving fast into AI territory — and if...

Monday Monitor Tips: AI Alert Analysis

By

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

Read the latest Blogs

Forums

BCA KCU SOEKARNO HATTA | Tlp/Wa:0817866887

By Layanan BCA_24jam

Tlp/Wa_Cs:0817-866-887. Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227...

BCA KCU PASURUAN | Tlp/Wa:0817866887

By Halo BCA

Tlp/Wa_Cs:0817-866-887. Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111 @BCA...

BCA KCP Lamongan | Tlp/Wa:0817866887

By Layanan BCA 24 JAM

Tlp/Wa_Cs:0817-866-887. Jl. Lamongrejo No.87, Krajan, Sidokumpul, Kec. Lamongan, Kabupaten Lamongan, Jawa Timur 62213 @BCA...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers