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.
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:
Dinner is being provided by
This event will also be broadcast remotley. Click Here to join
6:00 PM – Arrival, dinner, group announcments
6:30 PM – Daniel Frandsen and the MERGE statment
7:30 PM – Wrap up and questions