Database Mirroring Presentation

Posted: January 20, 2011 in Events, SQLServerPedia Syndication

 

Our local SQL Server users group has been working on how to reach out to people of all skill levels for the last year or so. Why? Our survey showed that we had many people attending that did not have advanced knowledge of SQL Server. What we did to see if we can assist in that area is to start a 100 level session. The 100 level sessions are intended to cover the basic information or give the user enough information to determine if it is a topic they would like to research more. Most 100 level topics we present last 20 to 30 minutes.

Last night I had the opportunity to present to the local group about database mirroring. There were a number of great questions that I may blog about in upcoming weeks, questions about connections, cluster vs. mirroring and mirroring in general.

One question in particular is how can an application take full use of Database Mirroring. I should define full use as being the ability to see a failover occur and to continue on with the application processing with minimal impact to the application. There may be other ways to accomplish this however I recommend that in your connection strings to the database that you use the failover partner option. I promised I would post a sample connection string.

 

connectionString=”Data Source=<DB001>; Failover Partner=<DB002>; Initial Catalog=ChrisTest;Persist Security Info=True;User ID=YourAccoung;Password=YourPassword”providerName=”System.Data.SqlClient”

If you would like to see the presentation on Database Mirroring you can find it on my presentations page.

On a side note, yesterday I was notified that one of the sessions I delivered at PASS in Seattle last November was selected in the Top 5 at PASS sessions for the Professional Development track. If you would like to see the other sessions that were selected you can find that information here. I really consider it a great honor to even be on the same list of speakers that present at PASS, but to make the Top 5 list is beyond what I could hope for.

If you attended the session, Thank You.

Comments
  1. First off, congratulations on being in the “top 5” session category at PASS. That’s quite a feather in the cap.

    This is good information about DB Mirroring… One thing that bears mentioning is the importance of configuring the endpoint correctly. Meaning, configuring it intentionally. In my opinion, it’s not an intuitive process and the outcome of different configurations (i.e. encryption, authentication type, etc…) can have dramatic outcomes in performance.

    Also, SQL Server 2008 offers “built-in” log-stream compression which has proven to be very valuable for those in the “high-safety” / synchronous mode.

    I’m sure the presentation was great and I’m sorry that I missed it.

  2. Chris Shaw says:

    Thanks Jeremy,

    Looking at adding a bunch to the presentation.

    Chris

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s