Welcome to the Northwest Ohio SQL PASS Chapter

Next Meeting

Wednesday,

September

09

SQL Server Notifications In A Manufacturing Environment

  • In-Person @ 333 N Summit St. Toledo, Ohio, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

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.

 

  

TopicSQL 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.

 

 

 Please register on EventBrite so we know how much food to order and we can coordinate with building security.  (If entering the building after 6pm, please use the after-hours door on N. St Clair St.)

 

This meeting is made possible by HCR ManorCare (www.hcr-manorcare.com).  Please be sure to visit our sponsor websites -- they are the reason why NWOPASS is able to host frequent events.


Featured Presentation:

SQL Server Notifications In A Manufacturing Environment

David Johnson, Software Developer Daimler Chrysler

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.

About David:
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.

cage-aids
cage-aids
cage-aids
cage-aids