Search results matching tags 'Performance' and 'New England'

Where Can You Find Me the Rest of This Year?

Adam Machanic — Mon, 22 Aug 2011 00:28:00 GMT

Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year:

September 8, 17:00 GMT (online) - 24 Hours of PASS webcast: "Baseline Basics or: Who Broke the Database?"

In this session, excerpted from my PASS Summit precon, I'll explain the whys and hows of using baselines to assist with performance tuning. If you find yourself more often than not tuning reactively rather than proactively, this session is for you. This is a free webcast, so why not join in?

September 8, 18:30 EDT (Waltham, MA) - New England SQL Server Users Group: "Windowing Functions in SQL Server 2008, Denali, and Beyond"

Two in one day! This session will kick off the 2011/2012 New England SQL Server season, and will cover what are (in my ever-so-humble opinion) the most important T-SQL enhancements in the past three versions of SQL Server: windowing function enhancements. I'll discuss what's there in today's shipping versions, and the new and incredibly powerful functionality that Denali brings to the table. If you're in the Boston area, don't miss it!

September 17 (Atlanta, GA) - SQL Saturday #89: (Two Talks)

After the great time I had at this year's TechEd show in Atlanta I could hardly wait to get back. Luckily, the fantastic SQL Server community in the Atlanta area scheduled this event, which gave me the perfect excuse to pack my bags for a return trip. The speaker lineup for this event is rock-solid, and I'll be contributing with two talks: my introductory dive into SQL Server parallelism, and an overview of my 15 favorite activity monitoring dynamic management objects. This should be a great event by anyone's standards, and it's free, so if you live nearby you have literally no excuse not to attend.

October 11, 08:30 PDT (Seattle, WA) - PASS Community Summit Pre-Conference Seminar: No More Guessing! An Enlightened Approach to Performance Troubleshooting

No more guessing! It's not just a catchphrase; it's a way of life. When faced with performance problems we have a choice: we can either run around panicking, wasting everyone's time (including our own), or we can use the huge amount of information at our disposal to figure out what's actually wrong and fix it. As the calm and collected type, I prefer the second option, and so should you. If you'll be attending the PASS conference, join me on Tuesday to learn how you, too, can quickly and accurately pinpoint the root cause of your performance issues.

October 12-14 (Seattle, WA) - PASS Community Summit Spotlight Session: Query Tuning Mastery: Zen and the Art of Workspace Memory

Your query is running, and it needs to sort some data. Or to hash some data. Or to perform a parallel operation. These things take memory, and as any SQL Server professional knows, in the world of SQL Server memory is worth much, much more than its weight in gold (even given today's hugely-inflated prices). Attend this session to learn the ins and outs of workspace memory: what it is, why it's needed, where the memory comes from, and most importantly, how to control it to make certain queries faster and other queries not have to wait as long. Workspace memory tuning is a mostly untapped performance opportunity that many DBAs can heavily benefit from learning how to leverage.

November 1-3 (Las Vegas, NV) - SQL Server Connections: (Three Talks)

My final speaking engagement of the year will be at the always-fun SQL Server Connections show in Vegas. (It's in Vegas! How could it not be fun?!) I'll be doing three talks during the course of the show: An introductory talk on my favorite topic the past couple of years, parallelism in SQL Server; a much more advanced parallelism talk to build on that one; and a talk on the various dynamic management objects that can be used in the quest for ultimate SQL Server performance. Save a spot for me at the poker table!

I'm really looking forward to these events. If you're going to be there let me know in the comments, and/or feel free to find me at any of the shows and say hi. (Buying me a drink or two wouldn't hurt either.) See you there!

World Class Training For Them, an Amazon Gift Certificate For You

Adam Machanic — Mon, 15 Mar 2010 15:40:00 GMT

We have just two weeks to go before Paul Randal and Kimberly Tripp touch down in the Boston area to deliver their famous SQL Server Immersions course. This is going to be a truly fantastic SQL Server learning experience and we're hoping a few more people will join in the fun.

This is where you come in: we have a few vacant seats remaining and we need your help spreading the word. Simply tell your friends and colleagues about the course and e-mail me (adam [at] bostonsqltraining [dot] com) the names of the people you believe will register, or have them e-mail me your name and contact information when they register. For every person who buys a full-price registration between now and March 28 as a result of your help, I'll send you a $300 Amazon gift card.

Note: To keep things fair, if I receive the same name from two people the gift card will go to the first person who sent the name.

For more information on the course and to register, visit the Boston SQL Training Web site.

Paul Randal and Kimberly Tripp - Boston Area - March 29-April 2

Adam Machanic — Tue, 26 Jan 2010 20:09:00 GMT

If you've been looking for advanced training in the northeast, your wait is over. Paul and Kimberly will be gracing us with one of their famous "SQL Server Immersion" events the week of March 29.

This course will cover storage engine internals, indexing and performance strategies, and of course in-depth sections on database maintenance from the guy who wrote DBCC. You can't go wrong there. A complete outline is available on the course web site.

If you've never visited the Boston area, the spring is a great time to do it--we usually have great weather right in between the winter freeze and the overly-humid summer. The course location is Cambridge, MA, right near MIT: a really cool area with lots to see and do, easy access to downtown Boston via public transportation, and the weather should be perfect for some brisk evening walks around the Charles river after days of having your head pumped with SQL knowledge.

If you register soon you can take advantage of the "early bird" special, $600 off the $3100 course fee. Use registration code "EARLYBIRD" to take advantage.

Hope to see many of you there!

[New England] NESQL October 9: SQL Server 2008 Performance Studio

Adam Machanic — Wed, 08 Oct 2008 15:43:00 GMT

Just a quick note to remind people in the greater Boston area that tomorrow night, Thursday October 9, Jeremy Gaige from Idera Software will be doing a presentation on SQL Server 2008 Performance Studio at the New England SQL Server Users Group. This should be a really interesting session on a fantastic new SQL Server 2008 feature. Hope to see you there!

Note: if you are planning to attend, please RSVP by sending an e-mail to nesql [at] hotmail [dot] com. Only people who RSVP will be able to win giveaways at the end of the night.