OC SQL Data Platform

Welcome to BIG PASS Community

  • We meet at the Del Taco Headquarters in their training room on the ground floor  |  25521 Commercentre Dr, Lake Forest, CA 92630 
  • We start mingling around 6:30, start the presentation at 7:00 and head to Los Cabos Cantina for drinks around 8:30

March 8th

Anday Nakamura will be presenting: A Beginners Adventure into Reporting Services 2017 and PowerBI Reporting

April 12th

No Meeting as SQLSaturday Orange County at Golden West College in Huntington Beach is 2 days later on the 14th.  Check out the Pre-Cons on the 13th!

May 10th

Speaker and Topic to be announced soon.


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 @ 25521 Commercentre Dr. Lake Forest, 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

March 2018 - Andy Nakamura   |  SSRS 2017 and PowerBI

April 2018  - SQLSaturday on the 14th and pre-cons on the 13th

May 2018 - One of our SQLSaturday 2018 speakers!

June 2018 - You?!

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