OC SQL Data Platform

Welcome

Orange County Data Platform Community

We have found a NEW HOME!  
Special thanks goes to Michellea David for hosting us at CBR Auto in Irvine/Tustin.

  • 6:30 > Networking and pizza
  • 7:00 > Presentations
  • 8:30 > Drinks at a nearby watering hole for additional networking and shop talk

CRB Auto
430 Exchange
Suite 200
Irvine, CA 92602

Just off I5 between Jamboree and Culver

 

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

 


 



Next Meeting

Thursday,

February

11

BIG PASS Community Monthly Meeting - Tim Mitchell

  • In-Person @ 430 Exchange Irvine, California, United States (map)
  • 18:30 - 20:30 (UTC-08:00) Pacific Time (US & Canada)
  • 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. Feel free to bring your dinner and join us for some great conversation. 

7:00 PM - Announcements

7:15 PM - Tim Mitchel (Remote)

8:30 PM - Raffle and wrap up

8:45 PM - Networking at Los Cabos Cantina

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 un-register 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:

Testing SSIS Packages

Tim Mitchell, Principal Data Architect Tyleris Data Solutions

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.” As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system. This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these: * Performance testing * Patterns for validating execution results at runtime * Validating package metadata before execution * Design time versus runtime testing * Making a graceful exit: testing for error handling

About Tim:
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Supplementary Materials

The following event attachments are available to you:

Upcoming Speakers

July 2018 - Month off while we spend time with families on vacation.

August 2018 - Kick off our new home in Irvine/Tustin with pizza and a special guest speaker.

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