SQL Server Notifications In A Manufacturing Environment
You are cordially invited to the September meeting of Northwest Ohio SQL PASS (Professional Association for SQL Server) on Wednesday September 9th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.
This month we have the honor to host one of our own members David Johnson. Please be sure to attend and pass this invite along to other SQL minded professionals in the area.
Speaker Bio: David Johnson is a MES and SCADA software developer at the Toledo South Assembly Plant. He splits his time between writing 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.
Topic: 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.
Event registration is by invitation only. Register with your email address to attend this event.