PASS Summit 2016: Recommendations and Invitations (#sqlpass #Summit16)

PASS_16_Twibbon_Attending_200x200

The last week of October, we’ll be at the PASS Summit in Seattle, WA.  As some of you already know – and as I said last year and the year before – “this is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in.”  It’s gonna be a blast, again-again, and so here’s some of the stuff you should know about.

Edit for PSA: If you’re the type to get a flu shot, NOW would be a good time. #NerdFlu is a thing. Got to give the vaccination time to take effect!

Beforehand

You really ought to register, you know, and while you’re at it you might want to sign up for an all day pre-conference session (a “precon”).

Get on Twitter to connect with other attendees. #Summit16 is the official hashtag, but most of us tend to use the more general #sqlpass.

24 Hours of PASS – 24 hours of live, free webcasts – is September 7.

Taking part, if you can’t attend

The keynotes and luncheons are usually live broadcast, and you can order session recordings to cuddle up with at home. I suppose you can put on a kilt, go hit a karaoke bar with friends, drink too much, and contract the nerd flu, if it’ll make you feel more like you were at Summit. That’s what I’d do.

Some of the best stuff, if you’re there

I’ll update this section as new stuff is announced.

Right before the Summit starts:

  • There is no official #SQLLongRun this year that I know of, but I’m thinking of doing my own personal long run the Monday of the Summit. So, you know, that’s a thing.
  • Monday, October 24  (5-7pm), have a meetup with the MidnightDBAs at Top Pot Doughnuts on 5th Ave. Yes, it’s donuts for dinner, and we’re fine with that. Or consider it a sweet, sweet appetizer. Register now!
  • Consider going on a 5k walk or run on Wednesday morning! See #SQLRun.

During the Summit:

  • There’s usually a first timer orientation on Tuesday night, right before the welcome reception. I haven’t seen news about this…anyone else?
  • Come see us in the vendor area! MinionWare.net is an official PASS Summit 2016 sponsor, and we’re really excited about it. While you’re at it, follow us on Twitter: @HeyMinionWare.
  • Hit a luncheon or two:  Women in Technology, and/or the Birds of a Feather (if they’re having it this year…I haven’t heard yet).
  • Drop by the evening events. The Welcome Reception is usually worthwhile, and the Community Appreciation Party was at the quite awesome EMP Museum in 2014! (No idea yet where it is this year…)
  • There are always more events, so keep an eye on Twitter and on the Summit website for photowalks, karaoke, Kilt Day, and more.

Happy days,
Jen McCown
http://www.MidnightDBA.com/Jen

P.S. For those who missed something in particular from this announcement, email or DM or email me with your questions. Apologies to the rest of you for the cryptic postscript.

October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”

Florida!On October 7 we will be presenting a full day of maintenance and backup learnin’!

Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724

And while you’re at it, register for the free SQL Saturday Orlando that follows! http://www.sqlsaturday.com/564/eventhome.aspx

Abstract for “The Lifecycle Approach”

Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more.  In this full day session, we’ll explore the many issues surrounding maintenance and how to solve them in a way that is cohesive and comprehensive.  If you’re managing more than one server, come to this session.

Learn how to:

  • Deploy maintenance routines to hundreds of servers, effortlessly
  • Standardize configuration throughout the enterprise
  • Set up custom alerts and reports.
  • Manage HA/DR failover scenarios and keep your maintenance intact.
  • Minimize the number of jobs
  • Tune backups and database integrity checks

For maintenance, you’ll learn how to:

  • Order index operations to maintain the most important tables first
  • Maximize your maintenance window by fine-tuning your routine.
  • Handle the most difficult CheckDB scenarios with dynamic custom snapshots, multi-threading and CheckDB offloading.

And for backups specifically, you’ll learn to:

  • Automate management of failed backups
  • Ensure that certificates and encrypted passwords are securely backed up
  • Automate configuration changes between HA/DR sites, in case of failover
  • Turn trace flags on or off automatically

Conference speakers: Why do you teach at events?

I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at events where there’s no compensation.

I know more or less why I do this, but I’ll hold off on my answer. I want to hear about you.

Real news, real tech.