Gateway/400 Group

Microsoft SQL Server is one of the most widely used database management systems. It is frequently found with the IBM i in many companies.

In this session, you'll see how you can use some of the major features of SQL Server to complement your IBM i database. You'll see how you can replicate data from your IBM i to SQL Server, or from SQL Server to your IBM i. The session shows the components of IBM i Access for Windows that are used to connect to SQL Server, how to define and use a Linked Server, how to run SQL commands using the Linked Server, how to use the SQL Server Agent and the SQLCMD command.

You'll also learn about other features of SQL Server, including SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). Included with the session is a PDF lab handout that shows you the steps used to create a Linked Server and run SQL commands over it.

Craig Pelkie has worked as an IBM midrange developer since the early days of the IBM System/38. Craig currently develops training and instructional materials for IBM i developers. He has developed training for Net.Data, Java and WebSphere, Microsoft .NET and Microsoft SQL Server for IBM i developers. His next course, available later in 2012, shows how to develop iPhone and iPad applications that work with the IBM i. 

 Craig's work has appeared in Midrange Computing and System iNEWS magazines. In addition, he founded and edited several print and online newsletters, including PC Support Expert, Client Access Expert, and My i-.NET.

Originally from the Northeast, Craig resides in North San Diego County, California.

Please join us at our  February meeting with Craig's remote presentation.  This lunch meeting at Spazio Westport will start promptly at 12:00, with the meeting starting at 1:00. To register for the event  RSVP by noon on Monday, February 6th.  Free to members and $25 for extra attendees from member companies and $40 for non-members.