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.