database

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.75 (4)

You rated this post out of 5. Change rating

2024-02-21

2,575 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.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

4,160 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.

5 (1)

You rated this post out of 5. Change rating

2023-10-06

1,313 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

External Article

How to Automate Cross-Platform Database Development

  • Article

In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.

2023-04-28

Blogs

Announcements from the Microsoft Fabric Community Conference

By

(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Read the latest Blogs

Forums

The Journey to Change

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Journey to Change

Check Azure SQL DB Space Used

By Cláudio Silva

Comments posted to this topic are about the item Check Azure SQL DB Space...

The Cloned Database Size

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloned Database Size

Visit the forum

Question of the Day

The Cloned Database Size

I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:database file propertiesI now run this command:

DBCC CLONEDATABASE(sandbox, sandbox_clone);
GO
When I examine the database file properties, what do they show?

See possible answers