We help IT Professionals succeed at work.
Get Started

How to learn new data model / database application efficiently?

Hec Ramsey
Hec Ramsey asked
on
78 Views
Last Modified: 2016-11-03
Is there a term for what I clumsily call "learning the database?"   I am not talking about learning how to develop or use SQL Server, I mean how to learn how  particular database application works, what code does what, what tables serve what function.

IE I get handed a ginormous SQL database application chock full of objects with 0 documentation (what a shocker) and told "get familiar with this and then we will meet with stakeholders sometime yesterday"

Is there a word for this?  Analysis seems to vague.  It's more like an autopsy, or "getting to know you".  Are there apps that help?

I've come up with some scripts that help.  There are 2 DMVs
sys.dm_sql_referencing_entities
sys.dm_sql_referenced_entities
the first shows all objects that touch an object, the other all the objects an object touches, which give me a good idea of what code does what.  

Also the DMVs that read the Execution plan data can reveal what code is used frequently.  

Armed with all this I can get a general sense of what tables and code are core and peripheral.
Comment
Watch Question
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
Unlock 2 Answers and 3 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE