Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

Category: PASS General

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.


PASS Summit 2014 Pre-Con Preview: Paul Randal

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, Paul Randal shares some quick tidbits from his pre-con, Performance Troubleshooting Using Waits and Latches.

Q: What excites you most about using wait and latch statistics to investigate performance problems?
It provides one of the easiest ways to get an idea of what's happening with a poorly performing workload and can help avoid a lot of wasted time when performance troubleshooting.

Q: What's the most surprising statement attendees might hear you say during the pre-con?
It depends. :-)
 
Q: What’s the biggest myth around waits and latches that you’d like to debunk?
Probably the worst myth out there is that if you see a lot of CXPACKET waits, you should set your instance MAXDOP to 1.

Q: What are a few of your favorite wait and latch types?
SOS_SCHEDULER_YIELD, PAGELATCH_UP, and WRITELOG.

Q: If attendees could start putting into practice just one thing after this pre-con, what would you want that to be?
Using sys.dm_os_waiting_tasks to immediately see what's happening on a SQL Server instance.

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

PASS Summit 2014 Pre-Con Preview: Erin Stellato & Jonathan Kehayias

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, Erin Stellato and Jonathan Kehayias give you a sneak peek at Everything You Never Wanted to Know about Extended Events.

Q: If your pre-con had a theme song, what would it be and why?
Jonathan:
“Let It Go” from Frozen, because we are all going to eventually have to let SQL Trace go. I'm surprised I even thought of that, I'm generally not someone who would think about a theme song.
Erin: Jon and I both have daughters, one year apart in age – his answer is perfect. :)

Q: Erin, what excites you most about working with Extended Events?
The flexibility of it. You have the ability to do so much more – compared to Trace/Profiler – when capturing data that it gives you better insight when you're troubleshooting a problem or just trying to understand what's going on inside SQL Server.   

 Q: Jonathan, what's the most surprising statement attendees might hear you say during the pre-con?
I still use Profiler and Trace some times. Old habits die hard, even after writing 400+ pages of content on Extended Events since 2008.
 
 Q: Back to you, Erin: What’s the biggest myth around using Extended Events that you’d like to debunk?
That Extended Events are difficult to understand and figure out how to use. Before the UI in 2012, I admit that they were not intuitive. But between the UI and the approach we take when teaching, I think people will see how easy XE is to grasp and immediately start using.

Q: Jonathan, what’s your favorite advanced XE troubleshooting method that isn’t possible with Trace?
I would say collecting a memory dump and callstack information for a specific error or event occurring one time, and one time only, to minimize impact to the system over previous methods.
 
Q: If attendees could start putting into practice just one thing after this pre-con, what would you both want that to be?
Replacing old methods of collecting data using Trace and Profiler with a new understanding of Extended Events and the UI in SSMS.

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


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.

Elections Blog Roundup

Sept 30 - If you’ve missed it, the PASS Board of Directors voted to extend the deadline for PASS members to be eligible to vote in this year’s elections. Catch up on the news and the community’s responses to the decision made by the Board of Directors:

What’s New at PASS Summit?

Sept. 30 – Every year, PASS Summit brings you an array of on-site activities and networking opportunities to make your SQL Server and BI learning experience the best one yet. This year is no exception, as we introduce new activities and refresh community favourites. Here are some of the exciting updates you can expect to see this November in Seattle:

SQL Around The World
In a new competition called “SQL Around the World”, attendees will have a chance to win prizes by meeting Chapter Leaders, Virtual Chapter Leaders and Regional Mentors from different regions. “SQL Around the World”, which will take the place of the Chapter Luncheon, is a great way to engage with fellow Summit attendees from all over the globe.

WIT Luncheon Keynote
The Women In Technology (WIT) Luncheon, sponsored by SQL Sentry, welcomes Kimberly Bryant, founder of Black Girls CODE, as its keynote speaker. Launched in 2011, Black Girls CODE promotes the under-represented female and African demographic in the tech industry. Kimberly will provide insight on the journey to helping women of color in technology, and answer questions from both the live audience & Twitter. This event will also be live-streamed for anyone unable to attend.

First-Timers Program
PASS Summit's First-Timers Program, sponsored by SolarWinds, helps first-time attendees connect with other attendees and learn about Summit and the PASS Community. This year, the First-Timers Program begins on Tuesday with an Orientation Meeting and Speed Networking event – choose between 1 of 2 sessions and get to know your fellow attendees!. Then Wednesday-Friday, join us for a selection of "Get To Know Your Community" sessions (see details in the session schedule) where long-term PASS members will share all you need to know about PASS, getting the most out of the week’s events, and the #sqlfamily.

Lightning Talks
While our three Lightning Talk sessions have traditionally been a mix of short, tidbit sessions from all different tracks, this year the Program team grouped the Lightning Talk sessions by track: DBA, BIA and AppDev/PD. Check out which Lightning Talks tracks suits your learning needs, and don’t forget to add them when you build your session schedule.

Speaker Idol
This year PASS Summit will host its first-ever Speaker Idol, with contestants vying for a session at PASS Summit 2015 by giving a 5-minute technical presentation in front of an expert panel of judges. For rules and information on how to register by Oct. 10 to be a contestant, see Denny Cherry's blog.

These are only a few of the activities and learning opportunities you can expect this year at PASS Summit. If you are attending, make sure you start building your schedules, and see how you can take PASS Summit home with you. Still need more reasons to attend PASS Summit? Check out our sneak peek webcasts of PASS Summit content!

See you at PASS Summit 2014!

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

New #SQLPASS Virtual Chapter Webcasts

Cross-posted from Brent Ozar’s blog.

By Brent Ozar
Sept. 30 – Want to learn more about what it takes to run a PASS Virtual Chapter? Want to volunteer to get one up and running? Or maybe you want to up the game for your local user group and start doing webcasts of local speakers?

Jen Stirrup is running a free Wednesday webcast series to get you started. She’s the Director of PASS Virtual Chapters, and she’s on the PASS Board of Directors. Click on the titles you’d like to register for:

Oct 8 (Wed) – Virtual Chapter Padawan, covering:

    • What is the difference between an organizer, panellist and a presenter? What can they do?
    • What’s the difference between Q&A and chat?
    • What do I do if attendees say that can’t hear or see?
    • What is the value of a tech check before we hold a VC, and what’s the best way to do it?
    • How do we record sessions and post them up to youTube? what is Go to Converter, anyway?
    • What’s the difference between GoToWebinar and GoToMeeting?
    • How can I tell if attendees are bored?
    • How can we use multiple screens?
    • And an open Q&A

Oct 15 (Wed) – Virtual Chapter Jedi, covering:

    • How do we do polls?
    • How do we do surveys?
    • Plan your webinar like a pro!
    • Can you include video in your presentations?
    • What about a blended event, where you have more than one presenter?
    • How can you help a nervous, first time presenter?
    • And an open Q&A

Oct 22 (Wed) – Virtual Chapter Management, covering:

    • Chapter Management console
    • Emailing your chapter
    • Updating the site
    • How do you get your sessions to appear on the PASS home page?
    • Using Time and Date announcer so attendees can check the timezone
    • Finalizing your session
    • And an open Q&A

Oct 29 (Wed) – Virtual Chapter Soft Skills, covering:

    • Marketing your Virtual Chapter (e.g., YouTube, Twitter, reddit)
    • Recruiting and retaining speakers
    • Sponsorship
    • Blogger help
    • And an open Q&A

 

For more information, check out Jen’s blog and follow @JenStirrup on Twitter.

PASS Board Elections Update: Protecting PASS Member Information

Sept. 27, 2014 – As many of you know, to help manage this year’s Nomination Committee (NomCom) and Board of Directors elections, PASS implemented a web-based online voting system called Simply Voting, one of the largest and most respected online voting solutions.

In response to questions about the security of member passwords in the voting process, we wanted to share how member passwords were communicated and authenticated between PASS and Simply Voting in June’s NomCom elections, as well as the steps taken to add SSO integration for Simply Votes and to add SSL certificates to all PASS websites to better secure member login information for this year’s Board elections and beyond.

To the best of our knowledge, no PASS member information has ever been compromised or misused by any party. However, protecting the integrity and security of PASS members’ information is paramount. With the steps we’ve taken to tighten security, explained below, we ask that all members take the opportunity this weekend while this information is fresh in your mind to update your password. With these changes, you can make your updates with confidence that your profile information is secure. 

SSO Integration for Voting
In our initial implementation of Simply Voting for the NomCom election, we used the system’s standard security option, which prompted the voter for his/her PASS username and password. Simply Voting then passed those credentials via SSL to PASS for validation and at no time stored the voters’ login information.

Simply Voting is certified with TRUSTe, the same certification used by websites such as eBay, Apple, and those of other retail giants. And while the standard Simply Voting implementation is faster and easier for organizations to deploy and the single link to the ballot is more straightforward for voters, there is still risk – however small – associated with giving a third party access to login data.

During the NomCom elections, several community members contacted PASS about the process and expressed concerns about that risk. The PASS Board agreed with the community’s concerns and implemented the stricter single sign-on (SSO) security protocol with Simply Voting for this and future PASS elections.

In the updated SSO solution for the PASS Board elections, voters log in to sqlpass.org to access a personalized voting URL that redirects them to the ballot on Simply Voting. No external log-in is required.

IT updated the API with Simply Voting and made the necessary UI changes under myPASS to set up and display the voting URL to eligible voters. The extra effort was well worth it to ensure the security of member information. While we appreciate that Simply Voting is a TRUSTe certified vendor, the security of our members’ information is our utmost concern.

SSL Certificates for PASS Websites
However, we weren’t quite finished. Community members noted this week that we still had a security vulnerability because PASS’s website didn’t have SSL certificates installed. In the case with Simply Voting, a query string containing the username and salted hash (composed of the username and a system security passphrase) is passed from the PASS website to Simply Voting, which validates the information and allows the member access to his/her ballot. Without an SSL certificate to validate our website's identity and encrypt all information sent to and from it, that string is still viewable and potentially vulnerable.

Over the past 36 hours, the PASS IT team applied SSL certificates to the main sqlpass.org site, our event sites and VC/Chapter sites, as well as SQLSaturday.com (public and admin sites). This effort resolves both the Simply Voting query string issue and the issues our members have raised about overall login security on our sites themselves. 

For the peace of mind and security of all PASS members, and especially those who voted in the NomCom elections, we ask that you please take a moment to update your password if you haven’t already. Note that all member passwords are encrypted in the database.

We apologize for the oversight in not having SSL certificates implemented earlier and for the inconvenience this has caused.

Thanks to everyone who provided feedback on better securing PASS’s environment and member information, and please let me know if you have other questions or concerns.
– Adam Jorgensen,
PASS Executive VP, Finance and Governance