Novick Software
SQL Server Consulting • Design • Programming • Tuning

  andy novick is a sql server mvp

 

 

Developing and Testing SQL Server Databases with
Visual Studio 2010

Watch the DNR TV episode

This one hour episode of DNR TV featuring Andy Novick Discussing Database Development and Testing using Visual Studio with Carl Franklin.  It's the material from this VS 2010 Data Dude presentation.

Database development has been a hodgepodge of ad hoc techniques from the beginning. The Visual Studio Database Professional Edition, a.k.a The Data Dude, gives us a new tool for developing and testing databases. Visual Studio 2010 is the third iteration of Data Dude technology and database development is no longer an exclusive product. It’s now included in every Visual Studio edition from Professional on up.


This presentation introduces database development with Visual Studio. This will demonstrate development of the schema, integration with source control, build processes, and development of Unit Tests. Testing databases has always been difficult and new techniques are now available to developers to build them and automate regression testing.

There aren't many slides but what I have is here: data-dude-slides updated September 30, 2010

There isn't much in the examples, yet.  But here's the project from Cape Cod.Net with a test project and example test.  vs2010-database-and-test-project-example
 

NH
Code Camp

June 5
2010

Cape Cod.Net
UG

June 16
3010

Hartford
Code Camp

June 19
2010 

Fairfield/
Westchester
SQL Server UG
July 8 2010

Code Camp 14
Saturday
Oct 2nd
2010


RSS as HTML

Personal Blog

 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule