An Example of Test-Driven Development, Part 5

Question

An Example of Test-Driven Development, Part 5

Andy Leonard

SSChampion

Points: 10144
More actions
August 20, 2009 at 12:09 am

#209713

Comments posted to this topic are about the item An Example of Test-Driven Development, Part 5
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

rd-600137 SSC Enthusiast Points: 131 More actions · Answer 1

Great series. Replicated all the steps and have it working except for one thing: When I drop the WeatherData db and run the MasterDeploy script, I get the following:

------------------------------------------------

[V1] Deploying WeatherData v1

[V1] Calling CreateWeatherData.test.sql...

Failure: WeatherData does not exist.

[V1] CreateWeatherData.test.sql called.

Msg 911, Level 16, State 1, Line 3

Database 'WeatherData' does not exist. Make sure that the name is entered correctly.

> DBVersion table exists.

> Dropping AddNewVersion stored procedure

...however if I highlight just the CreateWeatherData lines and run those first on their own, the database gets created and then I can run the MasterDeploy in its entirety. Any idea why it's getting stuck?

Mike Brockington SSC Eights! Points: 874 More actions · Answer 2

What is the point of storing this kind of information in the Database itself, but not using some kind of trigger?

People should be able to find out what they are looking at BEFORE they dive into the internals of the database, so the only point that I can see for storing version info in a table is if you can set things up to automatically record what changes are made.

Throw away your pocket calculators; visit www.calcResult.com

Scott Abrants SSCommitted Points: 1503 More actions · Answer 3

Great series Andy - Thank you.

I do have a question. All of the work you did here is something that has to be done manually and maintained manually. Now I understand in situations where you can’t buy a development too this is the way to go. I am a big fan of automation and using tools that help reduce errors and maintain efficiency. With that said is it me or are others seeing a big drop off in the number of posts for tools like Visual Studio Team Edition For Database Professionals even though 2008 was recently introduced? Reason why I ask is because I am pushing to use this tool as a standard yet I don’t want to go down this path only to have to go back to the manual way in the near future or worse yet back myself into a corner. Do you have any feedback on this? Again thank you for taking the time to put together a great series.

cornu_virginie Grasshopper Points: 15 More actions · Answer 4

cornu_virginie

Grasshopper

Points: 15

November 16, 2010 at 8:56 am

#1251382

Excellent Andy ! Thank you very much 🙂

Alexander Kuznetsov SSCrazy Points: 2217 More actions · Answer 5

Scott Abrants (8/21/2009)
Great series Andy - Thank you.
I do have a question. All of the work you did here is something that has to be done manually and maintained manually. Now I understand in situations where you can’t buy a development too this is the way to go. I am a big fan of automation and using tools that help reduce errors and maintain efficiency. With that said is it me or are others seeing a big drop off in the number of posts for tools like Visual Studio Team Edition For Database Professionals even though 2008 was recently introduced? Reason why I ask is because I am pushing to use this tool as a standard yet I don’t want to go down this path only to have to go back to the manual way in the near future or worse yet back myself into a corner.

Hey Andy, I have the same question - is VS Team Edition a popular tool? How many people are using it? Does it have many bugs? Do they fix them quickly?

Andy Leonard SSChampion Points: 10144 More actions · Answer 6

I haven't used Database Edition recently. I liked the earlier versions a lot, and liked the direction of the product. One thought when I started this series was to show how to do test-driven development manually, and then follow it up with ways to accomplish similar tasks using Database Edition. Obviously I haven't done that, at least not yet.

I've been disconnected from the Database Edition crowd for a bit, so I'm not sure how widely it's been adopted.

:{>

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Alexander Kuznetsov SSCrazy Points: 2217 More actions · Answer 7

Same here, Andy - I ended up unit testing almost everything, but with other tools.

awonke.fongoqa SSC Journeyman Points: 75 More actions · Answer 8

thanks i mastered it from part1 to 5 now where are the rest of the parts i want continue