<div>
All developers need to check-in their changes into trunk/dev branch only. As soon as someone check-in their code it is better to run a CI build (Continuous Integration) to make sure that new changes haven't caused any issue in existing code. If you are using TeamCity then you can add as many Unit tests as you want and be able to verify them after CI build is completed to make sure you are good with the latest check-in. <br />
<br />
Once CI is good then you can push those changes into a Stagging branch where you can deploy your code to QA/Stagging area and have your testers do an end to end testing. After all, tests are completed and the code base is ready for production then it is better to tag this branch with the release date or any identification which we can use in future if you need to release a hot fix for specific release. &nbsp;<br />
<br />
Example:<br />
<br />
Let's say you are planning to release something for March 2016 then below are branches that you can have for that release. <br />
<br />
Dev branch: trunk ( all developers can check-in into this branch). <br />
<br />
Code from trunk should be able to deploy to development branch for developers to run some tests. Before moving code to stagging/QA.<br />
<br />
Stagging: &nbsp;master (Code is ready for stagging area for QA testing). The code will be deployed to QA servers and handed over to testers for their testing. <br />
<br />
Production: master_march2016_release ( You can name it something like this, it is better to follow certain naming convention within your team or firm to be consistent)<br />
<br />
<b>Note:</b> Once you have deployed code to production, no one should access &quot;master_march2016_release&quot;<wbr /> branch anymore.<br />
<br />
Best Practices: <a href="https://www.simple-talk.com/opinion/opinion-pieces/branching-and-merging-ten-pretty-good-practices/" rel="ugc">https://www.simple-talk.com/opinion/opinion-pieces/branching-and-merging-ten-pretty-good-practices/</a>
</div>


<div>
all posted answers are very good and constructive
</div>


<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
Can any one demonstrate the best practise structure using TFS for DEV and Test and Prod environments? &nbsp;<br />
<br />
Thanks,<br />
Regards
</div>
</div>


Hi 

Can any one demonstrate the best practise structure using TFS for DEV and Test and Prod environments?  

Thanks,
Regards

TFS Branching

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.