•  
  • Archives for Community (44)

May 2013 Las Vegas UG

Categories: News, Professional, SSC, SSSOLV
Comments: No Comments
Published on: May 14, 2013

Spring is in the air, I think.

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

Meeting Details

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

Meeting ID: KWRMQ3

 

Las Vegas April 2013 UG Meeting

Categories: Corner, News, Professional, SSC
Comments: No Comments
Published on: April 9, 2013

AlwaysOn – Finally, A usable ‘mirror’!

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic fail-over using a real web app to see how well this feature works.

 

Jim Murphy

Speaker photo

Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90′s. He is the President/CEO of SQLWatchmen, LLC., a managed DBA service provider for smaller companies who do not need a full-time DBA. He runs the Austin SQL Server User Group: CACTUSS Central and sits on the board of SQLPOSSE.com. He has been a professional DBA and developer for over 20 years and has run a consulting company full-time for over a decade.

LiveMeeting Information:

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

Meeting ID:834ZNP

March 2013 LV UG Meeting

Categories: News, Professional, SSC, SSSOLV
Comments: No Comments
Published on: March 11, 2013

Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area.

This month we will be getting back on schedule with the usual meeting time and place.  We had a slight divergence last month due to that heartsy holiday.

We are excited about some of the upcoming speakers and feedback we have been getting of late.  We are feverishly working to get some presenters on Big Data and Hadoop.  If you are in the market to present on these topics, ping me.

Here are some of the details for the meeting.


Presenting is Jason Kassay

Jason Will be presenting to us on the topic of “The Accidental Programmer.

Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who have to work with databases. How about the other side of the coin? What about DBA’s an Dev’s who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.

BIO

Jason has been a software developer for over 10 years and currently works at EZFacility, providing scheduling, management, full-service billing, and membership solutions for the sports, health, and fitness industries. He has worked primarily with .Net (C# and VB) and SQL Server as well as HTML, CSS, and Javascript. When he is not coding or spending time with his awesome family, you will find him either running (to train for the zombie apocalypse) or stopping hockey pucks as a goaltender.

 

LiveMeeting Information:

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

 

VERY IMPORTANT

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.
We are also moving to meetup for meeting management. Please join us for free at http://www.meetup.com/SQL-Server-Society-of-Las-Vegas/

Las Vegas February 2013 UG

Categories: Corner, News, Professional, SSC
Comments: No Comments
Published on: February 12, 2013

I know it is right in the middle of TSQL2SDAY when this post is to go live.  If you don’t know what that is, you should go check out this months edition here.  The topic this month is good and should drive up a lot of participation.

It also happens that this week we have a group meeting for the Las Vegas User Group. We normally meet on the second Thursday of each month.  It just so happens that this month that lands on the 14th of February.  If you can’t fathom why we changed our meeting date, maybe you should Google the date or something (just joking).

This month we have a first time presenter.  I have been bugging her for months to try to get her to come out of her shell to present.  And now she is doing it so be gentle and check out the meeting.

Presenting this month is Terrie White.  She will be presenting on Replication Technologies and High Availability solutions.

Here are some of the details for the meeting.

Presenting is Terrie White

Terrie White Will be presenting to us on replication technologies and high availability.

 

 

 

 

LiveMeeting Information:

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

 

VERY IMPORTANT

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.
We are also moving to meetup for meeting management. Please join us for free at http://www.meetup.com/SQL-Server-Society-of-Las-Vegas/

T-SQL Tuesday #38 Recap

Comments: No Comments
Published on: January 15, 2013

This is the wrap up for TSQL Tuesday #38.  We had a good turnout this month with some new faces and with some regulars.  In total, we had 22 entries.  All of the entries this month were very good.

The topic was on “Standing Firm” and can be found by clicking the image to the left.

Stay tuned to twitter for future TSQL Tuesday announcements and news via the #tsql2sday hash tag.

 

Rob Farley (blog | twitter) - Running Goals: In his opening paragraph Rob says “Peer pressure can be useful at times, but I also find that it can make me even more stubborn.”  WOW!  I can really relate to that.  Then he proceeds to recount a story from his past that would be hard for a lot of people to overcome.  I know I would have a hard time with not being able to lift my children.  Now Rob is running and plans to keep going and improving.  Excellent story!

Jim McLeod (blog | twitter) - Environment: Jim also decided to write about fitness and exercise, specifically cycling.  Jim ties planning into his goal to cycle more and stick with it.  Then he ties that into SQL Server.  ”Put together an environment that supports and encourages you to stick to your resolution.”  Plan ahead whether it be with certification or cycling, and not just for the happy times but for the rough times as well.

Thomas Stringer (blog | twitter) - Lucky 13:  Like many cross country runners, Thomas wants to hit it hard.  Then he wants to maintain the pace.  The principle is to set out to do something and build up a routine.  Routine becomes habit – and eventually becomes easier.  Thomas is setting out to learn something new every day.  That is a good goal.

Robert Davis (blog | twitter) - Disaster Recovery Resolutions:  This month Robert happens to be providing a month long series on Disaster Recovery.  In keeping with that theme, he has offered up several resolutions every DBA should make.

Koen Verbeeck (blog | twitter) - Resolving an SSIS Performance Problem:  Koen reached Defcon 2 (not really – but you should read it) when presented an opportunity to troubleshoot performance problems in an SSIS package.  The problem seems pretty typical – package works and then starts slowing down over time.  Part of the reason for that is due to four bullet points that Koen discusses.

John Sansom (blog | twitter) - Take More Ownership:  John hits on a big button in his contribution this month.  There are problems within our database environments.  Often times these problems are allowed to coexist.  While they cost time and money and raise frustration levels, how many times do we step up and offer a solution to the real problem?  It’s a good story – check it out.

Matt Velic (blog | twitter) - Stuck:  Matt is a thinker and he was stuck in a rut of late.  Matt enjoys thinking about decisions – a lot.  This was contributing to him being stuck.  He reveals some quick tips about how to get unstuck and to enjoy life just a bit more.

Steve Jones (blog | twitter) - Resolute:  Many people have a hard time standing up for what they want or believe.  They have a hard time saying “no.”  We sometimes joke about DBAs being a stop in the flow in work because we say “no” too much.  I think we probably do not say “no” enough.  And Steve points out plenty of ways that we need to learn to say no more often.  It is all about life balance.  How many times do you say “no” to a new project when you already have a full plate?

Julie Koesmarno (blog | twitter) - Tribute to Mum:  Julie, like her mother, is a WIT/Engineering.  We learn   about some of the personal life of Julie as she gives credit to her mother for being a role model as she grew up.  Now, Julie wants to help be an inspiration to others as her mother was for her.

Chris Fradenburg (blog | twitter) - Avoiding the Repetitive Mess of a Disaster:  Chris is the first of the first timers that participated this month (we had a few – woohoo).  Besides the bottle of gel soap that must be used every time he washes his hands, he is trying to improve his environment by reducing the manual repetitive tasks.  This is a good story about a disaster encountered on the first day on the new job.

Wayne Sheffield (blog | twitter) - Learning:  I did a fair bit of arm twisting to get Wayne to participate this month.  He was having a bit of writers block.  Then a topic fell into his lap and it should provide a month of writing for him.  Wayne discusses how is looking to learn and also provide a series of articles on PoSH to help others learn.  It should be out soon!

Alan Dykes (blog | twitter) - Solid Skills:  Alan is pretty much a self taught SQL Developer.  He has recently resolved to sharpen his skillset.  He learned from reading another post about how performance can vary by using a different tsql solution (e.g. NOT EXISTS versus LEFT OUTER JOINS).

Robert Pearl (aka Bobby Tables) (blog | twitter) - HealthySQL:  Some more arm twisting on this one.  Bobby has an excellent idea and it is something we should resolve to do every year as Data professionals.  Too often we get into the break/fix mode rather than the preemptive strike mode.  Regular maintenance (like you should do with your car) keeps things running longer and with less overall cost.

Hemanth.D (blog | twitter) – Firmness of Purpose:  Hemanth is the second of our first timers to participate this month.  Hemanth goes back and explores the past a little and how community ties in with the #SQLFamily.  Hemanth wants to be more resolute in the upcoming year when faced with an issue and ensuring the issue is resolved.

Mickey Stuewe (blog | twitter) – Spoons:  Mickey introduces us first to Neo and his effort at bending a spoon.  Then she correlates that to her writing ability.  For her to write is like trying to bend a spoon with her mind.  So she uses other tools to accomplish the goal.  She shared a couple of tools of which I think I will try the mind mapping tool.  That might mean some bizarre maps though.

Ed Watson (blog | twitter) – Speaking of Resolve:  Another first timer to the party (iirc), Ed shares his resolution to start speaking more at the local level.  Ed was more prone to flight than fight when it came to public speaking.  He talks about his experience and what he did in 2012 to start speaking publicly.

Jeffrey Verheul (blog | twitter) – Standing Firm:  Jeff had already planned out his goals by the time TSQL Tuesday rolled around.  After he had written some goals, he ran into a rough patch.  Based on that week, he has chosen to stand more firm and improve all that much more.

Ana Mihalj (blog | twitter) – Getting Involved:  Another warm welcome to another first timer.  Ana is from Bosnia and Herzegovina and has been working on blogging and getting involved in the community for the past year and a half.  Now she wants to step up her efforts.

Ken Watson (blog | twitter) – Not an Average Accidental DBA:  Ken shares a story on how he transitioned from a jack of all trades to being a DBA.  Ken is not enamored with being an average DBA and is working at something about which he is passionate.  He chased a dream and it is working out for him.

Tim Ford (blog | twitter) – Bring out your Dead:  You’ll get it once you read his post.  Tim is bringing back #Learn365.  If there were two themes this month it was exercise and learning.  Learn365 is right up that alley with learning.  Go check it out.

Chris Yates (blog | twitter) – Hoops and Databases:  We have a baller among us.  Chris talks about the resolve he had as a High School athlete to be a better ball player and make it to the Collegiate game.  That same resolve is applicable to being an Exceptional DBA.  Practice your craft and stand firm in your determination to be an Exceptional DBA.

My entry (twitter) – A Firm Foundation:  I shared a story that relates to disaster recovery and database consistency.  In that article, I also explored the immediate impact of changing the page verify for your database (plan cache).

 

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:

 

Fast Starts

Categories: News, Professional, SSC
Comments: 1 Comment
Published on: January 8, 2013

We are barely under way with the New Year and it is shaping up to be a busier year already.  Not quite as busy as has been published by the folks at Confio – but busy nonetheless.

The first thing up for me is to get my SQL Learn on.  I will be joining a bunch of geeks and some of their families for a week at sea.  Yes, you heard that correctly – at sea.

I will be SQLCruising out of Miami through the Caribbean.  This should be a good learning/relaxing SQLcation.  Yes Tim, I took a little liberty to add the water ripple to that logo.  Just getting excited to be on the water and rippling water helps.  It’s almost time to go pack for this trip.

Right after I get back from Cruising, I will be in Albuquerque for SQL Saturday 183.  I will be joining people like Steve Jones, Aaron Bertrand, Tjay Belt, Denny Cherry, Ben Miller and a host of other talented people.  You can see the schedule here.

Here is what I am thinking about attending.

Time Presenter Topic
8:30 AM Jeff Renz Data Vault Data Warehouse Architecture
10:00 AM Carlos Bossy Using Columnstore Indexes in SQL Server 2012
11:15 AM I will be presenting
1:45 PM Rob Mandeville Virtualizing our Environment
3:00 PM Michael Fal Exposing the Core: SQL 2012 on Server Core
4:15 PM Chris Shaw Outages: Dispatchers, Cops and Detectives

That brings us to early February.  At some point I expect to retake the Lab exam in February or March.  And then I expect to be presenting at a couple more SQL Saturdays within the next few months.

T-SQL Tuesday #38 – Standing Firm

Comments: 29 Comments
Published on: January 2, 2013

Introduction

Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community.  This is the party that happens on the second Tuesday of each month.  The party was started by Adam Machanic (B|T) just over three years ago.

Each month a new host selects a theme and announces it about a week in advance.  And this month I will be hosting.

Theme

To kick off the new year (2013), we must first adhere to a little tradition.  This is not a T-SQL Tuesday tradition.  It is more of an annual tradition for all to welcome the new year.  Feel free to click the link and sing along!!

Now for the theme.  A common thing for many people to do this time of year is to do a little self reflection.  Some set meaningful goals for themselves.  Fewer actually accomplish those goals or even follow-up after initially setting the goal.

We are not going to set goals as a part of this T-SQL Tuesday – unless you want to.  I want to take a little different spin on the New Year’s “resolution” tradition.  So the theme this month is “Standing Firm.”

The idea for this theme is to start with a little self reflection.  Then to come up with a story relating to one of these words: resolve, resolution, or resolute.  Here are some examples of how these stories may be portrayed.

  • Resolve:  A system outage occurred and you “resolved” it.
  • Resolute:  You made an executive decision and did not waver from it.
  • Resolution:  You discovered a bug and documented a work-a-round resolution for it.
  • Resolution:  You have discovered certain T-SQL skills are fuzzy and want to sharpen your ability in that area.
  • Resolute:  You are determined to improve performance in your application.

All of these words are very closely related.  It is up to you to determine how you would like to apply them to your T-SQL world.  Your experiences and stories can be loosely or tightly coupled to T-SQL, it is up to you.

And since the theme requires a little bit of self-reflection first, bonus kudos to those that can tie a past experience to a future plan.

The Rules

I know, parties are not supposed to have rules.  Sadly, all parties have some rules – you just may not know them.  These rules are very simple.

  1. Your post must go live between 00:00:00 GMT on Tuesday the 8th of January 2013 and 00:00:00 GMT on Wednesday the 9th.
  2. Your post has to link back to the hosting blog, and the link must be anchored from the T-SQL Tuesday LOGO (found above) which must also appear at the top of the post.
  3. Trackbacks should work. However, all comments and trackbacks are moderated, so give me a few minutes. If you think you waited long enough and still don’t see yours, leave a comment below.
  4. Tweet your post to the #TSQL2sDay hash tag.
  5. Have Fun writing and participating.

Follow these rules, and your post will be included in the roundup that will be posted on the 15th or 16th of January.

T-SQL Tuesday #36 SQL Community

Categories: News, Professional, SSC
Comments: No Comments
Published on: November 12, 2012

Community – What is it?

Community is something that is improperly defined with words alone.  Community is best defined through first person experience.  Community is a feeling and a sense more than it is a definition in “pick your dictionary here.”

So how do you experience this thing we call the SQL Community (or SQLFamily as we have dubbed it)?

Let’s examine that question next…

Experience the SQLFamily

The SQLFamily has been really good about putting itself out there and helping others.  If you use twitter you may have become acquainted with the #sqlhelp hashtag.  If you use twitter and participate in some of the discussions streaming nonstop from various corners of the family, you can see how quickly you might have been adopted into the family.

Still with the twitter theme, you might also see on frequent occasion something posted to the #sqlfamily hashtag.  Personal news might be posted to this hashtag from time to time.  In times of personal duress, the family comes together to show some strength.  Though not as tough as what others may have posted, I saw this first hand last year when away from the family on business and my daughter had an almond experience of the third kind.  You can read about that here.

Outside of twitter, the SQLFamily has been very progressive in getting more training out to the masses.  This training comes in the form of SQL Saturday and PASS Summit.  PASS Summit just wrapped up on November 9 and was a rather large family gathering.

At Summit, you may run into some princesses, some kilts, and maybe even some red lights along with all of those really big names that you see on twitter, the intertubes and so forth.  Here is a bit of what I mean (all pictures used with permission by Pat Wright (twitter) and can also be found on his flickr stream here).

From the Princess (Rumor has it she will be starting a blog soon.  This Princess has a name and it is Andrea Allred (twitter) ).

To a PASS Tradition – yes those are kilts.

Maybe even some flashing red lights (this might have been after SQL Karaoke)

And rounding it out with the Community Zone (I blogged about that here).  You might recognize some of the SQLFamily here (Tim Ford (twitter), Sarah Strate (twitter), Allen Kinsel (twitter), Louis Davidson (twitter) in far background to name some of them).

And this was all from the Emerald City of Seattle.  We will miss you next year Seattle as we visit Charlotte.

Community in the SQL world is not always about straight laced SQL and nerdery about the product we dearly love.  But it is about relaxing and having a good time with your friends too.  And when you are in this family – there are many friends.  The family is very open and accepting.  When they greet you, don’t be surprised if they attempt to hug you – it’s family.

Conclusion

Thanks to Chris Yates for hosting the TSQL Tuesday party this month.  You can read the original invitation here.  The rules for participation are in the invite.  Check it out along with anybody else that may have submitted an entry this month.

Summit 2012 Community Zone

Comments: No Comments
Published on: November 2, 2012

 

 

 

 

Will you be at Summit 2012?

I will be. I will even be pretty easy to find on multiple occasions.  If you haven’t seen my schedule already – you can check it out here. You’ll probably notice that there are a few times where I will be in a very public spot helping at a booth of some sort (like the Apress booth with my book).

There are two times that you will find me as a volunteer with PASS helping out in the Community Zone. What is the Community Zone you ask? Well, it is mostly a place were you can just sack out on the bean bags (I hope they are LoveSacs - they are sooo comfy!). Not just kidding – though you could relax on the bean bags if you wanted.

From the PASS Summit Community Zone page, the CZ is a place to help you stay involved.

Want to stay involved in the SQL Server community year-round? Check out the Community Zone at PASS Summit 2012 and talk with PASS Community Evangelists, user group leaders, SQLSaturday organizers, and other SQL Server community groups about how you can participate.

The CZ is also a place where you can get some swag or get your game card to have a chance at some cool prizes.

The game card is for a networking game that involves you talking to and meeting other people at Summit.  Here is the full description in the email sent to me:

Networking Game:  We will start handing out the cards at the CZ when it opens on Wednesday. The game is actually two parts.

a.       Meet 10 people from outside of the country where you live and learn something interesting about their country. They will be required to write these individuals names down, along with what they learned, and what country they are from. We will have “icebreakers” and networking tips listed on the back of the game card to help them out. Once they have all 10, their card will go into the raffle drawing, which will be held right before the BoF lunch in the Exhibitors Hall (our drawings will be immediately after the Exhibitor raffles are done)

b.      Part two, the spin-off game from the above involves pics. The attendee who manages to get the most pictures taken of themselves with the people they meet, will win top prize. If we have several who get all 10, then we will of course do a drawing. We want to encourage folks to bring their pics by often, so we can copy off and possibly use in slides before the keynote Thursday, but also so we can get them up to flicker. Social Media will also be doing some picture contests, as well as several other fun social media games. The Community Zone will also be on FourSquare among other HOT Summit spots!

c.       Now the prize details:

For the completed networking game card drawing, the first winner drawn will get their choice between a Surface tablet or a $250 Amex Gift Card. We will draw a second person for this first game, they will win a MSFT Arc Mouse.  For the picture contest portion of this, the first drawn winner will receive whatever the first winner didn’t select (either the tablet or the gift card).  And we’ll do a runner up to this game as well, who will also receive a MSFT Arc Mouse. Great prizes, don’t you think!

I don’t know about you, but that sounds like some pretty good stuff to win just for talking to a few people.

If that kind of networking game isn’t your cup of tea, there is still the opportunity to get some daily swag. Each day there will be various new activities tweeted or written on the boards in the CZ.  Go do that activity and you can get some swag.  Easy Peasy Lemon Squeezy – right?

So where is this Community Zone?  Glad you asked.  The CZ will be near the SQLClinic, Bookstore, Exhibit Hall and the Lunch Hall.  It is in the Skybridge on the 4th floor. Directly across from the CZ you will find the PASS kiosks.  I hope you are able to find it and come visit!

*PASS Summit logo is hosted by the PASS Servers and is merely present via a link to the PASS website.

page 1 of 5»
Calendar
May 2013
M T W T F S S
« Apr    
 12345
6789101112
13141516171819
20212223242526
2728293031  
Content
Now Reading

Now Reading

Planned books:

Current books:

  • SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

    SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach by Jason Brimhall

Recent books:

View full Library

Categories

Categories

SQLHelp

SQLHelp


Welcome , today is Sunday, May 19, 2013