Sachin Rekhi's Ramblings

On Mastering DB Development with Visual Studio Team Edition for Database Professionals

Browse by Tags

Tagged Content List
  • Blog Post: Database Unit Testing Whitepaper Published

    I wanted to let you all know that I just published my detailed whitepaper on database unit testing. Summary: Microsoft Visual Studio 2005 Team Edition for Database Professionals is the first toolset to deliver a comprehensive framework for performing database unit tests. This product brings to...
  • Blog Post: Programmatic deployment sample

    Jamie Laflen, Tech Lead for database unit testing, has put together another great sample showing you how to programmatically deploy your database project using the database unit testing framework. The scenario here is that you can control the deployment of the database project to happen whenever...
  • Blog Post: Disabling triggers to support data generation

    Jamie Laflen, Tech Lead for database unit testing, has developed a code sample to show you how to automatically disable triggers to support data generation. The scenario is that you have delete or insert triggers defined on your database that inhibit proper test data generation. So this sample...
  • Blog Post: Database Unit Testing Whitepaper Draft

    So I’ve spent the last week authoring a detailed whitepaper on Team Edition for Database Professional’s database unit testing framework. I thought I would post the draft online here prior to publishing it to MSDN. Summary: Team Edition for Database Professionals is the first toolset to deliver...
  • Blog Post: Change in Database Unit Testing RAISERROR Behavior in CTP 7

    We have changed the behavior of the usage of the RAISERROR command in database unit tests. Prior to CTP7, a RAISERROR statement of any severity greater than 0 would cause the database unit test to fail. We have changed this behavior based on feedback such that the database unit test will only fail if...
  • Blog Post: Change in Test Conditions \ Generators Extension File in CTP7

    I wanted to make sure everyone was aware of a change that we have made in the extensions file for both custom Test Conditions & Generators in CTP7. We now perform xsd validation over the xml file and thus require the extensions xml to appropriately map to the required xsd. This thus requires...
  • Blog Post: DevConnections Presentation: Database Unit Testing

    I wanted to make available the other presentation that I gave at Dev Connections in Las Vegas , Nevada this week as well. You can find the title, synopsis, and powerpoint deck below. SDB310: Database Unit Testing with Team Edition for Database Professionals Come learn how to best leverage Team...
  • Blog Post: DevConnections Presentation: The Database Development Process

    This week I attended the Dev Connections series of conferences in Las Vegas , Nevada . I had a great time giving several presentations on Team Edition for Database Professionals, as well as interacting with many excited customers about their experiences thus far with the product. I thought I would...
  • Blog Post: Test Case Management

    If you have both Team Data and Test Test (or simply Team Suite), you’ll be able to take advantage of the Test Manager Tool Window and test lists. This provides more sophisticated test case management capabilities. The most useful aspect of this is the ability to create test lists. You can easily...
  • Blog Post: The Many Ways to Execute Database Unit Tests

    I wanted to make sure you were all aware of the various methods of executing database unit tests. I’ve talked with some users who were pleasantly surprised to learn of several of the other options, so I thought I’d throw it up on my blog for everyone’s delight. These should help for those trying to quickly...
  • Blog Post: Video on adding transaction support to db unit tests

    Learn how to add transaction support to your database unit tests in Team Edition for Database Professionals in order to better manage the database state during your test run. http://channel9.msdn.com/ShowPost.aspx?PostID=244523 Sachin Rekhi
  • Blog Post: Adding transaction support to database unit tests

    I wanted to describe how to add transaction support to your database unit tests. In this previous post I motivate why you would want to do this. It’s all about managing the database state prior to and during your test run. For managing the database state at the beginning of a database unit test run,...
  • Blog Post: Video on Creating a Custom Test Condition

    I just put together a 15 minute video on just how you go about creating a custom test condition. So check it out! You’ll see how quickly you can code, deploy, and use a custom test condition to extend the database unit testing functionality in Team Edition for Database Professionals. You can find...
  • Blog Post: Extensibility in Team Edition for Database Professionals

    I just gave a presentation at the annual Visual Studio Partner Summit on extensibility points in Team Edition for Database Professionals. So I thought it would be a great opportunity to share this on my blog as well. When I think of the extensibility points, I typically group them in three categories...
  • Blog Post: Creating a custom test condition: ResultSet Column Count

    I wanted to walk you through just how you can go about creating your own custom test condition. This test condition will be added to the existing suite of in the box conditions and can be leveraged just like all of the other conditions inside the database unit testing designer. Let me first motivate...
  • Blog Post: MSDN Webcast: Gert and Sachin on Database Testing and Refactoring

    Gert Drapers, Development Manager, and I did a MSDN webcast yesterday on Database Testing & Refactoring using Team Edition for Database Professionals. This is the third part of a four-part series on Team Edition for Database Professionals. I would encourage you to check it out! You can see me walking...
  • Blog Post: 2 connection strings in database unit testing

    If you’ve had a chance to play with database unit testing in Team Edition for Database Professionals, you have probably noticed in the below Database Test Configuration dialog that we allow you to specify up to 2 separate connection strings for use in running your database unit tests. The...
  • Blog Post: Under the hood of database unit testing

    In previous posts I have showed you how to create various kinds of database unit tests using Team Edition for Database Professionals. In this post I wanted to take you a little deeper and show you exactly how it works. With this knowledge, you’ll be able to customize your tests even further for complete...
  • Blog Post: Public Test Condition Extensibility

    I’m very excited to announce that Team Edition for Database Professionals will support public test condition extensibility! This means that you can easily create your own UI-based client-side test conditions. This provides great flexibility in extending the library of test conditions that we provide...
  • Blog Post: 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 with MSTest.exe in your path. The easiest...
  • Blog Post: 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 post describes the revolution that took place, bringing...
  • Blog Post: 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 test, the test will always fail with an Inconclusive...
  • Blog Post: 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, or trigger in your database project in Solution...
  • Blog Post: 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 that debugging the objects under test is enabled...
  • Blog Post: 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 look! Are you doing TDD with your database...
Page 1 of 2 (32 items) 12