380PASS – Another Successful Meeting!

Our 2nd 380PASS meeting was another success, by all accounts. We had 31 attendees! This is twice what registered and remains on par with our first meeting. The meeting was held in one of the very nice, state-of-the-art conference rooms at the University of Iowa. We began the meeting with a new feature, quick and easy SQL tips. I gave the first tip, which was how SSMS 2008 will display missing indexes. Afterwards, Zakir Durumeric from the Research Information Systems (RIS) team at the University spoke on database mirroring. Zakir gave an excellent overview of high availability options, the pros and cons of various methods, and some of the obstacles and solutions he’s faced in his environment. The materials for last night’s meeting will be uploaded to http://380pass.org later today.

Following Zakir’s presentation, Russ Allen shared some powerful and time-saving tips on how to use Central Management Servers to manage multi-server environments. The meeting ended with an interesting and informative discussion on Red Gate’s software. The conversation primarily revolved around SQL Compare, SQL Data Compare, and SQL Prompt, and the positive impact those applications have had on our lives.

We’re pleased to announce SQL Server MVP Hilary Cotter as the guest speaker for our May meeting. Hilary will be presenting remotely on performance tuning topics. More details to follow as we finalize them.

Thank you for all who attended and have helped make our new chapter such a success!

380PASS – Meeting Tomorrow Night!

Hi, everyone! Just a reminder that tomorrow night will be our 2nd meeting of the 380PASS chapter. Zakir Durumeric from the University of Iowa will be presenting on Database Mirroring topics. We had 31 members at our first meeting, and we’re hoping to keep the momentum going. This 2nd meeting will be held at the University of Iowa in Iowa City. Due to scheduling conflicts, this meeting will start at 6:00pm, with the presentation starting at 6:30pm. This is a one-time schedule change; future meetings will resume at 5:30pm. Additional details and directions can be found on our website at http://380pass.org.

If you haven’t already, please register for the event on our website at http://380pass.org. This will help ensure I order enough pizza. :)

To register for an event, you’ll first need to log into the site. If you’ve never logged in before, you’ll need to register for the site as well. Registration is free, quick, and fairly painless. Send me an e-mail at michelle @ sqlfool dot com if you’re having any trouble.

I hope to see you there!

PASS Summit – My Abstract, Deadline Extended!

PASS has extended the deadline for abstract submissions to Friday, 24 April at midnight.
If you’re even thinking about submitting an abstract, just do it.

In related news, yesterday I received the green light from GD legal to submit my abstract. This is my first-ever abstract for PASS, and I’m pretty excited about the topic. After some technical difficulties that resulted in SQL statements being displayed in the error message on-screen (tsk tsk), I finally submitted and received my confirmation number. Here’s an overview, just in case you plan to speak on the same topic…

Super Bowl, Super Load – A Look at Performance Tuning for VLDB’s

Few DBA’s have the opportunity to experience a real-life load test in their production environment. Michelle Ufford works for GoDaddy.com, a company that has experienced phenomenal success with its Super Bowl ads. These ads are designed to drive traffic to the company’s websites, which puts the database servers under high load. In her presentation, Michelle will explore the performance tuning techniques that have resulted in an 80% reduction in server response times and allowed her VLDB’s to reach rates of 27k transactions per second. Topics will include vertical and horizontal partitioning, bulk operations, table design, and indexing.

Source: http://sqlfool.com/2009/04/pass-summit-my-abstract-deadline-extended

380PASS Meeting – Tuesday, 14 April

We’re busy getting ready for our next PASS meeting, which is next Tuesday, 14 April. This meeting will be held at the University of Iowa in Iowa City. Zakir Durumeric will be speaking on database mirroring in SQL Server. More details, including directions and maps, can be found on our website at http://380pass.org.

Thanks to our Membership Officer, Ed Leighton-Dick, we now have a new Event Registration module! Please make sure to register for the event so we know how much food to order. But feel free to come even if you decide at the last minute and cannot register ahead of time.

Iowa Code Camp – Call for Speakers

This is a little late, but I want to mention that the Iowa Code Camp has put out a call for speakers. I’ve spoken with Greg, and he told me they’re still looking for 2 or 3 more SQL-related sessions. If you have a topic you’d like to speak on, please send him an e-mail!

I’ll also be speaking at this year’s Code Camp on May 2nd. Here’s a brief overview of my planned topic:

SQL Server for the .NET Developer
Most .NET developers will inevitably work with SQL Server in some form or another. Many will even be asked to create tables and stored procedures to support their applications. This session will focus on what every .NET developer should understand about SQL Server. We’ll cover the basics, such as good table design and efficient queries, and we’ll touch on some indexing concepts, too. Then we’ll wrap up with some strategies for developing high volume SQL Server applications.

Lately I’ve been trying to work on my speaking skills. So if you’re within a 4-5 hour radius of east Iowa (Chicago, Milwaukee, Minneapolis, etc.) and would like me to come speak at your next SQL event, please send me an e-mail at michelle @ sqlfool dot com. :)

380PASS Meeting – Success!

Our first meeting was a success by all accounts! We had a great turnout with 30 people showing up.

As an ice breaker activity, we had folks pair up and try to identify something related to SQL Server, i.e. commands or terms, for every letter of the alphabet. There was a 5 minute time limit, and with only 20 seconds to spare, Randy Vandergaast and Dave Brosseau turned their sheet in to each win a $25 gift card to Barnes & Noble.

Chris Leonard gave the group a great overview of PASS and the PASS Summit in Seattle.

Brian Duhn then gave a comprehensive overview of how to set up Server-to-Server Service Broker. The entire slide show can be found at http://380pass.org, under Resources.

Thanks to our awesome sponsors, we had some great prizes to give away, and everyone walked away with something.

Thanks to everyone who attended for helping us have a great launch meeting! :)

Michelle