How to Build a Basic Data Dictionary
Improve your SQL Server and Azure SQL database performance
In this session, we’ll teach you three methods for building a basic data dictionary useful for database administrators (DBAs), data engineers, and developers. The methods covered include:
- How to use the ANSI/ISO standard INFORMATION_SCHEMA to build a basic data dictionary from any existing database on Oracle, PostgreSQL, MySQL, and Microsoft SQL Server data platforms
- How to use a handful of system stored procedures to document an unformatted basic data diction for SQL Server and the Azure SQL data platform, i.e., the quick and dirty approach
- How to use a customized T-SQL toolkit to create a formatted basic data dictionary.
Improve not only your personal skillset, but also gain the potential to improve your SQL Server and Azure SQL database performance quickly and automatically.
Cross-platform database monitoring and management software built for SQL query performance monitoring, analysis, and tuning.
More resources similar to this
High Availability Alphabet Soup - FCI, AG, DAG, & RSAG
SQL Server has amazing tools for business continuity. The variety and scope of these tools can be overwhelming to even seasoned database administrators and architects, but the implementation has only gotten better/easier over the years.
View WebcastWorking without a DBA? A 10-Step Recipe for a Better SQL Environment
Your SQL Servers are up and running. Users aren’t complaining. And you haven’t had to do anything to them in a couple of weeks.
View WebcastTop 5 IT Database Security Features That Every SMB Needs
SQL Server Security should be on the mind of every company executive but is often neglected in small and medium-sized businesses. Like large companies, small and medium-sized businesses must also address data security.
View Webcast