February 2015 Meeting Announcement

SQL Server Notifications in a manufacturing environment

Are we there yet? Are we there yet? Queries that poll a database looking for changes can waste tremendous amounts of network bandwidth, CPU, and other precious database server resources. By changing the structure of your SQL client to use query notifications rather than polling, you can reduce computational load on both the client and the server. We’ll review how you can use query notifications from C# or VB.NET to receive notifications from Microsoft SQL Server. We’ll compare polling, database triggers, and query notifications, with respect to speed, reliability, and ease of implementation in a software bug tracking system.

Next, we’ll examine a case study of how these types of notifications can be implemented in an automotive assembly plant. The Toledo North and South Assembly Plants produce the Jeep Cherokee and Wrangler, respectively, and we’ll review a video explaining the assembly process at these plants with a special emphasis on some of the computer systems driving them. Given your newfound knowledge of query notifications, you’ll easily be able to understand why speed and reliability are so important in this environment. Examples of notifications include determining the positions of vehicles on the production line with RF-ID readers and real-time detection of production line failures.

David Johnson

David Johnson is a software developer at the Toledo South Assembly Plant. He splits his time between rewriting C# applications, maintaining legacy C++ applications, building new Java-based websites, performing database administration, and doing whatever else is required to keep new Jeeps rolling down the production line. The manufacturing environment poses many unique challenges for software development, from the implementation deadlines (e.g., five minutes ago) to the wide variety of hardware in use (e.g., PLCs to industrial PCs). David enjoys these challenges and the flexibility to use whatever combination of hardware and software best suits the problems at hand.

Pizza/Geek Dinner
Pizza will be provided as a snack during the meeting. For anyone interested in continuing the discussion a Geek Dinner will be held immediately after the meeting (Location – Logan’s Irish Pub).

5:30pm – 7:30pm
Tuesday February 24, 2015

Marathon Petroleum Company – Findlay, OH
Room 106M