Category: PASS Community Summit

PASS Summit 2014 Pre-Con Preview: Alberto Ferrari

Oct. 6, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this interview, Alberto Ferrari gives us a preview of his pre-con, From 0 to DAX.

Q: If your pre-con had a theme song, what would it be and why?
Queen's “Don’t Stop Me Now." After you start looking at the power of DAX, you’ll have that exact feeling.

Q: What excites you most about the DAX language?
You can write amazingly fast code using DAX, once you know how it works. Right now, it is the fastest engine I have ever seen, apart – maybe – from video games.
 
Q: What's the most surprising statement attendees might hear you say during the pre-con?
You may not get a “wow effect” from any of my statements, but what normally excites people is to see DAX querying a 4-billion-rows fact table with many-to-many relationships in… well, it is fast. You have to see it to believe it. And did I just tell you that many-to-many relationships are absolutely fine with DAX? 

Q: What’s the biggest myth around DAX that you’d like to debunk?
“DAX is easy.” I don’t want to scare anybody: DAX is simple, but it is not easy. I have seen so many people following my lectures say, “Wow! NOW I understand why my formula computes that value.” Learning DAX by trial and error, as some people still do, is really hard.
 
Q: What still trips you up in the real world when working with DAX?
After 4 years working full-time with DAX, there are still some formulas that take a few minutes to understand, and they are all related to evaluation contexts and the CALCULATE function. CALCULATE is a beautiful function, but sometimes it generates such a level of complexity that it is really, really hard to understand.

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
I want them to open Power Pivot, load some data, and start having fun getting the insights that looked nearly impossible to compute before this pre-con.

Check out our other Q&As with PASS Summit 2014 pre-con speakers.

PASS Summit Scheduling and Predictive Analytics

Sept. 30 – Many large technical conferences such as PASS Summit have a thorny problem: It’s hard for attendees to get into all the sessions they want to attend. The solution is to do a better job with session scheduling and room allocation, assigning sessions with larger expected attendance to  bigger rooms.

This year, Data Scientist and active PASS member Dev Nambi volunteered to help the PASS Program Team put predictive analytics to work to help predict which PASS Summit 2014 sessions would be most attended so we could schedule them in larger rooms. I encourage you to read Dev’s detailed explanation of the project, “Let Me In! The Attendance Challenge,” on his blog. 

After this year’s Summit, we will review each session’s actual attendance and other factors and continue to work with Dev on adding other possible inputs and improving the prediction model. We’re excited about leveraging predictive analytics for future Summits and other PASS events.

Dev and the Program Team will be hosting Office Hours at Summit (stay tuned for details) to review this effort with the PASS community. The Program Team will also be available during these times to talk about how the Program Committee works and other PASS Program-related topics. As always, please feel free to email me or the PASS Program team at program@sqlpass.org with any feedback.

See you at PASS Summit 2014!
– Amy Lewis
Director of PASS Programs

PASS Summit 2014 Pre-Con Preview: Chris Shaw & John Morehouse

Sept. 18, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this preview, Chris Shaw and John Morehouse share a few tidbits about their pre-con, Real World End-to-End Performance Solutions.

Q: If your pre-con had a theme song, what would it be and why?
Chris:
“Battle Born” by Five Finger Death Punch – I know it sounds strange, but the meat of our session comes from being there and doing it. We have read the best practices, but until you see how different settings impact the servers and the performance, the understanding just isn’t complete.
John: “Thunderstruck” by AC/DC – This too probably sounds strange, but that song just seems to always gets folks pumped up and moving. It usually reminds me of one of many movies where the good guys are about to beat the snot out of the bad guys. And given that Chris and I will be beating the snot out of some performance issues, I think it’s very fitting. Plus, what better way to get the energy flowing than with an awesome classic song like “Thunderstruck”!

Q: Chris, what excites you most about solving performance problems?
I think the best part is when I make a client’s day all that much better. When I’ve been a full-time employee and there have been performance problems and stress that surrounds that situation, being part of the solution has a lot of satisfaction associated with it.

Q: John, what's the most surprising statement attendees might hear you say during the pre-con?
That's a good question. I'm a firm believer that there is a time and place for any solution in SQL Server, so the attendees might hear me say that it's alright to shrink a database or that cursors are acceptable or that scalar user-defined functions serve a purpose. All of these (as well as others) can play a part in just about any solution. The trick is to know and understand the ramifications of using them, which in turn allows you to make an informed decision about your solution.

Q: Back to you Chris: What’s the biggest designing-for-performance myth that you’d like to debunk?
Not all performance issues can be resolved by throwing more hardware at them. Granted, there are times when you can fix performance issues with hardware. However, eventually bad design is just that – bad design, and adjusting the design may get you a much better performance gain than going out and buying new hardware.

Q: John, what still trips you up in the real world when trying to implement the fastest solutions?
Simple, sometimes everything. SQL Server is such a huge platform that it's very easy to forget one thing or another. This is why I'm always reading articles, blogs, whatever. I'm always trying to learn.

Q: And for both of you: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Chris:
I was going to answer something very tangible such as taking a baseline or setting up index maintenance, but really what I would want attendees to come away with is the ability and the skill to work through an issue with confidence. Each environment has differences that make it unique; the answer of “it depends” fits because of all these differences. When attendees walk out the door, I want them to know how other SQL Server DBAs make decisions.
John: I would agree with Chris in that I would want attendees to be able to tackle any solution with confidence and realize that there is definitely more than one way to accomplish a solution within SQL Server.

Check out our other Q&As with PASS Summit 2014 pre-con speakers.


PASS Summit 2014 Pre-Con Preview: Grant Fritchey

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, Grant Fritchey gives us a sneak peek at what to expect from his pre-con, Query Performance Tuning in SQL Server 2014.

Q: If your pre-con had a theme song, what would it be and why?
"More Human Than Human" by Rob Zombie. I picked this song because I think a lot of people are going to walk out of the session feeling like they’re ready to conquer the world, or at least tune a few queries.

Q: What excites you most about finding and fixing poorly performing queries?
Well, the business answer is that I’m improving the efficiency and reliability of our systems to better supply our customers with access to the information they need to make good decisions. But the nerd answer is that I really enjoy figuring out what’s going wrong and finding ways to improve things.

Q: What's the most surprising statement attendees might hear you say during the pre-con?
I’m going to tell them to not use some of the functionality within SQL Server. Flat out. It’s too dangerous and there are few, if any, requirements for this piece of functionality that are not satisfied elsewhere with zero danger.

Q: What’s the biggest myth around query tuning that you’d like to debunk?
That throwing an index at the query fixes it. The problems most of the time are right there in the code. Yes, indexes are great ways to tune query performance, but adjusting the query itself is frequently the better way.

Q: What still trips you up in mastering SQL Server’s query optimizer?
Figuring out why I’m seeing something unexpected. When you get behavior you didn’t anticipate, there’s seldom a quick and simple solution. I have to dig through the properties in the operators, same as everyone else.

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Maintain your statistics better. I don’t think people realize just how vital they can be to ensuring that your queries run well.

Check out our other Q&As with PASS Summit 2014 pre-con speakers.

PASS Summit 2014 Pre-Con Preview: Robert Cain, Bradley Ball & Jason Strate

Sept. 15, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. We caught up with Robert Cain, Bradley Ball, and Jason Strate to learn more about their pre-con, Zero to Hero with PowerShell and SQL Server.

Q: If your pre-con had a theme song, what would it be and why?
Robert:
 "Can't Stop Rockin'" by ZZ Top, because once you start rocking with PowerShell, you can't stop.
Bradley: "Timber" by Pitbull and Ke$ha. There’s a lot of tasks in the DBA/BI world that PowerShell makes easy. The bigger they are, the harder they fall.
Jason: "Come Sail Away" by Styx, because as I've told others, the boat for learning PowerShell has sailed, and it's time to get everyone up to speed on it.

Q: Robert, what excites you most about using PowerShell with SQL Server?
The incredible diversity of tasks you can automate using PowerShell. Everything from DBA tasks to BI to development can be automated using PowerShell with SQL Server.

Q: Bradley, what's the most surprising statement attendees might hear you say during the pre-con?
Sometimes PowerShell’s a better ETL tool than SSIS.

Q: Jason, what’s the biggest myth around learning PowerShell that you’d like to debunk?
PowerShell isn't for everything. It's a tool for the chest, but it isn't a magical hammer that can take care of everything. Knowing its capabilities will help you use PowerShell where it fits, while providing an understanding of when using it is like cleaning a window with a sledgehammer.

Q: If attendees could start putting into practice just one thing after your pre-con, what would you want that to be?
Robert:
Using PowerShell to explore their SQL Servers to get quick answers to common questions.
Bradley: Making their lives easier by using PowerShell to automate time-consuming tasks.
Jason: It bears repeating: PowerShell is sometimes a better tool for ETL than SSIS.

Check out our other Q&As with PASS Summit 2014 pre-con speakers.


 

PASS Summit 2014 Pre-Con Preview: Adam Machanic

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.


 

PASS Summit 2014 Pre-Con Preview: Itzik Ben-Gan

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.


 

Microsoft Jim Gray Systems Lab’s Rimma Nehme Keynoting at PASS Summit 2014

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 specific 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

PASS Summit Session Selection

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 program@sqlpass.org 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.

Previous Reason  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 program@sqlpass.org.
– Amy Lewis
Director of PASS Programs


 

PASS Summit: Already Setting Records

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:

    • Beginner
    • Big Data
    • Cloud
    • Hardware/Virtualization
    • High Availability/ Disaster Recover
    • Performance
    • Power BI
    • Security
    • 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