Category: PASS General
February 4, 2014 – PASS is thrilled to welcome Dell Software as a Platinum Level Global Alliance Partner, transitioning the company’s already strong individual event and program sponsorships into a comprehensive, strategic relationship that supports the worldwide PASS community year-round.
As a Platinum Level Global Alliance Partner, Dell Software will be a Platinum sponsor of both the PASS Business Analytics Conference and PASS Summit and will be supporting PASS Virtual Chapters, 24 Hours of PASS virtual events, PASS SQLSaturday events, and the entire PASS community through Connector sponsorships, web advertising, and more.
“We are very excited to be partnering with PASS as a Global Platinum Partner,” said Matt Wolken, vice president and general manager, Information Management, Dell Software. “With data growth and complexity driving the need for better management of leading databases, SQL Server continues to play a critical role in the IT management ecosystem. That’s why Dell Software remains focused on providing solutions for SQL Server that help organizations worldwide solve business-critical challenges, and why we are committed to remaining a leader now and well into the future. Our support for the PASS organization and the SQL Server community as a whole provides clear proof of that commitment.”
PASS sponsors are a vital part of the community, supporting the organization’s many training and networking opportunities, including free learning events. Through the Global Alliance Program, PASS looks forward to bringing many new opportunities and added value to our community and to our partners. For information about becoming a PASS Global Alliance Partner, please contact Craig Ellis.
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 email@example.com.
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.