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
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.
Tis the season once again. We have SQL gifts a plenty for any and all who wish to partake.
This month, we have Stacia Misner (twitter) that will be playing SQL Clause for the Las Vegas chapter of PASS. In this season of giving, it is nice to have a little SQL giving too. Then again, we get SQL giving all year long.
You can read all about the meeting and what Stacia would like to present to us at our meetup site. The link is here.
Besides the meeting, we have some news for the group. Stacia will also be assuming the role of President for S3OLV. Charley had a long run and started the group. Now Stacia and I will continue the group. If you see Charley, tell him thanks for everything he did.
Are you ready for some SQL?
If you are like me, you are probably almost always ready for some SQL. Well, we have just what you are hungry for – more SQL.
Thursday evening we have the distinct pleasure of having Bob Hovious present to the Las Vegas SQL User Group. If I am not mistaken, this is his first time presenting to a SQL audience outside of a work setting.
Bob is going to try and teach us about good design and proper datatype use. I think many a data professional could highly benefit from this type of presentation.
As usual, we will have the presentation available for those interested in showing up in person as well as those who can only attend via the virtual world.
Here are the details on how to attend.
With the Move to Meetup, All of the Meeting information (abstract and bio) is posted there.
The meeting location has changed. We will no longer be meeting at The Learning Center. New meeting location is M Staff Solutions & Training / 2620 Regatta Drive Suite 102 Las Vegas, NV 89128.
Spring is in the air, I think.
With that scent in the air, we have a nice juicy topic coming up this month for any and all that are interested.
Chad Crawford will be presenting to the group on the tastiness that is Service Broker.
Service Broker in Action
SQL Server Service Broker is a messaging framework built into the SQL Server engine. It enables SQL Server to handle messaging between servers and applications with light setup and overhead. The flexibility of the framework enables Service Broker to queue event notifications, task execution requests or other messages while leveraging the strength of SQL Server transaction management, reliability and recoverability. In this session we will see how to set up Service Broker, discuss case studies where it has been implemented in industry, and step through a practical example implementing an audit log.
Session Level: Intermediate
Chad Crawford’s BIO
Chad has been working with database engines for 14 years, the last 12 focused specifically on SQL Server. He has filled a variety of roles spanning architecture, development and administration. Chad is currently the Database Architect at Henry Schein Practice Solutions in American Fork. When he isn’t optimizing a query, you will find him running, dreaming about airplanes, or looking for a new strategy board game.
Attendee URL: https://www.livemeeting.com/cc/UserGroups/join?id=KWRMQ3&role=attend
Meeting ID: KWRMQ3