Most useful stored procedures for a new DBA?
What are the best or most helpful Stored Procedures for a New DBA to have in their tool kit, for SQL 2012/2014?


You are asking Tools that are most useful to DBA

In no particuliar order ...


Brent Ozar Crew has sp_Blitz®, sp_BlitzCache®, sp_BlitzIndex®, sp_AskBrent®, sp_BlitzRS™, sp_BlitzTrace™ - This helps to do health check for sql servers.
To migrate sql server from one server to another use powershell - dbatools [it migrates over 25 components] from Chrissy LeMaire
To document sql server use - SQL Power Doc from kendalvandyke
For login transfer use Transferring Logins - By SQLSoldier 
Monitoring SQL Server use sp_whoisactive from Adam Machanic
Analyzing Query plans - use SQL Sentry's Free Plan Explorer


The inbuild system SP are limited to what they can report or show. The best way is to create your own (use existing ones and build your own &lt;-- make sure you give proper credit ! ) using DMVs.

e.g. sp_who is way ancient vs sp_whoisactive is what you will install on your server to quickly findout whats going on with the server.

Remove sp_change_users_login 'report' as it is deprecated. Instead you should use ALTER USER