Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)

To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of maintenance awaits it today :) to present on Database Mirroring on SQL Server 2008.

The meeting when well and I met some very interesting people at the Competitive Computing’s Mountain View offices in Burlington, VT. Roman Rehak helped out very much in the meeting, by not only hosting it for the PASS Vermont SQL Server User Group (thanks to MyWebGrocer.com for the Free Pizza and Drinks! btw), but asking all the right questions to enrich our understanding of this great SQL Server Feature.

Here are the updated presentation slides. I was able to setup a Synchronous Mirror, demonstrate a manual failover, and simulate high amounts of traffic with Data Generator (I’ll try SQLStress one day too, I hope).

I’m going to have to ensure I do a fresh install of Entreprise version before I can demonstrate an Automatic Failover with Witness since my version seems to have a registry problem. Both machines involved in the Partnership were SQL 2008 Entreprise…but one was a reinstall, so I am assuming the registry is still messed, and will sort that out this coming week with my first Windows 7 install on the XPS M1530.  Cannot wait for the second life of my SSD!

Roman’s great suggestion was that if we placed the Witness on a clustered server, then it would be a much optimised high-availability solution.
I will propose that for our future Mirroring Quorum setups.

Last years' talk at the Vermont User Group was given on Database Compression for those following this PASS Chapter..

 

Dot Net Usergroup in Montreal Presentation notes - Grouping Sets in SQL Server 2008

On March 11th, 2009, I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original SQL Server Central front-page blog post on the subject and Rushabh Mehta's inability to be in two places at once:) 

As promised to those of you who were at the meeting (and for anyone else of course), here are the presentation notes as well as example scripts.

Speaking is very motivating to a very receptive crowd (as it was that night), and there are two more talks I have lined up:

1) in April:  SQL Server Data Compression in Burlington, Vermont, thanks to Roman Rehak's invite. Date to be posted as soon as I find his e-mail with the schedule.

2) June Will be joining Mario Cardinal, Jean-Yves Roy, and Erik Renaud at Vancouver’s International Developer Conference - Discussion on why Developers should care about Transaction Log Files

Merci à tous qui ont prit le temps dans cette énorme crise économique de m’écouter. A bientôt.