See below for remote attendance options for West MI SQL’s Jan 2012 meeting
Sherrie Mann presents — Administering SQL Server in a Virtual Environment
Webex Meeting information below
Topic: West MI SQL – Jan 2012
Date: Thursday, January 26, 2012
Time: 6:00 pm, Eastern Standard Time (New York, GMT-05:00)
Meeting Number: 624 613 044
Meeting Password: wmssug
——————————————————-
——————————————————-
For those who are not able to attend tonight’s meeting in person, please use the following link to connect to the remote presentation.
Meeting password: WestMISQL
Please join us October 25, 2011 at 6:00pm for this month’s West MI SQL User Group meeting. This month, we welcome Daniel Frandsen of BlueGranite, Inc.
Daniel will be doing a technical overview of the MERGE statment and its benefits. See the abstract below for more details.
Abstract:
This month’s topic will be a technical overview of the MERGE statement and its benefits. It will cover the traditional use of a MERGE statement, as well as how it can be used in a variety of places to speed up and simplify certain data tasks.
The MERGE statement first appeared in SQL Server 2008, allowing users to update with data from another sources quickly, by inserting new transactions and updating old ones (otherwise known as Upsert). In addition to the primary scenario, MERGE has found use in any situation where insert, update, and delete happen in combination based on a JOIN condition. We will explore the technical benefit of MERGE compared to its alternatives, including stored procedures, SSIS packages, and T-SQL scripts. We will also explore different business cases for using MERGE beyond the standard Upsert scenario.
About Daniel Frandsen:
Daniel Frandsen, Business Intelligence Consultant for BlueGranite, Inc has been working with Microsoft SQL BI technologies for over four years. He currently holds MCTS certifications in BI Development in SQL 2005 and 2008, as well as MCITP certification for SQL Server Database Developer 2008. He has a wide variety of knowledge in SQL Server (relational), SSAS and SSIS; as well as a range of UI solutions including SSRS, PerformancePoint, and Excel. He carries with him experience in application design in ASP.Net as well, from before his days developing BI solutions.
In order to ensure an accurate count for food, please RSVP at our EventBrite link: http://wmssug102011.eventbrite.com
This month’s meeting is brought to us by:
and
Dinner is being provided by
This event will also be broadcast remotley. Click Here to join
Agenda:
6:00 PM – Arrival, dinner, group announcments
6:30 PM – Daniel Frandsen and the MERGE statment
7:30 PM – Wrap up and questions
West MI SQL User Group members.
We are currently waiting on confirmation of venue availability before sending out meeting invitations for this month’s User Group meeting on Oct 25. We are hoping to be able to send out this invite by Monday, Oct 17 2011.
West MI SQL Users:
If you are unable to attend the meeting in person and would like to join us remotely please use the following Live Meeting link.
Please join the conference audio, and feel free to use the Live Meeting interface to ask any questions.
| https://www.livemeeting.com/cc/bluegranite1/join?id=Z79NZ6&role=attend&pw=qjd%3DH7J%3EJ |
Hello West MI SQL Members!
Kendra Little Bio (September Speaker):
Kendra Little is all about data, communication, and creativity. Kendra is a founder at Brent Ozar PLF, LLC, where she specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server– the highest technical SQL Server Certification available. In her spare time, Kendra draws quirky posters that start conversations about technology.
Abstract: Tell Me Where It Hurts: Three Cures for the Common Slow
Does your SQL Server sometimes just feel “slow”? Kendra Little knows how to quickly diagnose the ‘Common Slow’: long running queries, application timeouts, and maintenance jobs that get longer every week. Kendra shows how to find where it hurts and select the cure– and how to avoid killing the patient.
October’s meeting is sponsored by:
Agenda:
September’s meeting will be held at New Horizons in Grand Rapids MI. If you haven’t been to New Horizons lately, please note that they have moved locations. The new address is:
Please join us via the following Live Meeting link to discuss the event and assign volunteers to available positions.
Call information:
Conference Phone: 712-432-3900
Conference ID 7832320
Attendee LiveMeeting Link:
https://www.livemeeting.com/cc/bluegranite1/join?id=WZF5F5&role=attend&pw=c6q%7D6DK-T
This month’s meeting will take place in Grand Rapids and New Horizon’s Training Center. (5315 28th Street Court, Grand Rapids, MI) from 6:00pm to 8:00pm. Our speaker will be Daniel Frandsen of BlueGranite, Inc. Information is listed below. I’d like to thank Joshua Fennessy for taking the helm this month as I deal with a family medical emergency and the pending MVP Summit in Washington and SQL Cruise #2.
Due to issues with the RSVP plug-in for WordPress please reply back to wmssug@sqlpass.org if you plan to attend this month’s meeting so we have an accurate count of attendees for placing a food order. Thank you BlueGranite for once again funding this month’s food and beverages!
Abstract
This month’s topic will be Microsoft’s cloud-based Azure technology. We will cover both SQL Azure and Windows Azure, showing the advantages and disadvantages of a cloud-based solution.
We will take a broad look at the Azure platform, looking at everything from types of subscriptions to a live demo. Azure allows developers to deploy scalable solutions without worrying about server management. Cloud-based solutions are naturally accessible from anywhere and provide redundancy as well. Best of all, all you need to develop an Azure solution is all the applications you already know and love!
We’ll take an hour discussing an overview of Azure and see samples of where it can be utilized well.
Bio
Daniel Frandsen, Business Intelligence Consultant for BlueGranite, Inc has been working with Microsoft SQL BI technologies for over four years. He currently holds MCTS certifications in BI Development in SQL 2005 and 2008, as well as MCITP certification for SQL Server Database Developer 2008. He has a wide variety of knowledge in SQL Server (relational), SSAS and SSIS; as well as a range of UI solutions including SSRS, PerformancePoint, and Excel. He carries with him experience in application design in ASP.Net as well, from before his days developing BI solutions.
This month’s meeting will be strictly for initial planning of the proposed July 2011 SQL Saturday Kalamazoo event. The meeting will be online-only and the connection information for the call is listed below. Note, there is no associated Live Meeting presentation associated with this meeting; strictly a conference call.
We’ll be back to our regular meeting schedule in February. Details to come.
If you are interested in volunteering for the SQL Saturday event here is the appropriate call-in information. If you want to volunteer, but can’t attend the call please RSVP for the meeting on this website so I have your contact information.
What? SQL Server Kalamazoo Planning Meeting for WMSSUG
When? Tuesday, January 18, 2011: 12 Noon to 1:00 pm Eastern Time
Where? Online: 1-866-379-8990 Passcode 5997752
The presentation for tonight’s meeting will be available live via the following link:
https://www.livemeeting.com/cc/bluegranite1/join?id=BG_MDX_Beginnings&role=attend&pw=MDX_Attend
