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.

Speaker: 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.


Maritz Research

When arriving at Maritz please park in the long parking lot on the side of the building. Instead of entering through the front door please enter via the left-most door on the side of the building. It's located roughly in the middle of the building. You'll need to be buzzed in, and sign in with the security guard. Tell them that you're there for the .NET User Group meeting. You'll be directed up the stairs (immediately on the left after entering the building). We'll be meeting in the training rooms which are located to the right, in the middle of the floor.