Welcome to MSDN Blogs Sign in | Join | Help

July 2006 - Posts

Saturday, July 29, 2006 6:45 PM

Running database unit tests from the command-line

Since database unit tests are first-class test types in Team Test, you can take full advantage of the MSTest.exe command-line tool for running and automating the execution of your database unit tests. First you need to get yourself into a command prompt
Posted by SachinRe | 1 Comments
Saturday, July 29, 2006 8:08 AM

Link: Erich Gamma \ JUnit \ Unit Testing

Ed Burnette has a great post looking back on the successes of Erich Gamma. While I think of him most for his pivotal book on design patterns, he also made a large contribution with Kent Back on JUnit, one of the first real unit testing frameworks. The
Posted by SachinRe | 0 Comments
Saturday, July 29, 2006 7:43 AM

What is the Inconclusive Test Condition?

Several people have asked me about what the Inconclusive Test Condition is and why we add it by default to database unit tests. I thought I’d take a moment to address this here on the blog. If an Inconclusive Test Condition is added to a database unit
Posted by SachinRe | 0 Comments
Saturday, July 29, 2006 12:02 AM

Automatic Test Script Generation

One of the powerful features of Team Edition for Database Professionals is its ability to automatically generate a stub SQL test script for stored procedures, functions, and triggers. This feature allows you to right-click on an existing sproc, function,
Posted by SachinRe | 3 Comments
Friday, July 28, 2006 12:38 AM

Database Unit Testing and Debugging

With Team Edition for Database Professionals, you can create database unit tests and debug the objects under tests. This is an important technique that is very useful for investigating failed database unit tests. An important thing to remember here is
Posted by SachinRe | 1 Comments
Wednesday, July 26, 2006 9:26 PM

Article: Developer.com - Test Driven Development

Developer.com has a great article on Test Driven Development. This methodology is gaining momentum and is as important for database professionals to master as it is for application developers. http://www.developer.com/design/article.php/3622546 Take a
Posted by SachinRe | 1 Comments
Wednesday, July 26, 2006 7:16 PM

Trying out Team System

As you know, Team Edition for Database Professionals is part of the larger Visual Studio Team System. Much of the value of this toolset is only realized when you leverage the entire Team Suite. Some of the tighter integration you get when you use the
Posted by SachinRe | 0 Comments
Filed under:
Wednesday, July 26, 2006 4:55 AM

Checkin Policy for Database Unit Testing

Team Edition for Database Professionals, combined with Team Test and Team Foundation Server, provides a facility for allowing you to enforce a team-wide policy requiring that a set of tests are run and pass before every check-in. This is a practice that
Posted by SachinRe | 5 Comments
Wednesday, July 26, 2006 2:02 AM

Best Practice: Deploying Database Rename Refactorings

Team Edition for Database Professionals is targeted primarily at managing iterative changes for preproduction database development. The primary use case for deploying rename refactorings is to your local sandbox server. The cleanest way to setup this
Posted by SachinRe | 3 Comments
Sunday, July 23, 2006 12:16 AM

Link: Beck Testing Framework

For many database professionals, unit testing is a foreign concept. Many of you may have never heard of the xUnit family of test frameworks, including modern-day frameworks like NUnit and JUnit. I thought I would link you back to an early article by the
Posted by SachinRe | 1 Comments
Sunday, July 23, 2006 12:14 AM

Database Unit Testing: Managing Database State

One important consideration in database unit testing is managing the database state. This aspect of database unit testing makes it more difficult than its app-tier counterpart. However, it’s fundamental to what database unit testing is, as a database
Posted by SachinRe | 1 Comments
Friday, July 21, 2006 12:04 AM

Who is the database professional?

Another great question J There are several ways to answer that. In the broadest sense, the database professional is any professional who directly interacts with the database, ranging from the data architect, to the database developer, to the database
Posted by SachinRe | 0 Comments
Saturday, July 15, 2006 5:28 PM

Database Unit Test Verification

One of the most important aspects of database unit testing is verification. The application unit testing answer to verification is assertions. Most unit testing frameworks come with a collection of assertions that you can use to verify various conditions,
Posted by SachinRe | 6 Comments
Saturday, July 15, 2006 3:35 PM

Types of database unit tests

Since database unit testing is a fairly new concept, I thought I’d give you a sense for some types of unit tests you can write for your database. Feature Tests The first and likely most prevalent type of database unit test is a feature test. In my mind,
Posted by SachinRe | 5 Comments
Friday, July 14, 2006 11:30 PM

Creating your first database unit test

I wanted to show you how easy it is to create your first database unit test using Visual Studio Team Edition for Database Professionals. So we’ll walk through exactly how to create a unit test for the CustOrderHist stored procedure in the Northwind database.
Posted by SachinRe | 6 Comments
Saturday, July 08, 2006 2:40 AM

Team Data CTP4 Now Available!

The latest Community Technology Preview (CTP4) of Team Edition for Database Professionals is now available! You'll see introduced a brand new view of your database projects, as well as bug fixes throughout the product. And as always, keep the feedback
Posted by SachinRe | 0 Comments
Filed under:
Saturday, July 08, 2006 2:15 AM

A look back to an early article on Evolutionary Database Design

I wanted to take a moment to point people back to an early article that Martin Fowler & Pramod Sadalage put together describing the concept of evolutionary database design and some early thoughts on how to make this happen in 2003: http://martinfowler.com/articles/evodb.html
Posted by SachinRe | 0 Comments
Thursday, July 06, 2006 6:31 AM

Link: Walkthrough of test data generation

Cameron Skinner, Product Unit Manager (the guy who runs the product group), has a great post with a walkthrough of the test data generation tool. You can find it here: http://blogs.msdn.com/camerons/archive/2006/06/30/652407.aspx He shows you exactly
Posted by SachinRe | 0 Comments
Filed under:
Thursday, July 06, 2006 6:28 AM

A better approach to test data generation

Anytime you are doing any sort of serious database development, you’ll need realistic test data to verify your system. There are several commonly used approaches to test data generation: § Use production data for testing purposes . Typically you do this
Posted by SachinRe | 2 Comments
Filed under:
Saturday, July 01, 2006 8:10 PM

What's all the excitement about?

In case you have been living in your own little bubble and missed all the excitement around the new edition to Team System: Team Edition for Database Professionals, you should definitely check out Kimberly Tripp's overview of the buzz. She details a lot
Posted by SachinRe | 0 Comments
Saturday, July 01, 2006 7:22 PM

Book Recommendation: Refactoring Databases

I wanted to send kudos over to Scott W. Ambler and Pramodkumar J. Sadalage for recently publishing a great book on the very topic of refactoring databases. Refactoring Databases: Evolutionary Database Design http://www.amazon.com/gp/product/0321293533/104-1114081-9071168?v=glance&n=283155
Posted by SachinRe | 1 Comments
Saturday, July 01, 2006 6:54 PM

What is database refactoring?

Well, I’m glad you asked :) The best way to explain database refactoring is to offer two different perspectives, depending on the background you are coming from. I offer a view on database refactoring both from the perspective of a seasoned application
Posted by SachinRe | 9 Comments
Saturday, July 01, 2006 9:46 AM

What is database unit testing?

Unit Testing, while a well understood technique in the application development world, is not nearly as prevalent in the data community. Therefore, before jumping into how exactly you would utilize this technique and our toolset around it, you must understand
Posted by SachinRe | 4 Comments
Saturday, July 01, 2006 9:26 AM

Team Data Forums

A great way to learn more about the product, hear what other users have to say about it, and get your questions answered by the product team is by checking out the MSDN Forums dedicated to this product. You'll find that here: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=725&SiteID=1
Posted by SachinRe | 0 Comments
Saturday, July 01, 2006 9:22 AM

Meet the Team Data Bloggers

Beyond myself, there are quite a few other bloggers from the product team. I thought I would take this moment to quickly introduce each of these individuals and point you toward their blog: Cameron Skinner , Product Unit Manager Matt Nunn , Product Manager
Posted by SachinRe | 0 Comments
Saturday, July 01, 2006 8:53 AM

Welcome

I wanted to take a moment to introduce myself and tell you a little bit about what I hope to make of this blog. My name is Sachin Rekhi and I am a Program Manager on the Team Edition for Database Professionals. I've been working hard with the rest of
Posted by SachinRe | 0 Comments
 
Page view tracker