Sachin Rekhi's Ramblings

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

  • Sachin Rekhi's Ramblings

    Article: Developer.com - Test Driven Development

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

    Trying out Team System

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

    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

    Link: Beck Testing Framework

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

    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

    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

    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

    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

    Team Data CTP4 Now Available!

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

    A look back to an early article on Evolutionary Database Design

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

    Link: Walkthrough of test data generation

    • 0 Comments
    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...
  • 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's all the excitement about?

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

    Book Recommendation: Refactoring Databases

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

    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

    Team Data Forums

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

    Meet the Team Data Bloggers

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

    Welcome

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