I’m at SQL Rally today, presenting a spotlight session on Visual Studio Database Projects, aka Data Dude.
While the slide deck is not overly large, I did want to pass it along. You can download it from here.
Here are some of the topics we’ll be covering
–Creating a project
–Refactoring
–Deployment
–Data Creation
–Schema Comparisons
–Data Comparisons
–Unit Testing
If you are mostly interested in the links, here they are:
SQL Name Game – My example on how to generate Sample Data – https://arcanecode.com/2009/04/02/sql-server-sample-data-the-sql-name-game/
Data Dude Blog – http://blogs.msdn.com/gertd/default.aspx
VS Database Development Tools Forum – http://social.msdn.microsoft.com/Forums/en/vstsdb/threads
VS Development/Database Edition Home – http://msdn.microsoft.com/en-us/vstudio/dd408380.aspx
Finally, here are the tools we’ll be using, along with links to previous versions:
Visual Studio for Database Professionals “Data Dude”
Included with VS2010 Premium and higher
Included with VS2008/2005 Professional and higher
2008 GDR2 – http://www.microsoft.com/downloads/details.aspx?familyid=BB3AD767-5F69-4DB9-B1C9-8F55759846ED&displaylang=en
•2005 DB Pro Addon – http://www.microsoft.com/downloads/details.aspx?FamilyID=7de00386-893d-4142-a778-992b69d482ad&displaylang=en
Arcane Code 