So the title says it all, right? Well, only really partially.
Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part the title doesn’t say. It is really important to understand that we are talking about the top 10 recommended books for SQL Server.
The beauty of the top 10 list is that I have a book on that list. It caught me by surprise. That is very cool.
If you are interested in finding a book, I recommend naturally that you check out my book. But just as importantly have a look at the list. This was a list that was published independently by SQL Magazine. On the list you will find books by people like Kalen Delaney, Itzik Ben-Gan, and Grant Fritchey.
Check out the original list, here!
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.