How to Build a Basic Data Dictionary
Duration: 1 Hour
Not every software development team strongly emphasizes documentation. After all, they’re under a lot of pressure to create applications on a rapid schedule based on functional requirements. Often, these software development projects seldom include the creation documentation artifacts, like data dictionaries and data models. And yet, teams creating documentation often perform better and build a stronger core set of institutional knowledge than those who don’t. Wouldn’t it be useful to automate the creation of a basic data dictionary?
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.
Watch now to learn these tips and techniques to improve not only your personal skillset and that of the teams you support, but also gain the potential to quickly and automatically improve your SQL Server and Azure SQL database performance.
Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and co-author of SQL Server 2012 Management and Administration, Professional SQL Server 2008 Database Design and Optimization, and Database Benchmarking: Practical Methods for Oracle & SQL Server.
event205
event210
event211