Category: PASS Community Summit

PASS Summit 2015 Community Sessions

June 26, 2015--Have you heard the news? We’ve announced the speakers and session lineup for PASS Summit 2015 – and we think it’s the best one yet! Each year, the Program Team has the difficult task of choosing sessions from amongst a wealth of wonderful submissions. I want to tell everyone who submitted this year how much we appreciate the support and dedication of this community.

How We Choose

The program-selection process is a continually fine-tuned process designed to help ensure a fair, objective, and well-balanced program. Program Committee volunteers are assigned to review abstracts, speakers, or PowerPoint decks. Each team has specific duties that help ensure the integrity of our selection process. Scores and ratings are used to determine the top sessions from each track, and we used these to fill the community session slots. We look for a balanced track that contains sessions that represent all the key topics across a variety of skill levels and without a great deal of duplication. We also look for a good mix of both seasoned speakers and new voices. Still have questions about the process, we have a helpful FAQ you page you can refer back to. 

This year, 67 of our volunteers reviewed a total of 886 abstracts. Of those submissions, 20% were chosen for our community sessions, representing 52% of the speakers who submitted. 28% of those speakers will be speaking at PASS Summit for the first time!

Next Steps

Now that the community sessions have been selected, the next step is to open the Microsoft call for speakers. We’ll work with Microsoft to make sure that these submissions complement the community sessions; stay tuned for these sessions to be announced in August.

We’ll also begin constructing learning paths to make it easier for attendees to choose between sessions.  As always, we welcome your feedback on any step of this process.  
Finally, we will work to build the schedule, including partnering with Microsoft and the Program Committee Special Project team of volunteers to utilize data science to predict session attendance and schedule sessions into the appropriate sized rooms and timeslots. You can read more about the success of this additional process last year in Dev Nambi’s blogs: PASS Attendance and Summit Feedback

A Big Thank You 

Once again, thank you to all who submitted—and to all the volunteers who worked so hard these past few months during the selection process, particularly our Program Team Managers Lance Harra, Mindy Curnutt and Angela Henry. 

We can’t wait for you to dive into the lineup for this year’s PASS Summit, the premier event by and for the SQL Server Community. Help us spread the word, and don’t forget to register by July 12 to save $400 on registration—plus contact your Local or Virtual Chapter for an additional $150 savings! See you in Seattle!

– Amy Lewis
PASS Director of Programs


PASS Town Hall Q&A Webcast

June 18, 2015--The second quarterly Town Hall Q&A webcast took place on May 27, with more than 70 people in attendance. Thomas LaRock welcomed the audience and spoke about how the Board is continually looking at facilitating two-way communication within the community and how to contact the Board on the SQL PASS website. Before kicking off the session, Thomas introduced the panel:

    • Denise McInerney: PASS VP, Marketing (and moderator)
    • Amy Lewis: PASS Board Director at Large, Programs
    • Jennifer Moser: PASS Board, Microsoft-related questions
    • Lance Harra: Lead Program Manager, PASS Program Committee

With a focus on the Summit Speaker Selection process, the one-hour long webcast included an overview from myself (Amy Lewis, PASS Board of Director at large, Programs) on the process and timing from this year’s committee along with a considerable number of questions from the attendees for the Program Committee and the Board.

I thanked the panel and the program committee team and then summarized the committee’s processes for speaker selection.

In late January or early February, the Program Committee conducts a Call for Volunteers. Volunteers play a critical role in evaluating abstracts and helping to select community speakers. A total of 70 volunteers work together from mid-March until Summit. After the Call for Speakers closes in mid-March, the volunteers are broken into four teams:

Speaker Review Team: This team of eight volunteers review credentials, experience, and past attendee feedback to qualify speakers. This year, a total of 285 people submitted abstracts for Summit 2015, and the team goes through and rates each possible speaker. After all scores are submitted, the Speaker Review Team provides the Program Managers with the rankings.

Abstract Review Team: This team is tasked with reviewing the 886 abstracts submitted by the 285 potential speakers. Abstracts are reviewed by a minimum of three people. The team is divided into smaller teams for each of the five learning tracks and review accordingly. Feedback is given to every single abstract. The abstract review team first rates the abstract (without any speaker information or speakerID). After the teams have rated all the abstracts, they are tasked with ranking the abstracts for each track and recommending sessions to the Program Development Team.

The Program Committee offers guidance on the need for diversity of topics and speakers. At the outset, each speaker is assigned a speakerID number to maintain anonymity during scoring. Scorers can see whether they have ranked or recommended multiple abstracts from the same speakerID within a particular track, but they don’t know who that speaker is. This provides the team enough visibility to evaluate sessions and speakers for balance.

Program Development Team (Program Managers/Director): From May until the beginning of June, the program is built. The contributing factors include:

    • Rankings and recommendations from the individual teams
    • Topic, speaker, and session level
    • Repeat sessions from prior year
    • Session types (Pre-cons, Lightning talks, Half-day sessions, General sessions, and Labs)
    • Duplicate sessions
    • Depth and breadth of sessions across all tracks

After the Program Development team builds the Program, submitters are notified of their session status and, as of last year, are sent feedback on their abstract. After all submitters are notified, the community sessions are announced publicly by the end of June.

Special Project Team: From July onwards, the Special Project Team looks at the learning paths, predicting room assignment to ensure that rooms are not overcrowded and improving the schedule builder to be useful to both attendees and PASS Summit Operations teams.

Microsoft Sessions: Around early August, the Program Development Team works with Microsoft to understand what it wants to present and to ensure there is no overlap between Microsoft and the community sessions. This partnership has led to a more cohesive program where both the community and Microsoft sessions build upon and complement one another, leading to a fantastic and well-rounded program.

The Program Team is always open to feedback and ways to improve the Selection Process and the PASS Summit Program. We received feedback over the past year, and some of those changes were implemented this year:

    • In the process to review abstracts and the workflows for the team leads, all abstracts across all teams are now reviewed by at least three people.
    • The speaker profile was updated to allow for the submitter to list all their PASS and non-PASS presentation history. We are also working with IT to incorporate a lot of the SQLSaturday, Virtual Chapter, and User Group speaking events. We have been waiting until the rebuild of the SQLSaturday site is completed so that we can incorporate that functionality automatically. We wanted to be sure speakers could do that this year so we have implemented a table where you can add your speaker history. We added the video review, which was a request from the Speaker Review Team, so we can see samples of people speaking.
    • Improvements to the speaker resource page included updating the handbook, adding an FAQ page, and improving the process for the team leads.
    • Finally, the Program Team has improved the communication with the team leads through weekly calls and is working closely with PASS HQ and IT. Marcella and Leeza at PASS HQ were recognized for their support and commitment.

Amy introduced Lance Harra and explained that he has volunteered with the Program Team for 10 years and this year was promoted to Lead Program Manager.  In addition, Mindy Curnutt and Angela Henry have joined the Program Management Team to lead all the Program-related efforts throughout the year.

With an overview of the team and their responsibilities complete, the Q&A commenced with questions from the community. The full recording is available here. Look for more information about the next Q&A on the Board Contact Us page and in the Connector as we head into the next quarter.

Amy Lewis
PASS Board Member, Programs

PASS Programs Team Leverages Data Science for Attendance Predictions and Feedback Rating

December 17, 2014 – This year, Data Scientist and PASS volunteer Dev Nambi joined the Programs team to help with PASS Summit 2014 sessions scheduling and predictive analytics. Over the past month, Dev and the team have been digging into the data from both session attendance and session feedback, and we wanted to share the findings with the community.

In this first year of doing prediction for attendance, we saw a variety of results, including the reduction of overcrowded sessions. Dev details the results and provides a link to the raw dataset in his blog post PASS Summit Attendance and Predictions. With the lessons learned from our debut effort, we will continue to improve on and incorporate prediction models into our Summit scheduling process.

Dev and the team also examined Summit 2014 session evaluations. This year, we saw a 14.8 % return rate of evaluations from attendees, and we’re looking at ways to increase that number. Despite an increased possible margin of error based on the decrease in responses, we appreciate all the session evaluation feedback we received from attendees and are taking key findings into account as we start planning next year’s Summit. To view the correlations and rankings, please see Dev’s analysis in Say Anything! PASS Summit Feedback and Ratings.

A big thank you to Dev for the time and effort he spent analyzing and compiling the attendance prediction and session evaluations data. Thank you also to Summit attendees for using the Schedule Builder to help with attendance predictions and to the entire PASS community for your feedback. Moving forward, PASS Programs will continue assembling, sharing, and using this information and data analysis to help make the Summit experience the best it can be. If you have any comments or input, please don’t hesitate to email program@sqlpass.org.
– Amy Lewis
Director, PASS Programs

PASS Summit 2014 Pre-Con Preview: Brian & Devin Knight

Oct. 16, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. We caught up with Brian and Devin Knight for a quick chat about their pre-con, SSIS: Problem, Design, Solution.

Q: If your pre-con had a theme song, what would it be and why?
Devin:
I’d go with Kenny Loggins – “Danger Zone” because it’s an awesome song and so is our pre-con!

Q: What excites you most about working with SQL Server Integration Services?
Brian:
I like the logic problems. Each package you build is like solving a puzzle that has a dozen ways of solving it. 

Q: What's the most surprising statement attendees might hear you say during the pre-con?
Devin: “Okay, now everyone line up for the ceremonial Knight brothers pre-con hug.“

Q: What’s your favorite SSIS transform and why?
Brian:
The Swiss Army knife of any SSIS developer is the Script Transform. When you can’t do something in a native or third-party component, it’s time to whip out a script. We should cover about a dozen different patterns of how to use these in our pre-conference session. 

Q: What still trips you up in the real world when scrubbing duplicate data?
Devin:
Using Regular Expressions to scrub data has always been something that has thrown me, because it feels very unnatural to write coming from a SQL Server background. Luckily, there are plenty of resources such as http://regexlib.com/ to help!

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Devin:
I find that the package restartability section of the pre-con has a lot of content that’s often overlooked but that can be extremely useful for recovering from failed package executions. I think people skip these steps because most people don’t plan for their packages to fail.

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


SQLSaturday at Summit: Q&A Panels, Website Sneak Peek, and More

Oct. 14, 2014  Hello, PASS Community! It seems like it was just a couple months ago that we were meeting up for PASS Summit 2013 – I can’t believe it was actually a year ago. I’m looking forward to seeing you all again in person in Seattle next month.

As part of our Summit agenda, we always dedicate time to meet with our community organizers, including Chapter and Virtual Chapter Leaders, Regional Mentors, and SQLSaturday organizers. As Director of the SQLSaturday portfolio, I wanted to share some of what we’ll be discussing around SQLSaturday on Community Day at Summit, which is Tuesday, Nov. 4, as well as in the Community Zone throughout the week.

Kicking off the annual SQLSaturday Round Table will be a Q&A with the SQLSaturday leadership team, consisting of myself and our passionate Community Evangelists, Karla Landrum and Carmen Buchman. You can review the agenda here, and please bring all your questions and suggestions. We’re following up this year with some activities that go even further in supporting PASS’s mission statement:

Empower data professionals who leverage Microsoft technologies to connect, share, and learn
through networking, knowledge sharing, and peer-based learning.

We'll be hosting a new panel featuring some of our most experienced SQLSaturday organizers from around the world sharing their knowledge and tips and tricks for putting on successful events.

We’ll also be reviewing exciting updates to the SQLSaturday website, coming your way by the end of 2014. Working from your SQLSaturday website wish list – which we’ve cultivated over the past few years – as well as with a Community Focus Group, we’ve taken your feedback and ideas and put a great amount of time and consideration into building a more functional and modern web experience for SQLSaturday organizers and attendees alike. We can’t wait to show off the current version at Summit. You can find a list of all the wish list items that we’re integrating into the next SQLSaturday website here. We’ll also be emailing it along with a full Round Table meeting agenda to all SQLSaturday organizers for review in advance.

In addition, PASS Community Evangelists and SQLSaturday organizers from around the world will be available in the Community Zone Wednesday-Friday to answer all your questions – whether you’re looking for a SQLSaturday to attend or want to learn how to host one yourself. Check out the Community Zone Spotlight schedule to see when to stop by and meet with organizers from your area.

Our team is working hard to make these meetings as informational, transparent, and successful as possible, so we can quickly answer your questions, respond to any issues or concerns, and spend more time discussing how we can improve our future events. As owner of the SQLSaturday portfolio as well as a PASS Director-at-Large, I can’t wait to connect with all our passionate SQLSaturday organizers, volunteers, speakers, and attendees, share what we’re doing today to enhance everyone’s experience, and learn how we can better support SQLSaturday efforts around the world.   

Don’t forget to wear your favorite SQLSaturday shirt Wednesday at Summit, and I’ll see you in Seattle!
– Tim Ford
PASS Director of SQLSaturday


 

PASS Summit 2014 Pre-Con Preview: Allan Hirt

Oct. 7, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. We spent a few minutes with Allan Hirt to learn more about what to expect in his pre-con, The A to Z of Availability Groups.

Q: If your pre-con had a theme song, what would it be and why?
Tough choice, but thinking about it, maybe “La Villa Strangiato” by Rush. Besides the obvious if you know me, it’s an instrumental that starts off deceptively simple, but gets really complex and furious at times. I think it’s appropriate. AGs are deceptively simple, but in reality, not at all once you really start looking under the hood.

Q: What excites you most about Availability Groups?
It takes the best bits of a few different things and mashes them into one. That creates certain challenges, but that’s part of the fun.

Q: What's the most surprising statement attendees might hear you say during the pre-con?
If you don’t understand Windows Server failover clusters, you will fail at deploying AGs. 

Q: What’s the biggest myth around AGs that you’d like to debunk?
A secondary replica can be under-powered. That is completely false. 

Q: In the spirit of A-to-Z: What are some first words you’d like to say about AGs? How about a statement to leave attendees with?
First words: The Availability Groups feature is NOT AlwaysOn. AlwaysOn is not a feature.
Last words: Plan your deployments well, and you will be very successful with AGs.

Q: If SQL Server pros could start putting into practice just one thing after this pre-con, what would you want that to be?
I'd like them to understand things like networking, storage, and Windows Server failover clusters so they will have better deployments of AGs.

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


PASS Summit 2014 Pre-Con Preview: Davide Mauri

Oct. 7, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this Q&A, Davide Mauri gives us a quick look at his pre-con, Agile Data Warehousing: Start to Finish.

Q: If your pre-con had a theme song, what would it be and why?
“One Vision” by Queen. The data warehouse is all about having one, coherent vision of all company data and information.

Q: What interests you most about the Agile approach to data warehouse design, testing, and implementation?
It gives results quickly, and everyone involved in it, from developers to managers, get excited because they start to understand the strategic importance of the data warehouse. As a result of being able to quickly get insights, they start to use it to democratize the information in the company, really changing how decisions are made and ultimately making the process much more efficient and based on “real” data, not just intuition or, worse, suppositions. This is the era of data-driven decisions, and the data warehouse is one of the backbones of that.

Q: What's the most surprising statement attendees might hear you say during the pre-con?
That the only thing that will remain constant is that requirements will always change. I’m quite sure that many will also be surprised to learn that there is no product or model or tool that can make you Agile. Agile is a mindset, and thus the most important thing is to start to think that way. Everything will become natural after that first step.

Q: What’s the biggest myth around the agile process that you’d like to debunk?
I have two: The first myth is that the data warehouse is now obsolete, and with Big Data tools like Hadoop and In-Memory technologies, one can live without it. It’s really an important myth to debunk, because a data warehouse is not only a physical container, but is the place where people expect to find correct data. It’s a sort of metaphysical concept that alone can change how decisions are made within a company. 

The second myth is about tools that enable you to become Agile. As I noted earlier, this is another myth I’ll try to debunk.

Q: What still excites you in the real world when using Agile data warehousing principles?
I love to see the huge impact a good BI/DWH solution has in a company. And I love even more to see the faces of managers used to waiting for weeks or months to have a new business requirement put into production when I tell them, “OK, you’ll have it in a couple of days.” It’s like being a superhero… except they don’t allow me to go to their offices wearing a blue and red spandex suit. :)

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Automation. I’ll show attendees how they can automate up to 66% of data warehouse creation. This really changes the game because it allows you to support frequent changes and move in the direction of becoming Agile.

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


PASS Summit 2014 Pre-Con Preview: Adam Jorgensen & John Welch

Oct. 7, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this preview, Adam Jorgensen and John Welch take us inside their pre-con, Big Data: Deploy, Design, and Manage Like a Pro.

Q: If your pre-con had a theme song, what would it be and why?
Adam and John: "
The Imperial March" (Darth Vader's Theme) – Big Data is going to take over the world.

Q: Adam, what excites you most about helping attendees unlock the potential of Big Data?
I want to help them understand that they already work with data, big and small, but now they have tools to help them be more agile and proactive in their design and approach to this analysis.

Q: John, what's the most surprising statement attendees might hear you say during the pre-con?
There's no such thing as unstructured data. A lot of people associate Big Data with unstructured data, but really, all data has some sort of structure. If it didn't, it would be useless. It's more a matter of when and how the structure is applied to the data.
 
Q: Back to you Adam: What’s the biggest Big Data myth that you’d like to debunk?
That it has to be "Big" – size doesn't matter‏. The tools work regardless of the data size and offer new ways to work with any size of data.

Q: John, what still trips you up in the real world when designing, deploying, and managing Big Data solutions?
Staying on top of the options available. Relational databases are relatively stable at this point, in terms of the fundamental technology and approaches. Given a specific problem, there are generally known, proven approaches to solving it. Big Data is still rapidly evolving, and both the technologies available and the approaches are changing as people try to solve new problems, or solve older problems better. 

Q: If attendees could start putting into practice just one thing after this pre-con, what would you both want that to be?
Adam and John: That they can start working with these technologies today, with minimal investment, and leverage existing skills while learning new ones.

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


PASS Summit 2014 Pre-Con Preview: Kalen Delaney

Oct. 7, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this preview, Kalen Delaney gives us a sneak peek at what to expect from her pre-con, In-Memory OLTP Internals: How Is a 30x Performance Boost Possible?

Q: If your pre-con had a theme song, what would it be and why?
“It’s a Whole New World” (music by Alan Menken and lyrics by Tim Rice) because it IS a WHOLE new world – a completely new way to think about data and data management. And it’s almost like magic. :)

Q: What excites you most about In-Memory OLTP?
The most exciting thing is the potential for orders of magnitude performance increases with a very gentle learning curve.

Q: What's the most surprising statement attendees might hear you say during the pre-con?
If I told you, then it wouldn’t be a surprise!

Q: What’s the biggest myth around In-Memory OLTP that you’d like to debunk?
The biggest myth is that In-Memory OLTP is not really all that different from what we’ve had before or that it’s just a new implementation of the old DBCC PINTABLE.

Q: What still trips you up in the real world when working with concurrency issues and trying to implement the fastest SQL Server solutions possible?
The biggest thing that trips me up is thinking people really understand the dangers of using NOLOCK when they don’t. They use it anyway! So with In-Memory OLTP, they’ll never even have the inclination to use NOLOCK.

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
I hope that people will decide to give In-Memory OLTP a try and, in a test environment, start converting some of their performance-critical tables to memory-optimized tables to see how easy it is and how much difference just a tiny change can make. 

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


PASS Summit 2014 Pre-Con Preview: Marco Russo

Oct. 6, 2014 – Go inside PASS Summit 2014's full-day pre-conference sessions in this Q&A series with our presenters. In this preview, Marco Russo shares some of what you’ll learn in his pre-con, Data Modeling in SSAS Tabular.

Q: What excites you most about the SSAS Tabular model?
It is simple to learn how to create an SSAS Tabular model, and is very fast and powerful at the same time. You can achieve great performance goals on a large volume of data, even with complex calculations involved. 
 
Q: What's the most surprising statement attendees might hear you say during the pre-con?
Forget the traditional way of modeling data, worrying about the size of each data type. Now you have to think about data distribution.

Q: What’s the biggest DAX myth that you’d like to debunk?
Even if we won't talk too much about DAX (there is DAX-specific pre-con on Tuesday), I will quickly show that DAX is more similar to SQL than to MDX, whereas some BI developers still think the opposite is true.

Q: What still trips you up in the real world when creating and implementing Tabular data models?
The lack of a great DAX Editor!

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
I'd like them to quickly map their relational model into a Tabular model; they can get their first complete Tabular model up and working in less than 1 hour.

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