IN-PERSON That’s So Metadata: Discover Your Database From the Inside ~ Rob Volk

This event is sponsored by [Featrix.ai](https://featrix.ai/)

Featrix offers "embeddings as a service" for structured, tabular data. Now you can ingest CSV, Snowflake, SQL, and other tabular data directly into ML environments for ML workloads without cleaning, imputing, normalizing, and so on.
You can even embed multiple tables into a single space, meaning you no longer have to enrich data before working with it in ML and analytics workloads.
Featrix embeddings are built with deep learning using dozens to hundreds of dimensions to capture the underlying patterns in your data.

Abstract

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks and tuning opportunities
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties

We will also cover the official Microsoft documentation on these features and other resources on how to use them.