Virtual - Stored Procedure Data Flow Diagrams - Mike Burek
Hosted by Austin SQL Server User Group
Details
Online: RSVP to see link.
Topic: Stored Procedure Data Flow Diagrams
Abstract: Different from an Entity Relationship (ER) Diagram, a Data Flow Diagram will show how data flows from one table to another, especially for stored procedures. Sometimes you even go to the column level.
This is very helpful for learning a new code base, transferring knowledge, debugging, and documentation.
We'll go over the current way I do this myself, the tools I've tried, and some of the tools that didn't work.
Speaker: Mike Burek
Mike Burek has been working with SQL Server since 2000, in both DBA and development roles. He's worked with data across many different industries to import/export, process, performance tune, document, and automate. Much of his learning comes from community events, so he would like to give back some of his experiences, and encourage others to share their experiences and solutions.