Documentation

Technical Article

Free T-SQL Script: Database Schema Documentation Generator for Generative AI Services Integration

  • Script

This script automatically generates comprehensive schema documentation that can be easily consumed by AI services for natural language querying, automated report generation, and intelligent data analysis.

You rated this post out of 5. Change rating

2025-09-03 (first published: )

715 reads

SQLServerCentral Editorial

Creating Documentation

  • Editorial

Who should create documentation for software? In many companies, it's the developers. In fact, in Redgate, often our developers are tasked with updating articles for products on our documentation site. We do have a streamlined process that has developers can submitting changes in some format (markdown? ) and an automation process that automatically updates the […]

You rated this post out of 5. Change rating

2023-04-26

211 reads

SQLServerCentral Article

Reading and Writing your Database's Documentation using JSON

  • Article

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]

You rated this post out of 5. Change rating

2021-06-28 (first published: )

3,580 reads

External Article

Documenting your SQL Server Database

  • Article

One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.

2015-05-18

9,083 reads

SQLServerCentral Article

Oiling the gears for the data dictionary

  • Article

Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.

4.75 (51)

You rated this post out of 5. Change rating

2014-04-25 (first published: )

14,599 reads

Blogs

Monday Monitor Tips: The Jobs Report

By

A customer wanted a report they could email to their boss about jobs, something...

Automating SQL Maintenance: How DevOps Principles Reduce Downtime

By

In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

By

Do you know if your SQL Server is really running at its best? To...

Read the latest Blogs

Forums

Find Invalid Objects in SQL Server

By Nisarg Upadhyay

Comments posted to this topic are about the item Find Invalid Objects in SQL...

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

All the Costs of Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item All the Costs of Downtime

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers