Search results matching tags 'sql saturday' 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!

[New England] SQL Saturday 71 - April 2 - Boston Area

Adam Machanic — Tue, 22 Feb 2011 20:08:00 GMT

April in the Boston area means many things. The Boston Marathon, the beginning of baseball season, and -- hopefully -- a bit of a respite from the ridiculously cold and snowy winter we've been having.

This April will mean one more thing: A full-day, free SQL Server event featuring 30 top-notch sessions.

SQL Saturday 71 will be the third full-day event in the area in as many years, and is shaping up to be the best yet. For the past several months I've been working and planning in conjunction with Mike Walsh, Grant Fritchey, and Tom LaRock. We've upgraded the venue, upgraded the food, managed to get speakers from all over the country, have a great roster of vendors for you to talk to at the event. And that is not the end. We're pushing to create even more perks to make this a truly memorable day.

So if you're in the area, or even nearby, and want to attend a top-quality training event at zero cost to you, register today.

Please note: This event is being created at zero cost to you, but that doesn't mean that it's being created at zero cost. The opposite is true; our upgraded venue is not cheap. Our budget is fairly tight and so we will be closely monitoring registrations and will end up with a waiting list. If you are not able to attend, it is your responsibility to make sure to cancel your registration as soon as possible! This will allow someone else to join us, and will keep us from squandering the funds that we've worked so hard to collect.

Looking forward to seeing you there!

New England Data Camp v2.0 (SQL Saturday #34): The Almost-Final Schedule

Adam Machanic — Thu, 07 Jan 2010 17:25:00 GMT

The January 30 event is now starting to shape up quite nicely! Below you will find the current schedule of sessions for the day. We still have some room, so if you haven't registered already, now is the time to do so. Please make sure to register online if you're going to attend so that we can get a fairly accurate headcount for food, bags, etc.

Start Time	Business Intelligence	Data Development	Database Administration	Performance Tuning
08:15 AM	Slava Kokaev Introduction to SSIS - Developing SSIS Packages	Scott Abrants Automating Database Deployments with Visual Studio	Mike Walsh As a DBA, Where Do I start?	Bala Subra SQL Server Performance Tuning Tips
9:30 AM	Ayad Shammout Introducing PowerPivot (BI Self-Service) for Excel	Charles Hyman USING VSTS Database Edition and 2010 Preview	Aaron Bertrand Management Studio Tips & Tricks	Grant Fritchey Best Practices for Working With Execution Plans
11:00 AM	Bala Subra SQL Server Reporting Services	Matt Van Horn Developing with SQL Azure	Roman Rehak SQL Server Development Tips and Tricks	Mike Walsh You Can Improve Your Own SQL Code
12:15 PM	Michael Ruland Sponsor Lunch: Turbocharge your ETL with expressor
01:00 PM	Sunil Kadimdiwan Visualize your data on a Map	Steve Simon Data Access Layers: A Cornucopia	Ayad Shammout Building High Availablity SQL Server environment	Adam Machanic Dynamic Management Master Class: 15 Powerful DMVs
02:30 PM	Mike Litchfield Designing and Implementing an ETL Framework	Jim O'Neil "Dallas": Microsoft's Data Marketplace	Varsham Papikian Use PowerShell and SQLCMD - be more effective	Dean Richards Tuna Helper for SQL Server DBA's
03:45 PM	Steve Simon Data Mining.. Making $mart financial decisions	Matt Van Horn Pivot Data Visualization	Peter Tassmer Storage Design For SQL Server

Please note that registration opens at 7:45 a.m. We hope you'll show up on the early side to make the first session and avoid having to rush. We'll be providing coffee and some breakfast items to compel you to get out of bed and join us.

Please let me know if you have any questions. Looking forward to seeing many SQLblog readers at the event!

New England Data Camp v2.0 (SQL Saturday #34) - January 30, Waltham MA - Registration and Call for Speakers Open

Adam Machanic — Mon, 07 Dec 2009 14:59:00 GMT

Last week I very quietly announced, via Twitter, that we've officially launched the site for New England Data Camp v2.0, the second go at a full-day event jointly hosted by both the New England SQL Server Users Group and the Southern New England SQL Server Users Group. The event will take place on January 30, 2010, at Microsoft's Waltham, Massachusetts office.

If you missed last year's v1.0, you can check out the fantastic session list on my blog post for the event. We had just over 200 attendees and feedback was quite positive. This year's event promises to be even bigger and better, as we've partnered with SQL Saturday, which should smooth some of our rough edges.

We are planning to have up to 25 sessions in four or five tracks, and our public call for speakers is open and ready for your submissions. Never presented before? No problem--shake off your stage fright and give it a try. I promise, you will have a good time. The Data Camp audience is laid back and happy to learn from you, whether or not you're a seasoned presenter.

Just want to attend? That's fine, too. Our registration page is ready and waiting to reserve your spot at the event.

We're also looking for a few sponsors to help defer the cost of the event. If your company would like to increase awareness amongst the best and brightest data professionals in New England, you can do no better than to sponsor this event. Information on sponsorship plans is available on our Sponsors page.

Looking forward to seeing many SQLblog readers there! Please let me know if you have questions, concerns, comments, etc.