Sachin Rekhi's Ramblings

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

  • 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

    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

    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

    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

    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

    Checkin Policy for Database Unit Testing

    • 5 Comments
    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...
  • 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

    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

    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

    Team Edition for DB Pros 5 Min Demo

    • 3 Comments
    While preparing for my keynote demo for Tech Ed Malaysia, I produced a couple of short sample videos of quick demos of Team Edition for Database Professionals. One of these videos is a short 5 minute segment giving you a whirlwind tour of the functionality...
  • 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

    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

    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

    Who is the database professional?

    • 2 Comments
    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...
  • 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

    Product Documentation is now Live!

    • 2 Comments
    Just wanted to take a moment to direct folks to documentation for Team Edition for Database Professionals, which is now live on MSDN! You can find the root of the content here . You can find a detailed reference to our Public APIs here . ...
  • Sachin Rekhi's Ramblings

    Team Data CTP7 is now Live!

    • 2 Comments
    Team Data CTP7 is now Live! Download it here . Check out Cameron’s blog post to find out exactly what is new in CTP7. Sachin Rekhi
  • 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

    Process Guidance Incorporating DB Pro Available!

    • 2 Comments
    The other major announcement we made this week was that the MSF Process Guidance Templates have been updated to incorporate the new database professional roles and this updated guidance is available today! We have made updates to both the MSF Agile...
  • 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

    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

    New DB Pro Case Study

    • 1 Comments
    Check out this great case study that was recently published showing exactly how Team Edition for Database Professionals has significantly helped Gulf Coast Seal. I love seeing these success stories popping up for DB Pro, especially so quickly after RTM...
  • Sachin Rekhi's Ramblings

    Change in Test Conditions \ Generators Extension File in CTP7

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

    Change in Database Unit Testing RAISERROR Behavior in CTP 7

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