Benjamin Nevarez Rotating Header Image

SQLSaturday

Speaking at 24 Hours of PASS and SQL Server Connections

clip_image001

I can’t believe I haven’t posted anything in my blog in months. Just after getting back from the PASS Summit 2011 I got involved in several SQL Server projects and I’ve been really busy since then. By the way, I just recently saw my first article published in SQL Server Pro (formerly SQL Server Magazine). The article, “Improve the Performance of Data Warehouse Queries with Columnstore Indexes”, can also be seen online here at the SQL Server Pro website. Also, just a few days ago I was selected as a 2012 Idera ACE so I am really excited to be part of this team. In addition, I will be speaking at some SQL Server events this month.

First, I will be presenting a session at 24 Hours of PASS, which is a free event with 24 consecutive SQL Server webcasts and it is scheduled for March 21st. My session, Improving the Performance of your Data Warehouse Queries with Columnstore Indexes will be the last session of the event and it is scheduled for 4:00pm Pacific Time. This edition of 24 Hours of PASS will feature close captioning in 15 different languages and you can still register here.

Three days after 24 Hours of PASS I will be presenting four sessions at our local SQLSaturday #120 in Orange County, CA. SQLSaturday #120 will be held at the Goldenwest College in Huntington Beach on March 24th and will include many great speakers like Grant Fritchey, Kendra Little, Jeremiah Peschka, Denny Cherry, Lynn Langit, Audrey Hammonds, and Carlos Bossy, just to name a few.

Just after SQLSaturday #120 I will be headed to Las Vegas, NV to participate on my first SQL Server Connections conference. The Spring 2012 edition of SQL Server Connections will run from March 26th to 29th and will host one of the SQL Server 2012 launch events. I will be presenting my session Top 10 Query Optimizer Topics for Better Performance on Thursday afternoon.

As always, I look forward to meeting lots of SQL Server professionals on these events.

Speaking at the PASS Summit and other Southern California events

I am currently working on the two sessions that I will be presenting at the PASS Summit: Inside the SQL Server Query Optimizer and Parameter Sniffing: the Query Optimizer vs. the Plan Cache. In addition, I will be presenting these two new sessions in other SQL Server events in Southern California including SQLSatuday #95.

First, I will be speaking at the Los Angeles SQL Server Professionals Group on Thursday September 15th. The meeting will be hosted at the UCLA Anderson School of Management and will start at 6:30 PM. I will present only one session, Inside the SQL Server Query Optimizer, in this meeting. You can find additional information about the meeting and directions on their website.

Two days later, on September 17th, I will be speaking at SQLSaturday #95 in San Diego, CA. Of course, this SQLSaturday will also have many other great speakers and the final schedule is already posted here. In addition to presenting both of my sessions described before I will be participating in the Ask the Experts – SQL Server Q&A session coordinated by Thomas Mueller. For more details and directions for SQLSaturday #95 please go to their website here.

On October 7th I will be presenting my Query Optimizer session at the Orange County SQL Server Professionals User Group in Mission Viejo, CA. Details and directions will be posted soon on their website here.

Then it is time for the PASS Summit, the largest SQL Server and BI conference in the world. The PASS Summit is hosted again this year in Seattle, WA and it is scheduled for October 11-14. The schedule for my two sessions is not final at the moment of writing this but so far it looks like I will be speaking on Wednesday and Friday.

I am flying back from the PASS Summit on Saturday and planning to present my two sessions at the SoCal Code Camp the following day, Sunday October 16th. The SoCal Code Camp is a community driven event for developers to come and learn from their peers. At this moment they are still accepting sessions so no schedule has been created yet. You can register, find additional information and directions on their website here.

Finally, although I am not going to be speaking, I will be attending SQL in the City in Los Angeles, CA on October 28th. SQL in the City is a one day SQL Server training event which will include several SQL Server MVPs and you can look at their site here for more details and information.

I look forward to meeting lots of SQL Server professionals on these events.

SQLSaturday 73 Recap

This is yet another late review of SQLSaturday 73 which I had to postpone writing a couple of times before. Same as last year, this SQLSaturday was hosted at the Golden West College on Huntington Beach, California so I was already familiar with the place. Different than last year event, fortunately this time I was able to attend the speaker dinner on Friday night which was hosted at the Acapulco restaurant in Costa Mesa, just a few minutes from Huntington Beach. I had a great time at the dinner meeting event organizers Andrew Karcher (@akarcher) and Thomas Mueller (@tmspecial), some of the local speakers like Denny Cherry (@mrdenny), speakers which I usually only meet at the PASS Summit like Denise McInerney (@denisemc06) and Meredith Ryan-Smith (@coffegrl) and meeting new people like Carlos Bossy (@carlosbossy) who was traveling from Denver, Colorado.

The day of the event I left home very early in the morning as Huntington Beach is about 75 minutes from my place up north at Santa Clarita and the traffic is sometimes unpredictable but fortunately arrived to the event on time for registration and get some coffee. I saw many familiar faces helping as volunteers for the event and I spent some time talking to some of them before heading for the first session of the day. I was planning to attend as many sessions as possible but since I was also presenting on three of them that proved to be very difficult.

The event was scheduled to run six sessions simultaneously and for the first round I briefly attended Clint Kunz’s session “Microsoft Business Intelligence All Up” and later Randy Knight’s “Become Bilingual! Oracle for the SQL Server DBA”.

Then it was time for my first presentation of the day, “Top Query Optimizer Topics for Better Performance”, which was the same session I presented at the PASS Summit 2010 and, at the moment of this writing, I’ve presented a total of nine times (and I’ve just found that I will be doing this session again at SQLSaturday 83 for Johannesburg, South Africa too!). Actually, since I presented some of these sessions on local user groups and code camps I was afraid that the people interested may have seen the session already and decided to attend other sessions instead. Fortunately attendance was really good as you can see on the picture below. I finish my first session by giving away a copy of my book Inside the SQL Server Query Optimizer.

clip_image002

After my presentation I attended the only entire session I would be able to see that day and actually one that I was very interested in. It was Ted Tasker’s “Parallel Data Warehouse – Architecture Overview”, an excellent session describing PDW massively parallel processing (MPP) architecture designed for data warehouses of dozens or hundreds of terabytes.

Sessions during lunch was a new addition to the event this year and during this time I attended part of Bob Abernethy’s “BI: Then and Now” session and later I hang out at the speaker room for a last review of my next presentation, which I was presenting for the first time. The only other lunch session available was “Women in Tech: Encouraging the Next Generation”, hosted by Denise McInerney.

My second presentation was just after lunch and the topic was “Partitioned Tables and Indexes: Management & Query Processing”. As mentioned, this was the first time I was presenting it and I think it went really well, which I was able to confirm by looking at the speaker evaluations later. I finished the session by giving away another copy of my book.

From my session on partitioning I quickly ran to another room for the SQL Server Panel discussion where I was participating too. The Panel was coordinated by Thomas Mueller and included speakers Lynn Langit (@llangit), Ike Ellis (@EllisTeam1), Denny Cherry, Bret Stateham (@BStateham), Andrew Karcher and myself. Topics included discussing our favorite new features of SQL Server Denali; advantages and drawbacks of SQL Azure, features that you would like to see in a future version of SQL Server, favorite third party tools for SQL Server, among others. There were also some topics based on questions from the attendees.

After the SQL Server Panel discussion I went to the speaker’s room again and was able to meet a few more of the speakers including Harold Wong. I also attended part of Denny Cherry’s “Index Internals” session. SQLSaturday concluded with a raffle where attendees got books and prizes donated by sponsors. The after-party was at Michael’s Sports Pub and Grill located just a few minutes away from the Golden West College where I was able to meet a few more people including Mark Ginnebaugh (@markginnebaugh) who was traveling to the event from the San Francisco Bay Area.

In summary this was amazing SQLSaturday and I had a great time there. All I can say is I am ready for the next SQLSaturday here in Southern California.