N S

Novick Software
SQL Server Consulting • Design • Programming • Training

  andy novick is a sql server mvp

 

 

Developing and Testing SQL Server Databases with Visual Studio 2010

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

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

 


RSS as HTML

Personal Blog

 
New Tips:

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

Upcoming
Presentations:

SQL Server
Loadfest R2
Sept 24

NEVB
Sept 2
SQL Azure

Code Camp 14
Oct 2, 2010
Data Dude
SQL Azure


Full Schedule