Category: PASS Community Summit
October 11, 2013 – With the PASS Board of Directors elections completed and thousands of community members and volunteers gathering at PASS Summit 2013 in Charlotte next week, it’s time to meet your Board portfolio leaders for the coming year. It’s been a pleasure, as one of my first tasks as incoming PASS President, to match up Directors with the project portfolios where they can put their skills, experience, passions, and energy to best use.
Here are the portfolios for 2014:
- James Rowland-Jones led our Global Growth portfolio over the past year, helping us gather feedback and lay the groundwork for better supporting the global community, including converting two seats on the PASS Board to regional seats. JRJ will remain with Global Growth and also lead Special Projects.
- Sri Sridharan began his term on the Board last year with the reinstated Volunteers portfolio and will continue the important tasks of growing PASS’s volunteer pool, better organizing volunteer efforts, and recognizing volunteers’ valuable contributions.
- Wendy Pastrick will continue leading our Global Chapters portfolio, working to grow and support local user groups with a great team of Community Evangelists and Chapter Leaders and Regional Mentors throughout the world.
- Amy Lewis, newly elected to the Board, will begin her term heading up the Programs portfolio. Working with Director Adam Jorgensen, Amy has served as co-manager of PASS Programs for 2 years, helping improve processes and lead the team that selects sessions for PASS Summit and the PASS Business Analytics Conference.
- Jen Stirrup, elected to the new EMEA regional seat on the Board, will put her experience as PASS BI Virtual Chapter co-leader to valuable use in guiding the Virtual Chapters portfolio.
- Tim Ford, elected to the new US/Canada regional seat, will take over the SQLSaturday portfolio. A passionate SQLSaturday supporter, Tim organized Kalamazoo, MI’s first SQLSaturday. Over 80 SQLSaturdays were held throughout the world in FY2013, and we’re expecting continued growth of these popular free, 1-day training events as we focus on meeting the needs of even more data professionals around the globe.
The 2014 PASS Board also includes the PASS Executive Committee – consisting of myself; Executive VP, Finance, Adam Jorgensen; VP, Marketing, Denise McInerney; and Past President Bill Graziano – and Founding Partner Board members from CA and Microsoft.
The transition to new assignments is underway, and new portfolio leaders will be meeting with community leaders and volunteers at Summit to get a jump-start on their projects. Make sure you say “Hi” at Summit, join us at the Board Q&A on Friday, Oct. 18, and volunteer to pitch in on your favorite projects. We can’t wait to get down to business!
– Thomas LaRock
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.
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.
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
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.
June 24, 2014 – Congratulations to all the community speakers selected for PASS Summit 2014, and thanks to everyone who submitted abstracts in a record-breaking year! We had the most Summit submissions ever, with 943 abstracts submitted for the 144 community session slots in this year's program.
On behalf of the Program Team, I want to share how much we appreciate the SQL Server community’s ever-growing support in helping build the biggest and best educational program for SQL Server and BI professionals.
Thank You, Program Committee Volunteers
I would like to thank all of this year’s 88 Summit Program Committee volunteers for their dedication and hard work in the session review, scoring, rating, and selection process. The team reviewed all the 943 abstracts submitted by 335 speakers from around the world.
I also want to give a special thank you to this year's Program Managers, Lance Harra and Melissa Coates, who led the Program Committee through all phases of the selection process and spent countless hours analyzing and constructing a well-balanced conference program. Finally, a huge thanks to Marcella McKeown and Emilija Dufresne at PASS HQ – invaluable members of the Program Team who support and help coordinate and execute all program-related functions.
Behind the Scenes: How Are Sessions Selected?
The program-selection process is constantly being fine-tuned and improved based on lessons learned and feedback from each event. We welcome and encourage feedback and look forward to continuing to enhance our processes for a fair and objective approach that ensures a well-balanced program. Here’s a high-level overview of how Summit sessions are selected:
- Reviewing Abstracts, Speakers, PPTs: Program Committee volunteers are assigned to one of three teams:
- Abstract Review – Abstract Review volunteers work in sub-teams that match the program’s educational tracks, with each team reviewing and ranking abstracts in its track. The abstract review teams do not know which speakers submitted which abstracts; this "blind rating" is done to remove any favoritism in the scoring process, creating an even playing field for both new and seasoned speakers.
- Speaker Review – This team separately reviews speaker credentials, experience, and past attendee feedback to help select a slate of quality presenters.
- PowerPoint Review – After sessions are selected for Summit, the PowerPoint Review teams take over, reviewing speakers’ presentations, including verifying completeness, ensuring that required slides are included, and doing final spelling/grammar checks.
- Building the Program: When the Abstract and Speaker Review teams are finished, the program managers collect all the scores and ratings and analyze the top sessions from each track to fill the community session slots. Key factors in this analysis phase include:
- Topic Balance – The goals are to ensure that sessions within each track are inclusive and representative of the track’s key topics and to avoid duplication.
- Level Balance – We want to ensure a good mix of skill levels for beginners through experts.
- Speaker Balance – We strive for a lineup that includes both established expert speakers and rising stars. To offer a good variety of speakers, we limit the number of general sessions to two per presenter.
- Partnering with Microsoft: With the community sessions selected, our next step now is to open the Microsoft call for speakers, collaborating with Microsoft to make sure selected submissions complement the community sessions and create a cohesive overall Summit program. Watch for Microsoft sessions and the complete session schedule in early September.
New: Improved Filtering and Learning Paths
As part of our commitment to execute a robust and diverse educational program for Summit 2014, we are providing better attendee guidance through role- and skill-based learning tracks. This year, we are introducing Learning Paths, which are being rolled out as part of an improved session filtering and search feature.
Filter options include Track, Speaker, Level, Session Type, and the new Learning Paths, which let attendees further refine their search by leveraging nine cross-track topics:
- Big Data
- High Availability/ Disaster Recover
- Power BI
- SQL Server 2014
If an attendee is interested in sessions related to SQL Server running in a virtualized environment, for example, he/she can select the Hardware/Virtualization Learning Path. Additional Learning Path filters can be applied for an even more refined search.
Recognizing that Cloud/Azure-related topics cross various tracks and interests, this year we have incorporated Cloud sessions into the appropriate remaining tracks and have created new filtering and search options on the PASS Summit 2014 Sessions page. We hope the new filtering and search options will make it easier for all Summit attendees to locate sessions that are best suited to their interests and needs.
We have a phenomenal program this year, planned and presented by the SQL Server Community for the SQL Server Community. Help us spread the word, and don’t forget to register by June 27 to save $300 on your registration. See you in Seattle!
– Amy Lewis
PASS Director of Programs
July 2, 2014 – It’s been exciting to see all the blog posts and tweets from speakers selected for PASS Summit 2014 – especially those who will be presenting at Summit for the first time. It’s also a bittersweet time as we commiserate with those who weren’t selected for this year’s program.
The hardest part of the Program Committee’s monumental task of reviewing, rating, and selecting sessions and speakers is not being able to include all the quality sessions and speakers we want to. This year’s 88-member team of community volunteers worked extremely hard and had to make some difficult choices. As the Program Committee reviews this year’s processes as well as feedback from its members and the community on how to improve and deliver the best possible Summit program, we wanted to share some ideas around the main discussions regarding the 2014 session selection process.
A Great Place to Start Is with Data
As both the SQL Server and Business Intelligence space and the attendance at PASS Summit continue to grow, our program also continues to grow to cover key topics and meet the needs of our community. For PASS Summit 2014, we increased the number of community sessions to 135 (not counting Lightning Talks), nine more than last year, and the number of community pre-conference sessions from 12 to 16. For the 135 session slots, we received a record 943 abstracts from 335 speakers, meaning that from the outset, we would be able to select only about 15% of submissions. (For an overview of the session selection process, please see PASS Summit: Already Setting Records.)
We want PASS Summit to be a showcase of the best and brightest technical experts and compelling speakers – from seasoned experts to rising stars. That means creating a mix of returning and first-time Summit speakers; this year, 26% of our speakers will be new to Summit. Because we continue to see an increase in the number of great session proposals from quality speakers, we will continue to look at ways to increase the number of community speaking slots.
To Publish or Not Publish Ratings
Members of the speaker and abstract review teams separately rate each speaker or session they’re assigned. The Program Managers and myself then use those speaker scores and abstract ratings, as well as topic balance, speaker balance, and skill level considerations, to build a cohesive program. Even a highly-rated session in a particular track might not be selected for the final program if that speaker already has the maximum two general sessions, for example, or to achieve a balanced program in terms of topics and skill levels.
So why not make the ratings public? First, the Program Team doesn’t want to embarrass or discourage anyone whose session received a low rating. Publishing the ratings would also open the door to questions and disagreements about why speakers or sessions received certain ratings – even among sessions that were selected. Although it’s unlikely we will publically share the session ratings, we are continuing to look for ways to improve feedback on why a session wasn’t accepted, some of which we instituted this year (see the next point).
Providing a Feedback Loop
As part of the session review and rating process, each session is typically reviewed by three or more team members. Reviewers are encouraged to provide written comments about the abstract along with a rating. The Program Managers then use the comments and ratings to build the best possible program. Unfortunately, not all the abstracts have comments, and the quality and quantity of the comments vary greatly. Our current tool, Orator, does not have the capability to combine all the comments from the various reviewers into comprehensive feedback for each session. We are looking at how to improve the use of comments in the abstract review process for next year and enhance Orator with better feedback capabilities.
If you submitted a session proposal for Summit 2014 and would like the comments from the abstract review team, please email email@example.com and we will send you the comments that are available for your abstract. Please note that, as stated above, not all abstracts have comments, and the comments are related to the abstract only and not why the session was or wasn’t accepted.
Based on feedback from the community over the past year, we also worked to improve the wording we use in our speaker notification letters for sessions that weren’t selected, as follows, but we currently do not have more specific comments about why a session wasn’t accepted.
||Updated This Year To
|3rd party or vendor specific topic
||Session deemed too focused on a vendor product
|High number of sessions already selected for topic
|Popular topic, higher rated session selected
|Limited target audience
|Less popular topic than others submitted
|Max sessions allocated for track
|Allocated number for track filled based on session rating and topic coverage
|Speaker has exceeded number of selected sessions
|Speaker has exceeded number of selected sessions - 2 General Sessions max
We are forming a Program Committee Special Project Team to review and improve the feedback process for future events and are committed to having the changes in place for the PASS Summit 2015 session selection process.
Pre-cons by Board Members
Members of the PASS Board of Directors are also part of the SQL Server and PASS communities and are allowed to submit session abstracts and speak at PASS events, including presenting pre-conference sessions. All sessions proposals – including pre-con proposals submitted by members of the Board – go through the same blind abstract review, in which the abstract reviewers don’t know who submitted the abstract.
In most cases, pre-conference speakers are offered financial compensation for their pre-con sessions. Section VI.14. of the PASS Bylaws state:
“Directors shall not receive any salaries for their services as Directors, but by resolution of the Board of Directors, a fixed sum and/or expenses of attendance, if any, may be allowed for attendance at each regular or special meeting of the Board; provided that nothing herein contained shall be construed to preclude any Director from serving PASS in an educational or speaking capacity and receiving compensation upon approval by a majority vote from the Board of Directors.
Simply put, any member of the Board is eligible to give a pre-con or other session at Summit. They are eligible for compensation if compensation is approved by a majority vote of the Board of Directors. The Board member selected to give a pre-con at Summit 2014 did not request to be compensated, therefore no vote was required. The Executive Committee did discuss the situation prior to announcing pre-con speakers and ensured that all decisions were in compliance with the bylaws and that the Board member would be able to fulfill all his duties during the week.
Changing Session Titles and Abstracts
All session titles and abstracts are reviewed and rated exactly as they are submitted. After the Program Committee has selected the final session list, all titles and abstracts are proofed for accuracy, clarity, grammar, and marketability, and we work with speakers on any requested updates.
Let’s Put It to a Vote?
There’s been some discussion about supplementing the session review/selection process or avoiding it entirely by putting some or all sessions up for community vote. Although it’s an attractive idea, whenever we’ve invited the community to vote on sessions – as with past Lightning Talks or Community Choice sessions – we’ve received extremely low participation, which leads to skewed results. Well-known speakers also have a distinct advantage in a voting scenario, and even in a “blind voting” situation without speaker names, it would be difficult to achieve a balance of topics, speakers, and session levels.
PASS Summit is first and foremost a community conference – built by dedicated community volunteers around open submissions from passionate community members – and we are always open and looking at ways to improve that process. We appreciate your feedback around the session selection process and helping develop new speakers, and we are working to schedule Program Committee office hours at Summit to hear your ideas, as well as talks on such topics as how to write an effective abstract and a good speaker profile – stay tuned for details. In addition, watch for sessions throughout the year on creating successful abstracts, how the Program Committee works, and how sessions are selected.
The Program Team’s work is never done – as soon as sessions are selected, we’re working on PowerPoint reviews, supporting speakers during the event, reviewing attendees’ feedback, and brainstorming ideas for making the next Summit even better. Please keep your feedback coming all year long; email us at firstname.lastname@example.org.
– Amy Lewis
Director of PASS Programs
Plus, Black Girls Code founder Kimberly Bryant taking center stage at Women in Technology luncheon
Sept. 2, 2014 — Polybase and SQL Server query optimization guru Dr. Rimma Nehme, senior research engineer at the Microsoft Jim Gray Systems Lab, will kick off Day 2 at PASS Summit 2014 in Seattle, WA, Nov. 6, with Black Girls CODE founder Kimberly Bryant headlining the conference’s popular Women in Technology (WIT) luncheon.
Rimma, who has helped prepare Dr. David DeWitt’s celebrated PASS Summit keynotes since 2010, is known for her work on PolyBase, which integrates SQL Server Parallel Data Warehouse (PDW) with Hadoop, as well as the SQL Server PDW query optimizer, a partial results framework for database systems, an automated partitioning advisor for parallel database systems, and more. With her keynote, “Cloud Databases 101,” Rimma will be taking Summit’s 5,000+ SQL Server and BI professionals deep into the what, why and how of data processing in the cloud.
“It’s an honor to help carry on PASS Summit’s rich tradition of helping SQL Server and BI professionals get the most out of their database environments, and I’m thrilled to be sharing some of the exciting work done in the field around working with data in the cloud.” Rimma says. “When talking about cloud databases, people often mean different things. Some may be referring to a pay-per-use service; others may be speaking about a speciﬁc piece of software. In this keynote, we will look under the covers of cloud databases and try to dispel some of the myths.”
WIT luncheon speaker Kimberly Bryant, an electrical engineer working in biotech, was inspired by her daughter in 2011 to launch the non-profit Black Girls CODE (BGC), with the mission of supporting and promoting the underrepresented female and African demographic (25% and 3%, respectively, in 2012) within the technology industry. BGC has grown to 3,000 students across 7 US states as well as in Johannesburg, South Africa, and has received support from many companies both within and outside of the technology industry. Kimberly will be taking questions from the onsite audience and from Twitter during the Nov. 6 live-stream event, hosted by PASS’s WIT Chapter and sponsored by SQL Sentry.
“The motto of Black Girls CODE is ‘Imagine. Build. Create,’” Kimberly notes. “I can’t wait to share with the PASS WIT and data communities how we can all imagine a world where everyone is given the tools to succeed, and get even more data professionals involved in building ways for everyone to access information and create a new age of women and women of color in technology.”
PASS Summit, organized by and for the SQL Server community, is the largest SQL Server event in the world, delivering 200+ technical sessions, 18 full-day pre-conference sessions, and nonstop networking opportunities with the industry’s top SQL Server and BI experts.
For full details and to register at the discounted rate by Sept. 24, visit http://www.sqlpass.org/summit/2014.
Sept. 15, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. First up: Itzik Ben-Gan and Mastering T-SQL Querying Fundamentals.
Q: If your pre-con had a theme song, what would it be and why?
The Beatles’ “Here Comes the Sun.” The seminar will shed light on what correct T-SQL thinking is.
Q: T-SQL was named the most popular programming language in 2013 - what excites you most about it?
T-SQL is my native tongue; it’s kind of my language. It’s great to know that many others like what you like. It’s also evidence of the usefulness and practicality of the language.
Q: What's the most surprising statement attendees might hear you say about query fundamentals during the pre-con?
“Now you know everything there is to know about T-SQL fundamentals.” If I did say it, of course, it would be just a joke. The point is that people often get the wrong impression that the language is simple to master. But the more you learn, the more you realize how deep and non-trivial it is.
Q: What’s the biggest T-SQL querying myth that you’d like to debunk?
Probably the most common myth has to do with confusing the physical and logical layers, ignoring or being oblivious to the relational model’s physical data independence principal and thinking that the data is organized in certain physical order and that this provides guarantees that the rows will be processed and/or returned in that order. People keep falling into this trap over and over again, including very smart people. Classic examples are queries in table expressions that have TOP and ORDER BY, what people refer to as quirky update, and others.
Q: What still trips you up in mastering logical query processing?
The fact that there are so many things that seem unnatural about the language until your learn about logical query processing. When you learn about it, there are so many a-ha moments, and things suddenly start making so much more sense.
Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
I would say mainly that they would start using the language in the correct way, having the right expectations from it, and also knowing what not to expect from it. This is the "big picture" part.
As for an example of something more specific that attendees will be able to use immediately, they will be able to elegantly solve the problem of not being able to refer to column aliases defined in the SELECT clause in the WHERE, GROUP BY, and other expressions in the same SELECT clause. They will be able to do this using a trick that I will show them based on the APPLY operator and the VALUES clause.
Check out our other Q&As with PASS Summit 2014 pre-con speakers.
Sept. 15, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this interview, Adam Machanic takes us inside his pre-con, Better Performance Through Parallelism.
Q: If your pre-con had a theme song, what would it be and why?
"The Power" by Snap! This pre-con teaches people to take control of performance for large queries and to use techniques that put them in the driver's seat. The query optimizer does not – and cannot – make the right choice every time. If you want ultimate performance, you must take matters into your own hands.
Q: What excites you most about SQL Server’s parallel processing?
It's a feature set that is at once both very mature and very much in a growth phase. Parallelism works well, but it doesn't always kick in when it should or work in an optimal fashion. And not many people know how to get it to play nice. As a developer, having a deep understanding of parallelism gives you a huge edge over the competition.
Q: What's the most surprising statement attendees might hear you say during the pre-con?
Columnstore, despite what you may have heard, is not the answer to most of your tough performance challenges. (Even though it might help, sometimes.)
Q: What’s the biggest myth around parallelism and query optimization that you’d like to debunk?
Many people are still confused about what, exactly, this CXPACKET thing *really* means, and what to do about it. At the end of this seminar you will be able to describe CXPACKET very accurately and you will understand its exact implications.
Q: What still trips you up in mastering SQL Server’s parallelism settings?
Sometimes mixed workload scenarios present some interesting challenges. For some of the settings, there is only a single instance-wide configuration knob. That can be tough. But as with everything, there are options.
Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Some of my prior seminar attendees have written to tell me that my Parallel APPLY query patten has yielded performance gains of 10 times or greater. It often takes only a few minutes to bolt it on to an existing query, and properly applied, it does truly amazing things. This is why I teach the seminar; I want people to go back to the office and fix their tough performance issues so that they can spend their time building cool new apps instead of messing with the database all day.
Check out our other Q&As with PASS Summit 2014 pre-con speakers.