Sachin Rekhi's Ramblings

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

  • Sachin Rekhi's Ramblings

    Creating a custom test condition: ResultSet Column Count

    • 2 Comments
    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...
  • Sachin Rekhi's Ramblings

    Database Unit Testing Whitepaper Draft

    • 4 Comments
    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...
  • Sachin Rekhi's Ramblings

    A better approach to test data generation

    • 4 Comments
    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...
  • Sachin Rekhi's Ramblings

    What is the Inconclusive Test Condition?

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Creating your first database unit test

    • 6 Comments
    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...
  • Sachin Rekhi's Ramblings

    What is database unit testing?

    • 5 Comments
    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...
  • Sachin Rekhi's Ramblings

    Creating a custom data generator: PersonGenerator

    • 2 Comments
    One of the most exciting extensibility points in Team Edition for Database Professionals is the ability to create your own custom data generator. Team Data will ship with a comprehensive set of data generators to generate data for almost all data types...
  • Sachin Rekhi's Ramblings

    Database Unit Test Verification

    • 7 Comments
    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...
  • Sachin Rekhi's Ramblings

    What is database refactoring?

    • 9 Comments
    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...
  • Sachin Rekhi's Ramblings

    Types of database unit tests

    • 5 Comments
    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....
  • Sachin Rekhi's Ramblings

    Automatic Test Script Generation

    • 3 Comments
    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,...
  • Sachin Rekhi's Ramblings

    Adding transaction support to database unit tests

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Database Unit Testing Whitepaper Published

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Extensibility in Team Edition for Database Professionals

    • 5 Comments
    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...
  • Sachin Rekhi's Ramblings

    Common Regular Expressions

    • 0 Comments
    Gert Drapers has a great post on taking full advantage of the regular expression generator. He shows you some very useful regular expressions that you’ll want to take advantage of in creating meaningful test data using the data generation feature in Team...
  • Sachin Rekhi's Ramblings

    Best Practice: Deploying Database Rename Refactorings

    • 3 Comments
    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...
  • Sachin Rekhi's Ramblings

    Database Unit Testing: Managing Database State

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Programmatic deployment sample

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Under the hood of database unit testing

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Disabling triggers to support data generation

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Database Unit Testing and Debugging

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    Running database unit tests from the command-line

    • 1 Comments
    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...
  • Sachin Rekhi's Ramblings

    DevConnections Presentation: Database Unit Testing

    • 0 Comments
    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...
  • Sachin Rekhi's Ramblings

    Team Data Ship Date: November 30, 2006

    • 2 Comments
    We officially announced this week at the SQL Pass conference our RTM date for Team Edition for Database Professionals: November 30 th this year! Our customers have been clamoring for this release and we are incredibly amazed with what we have built...
  • Sachin Rekhi's Ramblings

    The Many Ways to Execute Database Unit Tests

    • 0 Comments
    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...
Page 1 of 3 (71 items) 123