Wednesday, July 1, 2009

The Best Thing I Learned At PASS

Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win it's worth a free registration or hotel stay for the 2009 Summit, and I like free!

Let me start by making a small confession: I've never actually been to the PASS summit in person. So how in the world can I write about what I've learned? Because I've been there vicariously through the blogs and Twitter streams of people who were there last year. Thank goodness, because before the rise of blogging\social networking if you had asked me what happens at the PASS summit I would have said…I honestly don’t know what happens at PASS besides a bunch of technical presentations given by people who write books and magazine articles for a living. My ignorance about what PASS is became clear to me last November as I read about the daily keynotes, the community sessions, and the nighttime parties. I came to realize that PASS is about so much more than just sitting in technical presentations. It’s about learning from people just like you who are doing the same things as you do every day. It’s about uniting with your peers and meeting new people who share a common interest. It’s about escaping the daily workload to reenergize and reinvigorate the passion to do our jobs as best as we possibly can when we return. So even though I haven’t been to PASS in person, I’ve learned one important thing: For the sake of my career, I need to go to PASS. If I can figure that out without actually having been to PASS, just imagine what I’ll learn when I do go this year.

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

 

2009PASS_Signature02

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!

Wednesday, May 20, 2009

Inside A Datacenter

I spent the last 4 days in Denver helping my company move in a new datacenter and while I was there it occurred to me that a lot of people have probably never seen the inside of a datacenter. I've been in 8 (that I can recall), and while that might not seem like a lot to seasoned hardware folks that's enough to get a feel for what makes these places tick (and understand the difference between a good facility and a great one).

Whenever I visit a facility I take a few minutes to walk through the aisles of racks and look at what hardware other people are running. I bet people probably think that datacenters are full of high end servers and SANs, but I've found that it's exactly the opposite. At the 3 facilities I visited on this trip I saw only a handful of SANs, maybe 1 per 20-30 racks. On the other hand, 9 out of 10 racks had at least one 1U server, 3 out of 4 racks had at least one 2U server, and 1 out of every 3 racks had at least one DASD drive enclosure. Regular readers of my blog may recall that I've done a lot of testing on drive performance for this kind of equipment. There are thousands of these servers in a medium sized datacenter and given the number of people I've talked to who haven't heard about disk alignment I'm guessing that adds up to a lot of wasted performance.

I also like to look at how people install their hardware in racks. Some installations are messy – cables strung about like spaghetti, no thought given to heat dissipation, etc.. A few make you stop and look twice because they're so pristine. On average I'd say that most installs are OK – not bad and done well enough to keep things running cool. There's definitely an art to installing servers in a rack.

If you end up spending any more than an hour working in a datacenter there are a few things to keep in mind. First, datacenters are climate controlled; they are cool and dry inside. Make sure you bring ChapStick to keep your lips from getting chapped and lotion to keep your hands from getting too dry. You should make sure to stay hydrated; you can't bring liquids into the facility so you'll want to remember to take frequent breaks to walk outside and get a drink of water. As I said, there are thousands of servers in a datacenter. It's loud. Wearing earplugs or headphones won't hurt. Walk outside if you need to hold extended conversations (especially on the phone – the person on the other end will appreciate it!).  You don't feel it while you're working inside, but the conditions can get to you. Between the dry air, lack of water, and near-shouting to talk to my coworker who was with me I just about lost my voice after day 2.

If you're interested in seeing a datacenter in person you can talk to your hardware\network admins and ask them to give you a tour; If you have even a mild interest in computers you'll probably enjoy the experience. You can always take a virtual tour too - the video below is from FORTRUST, one many facilities in Denver, and will give you a good idea of what's involved in running a datacenter. There are a lot more videos on YouTube of other facilities – just search for "Data Center Tour" (or save yourself the effort and just click here).

Tuesday, May 12, 2009

SQL Saturday Jacksonville Recap

sqlsat15 Note: I intended to post this last week but life\work\burnout and installing Windows 7 RC got in the way.

Another weekend, another SQL Saturday – this time in Jacksonville, put on by JSSUG, at the University of North Florida campus. This particular SQLSaturday was scaled back from the norm (by design) – one sponsor, no attendee SWAG bags, hand written name tags, etc.. While SWAG is nice, the lack thereof didn't seem to bother people; can you really complain about free breakfast, lunch, and a day of SQL training?

Even though I was scheduled to give 4 presentations – more than enough to keep me busy - I came into the day with the goal of meeting new people. Brian Knight's crew had the same idea and began the day by challenging each attendee to meet 3 new people. I asked in one of my afternoon sessions if everyone had met their 3 people and almost all hands went up; when I asked if they had gotten contact information (e.g. business cards) very few hands stayed raised. I'm not too surprised since people spend most of their day going back and forth between sessions which leaves little time to strike up meaningful conversations. On the other hand, the after-party was a great chance to relax and talk in a more casual atmosphere. I ended up talking (and exchanging business cards) with several people I met earlier, so I'll call success on my goal for the day.

The only hiccup for me on the day was that I had to bail on one of my presentations (IIS security) because my demos weren't working. I ended up giving a 15 minute verbal summary and then gave my presentation on useful T-SQL statements. Otherwise I really enjoyed the opportunity to present, catch up with old friends, and meet some new ones. All in all it was another great SQL Saturday!

Slide decks and demos for my presentations are below:

Download: Disk Performance and Configuration How & Why.pptx
Download: Useful T-SQL statements you may not be aware of.zip
Download: Transactional Replication Deep Dive.pptx
Download: XML Features in SQL2005 - SQLSat 4.zip