SQL Server, PASS, and other data mishaps
Allen Kinsel
This user hasn't shared any biographical information
Homepage: http://allenkinsel.com
Posts by Allen Kinsel
99 problems and the disk aint one
May 2nd
Its Meme Monday again and this time Tom has picked an interesting topic.
How many problems do we all see in our shops that arent related to disks? Since disk related issues would normally be my #1-10 I guess Ill have to start at #11
.
11. ESX misconfigurations
12. Old DBMS Version requirements from vendors
13. Bad DB design
14. Active Directory
15. Network connectivity/configuration
16. JAVA
17. Security architecture & design
18. Vendor Code…
19. Overly complex solutions to satisfy edge cases
This is my list of 9, What are yours?
Ill go out on a limb and tag 3 people
Lori Edwards, you havent written a blog post lately, consider this your invitation
PASS Summit 2011 Preconference meta details
Apr 26th
PASS Summit 2011 Preconference Session selection info
The other day I detailed as much info as I could about changes to this years session selection processes. The call for ALL Sessions at the Summit is officially open until May 5, 2011 that means we’re accepting abstracts for regular sessions as well as for the Preconference sessions.
Competition
For many of the more experienced speakers in the SQL Community the opportunity to give a full day highly technical session at the summit is attractive. Not only do they get to showcase their technical skills, they also get to showcase their own unique training style. Additionally, the pay isnt half bad either. Of course, most of these speakers will tell you that based on the amount of time needed to generate an all day session the pay is actually half bad, not half good
Requirements Change
For the past 3 years we’ve had a set of requirements in place that qualify speakers to present a preconference session, those requirements are looked at every year by a set of volunteers to make sure they are still valid and usually only minor adjustments are made. This year however I made a larger adjustment. In order to clarify the requirement that giving a precon requires you to also give a spotlight session, I added #11 to the list of criteria you should meet to deliver a precon. Since that is a gimme criteria, I bumped the total criteria needed to meet from 4 to 5
Improvements
After you’ve done your thing and submitted a terrific abstract for a precon session its up to us to try and be fair in the selection process for these sessions. Over the last few years we have tried many things to both open up the selection process and to open up submissions to a competitive process. There have been many ups and downs in this iterative process. Sometimes we do well, and sometimes… not so much. The point is that we’re always trying to produce a better process. I’m excited that hopefully this year we’ve ironed out a few more of the wrinkles we exposed last year.
Process Part one
After the Call for abstracts closes we are going to release a “preferencer” tool that we’re going to use to allow PASS Members the ability to communicate what their favorite sessions are. We’re going to use the data gathered from this tool to assist us in making the session selections. Additionally, we are tentatively going to use this same info to prepopulate your attendee schedule builder after the selections are made. I’d like to think we’ll be able to use the data from this tool in a 1-1 fashion where we take the top X precons per track and build the session schedule that way. In reality though, I expect we’re going to find several overlapping session subjects at the top of the list. I’m thinking things like 3 “indexing sessions” in the top 5 for the DBA track, or 2 Sessions from a single speaker for instance. We’ll need a a team to help make those decisions.
Introducing the team that will make the decisions
K. Brian Kelley Author/Blogger/Speaker Extraordinaire – A man with his credentials doesn’t need an intro.
Lori Edwards PASS Junkie, blogger, and all around pain in the … – I kid, Lori has been picking up all of the slack in the PASS Program committee, as well as participating in the PASS ERC
Me - Yeah, Im going to have a seat at the table this year. I havent participated in an actual abstract selection team in a couple of years so this should be a fun diversion.
In building this small team, I’m expecting that there wont be a heck of a lot of “work” to do. I’m really expecting that we will be able to rely mainly on the members preferences but I wanted to have insurance in case there was more to the selection than simply relying on preferences.
The multiple similar session problem
In the past one dilemma that Ive been looking for creative ways to solve goes something like this.
“If I specialize in Architecture for SQL Flux capacitors and Veteran speaker XYZ always presents a precon on SQL flux capacitor architecture how will I ever get chosen for a precon”
This year, I’m hoping that with the membership showing which sessions they’d like to see if a particular topic has an apparent huge interest, we can potentially give 2 precons on a similar topic (1 on Monday, and 1 on Tuesday). The way the tool is being built, we should get good data about which precons a group of people would most like to see. I dont know if this will work or not but, its a small enough risk that I cant see why we wouldnt at least try to see what the data tells us.
After thinking about the data this tool should generate, I wonder where I can find a good data analysis person to volunteer and tell me what it means. Maybe I should ask someone in the community for help with that before mucking it up myself *hint*
PASS 2011 Summit Abstract Submissions
Apr 11th
This week we’ll be launching the call for abstracts for the 2011 PASS Summit.
I thought it would be good to go over the basics for this year especially since some things are changing from years past. Many of the changes are minor, some are behind the scenes so to speak, and a small amount are larger and more public facing.
A New Site
PASS HQ and the Program Committee team has been diligently working to bring the summit speaker/education management programming inhouse. With this effort comes a new site for abstract submissions. We hope this new site will make the abstract submission process easier and more relevant to collecting the info PASS needs in order to facilitate session selections.
A New Process
One of the largest changes on the backend process this year is going to be seperating the speaker review from the abstract review piece of the selection process. Essentially, this year we have two seperate teams to do each task. This came about from the comments of previous review team members as well as the need to offload some of the work the call generates for the larger teams. Im hopeful that this change will help bring a little more stability to the scores each team gives an abstract as well as cut some of the subjectiveness (likely only a tiny bit)
A New Session Type
I wrote previously about having 1/2 day sessions at the Summit and they are still planned. Now you know where to bring your best and brightest content! In case your thinking what it would be like to have your 1/2 day session recorded, Ive got great news. Ive got a tentative compromise devised. This year we will be distributing two seperate DVD sets, 1 for attendees of the Summit which will have every session. Another for non attendees that will have all of the regular sessions excluding the deep dive 1/2 day sessions.
Spotlight Sessions & Invitations
Thanks to some great feedback last year The formula that we used for spotlight selections was adjusted and looks like this: We will invite all speakers who recieved an overall evaluation of 4.5 or greater and had at least 15 attendees and 15 completed evaluations. We will be excluding Lightning talks, Chalk Talks, and Microsoft speakers. This year that leaves us with a whopping total of 27 people getting spotlight invites. These speakers are truly spectacular, and they deserve the extra recognition/time for their sessions. All abstracts submitted as spotlight will be considered not only for a spotlight slot but, will also be considered for a regular session if they dont get picked for a spotlight session.
Preconference Changes
I would be remiss to not mention this here but, some different things (changes!!) are planned for this year, as soon as I get a chance to finalize them a bit more I will write about it, hopefully in the next few days to a week.
Abstract Limits
We have decided to change the limits on abstract submissions a bit for this year. We will be encouraging you to submit up to 4 total : Regular, 1/2 day and Spotlight (if invited) Sessions. In addition if you meet the qualifications you can submit up to 2 Preconference sessions. On top of this each person can submit 1 panel (discussion type) session for consideration. In order to do this each speaker in your panel will need to have speaker details entered so we can rate the session properly. This in itself is a pretty good sized change so get creative and see what the selection teams think!
But when
I can hear you asking from here… “All of thats great but, when will the call for abstracts for the 2011 PASS Summit open?” I have great news.
The call will open this Wednesday! 4/13/2011
look for more info coming officially from PASS
How deep can you dive?
Mar 24th
After last years Summit we launched a feedback site http://feedback.sqlpass.org in hopes of gathering all of the feedback about the event in one place. The number one thing people have asked for on that site is for there to be a track of sessions in the 400-500 level range. The problems with the community desire for higher level sessions are twofold, one we dont normally get a huge number of session submissions that are at the 400-500 level. Two, I’ve been told by those who are qualified to present those types of sessions that an hour and fifteen minutes (spotlight) is often not enough time.
Cramped for space
In the past our conference size has dictated the floor-plans at the conference center and we’ve been maxed out at 14 concurrent sessions. This year however, because of anticipated attendee growth, the logistical geniuses at PASS HQ were able to add another session room (I’m looking at you Anika and Craig). With this new room I have options on what to do with the extra session rooms!!
Changes for the Summit 2011
This year we’ll be using the space we gained from the new room addition to have longer deep dive sessions. The current idea is to offer these longer sessions in hopes that they will attract presenters who are qualified to present these deeper dive sessions. Currently, the plan is to have a maximum of 6 deep dive (lvl 400 or 500 only) 3 hour sessions. Because of the way the schedule is laid out, we will run 2 of these sessions concurrently every conference day.
Rules… Yeah there’s always rules
We will accept abstracts for this new session type in the same manner as a regular abstract. That is to say anyone can submit a half day abstract. If you submit an abstract for a 1/2 day session it will count as one of your 4 allowed abstract submissions. The session selection for these sessions will be handled by the regular respective abstract review teams. Even though we are going to allow anyone to submit abstracts for these sessions, it should go without saying that if you don’t have prior experience or reputation for being able to give an extended, strong 400-500 level session it may be best to focus on a regular summit session. What I mean by this is for these particular sessions we will be instructing the review teams to weigh the speakers perceived ability to deliver the session higher than we normally would for a regular session.
Possible Hiccups i.e. Changes
Two things could change with these sessions.
- I am considering making the sessions 4 hours long (roughly 3 regular session slots). If we do that the maximum number of sessions would drop to four. I’m leaning heavily away from this but, if anyone has a strong opinion on this I’ll listen
- Depending on the quantity and quality of the abstracts we receive, we may have less than the maximum sessions shown above (4 or 6)
- Im still considering a single DBA 101 “Accidental DBA” type session for one of these sessions but havent been swayed that there is more interest there than there is in deep dives
PASS Resources Revealed
Mar 17th
What has PASS been up to?
Ever find yourself with tons of extra time just looking for something to dig through?
yeah, me neither… But, I do make it a point to go out and read through lots of PASS documents regularly. Sure, Some of those documents are not for public consumption but, a large portion of them are available for any PASS Member to view. Almost all of them will require you to be logged in to the PASS site.
A good starting point is the PASS Governance Page <- lots of good stuff hides on this page, Im working on getting this page removed from behind the login wall
PASS BOD Meeting Minutes are posted on the left hand side
The Feb 2011 Minutes are here
- Good discussions in here about Globalization of PASS, especially revolving around events
The Jan 2011 Minutes are here
- This was an in-person meeting and there is a literal ton of info in here. Highlights are globalization, Summit 2011 Planning, Summit 2010 Post mortem, 5 Year plans, Bylaw Changes
PASS Monthly Reports are found in the middle on the left
These are gems that reveal the day to day inner workings of the BOD and HQ
The Feb report should be posted in the next day or 2
The Jan report however, is here
- In here You’ll find things about Chapters, IT Projects, Marketing initiatives, ERC info, Sponsorship Sales, Summit Program, SQLRally, Gloablization, etc
The Dec report is here
- This one contains things like Chapter info, HQ Finance, IT Projects, Marketing, Summit, Rally, 24hop, SQL Saturday,
The budget for PASS is included at the bottom of the governance page
2011 Budget is here
- Wanna know where the money is supposed to be coming from, and where its supposed to be going? this is where to look.
- Side note: Im going to check into where the 2010 audited financials are, they should be available by now.
The SQL Rally has posted all of the planning meeting notes posted here
- There is tons of good stuff in here, its especially interesting to me to watch the minutes back and forth dealing with very familiar problems as what I’ve seen in the Summit program group.
- Wanna know how many attendees are registered so far for the Rally? yup its in there. Wanna know how many are in Precons? yup its in there too
We (PASS Program) started posting meeting minutes near the lower left side of this page
- I have written about these minutes before
- Good information in here about many new changes that are being considered by the Program Committee
- Essentially It says that I’m not getting nearly enough done for the program committee lately. I need to work on that!
- Im including this here because lost of good stuff gets posted here but, for me I can only find it since its in my RSS Reader.
In Summary, PASS releases a ton of information about what its doing. The problem with this is two-fold, one its a ton of information. Two, the information is spread out all over the place and is often difficult to find on the site using conventional browsing methods so I hope this helps

