Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave a BIG mark.
That’s right, this last weekend was SQL Saturday in Sacramento Ca. You might have seen my announcement about it here.
This event had a lot of Unique flair to it. Besides having Jason Horner (blog | twitter) in attendance, the committee thought it wise to provide all of us with these little trinkets.
That happens to be a branding iron. I have inverted it in this picture for readability. We received these speaker gifts at the speaker dinner the night before the event. That is pretty normal. What was different about this speaker dinner is that it was in a volunteers backyard and was a barbecue. Yes! There was fire! Yes, we had implements of pain! And yes, there were many jokes flung about during the evening. If you were wondering, the first person to put his branding iron in the fire and to brand something was indeed Jason Horner.
Yes! This event left a BIG mark!
All the seriousness aside, there were some great presentations. I was a bit disappointed to not be able to see the presentation about parameter sniffing by Benjamin Nevarez. But I found my way into other presentations that made up for it.
If you haven’t already, congratulate the SQL SAC crew for their new youtube channel. While you are at it, don’t forget to thank them for a great event.
For my first event traveling west, this was a memorable one.
Coming up this week is the Vegas UG meeting. Keith Tate has been gracious enough to accept our speaker invitation and will be presenting.
The meeting will be held 10 July 2014 at 6:30 Pacific. Location and time details can be found on our meetup page.
Keith Tate is a Microsoft Certified Master in SQL Server 2008 and a Senior Database Administrator with over 14 years of experience as a data professional. During Keith’s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.
The Curious Case of Isolation Levels
Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
Attendee URL: https://www.livemeeting.com/cc/UserGroups/join?id=BSG34W&role=attend
Meeting ID: BSG34W
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States.
This marks the first time for me to present at a SQL Saturday so far West. From where I live, I have had to travel East for every SQL Saturday so far. This should make for a fun and interesting new experience.
This event is in Sacramento on 12 July 2014. It will be held at the following address.
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833
The fun stuff
When I take a look at the schedule I see some pretty interesting sessions. One session of note is by Kalen Delaney (blog | twitter). I have never heard Kalen present – ever. In the same room is Benjamin Nevarez presenting on parameter sniffing. Since his session is right before hers, I will probably just be hanging out in there for the morning.
The third session of the day poses an interesting dilemma. I could go watch a session I have never seen before, or I could go watch a session by any of the other four presenters knowing I have seen all of those sessions. Dilemmas, dilemmas.
In the afternoon, there are two sessions that really caught my eye. There is a session by Ami Levin about physical join operators (cool topic) and then this other session about Extended Events. I really hope to make it to that XE session. I hear there might be some surprises in it.
I hope to see you at the event. If you are there, find me and say hi. Maybe we can even chat for a bit.
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Randy Knight, MCM, is an IT professional who has worked with Microsoft technology for over 20 years, focusing on SQL Server for the last 16. He has worked in a variety of settings, including 6 years as a Database Architect for Match.com, one of the largest and most successful dot-coms. He is currently the President and Principal Consultant for SQL Server Solutions Group LLC, a Utah-based SQL Server consultancy.
Meeting ID: 9KSDPD
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that everything is squared away, we have some great news.
If you are in the Las Vegas area, you are welcome to attend our monthly meeting which is now being held at the south end of the strip. This should put you a bit out of the way of the CES 2014 crowds – though you will probably have a fantastic time getting through the crowd.
Then again, maybe you just can’t peel yourself away from these types of things at CES.
Or maybe you are just too busy trying to find the right pair of speakers for your car at CES 2014.
Well good news! S3OLV holds the meetings in the evening and the main show at CES should be pretty close to wrapping up.
Come join us this month for a presentation by Julie Koesmarno. She hails from down under and is making time in her schedule last minute to help us out. You can read all about the presentation and Julie at our Meetup site here.
Guess what else you can do by visiting our Meetup site. You can find out about how we have changed venues to the South end of the Strip. That’s right, S3OLV has moved. We are now meeting at the Tahiti Village. Details of the location are in the meetup. Check it out.
Oh, and don’t forget. We still offer an online virtual meeting space for the user group just in case you can’t make it in person. Details for joining the virtual meeting are also in the Meetup page.
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this mini-series on quick tidbits:
- SQL Sat LV announcement
- Burning Time
- Reviewing Peers
- Broken Broker
- Peer Identity
- Lost in Space
- Command ‘n Conquer
As tradition would have it, this is the first day of the new year. This is the first day of 11111011110.
As tradition would also have it, the New Year also means that there was plenty of partying and reveling throughout the night leading up to and beyond the stroke of midnight. One such party was reported as having the largest fireworks show in history. Seeing some of the video and pictures – it was a spectacular show. Check it here.
If you are interested in some of the other worldwide events, here is a pretty good slideshow of some of those parties too.
Another tradition that comes with New Year’s day is the quarterly announcement for MVP renewals (or newals) from Microsoft. If you happen to know somebody that was recently announced has being an MVP for the next year – tell them thanks.