Category: PASS General
February 3, 2014 – As the Program Committee prepares to open the PASS Summit 2014 call for speakers later this month, we’re excited to recognize the Top 10 sessions from PASS Summit 2013:
- Waits, Latches, and Spinlocks: Internals and Analysis (DBA) - Paul Randal, SQLskills.com
- Index Fragmentation: Internals, Analysis, and Solutions (DBA) - Paul Randal, SQLskills.com
- Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (DBA) - Kimberly Tripp, SQLskills.com
- Parallel Query Execution (DBA) - Paul White, SQL Kiwi Limited
- SQL Server 2012 Data Mining: Taking App Design to the Next Level (BID) - Peter Myers, Bitwise Solutions
- Power BI Self-Service Information Management and Data Stewardship (BIA) - Matthew Roche & Ofer Ashkenazi, Microsoft
- How to Tell When Storage Is a Problem (DBA) - Kendra Little, Brent Ozar Unlimited
- Convince Me – Persuasion Techniques That Get Things Done (PD) - Kevin Kline, SQL Sentry
- OLTP Sharding Techniques for Massive Scale (DBA) - Conor Cunningham, Microsoft
- Query Performance Tuning for Azure SQL Database (CLD) - Grant Fritchey, Red Gate Software
The Top 10 list is based on average attendee evaluations from sessions that had a minimum of 50 attendees and evaluations from at least 20 or 20% of those attendees (whichever is greater).
Recordings of these “best of” sessions are now available to all PASS members – just log in here to start watching. You can also view other selected PASS Summit 2013 sessions free on PASStv and own the entire set of PASS Summit 2013 session recordings.
And don’t forget to register by March 7 to save on this year’s event, Nov. 4-7, in Seattle.
January 27, 2014 – At its in-person meeting in Seattle last week, the PASS Board of Directors approved amendments to the PASS Bylaws as Founding Partner CA relinquishes its two seats on the PASS Board. The bylaw changes amend Section VI.2., Composition and Qualifications, to reduce the number of both voting Directors and vendor-appointed Directors and to remove CA from appointing vendor-appointed seats:
With CA’s resignation from the Board – official as of January 31 – PASS will say goodbye to its two longest serving Board members, Rick Bolesta and Neil Buchwalter. Rick joined the PASS Board as a CA Founding Partner representative in Year 2 (2000), and Neil joined him on the Board a year later.
Rick and Neil’s longevity with the Board has been invaluable to PASS. They have played a huge role in guiding the work of the Board, especially in areas of governance, leadership development, and strategic direction of the organization.
“One of my big takeaways from both these gentlemen is their ability to sit at the table during a Board meeting and always wear their PASS hat,” noted PASS President Thomas LaRock. “Over the years, they have consistently put the community first.”
On behalf of the community and the PASS Board and PASS HQ, we thank CA for its support and for allowing Rick and Neil to share their guidance and wisdom with us for so many years – they will be greatly missed.
You can read more about CA’s relationship with PASS in Andy Warren’s interview with Rick Bolesta from PASS Summit 2013.
January 21, 2014 – PASS Regional Mentors are all about helping local Chapter Leaders and event organizers on their way to success. From supporting new Chapter launches and sharing ideas on how to market and grow your user group to helping you find speakers, sponsors, and even host a SQLSaturday event in your city, these dedicated volunteers are helping build a stronger data community around the world.
PASS is excited to introduce new and returning RMs for many of our regions, and please join us in extending a heartfelt thanks and best wishes to our outgoing RMs as they continue to serve the PASS community.
- LATAM: PASS is welcoming a new RM team for the LATAM region this year, and we thank outgoing RMs Carlos Farias, Jesus Gil, John Bulla, and Mary Arcia – as well as departing Brazil RM Luciano Moreira – for all their efforts in building the foundation for LATAM PASS.
- Middle East/Africa: Nabeel Derhem (blog | @NabeelDerhem) is partnering with Jody Roberts as RM for the Middle East/Africa region as Gareth Swanepoel moves from MEA to the US-Southeast.
- UK: Jonathan Allen is leaving as UK RM, with Neil Hambly (blog | @Neil_Hambly) joining RM Mark Broadbent to support the region.
- US - North Central: John Morehouse (blog | @SqlrUs) is teaming up with existing North Central RM Ted Krueger in place of outgoing RM Jason Strate.
- US - Northeast: Mike Hillwig (blog | @mikehillwig) is joining Jack Corbett as RM for the US-Northeast as Steve Hughes finishes his tenure.
- US - Southeast: As noted earlier, Gareth Swanepoel (blog | @garethswan) is moving from the MEA region to join Southeast RMs Kendal Van Dyke and Tim Radney in place of Jose Chinchilla, who is now part of the new LATAM RM team.
Thanks again to our outgoing mentors for all their contributions, and good luck to our 2014 RM teams as they support the growing PASS communities in their regions. If you’re interested in becoming a PASS RM and would like to learn more about this valuable role and future opportunities, please contact Karla Landrum.
January 15, 2014 – As a data engineer at her “day job,” PASS VP of Marketing Denise McInerney has a special affection for business analytics. We caught up with her ahead of Feb. 5’s 24 Hours of PASS: Business Analytics Edition to see what she’s looking forward to at the free day of online business analytics learning.
Podcast: Listen to Denise talk more about business analytics, business intelligence, and PASS’s upcoming training opportunities in this podcast interview with SearchSQLServer.com.
What is 24 Hours of PASS: Business Analytics Edition?
24 Hours of PASS: BA Edition (24HOP: BA) is a day of free, live, back-to-back webcasts on how to get the most from your data, presented by some of the most knowledgeable and top-rated speakers from the world of business analytics and business intelligence. This edition features 12 live sessions – each with its own Q&A segment – followed by 12 hours of on-demand replay in case you miss a session or want to rewatch your favorites.
Thanks to our sponsors – Microsoft, Cisco, Confio, Dell Software, and SQL Sentry – we’re able to bring 24 Hours of PASS: BA edition to BA and BI professionals at no cost. In true PASS fashion, it’s a great community event that brings data professionals from around the world together to connect, share, and learn.
In the week since registration opened, each 24 Hours of PASS: BA session already has at least 700 registrations. So we’re looking forward to a blow-out event!
What will the sessions cover?
The sessions will cover best practices and the latest tips on everything from data analytics and visualization, predictive analytics, and data science to Big Data and information delivery, strategies, and architecture. We have sessions on Excel 2013, Power BI and Power Query, the Enterprise Data Warehouse, Parallel Data Warehouse, querying in DAX, data visualizations in SQL Server Reporting Services, and more.
And whether you’re a BA/BI novice or ready for advanced techniques, we have a session for you. I love it that we have “Predictive Analytics for Absolute Beginners” – our most popular session so far – as well as “Advanced Analytics in Excel 2013.”
Who should attend?
If you’re passionate about business analytics, this event is for you: data and business analysts, data scientists, data architects, BI professionals, IT pros… Whether you’re already working in analytics or looking to make a transition or just learn more about this fast-changing industry, you’re going to come away with practical information that you can use right away for managing, analyzing, and sharing business information and insights.
What’s your favorite part of 24 Hours of PASS?
For the past 2 years, I’ve been responsible for PASS’s online training opportunities as Director of Virtual Chapters and 24 Hours of PASS. And although as PASS VP of Marketing I’m no longer directly in charge of 24 Hours of PASS, I still feel a special connection to the event.
Since 2009, 24 Hours of PASS has grown into a well-known and well-loved event in the SQL Server community. And what’s not to love? Excellent content from top experts in the field delivered directly to your computer – wherever you’re located in the world – for free.
I’m thrilled that we’ve expanded this valuable training opportunity to BA and BI professionals. At last year’s first 24HOP: BA event, we saw almost 30,000 registrations across 89 countries. It’s just a fantastic complement to the free online learning that our Business Analytics, BI, Big Data and other Virtual Chapters provide throughout the year, as well as a great preview event in the lead-up to the upcoming PASS Business Analytics Conference in May.
What is 24HOP: BA’s relationship to the PASS BA Conference?
All 24HOP: BA speakers will also be delivering in-person sessions at the PASS BA Conference May 7-9 in San Jose, CA. So it’s a nice sneak peek at the world-class business analytics sessions and speakers who will be on tap there. If you enjoy 24HOP: BA, you’re going to love the BA Conference.
When is 24HOP: BA again?
Please join us from the comfort of your office, home, or home office on Wednesday, Feb. 5, beginning at 8am PT (11am ET, 16:00 GMT) for a great day of business analytics learning. Tell your friends, and make sure you follow us on Twitter at @PASS24HOP / #pass24hop for all the latest updates.
How do you register?
Seating in the virtual meeting room is limited, so you’ll want to register now and make sure you’re in the session early the day of the event. From the website, just select the individual sessions you want to register for – or like some die-hard attendees who attend them all, click “Select All” – and then click Register. You’ll receive an email confirmation containing your meeting access links and can add the events to your calendar through the iCal links.
I’m looking forward to having as many business analytics professionals as possible join us for this great online event. Make sure you register today!
January 7, 2014 – The 2013 elections cycle highlighted some issues with how ballots are generated for the annual PASS Board of Directors elections. Historically, all PASS members – identified as those for whom we have a unique email address – have been eligible to vote. Under this broad definition, however, it is common for members to have multiple unique email addresses in the system and to thus receive multiple ballots.
In an effort to reduce the number of duplicate ballots sent out, the PASS Board has established more specific eligibility requirements for voting. In a recent meeting, the Board agreed that to receive a ballot, members must have a completed PASS profile.
PASS has added new fields to the myProfile section of sqlpass.org to help us better serve the community. The additional information will also help us de-dupe member data for eligible voters before sending ballots. As part of a new membership drive, we are encouraging all members to update or fill out their profiles and review them for completeness and accuracy.
All members who complete their profiles – including the new fields – by June 1, 2014, will receive a ballot to vote in the PASS elections, with one caveat: All completed profiles will be checked for duplication, and those identified as duplicate will be eliminated from the ballot send out.
Looking forward to your feedback on this change in voter eligibility, and please complete or set up your profile as soon as you can!
Immediate Past President
January 7, 2014 – 2013 was a wonderful year for PASS. We grew in service to data professionals around the world across many areas – adding 31 local PASS Chapters, six new Virtual Chapters, and the inaugural PASS Business Analytics Conference – and welcomed over 16,000 new members. With 2013 now in our rear-view mirror, it’s time to look at what lies ahead for PASS.
Before we dive into the coming year, I want to thank Rushabh Mehta, Douglas McDowell, and Rob Farley for their many years of service to the PASS community as they leave the Board of Directors. Their hard work and dedication will be sorely missed.
Let’s also take a moment to welcome the new Directors joining the Board for 2014-2015: Amy Lewis, Jen Stirrup, and Tim Ford. Amy will be taking over PASS Programs, Jen will lead Virtual Chapters, and Tim will be responsible for the SQLSaturday portfolio. You can read about all the Board portfolio assignments on the PASS blog.
As PASS continues to grow, the Board understands the need for Directors to shift away from their historical role as “doers” and toward setting direction through strategic thinking. We have been taking measured steps as part of this transition. And after the 2013 elections, I shared the vision that myself, Adam Jorgensen, and Denise McInerney have for PASS as your Executive Committee (ExeCo).
Vision statements are good, but actions are better. So to start, every Board member is outlining their portfolio tasks so that we make certain they roll up to our higher-level goals and that we hold each other accountable. In my years on the Board, we have had a lot of great ideas but struggled with follow-through and accountability. We are aiming to change that in 2014.
I’ve asked all Board members to submit their goals for 2014 before Jan. 13. The ExeCo will then review the goals before the Board’s January in-person meeting and provide feedback about any tasks not aligned with the overall vision.
With your help – and the leadership of dedicated Board members – I’m looking forward to hitting the ground running this year.
Let’s make 2014 a year to remember, together.
December 19, 2013 – As CA announced at PASS Summit 2013, it has relinquished its two Founding Partner seats on the PASS Board of Directors, currently held by Rick Bolesta and Neil Buchwalter. A 1999 founding partner member of PASS along with Microsoft, CA has witnessed the organization’s membership grow to 100,000+ data professionals over the past 14 years, and we thank CA, Rick, and Neil for all their support and contributions. Read more about CA and its relationship with PASS.
In light of CA’s departure, the Board has revised the PASS bylaws to address the company’s vacant vendor-appointed seats. The proposed bylaw changes amend Section VI.2., Composition and Qualifications, to reduce the number of both voting Directors and vendor-appointed Directors and to remove CA from appointing vendor-appointed seats.
The proposed bylaw changes are open for member review now through Wednesday, Jan. 22. Please take a few minutes to read over the changes and send any comments or questions to firstname.lastname@example.org.
The Board will be discussing your feedback at its January in-person meeting. Once finalized and approved by the Board, the updated bylaws will be posted on the PASS Governance page.
– Bill Graziano
December 10, 2013 – Congratulations to all PASS local Chapters that helped refer their members to PASS Summit 2013. Sixty-nine Chapters participated in the program and earned anywhere from $50 to $1000 for their respective Chapters. Gift cards will be sent to each participating Chapter leader early next week. Find out how much your Chapter earned:
Chapter Amount Chapter Leader
Atlanta Business Intelligence Group $450 Teo Lachev
Atlanta SQL Server User Group; Atlanta Microsoft Database Forum $500 Donald Wert
Belgian SQL Server User Group $50 Frederik Vandeputte
Calgary PASS $150 Noel Tan
Canada - British Columbia (Vancouver) $100 Richard Baumet
CBusPASS $100 Dave Schutz
Central New Jersey SSUG $100 Linda Zhang
Central PA SSUG $100 Dustin Jones
Charleston SQL Server User Group $50 Ryan McKnight
Charlotte BI Group $350 Jason Thomas
Charlotte SQL Server User Group $200 Peter Shire
Chicago SQL BI User Group $150 Marcello Benati
Chicago SQL Server User Group $500 Aaron Lowe
Cincinnati PASS $50 Anthony Mattas
Denver SQL Server User Group $250 Steve Wake
Eugene Area SQL Server User Group $50 Dan Guzman
FoxPASS $150 Jes Borland
French SQL Server User Group/Groupe des Utilisateurs
Francophone de Microsoft SQL Server (France) $150 Arian Papillon
Hampton Roads SharePoint and SQL Users Group $50 Susan Lennon
Houston Area SQL Server User Group $1,000 Nancy Hidy Wilson
IndyPASS $650 Ray Lucas
Inland Empire SQL Server User Group $50 Shannon Shields
Iowa SQL Server User Group $250 Juan M. Moya
Israeli SQL Server User Group $150 Guy Glantser
Jacksonville SQL Server Users Group $150 Devin Knight
Kansas City SQL Server User Group $300 Andrew Cross
KnoxSQL - SQL Server User Group $250 Arlene Gray
Louisville SQL Server User Group $50 Dave Fackler
Malibu SQL Server User Group $150 Steve Rezhener
Microsoft Business Intelligence Community (MSBIC) $50 Greg Taylor
Microsoft Business Intelligence User Group of South Florida $200 Luis Figueroa
Midlands PASS $50 Kenneth Brian Kelley
Minnesota Microsoft BI User Group $450 Dan English
Minnesota SQL Server User Group $750 Paul Timmerman
Nashville SQL Server User Group $100 Tamera Clark
Netherlands Antilles (Curacao) $50 Roy Ernest
New England SQL Server Users Group $100 Adam Machanic
New Jersey SQL Server User Group $100 John Dempsey
North Texas SQL Servers Users Group $650 Sri Sridharan
Northern Virginia SQL Server Users Group $250 Jim Rotan
Oklahoma City SQL Server Developers Group $350 Kristin Ferrier
Olympia Area SQL Server User Group $100 Greg Larsen
Omaha SQL/BI User Group $200 John Morehouse
Oregon SQL $50 Arnie Rowland
PASS DC $50 Chris Bell
Philadelphia SQL Server User Group $800 Vince Napoli
Pittsburgh SQL Server Users Group $50 Gina Walters
Portland SQL Server User Group $200 Ken Starnes
Quad Cities PASS Chapter $350 Sheila Acker
Rochester PASS $100 Matt Slocum
Russian SQL Server User Group $50
Sacramento SQL Server User Group $150 Mitch Bottel
Salt Lake City SQL Server User Group $100 Pat Wright
San Antonio SQL Server User Group $100 Jim Steiner
Southwest Missouri SQL Server Users Group $100 Anthony Young
SQL PASS Edmonton $100 Harry Zheng
SQLPASS in Detroit $150 Joseph Fleming
St. Louis SQL Sever User Group $100 Julie Bloomquist
Steel City SQL User Group $50 John Baldwin
Tampa Bay SQL User Group $50 Jose Chinchilla
Toronto SQL Sever User Group $100 Karen Lopez
Triad SQL Business Intelligence User Group $300 Katherine Fraser
Triad SQL Server User Group $50 Kevin Goode
Triangle Area SQL Server Users Group $50 Brett Tomson
Victoria SQL Server User Group $1,000 Jonathan Mears
Wellington SQL Server User Group $50 David Curlewis
West Michigan SQL Server User Group $200 Josh Fennessy
Wichita SQL Server User Group $50 Patrick Purviance
Winnipeg SQL Server User Group $50 Michael Defehr
All current PASS Board members were on stage to help answer questions from the community. Here’s a quick recap of the top three questions and answers:
Q: There are concerns in the community that duplicate votes occurred in the recent PASS Board elections. How did PASS review the votes, and how did this affect the election results?
A: The election results remain unchanged even when taking duplicates into account. Eligible voters were determined by unique email address and date entered into the system. All submitted ballots were compared to registration lists for paid PASS events. Duplicate ballots were discovered based on first name, last name, and address. Ballots were also compared to our membership data (people who fill in the member profile on sqlpass.org), and additional duplicates were uncovered based on identical first and last name and identical voting pattern.
Q: What are PASS’s plans to host another Summit event outside of the Seattle area?
A: This Summit in Charlotte, NC, is the first time we’ve been out of Seattle since 2007! It has been a great success, but we are going to spend some time analyzing the pros and cons of hosting outside of Seattle before we decide to move to different locations. Booking facilities for events of this size happens years in advance, and we are booked in the Seattle area for the next 3 years.
Q: There was some confusion among PASS Chapter leaders about how to reach out to local SQLSaturday event registrants.
A: Any Chapter Leader involved in organizing a SQLSaturday event may use the SQLSaturday sponsor opt-in list to append registrant contact information to their Chapter email list.
Cross-posted from my blog
October 14, 2013 – As I type this, I’m on an airplane en route to my 12th PASS Summit. It’s been a very busy 3.5 months since my last post on my work as a Board member. Nearing the end of my 2-year term, I am struck by how much has happened, and yet how fast the time has gone.
But I’ll save the retrospective post for next time and today focus on what happened in Q3. In the last three months, we made progress on several fronts, thanks to the contributions of many volunteers and HQ staff members. They deserve our appreciation for their dedication to delivering for the membership week after week.
The Virtual Chapters continue to provide many PASS members with valuable free training. Between July and September of 2013, VCs hosted over 50 webinars with a total of 4300 attendees.
This quarter also saw the launch of the Security and Global Russian VCs. Both are off to a strong start, and I welcome these additions to the Virtual Chapter portfolio.
At the beginning of 2012, we had 14 Virtual Chapters. Today we have 22. This growth has been exciting to see. It has also created a need to have more volunteers help manage the work of the VCs year-round. We have renewed focus on having Virtual Chapter Mentors work with the VC Leaders and other volunteers. I am grateful to volunteers Julie Koesmarno, Thomas LeBlanc, and Marcus Bittencourt, who join original VC Mentor Steve Simon on this team.Thank you for stepping up to help.
Many improvements to the VC websites have been rolling out over the past few weeks. Our marketing and IT teams have been busy working a new look and feel, features, and a logo for each VC. They have given the VCs a fresh, professional look consistent with the rest of the PASS branding, and all VCs now have a logo that connects to PASS and the particular focus of the chapter.
24 Hours of PASS
The Summit Preview edition of 24HOP was held on July 31 and by all accounts was a success. Our first use of the GoToWebinar platform for this event went extremely well. Thanks to our speakers, moderators, and sponsors for making this event possible. Special thanks to HQ staffers Vicki Van Damme and Jane Duffy for a smoothly run event.
Coming up: The 24HOP Portuguese Edition will be held November 13-14, followed December 12-13 by the Spanish Edition. Thanks to the Portuguese- and Spanish-speaking community volunteers who are organizing these events.
July Board Meeting
The Board met July 18-19 in Kansas City. The first order of business was the election of the Executive Committee who will take office January 1. I was elected Vice President of Marketing and will join incoming President Thomas LaRock, incoming Executive Vice President of Finance Adam Jorgensen ,and Immediate Past President Bill Graziano on the ExeCo. I am honored that my fellow Board members elected me to this position and look forward to serving the organization in this role.
Visit to PASS HQ
In late September, I traveled to Vancouver for my first visit to PASS HQ, where I joined Tom LaRock and Adam Jorgensen to make plans for 2014. Our visit was just a few weeks before PASS Summit and coincided with the Board election, and the office was humming with activity. I saw first-hand the enthusiasm and dedication of everyone there. In each interaction I observed a focus on what is best for PASS and our members. Our partners at HQ are key to the organization’s success. This week at PASS Summit is a great opportunity for all of us to remember that, and say “thanks.”
PASS Summit—of course! I’ll be around all week and look forward to connecting with many of our members over meals, at the Community Zone, and between sessions.
In the evenings, you can find me at the Welcome Reception, Exhibitor’s Reception, and Community Appreciation Party. And I will be at the Board Q&A session Friday at 12:45pm.
The newly elected ExeCo and Board members take office January 1, and the Virtual Chapter portfolio is transitioning to a new director. I’m thrilled that Jen Stirrup will be taking over. Jen has experience as a volunteer and co-leader of the Business Intelligence Virtual Chapter and was a key contributor to the BI VC's expansion to serving our members in the EMEA region. I’ll be working closely with Jen over the next couple of months to ensure a smooth transition.