Intro to SQL Power Doc: Data Dictionaries and Inventory Management


Date: Wednesday, December 9
Time: 11am ET
Length: 1 Hour, 30 Minutes


An important part of database administration and a critical component of SQL Server performance tuning and troubleshooting is to learn the lay of the land—that is, what are the hardware, OS, and configuration settings for all your SQL Servers and, going one level deeper, what are the databases that are running on those servers. The great news for everyone is that there are some excellent tools that turn this normally arduous and time-consuming project into a fast and easy half-hour activity. Enter SQL Power Doc!

In this session, you will learn:

  • The basics of data dictionaries and why they are important for DBAs, Devs, and consultants
  • How to collect the necessary SQL Server metadata to confidently build a data dictionary from a pre-existing database
  • How to query and gather the server- and OS-level details of all the servers you are responsible for
  • Running reports on data dictionary and inventory data
  • How SQL Server and Azure SQL classification and tagging features can improve the quality of your data dictionaries

Why go through all of the hard work of building this information by hand when you can join us to see a demonstration of the powerful and free PowerShell scripts, available on Github, called SQL Power Doc. Join in the discussion to advance your database development knowledge so that your next project will be the most successful yet! With a data dictionary and server inventory information in hand, you can ensure that your database development projects won’t be filled with irregularities and inconsistencies, while also making sure your server inventory and OS-level configurations are adhering to solid best practices and standardization.


Interested in additional SentryOne webinars?  Check our webinar library.

Register now

Kevin Kline

Kevin Kline

Principal Program Manager

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Kendal Van Dyke

Kendal Van Dyke

Senior Consultant at Microsoft

Kendal is a database strategist, community advocate, public speaker and blogger. He is passionate about helping leaders use Microsoft’s SQL Server to solve complex problems that protect, unlock and optimize data’s value.

Since 1999, Kendal has specialized in SQL Server database management solutions and provided IT strategy consulting. Kendal excels at disaster recovery, high availability planning/implementation and debugging/troubleshooting mission critical SQL Server environments.

Kendal currently serves the SQL Server community as Founder and President of MagicPass, the Orlando, FL based chapter of the Professional Association for SQL Server (PASS). In 2012, Kendal served as a member of the PASS Board of Directors.

Kendal remains active in the SQL Server community as a speaker and blogger. He teaches SQL Server enthusiast and technology leaders how to protect, unlock and optimize data’s value. Since 2008, Kendal has operated a SQL Server focused blog at http://www.kendalvandyke.com/.

Kendal earned a Bachelor of Science in Computer and Information Sciences from Florida State University. He enjoys spending time with his wife and four children. He is also an active volunteer within the community, serving as a parent assistant for Boy Scout Troop 125.

Companies with the highest demands for database performance choose SentryOne