Viewing 0 current events matching “nwossug” by Date.

Sort By: Date Event Name, Location , Default
No events were found.

Viewing 8 past events matching “nwossug” by Date.

Sort By: Date Event Name, Location , Default
Wednesday
May 14, 2014
Northwest Ohio SQL Server Users Group
HCR ManorCare

You are cordially invited to the first meeting of the Northwest Ohio SQL Server Users Group on Wednesday May 14th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.

TOPIC: SQL 2014 In-Memory OLTP

SQL Server 2014 has added In-Memory OLTP capabilities that provide new high-end performance for mission critical applications. This session will describe the new in-memory features and the table and stored procedure changes to support in-memory. We will review the new in-memory architecture that has been added to the SQL Server database engine and show a few demos that illustrate the tremendous performance gains SQL Server 2014 delivers.

SPEAKER: Rick Brewis. Rick Brewis is a veteran of Microsoft for over nine years. He is a Technology specialist focusing on SQL Server, Business Intelligence, Data Warehouse, and beginning a journey into Big Data and cloud computing. Rick has worked in the database arena for Oracle Corporation, Digital Equipment, and also has experience with Sybase, Ingres, and database management and development tools.

This meeting is made possible by Warnock, Tanner & Associates, Inc., Microsoft, and HCR ManorCare.

Wednesday
Jul 9, 2014
Top 10 Issues Identified By SQL Health Checks
HCR ManorCare

You are cordially invited to the July meeting of the Northwest Ohio SQL Server Users Group on Wednesday July 9th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.

TOPIC: Top 10 Issues Identified By SQL Health Checks

In a complex database environment, keeping tabs on the health and stability of each system is critical to ensure data availability, accessibility, recoverability, and security. Through performing thousands of health checks for clients, Datavail has identified the top 10 issues affecting SQL Server performance.

From misconfigured memory settings to missing backups, Datavail has gathered evidence from client health check history that identifies the most common issues DBA managers must correct for optimal database performance. Datavail’s SQL Health Check is used not only as a diagnostic tool but also a road map of the work that needs to be performed. From there, routine health checks have proven to improve database performance. SQL Server Senior DBA for Datavail Andy McDermid will share the top 10 issues, the consequences of not taking action, and why consistent use of a SQL Server Health Check in conjunction with ongoing database management can lead to improved database environments and maximize the investment of time and resources.

SPEAKER: Andy McDermid, SQL Server Senior DBA, Datavail

Andy is a MCITP certified MS SQL DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. He has conducted dozens of health checks on a variety of client databases. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing. You can read more about his work here http://www.datavail.com/author/andy-mcdermid.

Thursday
Dec 11, 2014
4th Annual GeekDinner HolidayMixer
Packo's at the Park

Tech Toledo invites all information technology professionals to join us on December 11th for the 4th Annual GeekDinner HolidayMixer. This will be the year’s largest social gathering of the IT community in the Toledo Region. We have been averaging 50 people over the first 3 years.

It starts at 5:30pm on Thursday, December 11th, 2014. We are meeting at Packo’s at the Park, 7 South Superior Street, in downtown Toledo, in the Outfield room.

No RSVP is required. Show up hungry for Packo’s, money to pay for your own food and drink, and a desire to connect with colleagues.

Many members of regional IT groups will be in attendance, holding their annual end-of-year Geek Dinners with us. The groups include Toledo Web Professionals, Nerd Summit, NWOACM, ISACA, Girl Develop It Toledo, NWNUG, Toledo iOS Developers, and TALUG (and we expect more groups). You will be able to meet the leaders and members of the groups at the event.

You are NOT required to be a member of any of these groups to attend. We welcome anyone who wants to hang out with us, such as entrepreneurs, designers, business leaders, engineers, government officials and marketing professionals.

The StartUp Toledo holiday party is the same evening (at the Art Museum). The TechToledo mixer is where you can geek out with other IT folks, while StartUp Toledo will help you connect with entrepreneurs and others involved in tech startups in the region. For those who want to attend both, we will remind you when to leave the mixer and drive to the Art Museum.

The general schedule for the evening:

  • 5:30pm – 6:00pm: Socializing and networking
  • 6:00pm – 6:30pm: Sit down and order food
  • 6:30pm – 7:00pm: Group introductions & announcements
  • 7:00pm: Depart for Art Museum for those who want go to the StartUp Toledo event
  • 7:00pm – whenever: More socializing and networking at Packo’s
Website
Wednesday
Jan 14, 2015
Northwest Ohio SQL PASS
HCR ManorCare

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

Wednesday
Mar 11, 2015
SQL PASS March Meeting -- SSIS Templates Can Make Your Life Easier
HCR ManorCare

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.

Wednesday
May 13, 2015
NWO SQL PASS - May Meeting
HCR ManorCare

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.

Website
Wednesday
Sep 9, 2015
SQL Server Notifications In A Manufacturing Environment
HCR ManorCare

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.

Website
Thursday
Apr 6, 2017
Northwest Ohio SQL PASS Reboot
Buffalo Wild Wings - Central Ave

This is a social mixer to reignite the Northwest Ohio SQL PASS group.