Stored Procedure Data Flow Diagrams
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.
16 RecordingsMike Burek has worked with SQL Server for 25 years. Throughout his career, he has often worked with marketing data. From this, he has experience with various tools for ETL as the industry and programming has changed and matured over time. On the SQL Server side, he has held senior positions in database administration and database programming, focusing on optimization, automation, and increasing the value of data. Outside of work, he also runs the Austin SQL Server user group and makes a big effort to train others to help them grow in their careers.
- Capitol Area Central Texas Users of SQL Server 87 Recordings
Oct 17, 2023
- SQL Server 14 Recordings