What Features Visual Studio 2010 Offers DBAs and Database Devs

by Jonathan on April 8, 2010

I was recently reviewing some the change management and document control policies that governs our IT group. While I have been confirming to these change management policies I started to think back on how we make our developers work with code.

We have deployed a Team Foundation Server 2010 and are using it for source control and remote build functionalities. We require all source code to be managed and maintained on the TFS. We also work with a Test Driven Development philosophy creating Unit Testing to ensure code integrity as members of the team work on different aspects of an application.

It seems that we were holding our database developers (i.e. me) and our application developers to two different standards. This article is the first in a series to explore what Visual Studio 2010 and TFS 2010 has to offer for Database Developers and DBAs.

These topics will include but not be limited to:

  • Database Deployment
  • Database Change Management
  • Database Unit Testing
  • Database Test Data Generation
  • Data Access
  • Version Control
  • Build Automation

Some of these features are only available in certain versions of Visual Studio and/or only available via TFS. I will outline and note these feature when we cross them. Keep an eye out for our first article on Database Deployment next week.


Tagged as: SQL Server, Visual Studio 2010

Article by Jonathan Gardner

Jonathan has written 72 articles.

Jonathan is a PMP, Technical Manager and MCITP: Database Administrator 2008 working with Insource Technology in Houston, TX. He has over 8 years of experience with a wide range of IT solutions including Database Administration, Project Management, Virtualization, SAN Administration, and Windows Server environments. He writes from his website, jonathanagardner.com and is syndicated on SQLServerPedia.com.

Previous post:

Next post: