We will be focusing on SQL 2012 SSIS in January. Details are not available yet. Currently we have tentative date of Saturday, 21 Jan for a workshop.
Stay tuned in for more information!
Official Chapter of the Professional Association for SQL Server
The first meeting of tripassBI was held on 27 Jan 2011. The location was graciously provided by FM:Systems in Raleigh.
We had a small crowd, which was to be expected since it was advertised as a search for volunteers! The good news is that we did get through that part and discussed upcoming events, sessions and even 2012 material. First, let me introduce the two new Committee Chairman.
Logistics Committee Chairman will be Jimmy Dixon. He can be reached at the chapter’s e-mail address: Logistics@tripassBI.org. This position will handle the following items for the chapter:
Sponsorship Committee Chairman will be Mike Thomas. He can be reached at the chapter’s e-mail address: Sponsors@tripassBI.org. Gary Hollis volunteered to help Mike as needed. This position will handle the following items for the chapter:
Communications Coordinator position did not get filled. We elected to divide some of the media’s up between people to ensure coverage without overtaxing anyone.
Speaker Coordinator responsibilities will be handled by Sandra Mueller who can be reached at Sandra@tripassBI.org. Responsibilities will include:
The meeting was a success from the perspective us starting work as a team. The slides used are available in a PDF document you can download.
Next meeting will be February 24th. Stay tuned for location and topic.
All — we have a location for our first meeting. This will be a PLANNING meeting, we will not have a featured topic or speaker. The intent of the meeting is to explain the concept of the user group (quarterly bucket learning, Saturday workshops, etc.) and to discuss topics, logistics, volunteers. If you want to shape this group — then this meeting is for you!
Please register for the meeting. Being our first an accurate headcount is important!
We will meet at:
4515 Falls of Neuse Road, STE 420
Raleigh, NC 27609
|The cross streets are bland / Pacific and Falls of Neuse Road. We are located directly across the street from the Ale house.|
|Call Gary at 919-746-7366 (in case you are late and doors lock).|
All — we have a tentative schedule set. The BI User Group will meet on the 4th Thursday of the Month – or the 4th Saturday for the first month of each quarter. The first quarter we will have planning meetings, and some general presentations; starting the Saturday’s in April.
27 Jan 2011 — Planning Meeting!
24 Feb 2011 — Planning Follow-Up and a Presentation
24 Mar 2011 — Information About Saturday Setup and a Presentation
23 Apr 2011 — Saturday Workshop — Intro to Report Design
26 May 2011 — Presentation on Report Design (building on where we stop on 23 Apr)
23 Jun 2011 — Presentation on Report Design (building on where we stop on 23 Apr)
23 Jul 2011 — Saturday Workshop — Intro to Data Warehouse Design
Things are still fluid at this time. The location we might be using has a conflict with several dates so I am trying to find another. One of the first things I would like to get a volunteer for is logistics. Someone who isn’t over an hour drive to everything.
Just wanted to share an opportunity with everyone. Red Gate is giving away 30 iPad’s and 30 licenses for SQL Monitor. They are doing this through three of the top bloggers to the SQL Server community. Visit one or all of the following sites for ways to enter and win (Jimmy and Mark — you can only win/enter through one site; let me know which so I can go to another) !
Brent Ozar’s blog at BrentOzar.com — http://www.brentozar.com/archive/2010/12/giving-away-apple-ipads-and-red-gate-sql-monitor/
Steve Jone’s blog at SQLServerCentral.com — http://www.sqlservercentral.com/articles/Editorial/71830/
Grant Fritchey’s blog at ScaryDBA.com — http://scarydba.com/2010/12/13/lifework-balance/
Our first meeting will be in January 2011 — it will be a planning/organization meeting. We will introduce content in February and March, then start the quarterly rotation with a Saturday in April.
Currently I am finalizing the location and date. Since our sister chapter tripass normally meets the third Tuesday, I am looking considering the first Tuesday and first Saturday of the month. Open to any thoughts and comments!
Added a new feature to the new site. Loaded an events section which I plan to keep current on various opportunites available to Raleigh region. Most of the events are free — most are vitual online training sessions. However, I will also be loading events that are at a cost, but are HIGH VALUE! Examples of this would include PASS Summit, SQL Rally and local training of phenomenal value like SSIS Training with Andy Leonard (Blog | Twitter).
Basically, every post that has a date affiliated with it and a category of ‘calendar’ automatically gets added to the Upcoming Events list. The sidebar will contain a calendar with red dates when an event is scheduled and a list of the next 10 events. Of course, the number of months and events can be updated as I play with more options of the plug-in. When a member clicks on a date or an event, a blog post will display showing the details entered for the event. Some events will have a full description, others just a URL link, depending on what information the post creator enters.
If someone wants to see a full list of upcoming events two features provided to get them. First there is a view all link under the Upcoming Events title in the sidebar. There is also an additional navigation menu for Upcoming Events. Both links access all posts of the ‘calendar’ category in order posted, not in event order. I am hoping to find some code trick to rearrange these by event date.
One awesome feature of the calendar that I am already enjoying is the subscribe feature. It is a button on the top of the window, one click later and I see the events in my Outlook calendar! It shows up under Other Calendars in Outlook.
Things I am working on figuring out or configuring: I haven’t been able to get the ‘blog’ details to publish with the calendar, or at a minimum a link to the blog post.
This will be the challenge. Researching the ability to have people e-mail a blogpost with a category of ‘calendar’ to an address and have it automatically appear. This will allow any of the members update. Of course, someone will need to either approve or monitor what is submitted. As with everything we are doing right now — work in progress that will continuously evolve.
Obviously, the website is up. I added the hosting to my domain for a mere $3 more plus domain name registration (tripassBI.org and tripassBI.com). I considered getting someone to design an asp site, and I almost hired a friend to design a php site. In the end, I decided to try using a Word-Press site. The reasoning behind this approach is based on the needs I saw for the chapter. A site that contained fairly simple information. We needed something that could be kept current easily. A site that supported archiving of meeting slides and scripts. I also saw a dynamic site that could be updated by committee heads and members (with some monitoring). The more I thought of the options the more I realized that Word-Press sites and themes come very close to meeting all these requirements. There are still issues to work out and quirks that will appear, but it is proving much easier than the temp site I set up using GoDaddy’s WebSite Tonight (great product for web starters)!
One of the first challenges with a WordPress site is finding a tool to manage e-mail subscriptions/membership. I have a lead on one that Florida uses so a page to subscribe should appear on the site soon.
triPASS uses Eventbrite to announce meetings and get a head count on attendees. I would like to use Microsoft Events and the User Group registration. Would love help if someone has time to explore how this is done. NYC SQL User Group uses this approach.
Considered a way for people to submit local or virtual events so that others can tap into the resources available.
Another feature I would like to add to the site is a discussion board, but I am not sure it would really be used. There are so many options available to us these days, I have a feeling it would be a waste of my time.
Add some comments and let me know what you would like to see — and what I am completely forgetting about!