OC SQL Data Platform

Welcome to BIG PASS Community

  • We meet at Del Taco (Corporate) at 25521 Commercentre Dr, Lake Forest, CA 92630

Do you have any events to share? If you do, send them to Ted Stathakis.


January 2018 meeting has been canceled, due to presenter being sick. We'll see everyone in February.

 


Mark Your Calendars: An all-day free training is coming to Southern California

Friday, June 17, 2016 from 8:00 AM to 4:30 PM

SQL Server Launch 2016 Discovery Day - Irvine, CA

Microsoft Technology Centers
3 Park Plaza, Suite 1600
Irvine, CA 92614

PLEASE USE THE FOLLOWING LINK TO REGISTER: Click Here

Next Meeting

Thursday,

May

08

BIG PASS Community Monthly Meeting - With Hugo Kornelis

  • In-Person @ 25521 Commercentre Dr. Lake Forest, California, United States (map)
  • 18:30 - 21:00 Pacific Daylight Time
  • Language: English

We are really looking forward to our next meeting. I hope you are too. If you can make it, please RSVP here.

Agenda

6:30 PM - Networking and a bite to eat. (Our sponsor this month is Technical Connections Inc.)

7:00 PM - Announcements

7:15 PM - Hugo Kornelis

8: 15 PM - Break

8:45 PM - Raffle and wrap up (Bring a new person to the meeting and you both get an extra raffle ticket.)

You do not need to bring a paper ticket to the event. The registration is to obtain a head count for the size of the room and for how much food needs to be purchased. Please unregister by Wednesday if you know that you won't be able to make it. Thank you.

Abstracts below
 
Please contact Mickey Stuewe if you have any questions.

Featured Presentation:

Everything You Always Wanted To Know About MERGE?

Hugo Kornelis, Database Consultant JuTi Holding BV

The basic function of the MERGE statement is the ability to synchronize imported data with base data, inserting new rows and updating existing rows, all in one go. But step beyond basics and MERGE becomes a tool that can do much, much more. In this demo-rich session, we will present the full syntax of the MERGE statement, explain all the options, and show the possibilities. We will also demonstrate the pitfalls that you need to be aware of if you, or even someone else, uses MERGE – and show you how to solve them. Whether you already used MERGE or not, this session will show you new ways to tackle problems that would otherwise be much harder to solve.

About Hugo:
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was an SQL Server MVP from January 2006 to December 2016. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.

Supplementary Materials

The following event attachments are available to you:

Upcoming Speakers

Jan 2018 - Ryan Adams - CANCELED

Feb 2018 - TBD

Mar 2018 - TBD

Apr 2018 - TBD

May 2018 - TBD

If you would like to speak for us, please contact the chapter leader, Ted Stathakis.

 

PASSChapterLogo.jpg


Sponsors



 

sql_micro_sm.gif

 

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids