Monday, June 15, 2009

See You In Seattle For PASS 2009!

Last Friday I got the official notice that I've been selected to present a community session at the 2009 PASS summit in Seattle. I've also had 2 other abstracts selected as alternates. Ecstatic doesn't even begin to describe how I feel right now. I've never been to the summit before and now not only do I get to go but I get the chance to talk on a national stage about something I love doing. Very, very cool!

Here's what my session is about:

Transactional Replication: Beyond The Basics
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

Session Goals:

  • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, & agent profiles. Learn how to configure advanced options such as vertical and horizontal filtering
  • Demonstrate how to monitor transactional replication performance
  • Learn advanced troubleshooting techniques to apply when problems occur



Tuesday, June 9, 2009

Speaking At Space Coast SQL Users Group On June 11

SCSUGLogo Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June 11, 2009. I'll be presenting Useful T-SQL Statements You May Not Be Aware Of and I'll cover identity functions, OUTPUT, PIVOT\UNPIVOT, MERGE, and statements like OVER, ROW_NUMBER, etc. The meeting starts at 6:30 PM and is held in the Odyssey Conference room of Space Coast Credit Union headquarters at 8045 N. Wickham RD, Melbourne, FL 32940. Refreshments and snacks are provided some come out for an night of free SQL education and networking!