Quad Cities PASS Chapter

Welcome to the Quad Cities PASS User Group (QCPASS)

QCPASS is a SQL Server User Group in the Quad Cities area (Davenport & Bettendorf, IA and Rock Island & Moline, IL and the surrounding area).  We meet monthly, typically on the 2nd Wednesday of the month.  Meetings are always FREE and food will typically be provided.  Please come be a part of our local community! 

Time:           5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:     201 N Harrison St (4th Floor)
                   Davenport, IA

Parking:     Parking Ramp      - enter from Harrison St (.75/hr)
                 Parking Ramp      - enter from Harrison St (south side, no gate, FREE)
  On street parking - FREE after 5:00 PM

If you would like to be on our email list, please join our chapter by registering for a free PASS membership at http://www.sqlpass.org and adding our chapter to your myChapters page.  Please also check back here at the website for details!

Speakers and sponsors please contact us from our "About Us" page.


Wednesday, April 17, 2019 - Remote Speaker

 

Meagan Longoria - Consultant, Denny Cherry & Associates

 

Meagan Longoria is a business intelligence consultant with Denny Cherry & Associates who lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings as well as through her blog (DataSavvy.me).

 

 

Creating Accessible Power BI Reports: Challenges & Opportunities

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.

                                     Click to RSVP

Thank you to our sponsor!


Wednesday, May 15, 2019 - Remote Speaker

 

Deborah Melkin - Senior Database Engineer, Casenet, LLC


Deborah Melkin has been working as a database professional with SQL Server since 2000. She has worked at software companies in product development, which means spending her days helping programmers with all aspects of database design, queries, performance, and deployment. She has done some work with MySQL, Oracle, Informix, and PostgreSQL over the years - just enough to say that she could probably do damage in any of those databases. When not working with databases, Deborah's usually finding something musical to do.

 

Looking "Normal" and Seeing "Stars": Table Designs Working Together

Most database professionals know there are two different database design patterns - normal forms for OLTP databases and star schemas for data warehouses. We tend to discuss these separately. But these two designs actually work together when we create our table schemas. In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa. By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.                                     

                                                  Click to RSVP


Wednesday, June 12, 2019 - Remote Speaker

David Klee - Founder & Chief Architect - Heraflux Technologies


David Klee is a Microsoft MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blogs at heraflux.com and davidklee.net, and reach him on Twitter at @kleegeek. David speaks at a number of national technology related events, including the PASS Summit, VMware VMworld, SQL Nexus, SQL Saturday events, PASS virtual chapter webinars, and many SQL Server User Groups.


Level Up Your Cloud Infrastructure Skills

Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

                                                   Click to RSVP


Wednesday, July 10, 2019 - Remote Speaker

 

Ryan Adams - Microsoft


Ryan Adams is a Senior Premier Field Engineer for Microsoft.  He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company.  His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

 

How Active Directory Affects SQL Server

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence how SQL Server performs.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos, and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

                                                  Click to RSVP


Wednesday, August 14, 2019 - On Site Speaker

 

Juan Soto 

Juan Soto is a frequent speaker at SQLSaturdays.com and prolific author of articles at the official Microsoft Access blog, including being the only Access developer to be profiled on the site. He’s also the founder of AccessUserGroups.org, a worldwide organization of user groups that meet virtually online to discuss Access topics each month in multiple languages and countries. When he’s not presenting he’s managing one of the largest practices of Access consulting in the world at AccessExperts.com

Optimizing Microsoft Access with SQL Server 

SQL Server DBA’s are often asked to take over a Microsoft Access application that has become mission-critical, the conversation usually goes like “You’re a DBA and Access is a database, so take over this system and upgrade it to SQL Server...”, but simply moving the data over may not guarantee better performance and can even make matters worse.

The reality is Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries.

                                                  Click to RSVP

 

 



 


EventDisplay

Next Meeting

Wednesday,

May

15

QCPASS Meeting - May 15, 2019

  • In-Person @ 201 N Harrison St, Suite 600 Davenport, Iowa, United States (map)
  • 17:30 - 20:30 Central Daylight Time
  • Language: English

Time:         5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:     201 N Harrison St (4th Floor)
                   Davenport, IA

Parking:   Parking Ramp      - enter from Harrison St (.75/hr)
                 Parking Ramp      - enter from Harrison St (south side, no gate, FREE)
         On street parking - FREE after 5:00 PM
 

                                  Click to RSVP

Featured Presentation:

Looking "Normal" and Seeing "Stars": Table Designs Working Together

Deborah Melkin, Senior Database Engineer Casenet, LLC

Most database professionals know there are two different database design patterns - normal forms for OLTP databases and star schemas for data warehouses. We tend to discuss these separately. But these two designs actually work together when we create our table schemas. In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa. By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.

About Deborah:
Deborah Melkin has been working as a database professional with SQL Server since 2000. She has worked at software companies in product development, which means spending her days helping programmers with all aspects of database design, queries, performance, and deployment. She has done some work with MySQL, Oracle, Informix, and PostgreSQL over the years - just enough to say that she could probably do damage in any of those databases. When not working with databases, Deborah's usually finding something musical to do.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 













 












  

Curative Computers LLC

 


 

 

 

 

 


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids