July 2014 Vegas UG Meeting

Categories: News, Professional, SSSOLV
Tags: , ,
Comments: No Comments
Published on: July 9, 2014

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.

BIO

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.

LiveMeeting Info

Attendee URLhttps://www.livemeeting.com/cc/UserGroups/join?id=BSG34W&role=attend

Meeting ID: BSG34W

SQLSaturday Vegas Style

Comments: No Comments
Published on: April 3, 2014

sqlsat295_web

We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas, Nevada.  Can you feel the excitement building?

The SQLSat 295 team has been working hard to bring together what we think will be a great event.  From the volunteers, to the speakers, to the vendors, and most importantly to the attendees.

las-vegas-nv2

If you are in Vegas or nearby, we welcome you to come down and check out what we have for you.

This event will be held Apr 5 2014 at The InNEVation Center, 6795 Edmond St., Las Vegas, NV 89118.

Where else do you get an open invitation to learn about SQL Server for free combined with what Vegas has to offer for entertainment?

Just remember, what is learned in Vegas doesn’t have to stay in Vegas.  But what happens in Vegas is up to your discretion.

sqlsat295_tokes

Locks, Blocks, and Deadlocks Oh My!

Categories: News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: February 12, 2014

Picture0001

Abstract

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.

BIO

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.

LiveMeeting Info

Attendee URL:

https://www.livemeeting.com/cc/UserGroups/join?id=9KSDPD&role=attend

Meeting ID: 9KSDPD

January 2014 S3OLV and Tabular Models

Categories: News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: January 9, 2014

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.invite

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.

single_car

 

Or maybe you are just too busy trying to find the right pair of speakers for your car at CES 2014.

carwbeats

 

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.

12 Days of Christmas 2013 Day 1

Comments: 21 Comments
Published on: December 25, 2013

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar series this year.  Over the next 12 days, I will share short tidbits on an array of topics.  The tidbit may be a tip to help with SQL Server, or it could be an announcement that is SQL related.  As an example, the announcement could be a short bit of information on how to get SQL training.

las-vegas-nv2

To kick things off, there is a pretty cool announcement from the Desert.  Down in Vegas we have been working pretty hard to bring some free SQL learning to the area.  And we have finally done it.  The inaugural SQL Saturday in Las Vegas is confirmed.

sqlsat295_web

 

The first SQL Saturday in Las Vegas is to be held on April 5, 2014.  You can register for the event and submit presentations via this link.

It was great to hear that we could get the venue on a good date.  The people at InNEVation are stoked to have this event in their building.

Many thanks to the Stacia Misner and Pat Wright for pulling this together.

SQL Claus and BI at S3OLV

Categories: News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: December 9, 2013

tree

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.

Invite

January S3OLV 2013

Tags: , ,
Comments: No Comments
Published on: January 9, 2013

I hope you are ready for some free SQL learning.  Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar opportunity to do just that – Learn!

Edwin Sarmiento will be presenting for us this at the upcoming monthly Las Vegas User Group meeting.  Edwin has chosen (well he left it up to me to decide) to present on Powershell.

Title: Windows PowerShell for the SQL Server DBA

Abstract

Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell. In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.

Here is the bonus behind all of this – we will be broadcasting the presentation to the virtual sphere.Here are the details for joining the meeting via livemeeting.

Copy this address and paste it into your web browser:

Copy and paste the required information:

 

September Events

Categories: Corner, News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: September 4, 2012

Wow, I can’t believe it is already September of 2012.  Labor day has come and gone, school is in session and the SQL Community is still busy.  With that, I am trying to be a bit busier within the community.

September is already bringing us some good things.  Just this morning I read some excellent news from the people at SQLSkills.  They have teamed with Pluralsight to bring even more SQL Server goodness to the community.  Paul, Kimberly and crew are providing tons of video training materials through Pluralsight.  You can get all the skinny from their announcement on the matter.  This is an opportunity you probably should not pass on.

Next up is a little thing called SQL Saturday.  The one in particular that I am talking about is happening in Rhode Island.  September 15 is the date and all day is the time.  This is the 156th installment of this free training event.  I have two sessions that I will be presenting.  One is on Table Compression and the other is on SSRS for us mere mortal DBAs.  You can discover a bit more information about that from the SQL Saturday site, here.

As a part of that SQL Saturday there are a bunch of presentations that I hope to get to.  Unfortunately, many are at the same time so seeing them all will be a bit of a problem.  I am looking forward to at least chatting with a few other presenters (like Jeff Moden, Grant Fritchey (Twitter), Wayne Sheffield (Twitter), Jack Corbett (Twitter), Mike Walsh (Twitter), Aaron Bertrand (Twitter), Andy Roberts and Mike Corey (Twitter)) while there.  Yes, it looks to be a very good cast coming up on September 15th.  With such high class presenters as Grant, Aaron and Wayne presenting at the same time as me in the afternoon though, I will probably have an opportunity to catch a session then though ;) .

Also coming up this month is a special SSIS workshop in Las Vegas by Brian Knight and company.  While he is in town, he will be presenting to the Las Vegas User Group called “SQL Server Society of Las Vegas.”  The date on that is September 18th.  Details can be found in meetup, here.

Those events pretty much cover the month of September from coast to coast and practically worldwide (at least virtually).  Check them out.  I hope to see you at the minimum at one of these events.

August 2012 S3OLV Meeting

Tags: , ,
Comments: 2 Comments
Published on: July 30, 2012

Well well well.  It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group.

We have had to cancel a couple of times in the past few months – but the meetings have been happening with or without the blog post about it.  I have been a little more occupied with a few other things (like the book).  But we are back (at least for a little bit) in the saddle!

Here are the meeting details in case you are not on the mailing list.

Next Meeting
August 09, 2012 6:00-8:00pm PDT

Jason Brimhall
Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments. He is currently a DB Architect and an MCDBA. He is he VP of the Las Vegas User Group (SSSOLV). Jason is also the co-author of the book “SQL Server 2012 T-SQL Recipes”
You can read more about the book here: SQL Server 2012 T-SQL Recipes 

SQL 2012 Table Compression
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

LiveMeeting Information:
Attendee URL: https://www.livemeeting.com/cc/UserGroups/join?id=FQS7BW&role=attend
Meeting ID: FQS7BW

Location:
Still meeting at M Staff Solutions & Training / 2620 Regatta Drive Suite 102 Las Vegas, NV 89128

S3OLV – Get your Merge On

Categories: News, Professional, SSC, SSSOLV
Tags: ,
Comments: No Comments
Published on: February 7, 2012

We are rapidly closing in on the February meeting for S3OLV.  You might remember reading about the upcoming meeting here.

We are looking to have an excellent meeting this month.  We have had a good run on superb presentations, and Troy aims to keep us going in the right direction.

Troy will be teaching us how to use the Merge statement.  He will help us to learn how this statement can help improve our queries.

We will also continue our ugly code segment.  Bring your ugly code.  Send your ugly code to admin at s3olv dot com.  We are doing this segment in an effort to have the group help each other and learn from each other.  Honestly, it is also an effort to help drive up group interaction.

Here is the information for the meeting.

Date: February 9, 2012

Time: 6:30 PM Pacific

Virtual Meeting Info

Attendee URL: https://www.livemeeting.com/cc/UserGroups/join?id=H3ZGRQ&role=attend

Meeting ID:  H3ZGRQ

Physical Meeting Info

M Staff Solutions & Training / 2620 Regatta Drive Suite 102 Las Vegas, NV 89128

«page 1 of 5




Calendar
July 2014
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
28293031  
Content
SQLHelp

SQLHelp


Welcome , today is Wednesday, July 30, 2014