PASS Summit 2014 Recap

Image

Just moments ago, the PASS Summit 2014 wrapped up, and will be forever in the history books. When I got back to my hotel room, I started thinking about the event, the awesome people that I met for the first time, the old friends that I was able to reconnect with, the completely mind-blowing experience of being a first time speaker at the Summit, and everything else that has gone on over just one short week. I quickly realized that I wanted to take a moment to blog about it and share some of my experiences, but to also act as a journal of sorts. Below are just some of the awesome things that I’ve done, or that have happened to me this week:

  • I finally got to meet Paul Randal, Kimberly Tripp, and Jonathan Kehayias of SQL Skills and I was able to attend Paul’s pre-conference session on Performance Tuning Using Waits and Latches. As expected, the pre-conference session was awesome, as were Paul, Kimberly, and Jonathan.
  • I was able to network with other people from the Cleveland area, as well as from around the world, and I was even able to recruit at least one person to apply for a job at my company.
  • I was able to attend volunteer meetings and the SQL Saturday Roundtable meeting for the first time and to get some insight into PASS as an organization and how other community members approach their events. In addition, I was able to hear from several sponsors about how the community can better engage them.
  • I volunteered as a Summit Ambassador for the first time and was able to assist attendees with finding their way around the conference center.
  • I was interviewed by PASS TV to speak about local events and was able to give a shout-out to both the upcoming Cleveland SQL Saturday and Columbus SQL Saturday.
  • I presented my Introduction to AlwaysOn Availability Groups session to one of the largest audiences that I’ve ever presented to in-person (it was also video recorded), and even had a Microsoft employee attend my session and offer some insight into where AlwaysOn Availability Groups are heading in future versions of SQL Server. I was also paid a visit by the Demo Gremlins when my demo laptop decided to reboot while I was presenting the first half of my session. Fortunately, I was able to recover from the issue on the fly and still presented a successful, working demo of an Availability Groups (it just had 2 replicas instead of 3 😉 ). My audience was energetic, enthusiastic, and engaged, and I even had a swarm of attendees approach me after my session to say hi and to ask follow-up questions. As a speaker, I couldn’t be happier with how things worked out.
  • I was able to visit the Experience Music Project (EMP) museum for the second time for the PASS Community Appreciation Party, and it ROCKED!
  • I was also approached by Pluralsight to produce a training video about AlwaysOn Availability Groups, and by Apress to write a book about them as well. We’ll see how these opportunities pan out, but I’m cautiously optimistic about them at this point. *fingers crossed*

As you can see, it’s been a busy, exciting, fun, and exhausting week for me. I’m still blown away by the fact that I was selected to speak and that I was approached by Pluralsight and Apress, and it’s all thanks to PASS and to amazing friends and mentors like Allen White, Erin Stellato, and Brian Davis who got me started as a speaker and helped me grow over these past several year. I’ve said it before, and I’ll say it again: this community has an amazing ability to change peoples’ lives and to help them grow by bring them together for a common cause. It’s been a wild ride, and the best part of it is that it’s only just the beginning.

SQL Saturday Cleveland 2014

Cleveland SQL SaturdayHappy New Year, and welcome to another exciting year of SQL Server learning! With that said, why not join us at Cleveland’s 3rd SQL Saturday on February 8th at Hyland Software? The weather may be cold and gray outside, but I promise you it’ll be warm, inviting, and fun at our event! This year I’ve decided to step into the captain’s seat and lead the planning efforts for SQL Saturday, and it’s been a blast! We have a ton of awesome speakers and experts lined up like Tom LaRock, Steve Jones, Tim Ford, Grant Fritchey, Kendal Van Dyke, Argenis Fernandez, Stacia Misner, Andy Leonard, and Erin Stellato, just to name a few. Check out the full line-up here! In addition to our amazing speaker line-up, we’ll also have some fun activities and experts available to answer your questions. Believe me, you don’t want to miss this event!

Oh, and did I mention that we have two awesome pre-con sessions available? Why yes, yes we do!

A Day of SQL Server Internals and Data Recovery

Take your recovery game to an all new level. Take a deep dive into SQL Server internals and data recovery and learn how to handle a wide variety of data loss and corruption scenarios. The session will cover how to be prepared for, prevent, and recover data lost due to deletion or corruption.

Learn the following skills in this session:

  • Built-in functionality in SQL Server for preventing and detecting corruption that you may not even know about.
  • How to identify a specific transaction in the transaction log and recover data lost from that transaction.
  • Categories of corruption and how to manage recovery differently for each one.

Don’t come empty handed. Bring your laptop and we’ll practice recovering corrupt databases together.

Speaker Bio:

Argenis Fernandez is a Senior Database Engineer for SurveyMonkey based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys large SQL Server farms, high-end OLTP databases, managing Windows environments, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Prior to SurveyMonkey, Argenis worked as a Senior Database Administrator for Coinstar/redbox and as a Senior Consultant on SQL Server Core for Microsoft Consulting Services. In 2013 he founded the Security Virtual Chapter for the Professional Association for SQL Server (PASS) (http://security.sqlpass.org).

Argenis is a SQL community enthusiast and speaks frequently at major SQL Server conferences, including the PASS Summit, PASS SQL Rally, IT/Dev Connections, SQLBits, and Microsoft TechEd. He is also a Microsoft Certified Master on SQL Server 2008, an avid Twitter user (you can follow him at @DBArgenis), and occasional blogger on SQL Server topics at SQLBlog.com.

Register for this precon

Automate and Manage SQL Server with PowerShell

This soup-to-nuts all day workshop will first introduce you to PowerShell, after which you’ll learn the basic SMO object model, how to manipulate data with PowerShell and how to use SMO to manage objects. We’ll also cover how to manage data using the Invoke-SQLCmd cmdlet as well as ADO.NET.  We’ll then move on to creating Policy-Based Management policies, work with the Central Management Server, manage your system inventory and gather performance data with PowerShell. We’ll wrap up with a look at PowerShell Remoting and how you can use PowerShell to manage SQL Server 2012 in server environments including Windows Server Core. After this one day, you’ll be ready to go to work and able to use PowerShell to make you truly effective.

Speaker Bio:

Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch. Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. He currently serves the SQL Server community as President of the Ohio North SQL Server User Group, the Cleveland, OH based chapter of the Professional Association for SQL Server (PASS).  Contact Allen at upsearch.com. Follow Allen on Twitter: @SQLRunr

Register for this precon