Tag Archives: SQLSaturday

Wheeling, WV to Dallas, TX? A SQL Saturday 56 Recap

Why would I travel from Wheeling, WV to Dallas, TX to speak at a free SQL Saturday? First, of all SQL Saturday’s in general are bleeping awesome. In a nutshell SQL Saturday is an all day multi-track, multi-session learning opportunity to learn SQL Server.  SQL Saturday #56 was was the first Business Intelligence SQL Saturday in the nation.  Second, I am blessed to have a great mother-in-law and father-in-law in Dallas and I enjoy hanging out with them so this was a huge bonus. Third, I enjoy connecting with people in the SQL Server Community so I can network and talk shop and see how we do things differently.

Facility & Logistics

First of all let me say this Pittsburgh we got gipped. Microsoft’s Campus in Dallas (yes campus not floor) was super cool. When I walk in the main door the first thing I saw was servers. You know I am a geek when I love the fact that servers are the first thing I see when I enter a business building. Anyways back to how the facility worked with the SQL Saturday event. The facility was a great fit for the 200+ attendees. There were several rooms that held 50 or more attendees and a gigantic room for the opening, main events and the end of day raffle. There were also some smaller rooms that brought everyone in closer and made for some good collaborative sessions.

Sessions

I attended Jen McCowen (twitter) SSRS from Ground Zero session and was very impressed especially when I found out Jen only had one day to prepare. I already know the basics in SSRS so I was really interested in picking up a few tips while I see how an experienced speaker gives an introduction session.  I really liked Jen’s style as she just dove straight into BIDS and went over key concepts you need to know to start using SSRS.  I also got to steal a few minutes after the presentation and see how she records her videos for midnightDBA.  For those out there who are interested in recording demos it looks like she uses Camtasia Studio and from what she showed me it looks like it’s not hard to use. More on camtasia a little later.

Another session I attended focused on evaluating use case personas for a new feature coming up in the next edition of SQL Server.  I really enjoyed this session because it basically was an hour group discussion about how we do things in our shop.   I would love to go into more details but I signed an NDA. 

My Session

I gave a talk on SQL Server 2008 for Developers.  Overall I think the session went well and I was glad to take part as a speaker.  The session was interactive as there were great questions from the audience.  I didn’t do a head count so I would estimate that there were about 30 attendees in the session. 

The host crew did a great job with speaker evaluations.  I even recieved my evaluations a few minutes after my session was complete.  In fact, I had a really helpful evaluation from an attendee who mentioned I should have went over Change Data Capture and MERGE in more detail and skipped the other features.   Being that this was a BI SQL Saturday I agree so I am going to evaluate Camtasia and see if I can record a video over these features and add them to my blog over the next two weeks.

Networking

On of my favorite parts of attending SQL Saturday is networking.  I was able to meet a lot of great people.  I apologize in advance as I am sure I am leaving some super cool people off this paragraph.  I meet Ryan Adams and had a great discussion about how he uses visual basic to perform actions on alerts with MOM for SQL Server. I also shared some information about our TFS configuration with Robert Crocker during lunch.  I also meet Thomas LeBlanc, Tim Mitchell, David Stein and had several great conversation in the speakers room and at the after party.

Other Posts

The following is a short list of other bloggers recaps on SQL Saturday 56

Conclusion

In conclusion this was a great event. The North Texas SQL Server User Group did a great job.  I would love to speak at another one of their SQL Saturday’s.  I cannot believe they are going to have three within a twelve month period.

Recap: Mid-Atlantic Community Leadership Summit

Last weekend I attended the first annual Mid-Atlantic Community Leadership Summit (#MACLS) held for user group leaders. I would like to thank Andrew Duthie (Blog | @DevHammer)  for inviting me.  He did a great job putting the event together at the Microsoft Offices in Reston, VA. 

The following are some notes for everyone that didn’t get a chance to make it out. In general the purpose for the event was to get user group leaders together to share what’s works and what doesn’t work.  There is no order to the post just some notes with some random comments from my experience running the Greater Wheeling Chapter of AITP and hosting SQL Saturday #36.

How do you measure your user Group?

Your user group doesn’t have to be huge to be successful. I learned first hand that 20 attendees is not considered a small group from the consensus of user group leaders.  Sometimes leaders get lost in user group stats. Stats being the number of new members or attendance per meeting.  I will admit that I have been guilty. These stats really don’t hold water towards determining if a user group meeting is successful.  If you have a lot of people attend but no value provided to the attendees the meeting is not successful.

How does the user group get better?  You have to ask the members.  Its hard to meet the attendees expectations if you don’t know what they are expecting. Doing so could be a rewarding exercise for the leaders of the group and the attendees.  It helps the attendees feel like they are part of the group and it helps the leaders provide value by implementing the missing pieces. 

When should I hold that event?

BatmanWhen should I hold that event? This is a question that is asked by many user group leaders during the planning phase of an event or startup phase of a new group. Andrew Duthie created a website known as Community Megaphone to help solve this problem.  There are several user groups which means you might be competing for speakers and attendees. The Community Megaphone cannot predict when another group is going to have an event but if everyone adds their events it is a great system to see if anything else is planned.

Just like the Batman cartoon try to have your events on the same bat day, same bat time, same bat channel.  From my experience I think this works well for user groups.  Its easier for members to attend if you hold the meetings monthly on the same day (number of month or day of a week), same time and same location.

Speakers and Topics

User groups need to communicate with their members and make sure the topics are covering what the needs of the user group.

When you decide to bring a speaker in to talk have them submit multiple topics.  This allows the user group leader to follow-up with its members to decide which presentation will be a better fit for the members.  This benefits both the group and the speaker.

Instead of always having one speaker talk during the meeting or a time slot consider having several speakers talk for a short period of time.  This will light a fire and motivate some new speakers to step forward and give their first presentation because they only need to present one small topic.  The PGH.NET User Group does a good job of doing this a couple times a year.  I really enjoy them check out my thoughts on the five guys with code meeting.  The SQL Server community is also doing this at the 2010 PASS Member Summit with their lightning talks series.

The general consensus of the group is that user groups need more real-world examples during presentations and more beginner (101) sessions.  More lights go off in attendees heads when they see something they can or should implement when they go back to the office.

Liability and Coverage

First of all I am not an attorney so everything covered in here is just notes from the meeting not my opinion.    If you are in a metro area you might want to combine user groups into one non-profit organization.  I learned that the DC area is currently doing this and it seams to be working out for them.  I also believe that the Pittsburgh area does the same leveraging the Pittsburgh Technology Council (This is not verified so don’t quote me on this).  If you are in a rural area then you can look at legalzoom or try to find an attorney who might be interested in doing a little pro-bono work.

It seams like a lot of small user group start off without incorporating.

If you are a lawyer or are friends of a lawyer ask them to do a white paper on the legal side of starting a user group.  It seams like there isn’t a lot of information out there on this.

Vendors (Sponsors)

One of the most surprising things I learned this weekend is that vendors want relationships not just sales.  Okay I you caught me, I knew this but sometimes its great to be reminded because it can be easy to forget.  Anyways, ComponentOne and Infragistics had evangelists at the meeting.  They both wanted all the user group leaders to know they are willing to help they just need to know what you need.

Vendors can also do more than provide swag, pizza and money.  A real world example is SQL Saturday #36.  I had no idea where I should put the sponsors.  I called Andy Warren (blog | twitter) my mentor for the event and he reassured me that this was a common problem.  His advice was very helpful.  Andy said, “Ask your platinum sponsor Confio they have sponsored SQL Saturday’s in the past they will know the best spot for the sponsors.” I followed Confio’s advice and the rest was history. The moral of the story is that vendors are not evil they can be helpful if you choose to ask them for help.

Hosting an All Day Event (SQL Saturday, Code Camp, SharePoint Saturday etc..)

The following advice was given about hosting a big event like Code Camp, SQL Saturday, SQL Saturday (or any other all day multi-track event) but I believe it also is good advice for running a user group.  You need to treat the event like a business and get a core team together to make it happen. A core team doesn’t have to be a huge team but it has to be more than one individual.  Treat the event like a business means assign action items and have people be responsible for the detailed action items and assign due dates. The group needs to have a task manager who can get things running and make sure everyone is meeting deadlines.

Always put your attendees in charge of giving away their information. Allow sponsors to have raffles where they can collect business cards or information.  At SQL Saturday #36 we printed out cards with everyone’s contact information and gave them to the attendees in their welcome kit.  This sponsors could get contact information from attendees who don’t have or forgot their business cards.

Don’t do individual sponsorship as it can be too complicated. For example, you might think to have a lunch sponsor, snack sponsor, after-party sponsor and so on. This can be complicated because one group had an after-party sponsor but found out after the fact that the sponsor would only cover non-alcoholic drinks.  The group had to pay out of pocket for half of the dinner bill. So what’s an easier way to handle sponsorship?  Divide up sponsorship by using levels.  Break sponsorship levels out into Platinum, Gold, Silver and Bronze and then assign values and benefits to them so that the sponsorship will cover your total budget and still get value out of their money.  Remember that you should build your sponsorship plan like a pyramid and have only a few Platinum level sponsors.

This covers everything I have in my notes.  If you attended and I left anything out feel free to add it in the comments section.

Upcoming Speaking Engagements

With football season starting I thought I would share some travel dates.  If you are at any of the following events please don’t be shy and say hi.  I look forward to hitting the road and making some new friends as I continue to connect, share and learn.

Sept 18th : Reston, VA
Microsoft Regional Leadership Summit (Non speaking)

Oct 16th : Pittsburgh, PA
Pgh.NET Code Camp 2010.2 (SQL Server 2008 for Developers)

Oct 23rd : Dallas, TX
SQL Saturday #56 BI Edition (Submitted: SQL Server 2008 for Developers)

Nov 8th – 12th : Seattle, WA
SQL Server PASS Member Summit (Submitted Chalk Talk – SQL Server 2008 for Developers)

Nov 19th : Pipestown, WV
AITP Region 18 Fall Conference

Jan 29th : Houston, TX
SQL Saturday #57  (Submitted  SQL Server 2008 for Developers)

PGH.NET Code Camp Review

This past weekend I had the pleasure of helping out David Hoerster (bio, twitter) with the setup of PGH.NET Code Camp.  Why, would I want to get up before the crack of dawn to help?  Well for starters David is a die hard Pittsburgh Pirates fan like myself.  Okay the real answer, is that I wanted to help with the code camp before I ran my first SQLSaturday in West Virginia.   This was a great practice before the game starts on May 1st.

In short I learned that if you have good volunteers it’s actually not too hard to have a great event.  If the event is free there will be people who just don’t show.  I guess mowing their lawn is more important than free training?  People will also leave before the event is over.  I could be wrong but I thought about half of the crowd left before the last session ended.  Finally, if a speaker doesn’t show you could replace the session with speakers panel.  This was a great move and actually was my favorite session of the day. 

SQL Server 2008 for Developers

During the day I also did a presentation on SQL Server 2008 for Developers.  I presented right after lunch and expected the majority of the crowed to have a food coma from the free burritos but this was not the case.  It actually was a nice interactive session. The following are a few quick facts from the presentation. 

About 40 people attended this session and only five of them are currently using SQL 2008.  I know this is a small sample size but it makes me believe that there are a lot of people out there still on SQL 2005 or SQL 2000.

The majority of the people awake (yes,  a few experience the food coma) were really impressed with using the real-time debugger to debug stored procedures, using merge to replace truncate table insert into table and use TVP to pass a data table in as an input parameter.

Follow-up Answers

The following are answers to some questions that were asked after the session.  Thought I would answer them here so others could find them in the future.

Can I create an index to filter based on dates?

Yes, you can.  I believe this is a new feature added in SQL Server 2008.  The following script will execute.

CREATE NONCLUSTERED INDEX FIBillOfMaterialsByStartDate
    ON Production.BillOfMaterials (ComponentID, StartDate, EndDate)
WHERE StartDate > '20000801' AND StartDate < '20010801';
GO

Checkout this MSDN link for more on Filtering Indexes. 

How can I make my database run faster? 

This is always a fun question and a hard one to answer without looking at the database and the server it resides on.   I recommended that this individual start with the free performance boosts.  This is also known as managing your indexes.   To do this checkout the following great links with video from SQLServerPedia.

Can I find the last time database objects were modified?

Yes, check out this link for a script that does the following task

Book Review: “Confessions of a Public Speaker”

This year I made a goal to read six new books and to share my experience with everyone via book reviews.  This is the first review of the year and I am excited to give feedback on a book I really enjoyed.  Normally self help books put me to sleep but this was an exception as it was informative and entertaining to read.  If you plan to do public speaking in the near future I highly recommend this book.

My motivation for reading “Confessions of a Public Speaker” by Scott Berkun is simple.  I find myself doing more presentations and I want to improve my craft.  This year I will be speaking at PGH.NET Code Camp in April and also at SQL Saturday #36 in Wheeling, WV. Public speaking is not easy for me.  I completely agree with Adam Machanic’s blog post.  It takes a lot of practice and some reading to see how others succeed. Therefore, I want to take any advantage I can to make my presentations better.   The lessons I learned in the first chapter alone made this book worth the $17 on Amazon.

The following are some very important lessons learned.  Most people at your presentation hope you do well but also hope your presentation ends soon.  It’s funny, after I read this I started laughing because it’s so true. I also learned to know your material but know you shouldn’t be perfect.  Normally, I try to be a perfectionist so this is something I had to know.  I cannot go back in time and correct my mistakes. Ummm… maybe I can I will have to add this to my todo list.   Finally, I learned it’s the mistakes you make before you present that matter the most.  I will dive into this with my confession below.

Being that the title of the book is “Confessions of a Public Speaker” it’s only fair to include a confession of my own.  With experience I learned that I must take control of what I can control.    Three years ago I did my first presentation at the Pittsburgh Code Camp and did a presentation on extending the Reporting Service API’s.  While no one booed or threw fruit at me the presentation was a hot mess.  I was modifying slides in the speakers room, I didn’t do a practice run of the demos, heck I didn’t go through the audience’s point of view when I built the presentation.  If I would have taken care of what I could control (my presentation) this could have been a killer presentation.  Regardless, it was a great learning opportunity which made my future presentations much better.

If you want to improve your public speaking I highly recommend Confessions of a Public Speaker. This book will stay on my bookshelf within an arms reach for quite some time.

Its on like Donkey Kong!

I am glad to announce that SQLSaturday is coming to Wheeling, WV.  This will actually be the first SQLSaturday in West Virginia. The goal is simple, provide a free day of training on  Saturday, May 1st 2010 for SQL Server DBA’s and developers.  This event focuses on speakers, providing a good variety of topics, and making it all happen through the efforts of volunteers.

SQLSaturday

Below is the following list of submitted topics as of February 3rd.  If you would like to speak the call for speakers is still open until March 15th. We are firm believers in SQLSaturday’s goal to find, grow, and feature speakers that include the next generation of talent.  If you are an MVP or first time presenter we will try to fit you in.

SQLSat36Image

Registration is now open so you can sign-up to attend SQLSaturday #36.  This event will include a free lunch, door prizes and a post training party.  Did we mention that its free?  Below is photo of West Virginia Northern Community College the venue for our event.

wvncc

We look forward to seeing you in May.  In the meantime you can follow our SQLSaturday blog posts here.

SQLSaturday Update & Future Presentations

I wanted to give a quick update and thank everyone who has responded to my initial posting about bringing SQL Saturday to Wheeling, WV.    I have spoken to a couple technology groups and several individuals and everyone is very supportive of this event.

The following are upcoming work items:

  1. Establish a budget
  2. Build a support team that will help with organizing the event.
  3. Find a location and pinpoint a date (tentatively First Quarter 2010.)

I look forward to blogging the status of these work items.

On another note, It looks like I will be presenting the following topic “Building a Data Warehouse with SQL Server” twice in November.  I will present first at the Greater Wheeling Chapter of AITP meeting on November 11th.  I will also give the same presentation at the Pittsburgh SQL Server User Group Meeting on November 16th.

You will soon see a series of blog post that go over building a data warehouse.  You can find the first one here.

Can SQLSaturday happen in Wheeling, WV?

I noticed a great event that is occurring down south.  Its called SQLSaturday and one of my short term goals is to see if it’s possible to bring this great event to Wheeling, WV. 

What is SQLSaturday?

SQLSaturday is a platform for free one day training events for SQL Server professionals. This event focuses on speakers, providing a good variety of topics, and making it all happen through the efforts of volunteers. Whether you’re attending one or thinking about hosting your own(this would be me), we think you’ll find it’s a great way to spend a Saturday.

Initial Goals:

  1. Bring technology professionals from Pittsburgh, Columbus and Morgantown to Wheeling.
  2. Have 50 to100 attendees attend this initial event.
  3. Provide great speakers to present topics about SQL Server and .NET
  4. Utilize sponsors to make the event 100% free to all who attend.
  5. Provide the opportunity for IT Professionals to network with their peers.
  6. Provide exposure for AITP and the Greater Wheeling Chapter of AITP 

Conclusion:

Will this event happen?  I sure hope so, but  I am still planning.  I hope to have an answer soon.  If we do go live I am targeting early 2010.

I will post my future action items and the decisions I make soon.  I hope that this series of posts are helpful for people who are contemplating if they should start a similar event in their area.

If you have any comments, thoughts or suggestions please share them.