add-memberalign-toparrow-leftarrow-rightbellblockcalendarcamerachatchevron-leftchevron-rightchevron-small-downchevron-upcircle-with-crosscomposecrossfacebookflagfolderglobegoogleimagesinstagramkeylocation-pinmedalmoremuplabelShape 3 + Rectangle 1pagepersonpluspollsImported LayersImported LayersImported LayersshieldstartwitterwinbackClosewinbackCompletewinbackDiscountyahoo

Implementing SQL Server Continuous Integration using Jenkins & Red Gate

  • Apr 10, 2013 · 6:30 PM
  • Microsoft Office

Hey .Net Developers,

The SQL Server User Group has invited us to join them this Wednesday. Here are the details:

Speaker: Ernest Hwang of Practice Fusion

At this meeting, you'll learn how to simplify your database deployments, ensure that no database changes are overlooked, and implement unit tests using the suite of Red Gate developer tools.

You'll see how Practice Fusion streamlines database deployments in their Integration, Testing, Staging, and Production environments.  This frees developers from the burden of maintaining deployment scripts, while reducing the number of overlooked breaking changes to zero.

The demo will use a Windows Azure box as the Jenkins (Continuous Integration) server and several SQL Azure databases (representing Integration and QA environments). The entire repository will be hosted on GitHub for anyone to download. 

During the raffle, you might win a free license of Red Gate's SQL Source Control (valued at $395).

You'll learn how to:

  • Add your database to source control in under five minutes
  • Create a CI Job to validate your database “build”
  • Deploy database changes to your environments with a mouse click
  • Set up database unit testing using tSQLt
  • Avoid problems when implementing Database CI in the “real-world”

Ernest Hwang is a Principal Software Engineer at Practice Fusion in San Francisco and has been working with SQL Server since 1999 and .NET since 2001.  For the past two years, Ernest has been using Red Gate SQL Source Control, SQL Compare, SQL Data Compare, and SQL Test to automate Practice Fusion's Continuous Integration efforts and instrument database deployments.

Practice Fusion is the fastest growing Electronic Health Record community. Over 150,000 physicians and practice managers in 50 states currently use Practice Fusion’s Electronic Health Record.

Join or login to comment.

  • Ernest

    For those of you who attended, everything (including the PowerPoint presentation and a backup of the database) can be downloaded from GitHub at

    April 11, 2013

  • fuad

    Hi All! I am with SQA Solution, we are QA Testing Company in San Francisco. We can help you staff QA position, or you can outsource testing to us. Our model offers onshore QA resources at offshore rates. Stop By and Talk To Me About Testing. and visit us at

    Fuad Mak
    CTO SQA Solution [masked]

    April 9, 2013

12 went

Our Sponsors

  • AppDynamics

    AppDynamics supports us by keeping our meetings free for all.

  • JetBrains

    Win a license for ReSharper, dotTrace, or dotCover each meeting!


    LVS Supports our group with one free annual license per month.

  • Typemock

    Typemock Supports our group with one free Isolator license per month.

  • Telerik

    Telerik supports our group with one free component license per month.

  • TEK Systems

    People you can trust, results you can count on

  • Dynamics Edge

    Dynamics Edge is a valued sponsor of the San Francisco .NET User Group.

  • Silicon Valley Code Camp

    The biggest & best peer-run software conference on the planet.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy