Category Archives: sql saturday

PASS SQL Saturday #356 Slovenia Recapitulation

So the event is over. I think I can say for all three organizers, Mladen Prajdić, Matija Lah, and me, that we are tired now. However, we are extremely satisfied. It was a great event. First few numbers and comparison with SQL Saturday #274, the first SQL Saturday Slovenia event that took place last year.

SQL Saturday #274

SQL Saturday #356

People

135

220

Show rate

~87%

~95%

Proposed sessions

40

82

Selected sessions

15

24

Selected speakers

14

23

Countries

12

16

The numbers nearly doubled. We are especially proud of the show rate; with 95%, this is much better than average for a free event, and probably the highest so far for a SQL Saturday. We asked registered attendees to be fair and to unregister if they know they can’t attend the event in order to make room for those from the waiting list. An old Slovenian proverb says “A nice word finds a nice place”, and it works. 36 registered attendees unregistered. Therefore, we have to thank to both, the attendees of the event and those who unregistered.

Of course, as always, we also need to thank to all of the speakers, sponsors and volunteers. All volunteers were very helpful; however, I would like to especially point out Saša Mašič. Her work goes well beyond simple volunteering. I must mention also the FRI, the Faculty of Computer and Information Science, where the event was hosted for free. It is also worth mentioning that we are lucky to live in Ljubljana, such a beautiful city with extremely nice inhabitants who like to enjoy good food, hanging around and mingling, and long parties. Because of that we could be sure in advance that both speakers and attendees from other countries would enjoy spending time here also outside the event, that they would feel safe, and get help whenever they would need it.

From the organizational perspective, we tried to do our best, and we hope that everything was OK for speakers, sponsors, volunteers, and attendees. Thank you all!

Some Thoughts on Event Speaker Selection

I write this from the perspective of experience. I’ve helped organize dozens of events over the past ten years. Feel free to take the parts of this advice that help and discard the parts that don’t. Enjoy! Planning an event is hard work. If you’ve never volunteered to help your local User Group or SQL Saturday, I encourage you to get involved. You will work hard and put a lot into it. But I promise you will get more out of it than you put in. Every organizer is free to organize their event in whatever…(read more)

PASS Summit Attendance “Advice”

Wow, it is fall again, and in a large percentage of the minds of SQL Community members, that means that the PASS Summit is here again. I have been to all of the Summits save the first one, and honestly it has become one of the highlights of my nerd year. I have learned a tremendous amount about SQL, made a lot of real friends, and gained a taste for travelling over the years, something I never did before I started making the yearly journey to the summit. This year, I decided not to put in to speak,…(read more)

PASS SQL Saturday #356 Slovenia Pre-Conference Seminars

I am proud and glad I can announce two top pre-conference seminars at the PASS SQL Saturday #356 Slovenia conference. The speakers and the seminars titles are:

Both seminars will take place on Friday, December 12th, in the classrooms of our sponsor Kompas Xnet. The price for a seminar is € 149, with early bird price at € 119. Early bird price is valid until October 31st.

I am also using this opportunity to explain how and why we decided for these two seminars. The decision was made by the conference organizers, Matija Lah, Mladen Prajdič, and Dejan Sarka. There was a lot of discussion in different social networks about PASS Summit pre-conference seminars lately. If you have any objections for our seminars, please do not start big discussions in public; please tell them to the three of us directly.

First of all, unlike at the PASS Summit seminars, the speakers are not going to earn big money here, and therefore it is not really worth spending much time and energy on our decision. We think that any of the speakers who sent proposals for our SQL Saturday could present a top quality seminar. We would like to enable seminars for every speaker that wants to deliver one. However, in a small country, we will have already hard time to fill up the two seminar we have currently. Our intention is to reimburse at least part of the money the speakers spent on their own for travelling expenses and accommodation. In our opinion, it makes sense to do this for the speakers that spent the most for the travelling. Coming here from USA is expensive, and it also takes three days in both directions. That’s why we decided to organize the seminars for the first two speakers from USA.

Of course, this is not the last event. If everything goes well with SQL Saturday #356 and with the seminars, we will definitely try to organize more events in the future, and invite more speaker to deliver a seminar as well.

Thank you for understanding!

SQL Saturday Dublin and Pre-Conference Seminars

One of my favorite events is just around the corner! It’s just a few days until SQL Saturday Dublin , Ireland’s largest SQL Server conference on the 19th/20th September, run as a community event by the SQL Ireland User Group. Have You Seen the Schedule? The schedule is complete with an amazing line up of speakers from around the world and you can download a copy HERE . Closer to the event we will be launching a mobile guidebook so you can plan your schedule on a mobile device. I’ll be doing my very…(read more)

SQL Saturday Birmingham #328 Database Design Precon In One Week

On *August 22, I will be doing my “How to Design a Relational Database” pre-conference session in Birmingham, Alabama. You can see the abstract here if you are interested, and you can sign up there too, naturally. At just $100, which includes a free ebook copy of my database design book, it is a great bargain and I totally promise it will be a little over 7 hours of talking about and designing databases, which will certainly be better than what you do on a normal work day, even a Friday. You can…(read more)

How In-Memory Database Objects Affect Database Design: Hybrid Code

In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote the on-disk code to only use features that worked in-memory. This lead to one majorly silly bit of code, used to create system assigned key values. How would I create a customer number that was unique. We can’t use the Max(value) + 1 approach because it will be very hideous with MVCC isolation levels, since 100 connections might see the same value, leading to lots of duplication. You…(read more)

Speaking on 7/25 for the Nashville SQL Server User Group: How In-Memory Database Objects Affect Database Design

So I have blogged about it, and I have prepared for it, and next Friday at lunch time I will be unveiling my new presentation. The location/other details can be found here: http://nashville.sqlpass.org/Home.aspx , but the abstract is: How In-Memory Database Objects Affect Database Design With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn’t that simple, internally everything that uses…(read more)

Conferences – 2nd Semester 2014

I am finishing my plan for conferences in the 2nd half of 2014. I think I will speak in most of them. Here is my list.

1. SQLBits 2014, July 17th-19th: high time to register, pre-conf seminars start in two days. I have an interesting pre-con seminar there – Advanced Data Modeling Topics. In addition, I have a session as well.

2. Kulendayz 2014, September 5th – 7th: I guess I will speak there. However, the most important thing there is to cool down:-)

3. SQL Saturday #344 Tirana, October 4th: Never been in Albania, looking forward to visit Tirana.

4. SQL Saturday #311 Bulgaria, October 11th: Visiting Sofia after many years. Nice people, good rakija.

5. Sinergija 14, October 20th – 21st, Belgrade, Serbia: Best barbecue. Besides great sessions, of course.

6. PASS Summit 2014, November 4th – 7th, Seattle, WA, USA: Can’t miss the most important community conference in the world.

7. SQL Saturday Ljubljana, December 13th, Ljubljana, Slovenia: I am co-organizing this event. Date reserved, call for speakers is going out soon. Consider coming – most of the session will be in English. Maybe not the best parties, but definitely the longest. Ljubljana lives all night.

Hope we will meet at some of these events.

Speaking this weekend at SQL Saturday 286 – Louisville

Wow, where does the time go? Hope I see every reader there in Louisville this weekend for a lovely time. Say you live in Alaska and it would be too far to go in one day? Hey, we all have our problems ( and don’t tell anyone, but I am going to try to finish up video versions of these sessions by the end of the year.. shh .) I will be doing my session on Database Design Fundamentals and How to Write a DML Trigger, both sessions I have done quite often of late, and I really like how they work now. I…(read more)