Toledo Tech Events

You are cordially invited to the January meeting of Northwest Ohio SQL PASS on Wednesday January 14th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.

We are very excited to have Adam Belebczuk joining us for a great presentation: "Introduction to AlwaysOn Availability Groups" . Please be sure to attend and pass this invite along to other SQL minded professionals in the area.

Speaker Bio: Adam Belebczuk is a Consultant, Accidental DBA, and Developer with over 10 years of experience in IT, ranging from customer service to server/network administration to software and database development. Adam holds the MCSE: Data Platform and MCITP DBA 2005/2008 certifications, is a frequent speaker at SQL Server Users Groups and SQL Saturday events, and specializes in SQL Server development and performance tuning.

Topic: Introduction to AlwaysOn Availability Groups

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

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 WTA Inc. (www.wtainc.com) and HCR ManorCare (www.hcr-manorcare.com).

You are cordially invited to the March meeting of Northwest Ohio SQL PASS (Professional Association for SQL Server) on Wednesday March 11th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.

This month we have the honor to host Brian Davis (PASS Regional Mentor). Please be sure to attend and pass this invite along to other SQL minded professionals in the area.

Speaker Bio: Brian Davis is a SQL Server Consultant with UpSearch and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands on experience with SQL Server 2000-2014. Brian is also a Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

Topic: SSIS Templates Can Make Your Life Easier

How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again. Finally we’ll take an introductory look at BIML (Business Intelligence Markup Language) and discover how you can dynamically generate SSIS packages.

You are cordially invited to the May meeting of Northwest Ohio SQL PASS (Professional Association for SQL Server) on Wednesday May 13th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.

This month we have the honor to host Chris Schmidt from CBusPASS (Columbus). Please be sure to attend and pass this invite along to other SQL minded professionals in the area.

Speaker Bio:

Chris Schmidt is a Data Architect with Centric Consulting and has more than 7 years experience in developing business intelligence solutions. He lives in Columbus, OH and is an active member of the SQL community, currently serving on the board of the CBusPASS user group as vp of membership/marketing. Chris is extremely passionate about business intelligence, and helping companies achieve insight through data.

Topic: An Overview of Microsoft BI

Have you wanted to understand the possibilities offered by the Microsoft BI toolset? Chris will provide more than just a demonstration of the tools. He'll show you when to consider using one tool vs. another; how the MS tools interact to create a powerful analytics ecosystem.

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 TEKSystems Inc. (www.teksystems.com) and 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.

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.