PostgreSQL Users' Group monthly meeting. Followed by refreshments at the Lucky Lab.

Topic: Visual Planner Presenter: Tom Raney, PSU Where: FreeGeek, 1731 SE 10th Avenue, Portland, OR When: 7pm, September 18, 2008

Tom Raney will be presenting the Visual Planner, a GUI tool written in Java that enables the user to peek inside the PostgreSQL planner's decision making process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Summer of Code, and credits Dr. Len Shapiro, a professor at Portland State University and PDXPUG regular, as a great help.

Tom showed off his tool during OSCON and has gotten some feedback from community members on it. He's working up a test example that should appeal to DBAs, and I'll link directly to the source code once he's got it ready.

This work also involves a patch to PostgreSQL, which should be available soon!

After the meeting, retire to the Lucky Lab for refreshments!

The Oregon SQL Developers (OSQL-d) Professional Association provides opportunities for .NET developers, SQL Server developers, and SQL Server administrators to meet and discuss SQL Server technologies that are of specific interest for developers. Discussion topics include 'Best Practices', T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered 'old') features.

Our meetings are on the second Wednesday of each month -except there is no meeting in December. We meet at the Portland Microsoft Office in the large conference room.

Microsoft Portland Office Suite 600 (Sixth Floor) 10260 SW Greenburg Rd Portland, OR 97223

Join the Portland PostgreSQL Users' Group for our monthly meeting!

Where: FreeGeek When: 7pm 20 August, 2009 Who: Jim Cser What: Metro simulation database

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 17 Sept, 2009 Who: David Wheeler What: Unit Test Your Database!

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 15 Oct, 2009 Who: Selena Deckelmann What: Bucardo: Replication with tiny little goats

Drinks afterward at the SE Lucky Lab.

OpenSQL Camp is an un-conference style get together for people interested in Open Source Databases. We are not focusing on any one project, and hope to see representatives from a variety of open source database projects attend. OpenSQL Camp is free and our target audience are users and developers, but others are encouraged to attend too. See the website to sign up, and to see the full schedule.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 19 Nov, 2009 Who: Dan Colish What: Materialized Views (with cupcakes)

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 18 Mar, 2010 Who: you! What: PostgreSQL 9.0alpha testing party

Drinks afterward at the SE Lucky Lab.

speaker: Robert Buels

Rob will give an introduction to and overview of DBIx::Class. It's an object-relational mapping framework, much better than the old Class::DBI, and it will make your life easier if you are currently writing a lot of SQL in your Perl.

As always, the meeting will be followed by social hour at the Lucky Lab.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Melissa Hollingsworth What: Normalization!

Drinks afterward at the SE Lucky Lab.

Sheryl Larsen is one of the most sought-after DB2 consultants in the world, and IBM is sponsoring her to present a free half-day seminar about DB2 10 (the newest version of DB2 z/OS recent) and valuable advice from dozens of real-world SQL performance tuning engagements.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Mark & gabrielle What: What's new in 9.0

Drinks afterward at the SE Lucky Lab.

Panel: Selena Deckelmann, Igal Koshevoy, Jeff Lavallee, David Wheeler

This will be a panel discussion about the ups, downs, ins, and outs of relational, row, key-value, and hierarchical data stores (simplistic buzzwordiness: SQL vs NOSQL aka ACID CRUD.)

The panel will discuss parallelism, scale, data integrity, normalization, business logic, ORMs, and performance. Some of the following might be addressed:

• why do you want a relational DB?
• why do you not want a relational DB?
• Membase, MongoDB, Redis, Cassandra
• Tokyo Tyrant, CouchDB, old school K/V (zodb, bdb)
• distinctions between "relational" and "row store"
• how filesystem settings affect the database
• how important is your data?
• common errors in SQL schemas or usage
• is count(*) supposed to be fast?
• efficiency vs speed vs parallel cleverness
• sharding
• what is "scale" and do you need it?
• massively denormalized, or massively normalized?
• ORMs, materialized views, indexes, and the query planner
• typical performance with small/large, simple/complex data sets

As always, the meeting will be followed by social hour at the Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 21 Oct, 2010 Who: Aurynn Shaw What: PostgreSQL and node.js

Postgres and Node.js, a powerful event-driven programming environment paired with our favourite open-source database, now together in the same great package! Aurynn will be going over the node.js environment, how it differs from other programming environments, and how to use postgres with node.

Aurynn Shaw is Lead Userspace Developer at Command Prompt, Inc. She has come all the way from another country to present this talk, so don't miss it!

Beer afterwards at the Lucky Lab.

See you there!

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This year's SQLSaturday Oregon is hosted by Oregon SQL, and will be held Oct 8, 2011 at Portland, OR, USA. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event. Visit Oregon SQL at http://osql-d.org

The alt.net group is kicking off again talking on all sorts of dev topics, come join us for discussion, presentation, and impromptu developer bits.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

We'll have a few lightning talks on Visual Studio .NET 2010 & AWS (Amazon Web Services) Toolkit, utilizing CouchDB for data processing & testing, and more! Following that we'll touch on some mixed environment topics (Ruby on Rails + ASP.NET MVC w/ SQL Server) along with some.

We'll end the evening with a round at Bailey's (or other democratically elected establishment) with the distinctive possibility of some TDD, BDD, or hackery of some sort.

Note: There is also an invites... ...and for final location directions please see the meetup invite. Thanks!

on eventbrite.com here: http://www.eventbrite.com/event/2473010842

on meetup.com here: http://www.meetup.com/ALT-NET-Portland/events/39881962/

on plancast.com here: http://plancast.com/p/8fep

We'll have a few lightning talks on Visual Studio .NET 2010 & AWS (Amazon Web Services) Toolkit, utilizing CouchDB for data processing & testing, and more! Following that we'll touch on some mixed environment topics (Ruby on Rails + ASP.NET MVC w/ SQL Server) along with some.

We'll end the evening with a round at Bailey's (or other democratically elected establishment) with the distinctive possibility of some TDD, BDD, or hackery of some sort.

Note: There is also an invites... ...and for final location directions please see the meetup invite. Thanks!

on eventbrite.com here: http://www.eventbrite.com/event/2473010842

on meetup.com here: http://www.meetup.com/ALT-NET-Portland/events/39881962/

on plancast.com here: http://plancast.com/p/8fep

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

December meeting sponsored by EdgeLink

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Again, we'll be meeting for technical discussion and a lot more. So far, this is what is on the agenda. We'll start this meetup off with a presentation on Git, pair programming, and code katas and koans with .NET. The presentation will cover what these things are, how they're implemented, and what the best usage and benefit of each is. TDD/BDD Pair

Programming Session! Ever wanted to pair program? Wanted to learn about ping pong style, promiscuous pair programming or some other style? Well after the presentation, for those interested bring a laptop with Visual Studio 2010 with the latest services packs and MVC tools and we'll be stepping through exactly what these techniques are and how they're implemented with the .NET stack (and a few open source components too).

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server, and will be on October 8, 2011 at Portland, OR, USA. Admittance to SQLSaturday Oregon is free, all costs are covered by donations and sponsorships.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

Monthly meeting of the Oregon SQL -developers user group, where the topic is always SQL Server, but from a developers perspective. Check the website for the next meeting details.

speaker: David Wheeler

SQL change management is hard. Most “migration”-style implementations require opaque naming conventions, prefer DSLs that cover a fraction of SQL, and require duplication of code for simple changes to existing functions. Such does not have to be. And now it’s not

Introducing Sqitch, simple SQL change management that doesn’t suck. Sqitch doesn’t care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn’t require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration scripts that target your database, and provides a simple, unintrusive interface for specifying dependencies, so that it can run things in the proper order.

So come to this talk to learn all about Sqitch: How it works, where to get it, and how to get the most out of managing database deployments.

David Wheeler is Senior Data Architect at iovation and an associate at PGExperts. He is responsible, among other things, for PGXN, pgTAP, DesignScene, and way too many CPAN modules. He lives in Portland unless he’s traveling with his family.

As usual, the meeting will be followed by social hour at the Lucky Lab Brew Pub.

SharePointlandia is a free educational event focused on Microsoft SharePoint.

The event is open to the public and offers something for SharePoint users of all experience levels.

SharePointlandia will offer over 24 educational sessions and multiple content tracks: • End Users • Developers • Administrators • Business Users

Register for the event here: http://sharepointlandia2013.eventbrite.com/

We bring in experts, consultants, and Microsloth MVPs from around the country to share their experiences, tips, and best practices. This is also a great opportunity for you to meet the local SharePoint community, ask questions, network, or share your experiences. We hope to have lots of giveaway items as well. Join us!

This event is a part of the Portland SharePoint User Group, more information on the workshops, speakers and sessions will be posted on our website: http://portlandsharepointusergroup.org/splandia2013

COPIOUS is a user-centered digital experience agency. We build digital products with the user at heart and technology in our bones. We recently moved to a new office and now have a large space to host our TechTalks.

About TechTalks:

COPIOUSLabs TechTalks series meets every other Friday at 1pm at the COPIOUS offices. Our talks span artificial intelligence, new programming languages and techniques, computational linguistics, geographic data processing, systems and software architecture, augmented reality, network security, and more as proposed to the Copious engineering team.

About this talk:

Speaker: Andrew Gauger, Systems Engineer, Rejuvenation

MongoDB allows for abstracted data storage, so Andrew will talk about implementations of this flexible data design pattern. State machine and its ability to extend a document asynchronously gets highlighted. We will talk about data abstraction, and how to abstract structured data into a schema-less logger to perform validation.

In this TechTalk, Andrew will aim to describe clustering and replication as well as referencing and embedding in a simple language. The samples come fast but keep to explaining a simple topic. The talk diverges about how distributed database technology can be brought to firmware, how massive quantity small computing instances best leverage this technology, and what frameworks exist to leverage MongoDB on an upcoming project.

All are welcome to attend. If you have a talk that you'd like to suggest presenting, please email it to [email protected] along with a brief outline of what you'd like to cover.

Join us for an evening of Peer Mentoring hosted by PDX Code Guild.

Bring your laptop. Learn and/or share your existing knowledge with others. This group focuses on Python, Django, JavaScript, jQuery, SQL, CSS and HTML. Other languages are welcome.

This week we will do introductions and then pair up mentors and learners and/or work on projects.

Set aside one night a week to become a better developer, pick up new skills, and get help with your projects and learning. We'll have mentors on hand and a community of other learners to meet and work with.

Our event is beginner friendly, we can help get you started with programing, support your online learning, or just talk about where you are at and what comes next.

Bring your laptop, and something you want to learn, try, or build.

Party with us in our new location!

RSVP Here: https://www.eventbrite.com/e/pdx-code-guild-spring-happy-hour-tickets-11623290575

Join us for the fist Meet and Greet Party in our new location!

Share beverages and some snacks, meet our staff, grads and current students.

Enter our free drawing for $200 off of the upcoming Junior Developer Bootcamp.

Connect with the community.

Have a ball!

Saturday, September 6th, is PostgreSQL Day, co-hosted by the Portland Postgres Users Group (PDXPUG) and Portland State University. Attendance is free, but RSVP is required (link below)

Place: Portland State University, Engineering Building, Room EB 102, 1930 SW 4th Avenue, Portland, Oregon 97201.

Registration: Space is limited, please RSVP!

RSVP here: https://www.eventbrite.com/e/portland-postgresql-users-group-pdxpug-day-2014-tickets-11916561757

Food: Light snacks & beverages provided. Breakfast and lunch is on your own; food carts are nearby.

Presentations: Organizers are looking for presenters for PostgreSQL Day. Talks should be about 45 minutes in length, and about any of the following topics:

PostgreSQL administration and performance Case studies of interesting uses of PostgreSQL and PostGIS Interesting applications built on PostGIS or PostgreSQL Database and/or geographic application development Database-related DevOps SQL and stored procedure programming New Postgres/PostGIS features and hacking Postgres/PostGIS

Organizers will also be taking lightning talks of 5 minutes each, on similar topics. Email your talk proposal to Mark Wong at markwkm -at- postgresql.org.

Frontend, Backend, DevOps! Server-side rendering! SSL and HTTPS and SQL injection?! What the heck does all this jargon actually mean? If you're in a leadership position and you need to fill a tech role, it can be hard to know up from down. If your software engineer tells you to pay for an expensive service "for security reasons", how do you know whether its worth your money?

In this workshop, we'll answer the question "how does the internet work" from a Helicopter's perspective. You don't need any programming skills to attend, but be sure to come with questions! By the end, you'll understand the following concepts and how they fit together:

• The difference between websites, apps, and servers
• Cybersecurity hygeine (and how to avoid being hacked)
• Common software developer job descriptions
• Basics of computer programming (bring a laptop if you want!)

Tickets: Free for Hatch Members, $20 for non members

Workshop Leader: Finn Terdal, Technology Manager at Hatch

Ahoy database folk! Time for another meetup and more container chit chat. Yeah yeah, you, like me, have heard that you shouldn’t run databases in containers. Well without throwing all caution to the wind, I’m hoping to show you guys some container workflows with Postgres that I’ve been using lately. We’ll talk a bit about why you haven’t been running databases in containers, then walk through some development work flows with Postgres, and lastly look at options for deploying and running persistent databases in containers.

———

Hi, its me Grant Holly. I work at Iovation on the data science and analytics team wrangling our data into visualizations and machine learning models. I live in SE, play in bands, and am a learning machine.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.

Oregon SQL is an official chapter of the Professional Association for SQL Server (PASS), an independent, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results.

Visit https://tinyletter.com/OregonSQL and sign up to receive the Oregon SQL News and Meeting Announcements and be kept informed of meeting dates and discussion topics. We do not provide our mailing list to anyone for any purpose other than meeting notices and general announcements for the User Group.

6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting

Microsoft’s AI Landscape: The What and How’s and What You Need to Know

This talk will focus deeply on Microsoft’s Cognitive services. We’ll look at how AI is developing and the Microsoft AI landscape, and what you need to know to become familiar with and understand AI in the world of Microsoft. We’ll look at many demos that cover the many AI facets including Vision, Speech, and Text and how these apply to real-world scenarios.

Scott Klein Scott (LinkedIn | Twitter) is a Microsoft Data Platform Technical Evangelist who lives and breathes data. His passion for data technologies brought him to Microsoft in 2011 which has allowed him to travel all over the globe evangelizing SQL Server and Microsoft’s cloud data services. Prior to Microsoft Scott was one of the first 4 SQL Azure MVPs, and even though those don’t exist anymore, he still claims it. Scott continues to look for ways to help developers grok the benefits of cloud computing.

In a world in an ever-changing software development languages, which career path do you choose and how do you stay current on the latest trends?

How about becoming a full-stack developer? As a full-stack wizard, you get your hands on many technologies and languages in the front-end, middleware, and backend.

In the Meetup, I'll share a plan on how you can get started to become a full-stack developer within a year. I'll cover the basics of HTML5, CSS, React, JavaScript, APIs, Python, and SQL.

Everyone is welcome to come share their software development journey.

Be inspired! Knowledge Mavens

Speakers: Gabrielle Roth & Michelle Franz

In February, long-term PDXPUGers Michelle Franz & Gabrielle Roth return to discuss DBLINK and FDW, two methods of accessing data that’s outside your database. We’ll briefly mention SQL/MED on the way, and tell a couple of bad (Dad) jokes.

We’ll cover use (and mis-use) cases, configuration of each, and interesting quirks. Gabrielle will attempt a live demo of file_fdw and postgres_fdw. You’re welcome to follow along if you’d like, just show up with a couple of Pg databases: they can be on the same cluster (or container or RDS instance or what have you) or different ones, doesn’t really matter. One of them should have at least one table with data in it.

About the speakers:

From embedded systems to UI to relational database programming, Michelle’s running an interesting path through the software world. Working with databases is her current episode, with some programming, some DBA, some SysAdmin and a healthy dose of learning agile. She’s very quickly come to appreciate and enjoy working with Postgres and her work has allowed her to learn from some super talented database experts.

Gabrielle has been using Postgres since sometime in the version 7s, and thinks that the best part of using Open Source software is the culture of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder and former co-lead of PDXPUG.

Marquita Hartman graduated from The Tech Academy in 2019, and has since become a software developer at Computershare, where she mainly works with SQL and other Microsoft data services.

Marquita will be joining us to speak on creating efficient code in SQL, and giving some insight on SQL related skills that potential employers might be looking for.

Her talk will entail:

-Creating tables and using the appropriate indexes -When and Why you should use a View vs. a Table -Tuning techniques for stored procedures -How to test the efficiency -A brief overview of an Explain Plan

Join us Friday May 27th at 1pm Pacific Time (2pm MT, 3pm CT, 4pm ET) in our Google Meet Room.

RSVP on MeetUp: bit.ly/tta527

Can't make it live? We will be posting the recording to our Tech Talks playlist on our YouTube Channel: bit.ly/TTA-techtalks

Don't miss this opportunity to learn about creating efficient code in SQL!

Marquita Hartman graduated from The Tech Academy in 2019, and has since become a software developer at Computershare, where she mainly works with SQL and other Microsoft data services.

Marquita will be joining us to speak on creating efficient code in SQL, and giving some insight on SQL related skills that potential employers might be looking for.

Her talk will entail: -Creating tables and using appropriate indexs -When and Why you should use a View vs a Table -Tuning techniques for stored procedures -How to test efficiency -A brief overview of an Explain Plan

Join us on Friday June 10th at 1pm Pacific Time in our Google Meet Room.

RSVP on MeetUp: bit.ly/tt0610 RSVP on EventBrite: bit.ly/ebtt0610

Can't make it live? We will be posting the recording to our Tech Talks playlist on our YouTube channel: bit.ly/TTA-techtalks

Don't miss this opportunity to learn about creating efficient code in SQL!

Join us Friday, July 15th, to learn how to optimize your SQL queries!

Wesley Rolfson started working with data when he was in high school, while working on Steam and Culvert surveys, using the data to explain how nature is responding to human activity. He now works as a data analyst working with environmental, health and safety data.

Wesley's talk will cover optimizing your SQL Queries by looking at the layers of processing. He will also cover how the SQL engine looks at your query so that you can better write queries and ultimately explain your results.

Join us Friday July 15th at 1pm Pacific Time (2pm MT, 3pm CT, 4pm ET) in our Google Meet Room.

RSVP on Meetup: https://bit.ly/techTalk715 RSVP on Eventbrite: https://bit.ly/techTalkE15

Can't make it live? We will be posting the recording to our Tech Talks playlist on our YouTube Channel: bit.ly/TTA-techtalks

Don't miss this great opportunity to learn and network!

Kent Gray, Tech Academy graduate will be joining us to discuss Object Oriented Programming with SQL.

In this Talk Kent will cover:

-What is OOP/OOD

-A brief overview of SQL

-Why use Object Oriented Design with SQL

-What is DBT (Data Build Tool)

-Real World implementation of OOD w/SQL using DBT

Kent graduated from The Tech Academy in 2016 and is currently working as a Data Engineer at Camelot Strategic Marketing & Media.

Join us Friday, November 11th at 1 pm Pacific Time (2p MT, 3p CT, 4p ET) in our Google Meet room.

RSVP on Meetup: https://bit.ly/TechTalk111 RSVP on Eventbrite: https://bit.ly/TechTalkE111

Can't make it live? We will be posting the recording to our Tech Talks playlist on our YouTube Channel: https://bit.ly/TTA-techtalks

Don't miss this great opportunity to learn and network!

We're all gathering January 19 at 10 Barrel Brewing in Portland, and we'd love for you to come! Join a select group of data professionals as we sit back and unwind over some light bites, beer, and awesome conversation. Start 2023 with the OA Club & Census. 😎

Wesley Rolfson will be joining us to discuss Instrumentation.

Data Instrumentation is the process of connecting things like output (from sensors, actions taken by a user, or feedback from a user action) and forming them into Events/messages which are then stored/translated into data structures.

In this Talk Wesley will cover: -What Data Instrumentation is -How it is applied by organizations -Where it fits in most data pipelines -What analytics should pay attention to -What graphic interface/ product owners should consider -Walkthrough 2 examples (website and application)

Join us Friday, February 3rd at 1 pm Pacific Time (2p MT, 3p CT, 4p ET) in our Google Meet room.

RSVP on Meetup: https://bit.ly/TechTalk023 RSVP on Eventbrite: https://bit.ly/TechTalkE023

Can't make it live? We will be posting the recording to our Tech Talks playlist on our YouTube Channel: https://bit.ly/TTA-techtalks

Don't miss this great opportunity to learn and network!

Few abstractions and tools have proved as enduring in the field of Computer Science as the relational database model. Due to the diligent efforts of the Postgres team, the Postgres project has an ever increasing popularity in the software world and a fully modernized feature set. One effect of the longevity of the project has been to create a deep pool of received wisdom regarding the use and misuse of Data Models and SQL. Revisit some of the wisdom from a classic of the genre: SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin, with updated opinions and commentary to modernize the material. Stay after for pizza and a rousing exchange of ideas on the past, present, and future of SQL and of the Postgres project.

Speaker: Joseph Hammerman

Joseph Hammerman is a Linux Systems Administrator and Database Reliability Engineer with 18 years of experience. For the last 10 years that work has focused on Postgresql database reliability and High Availability engineering practices. Some career highlights include: serving on the iHeartRadio launch team, working at SecondMarket prior to and during their acquisition by NASDAQ Private Markets, and founding and serving on the Squarespace Database Reliability Engineering team. He is currently employed as Technical Lead for the DataDog Postgresql database reliability engineering team. He is a passionate advocate of Free and Open Source software and the ideals that it embodies.