SQL Server FAQs

Question 1

What is the primary function of the SQL Server Documentation tool?

Accepted Answer

This tool allows you to query and manage table and column-level documentation in SQL Server databases, leveraging SQL Server's extended properties for rich metadata storage.

Question 2

What types of authentication are supported for connecting to SQL Server?

Accepted Answer

The tool supports flexible SQL Server connection configurations using environment variables, accommodating both Windows Authentication (Trusted Connection) and SQL Server Authentication.

Question 3

Can I filter the documentation when querying?

Accepted Answer

Yes, you can filter documentation queries by schema name, table name, and even by documentation completeness status, allowing you to easily find undocumented or partially documented tables and columns.

Question 4

What information can I retrieve for individual columns?

Accepted Answer

For columns, you can retrieve details such as data type, nullability, descriptions, data classification (e.g., 'Sensible'), and associated obfuscation scripts, providing a comprehensive view of your data assets.

Question 5

How does the tool help with data governance and compliance?

Accepted Answer

It facilitates data governance by enabling data classification (e.g., Sensible, Privado) and the management of data obfuscation scripts directly within SQL Server's extended properties, helping identify and protect sensitive information.

SQL Server

SQL Server

Key Features

Use Cases

Key Features

Use Cases