SQL Saturday #909 San Diego–Jared Kirkpatrick & Steve Rezhener

 

SQL Solutions Group is a silver-level sponsor of SQLSaturday San Diego on Sept. 21 and two of its consultants presented at the event.

Jared Kirkpatrick’s topic was How to build a T-SQL Framework

In this session we will create a framework that we can leverage through a template that will take care of the tedious tasks that come with development. These tasks or features include audit logging, designing a dynamic data driven error handling process, and control level batching in order to document, troubleshoot, and base line your code base. Once these features are developed you can spend more time in doing what really needs to happen like developing logic to perform processes while allowing the framework to control the necessary error handling tasks for you so you can continue to produce rapid development code.

Steve Rezhener’s topic was ETL, Introduction to SSIS, and third-party tools like MelissaData and CozyRoc

We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement third-party tools like MelissaData and CozyRoc

Date/Time
Date(s) – 09/21/2019
8:00 AM – 6:00 PM

Location
UCSD Extension University City Center

Categories No Categories