What: All-day PostgreSQL one-track mini-conference When: Sunday, July 20th, 9am to 5pm, possible party afterwards Who: PDXPUG will select speakers Where: Portland Convention Center, Portland, Oregon

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!

Join us for the second annual PostgreSQL Conference West! Scheduled to begin October 10 and go through the weekend, West being held at Portland State University is going to be the destination for learning, fun and general education about PostgreSQL.

This Friday's paper is: "Interactive Paper as a Reading Medium in Digital Libraries" by Moira C. Norrie, Beat Signer, and Nadir Weibel.

Jeremy Steinhauer will be the discussion leader.

You can get the paper from: http://www.globis.ethz.ch/script/publication/download?docid=528

Join us to gossip about databases while eating lunch.

RSVP:

@selenamarie @gorthx @donpdonp @jmelesky @Theory @igalko

David Wheeler will be giving his "Unit Test Your Database" talk. It was well-received at Open Source Bridge; now he's giving it to an audience of Agile practitioners.

We’re all used to unit testing our applications by now. The Extreme and Agile programming movements have done a great deal to promote unit testing, to the extent that many of us are now dependent on tests to assure that our applications work reliably. But how often do we test the database underlying our applications? Given that the database, as the repository for all of the knowledge and data for an application, just might be the single most important part of that application, the time for standardized database unit testing has come.

This talk promotes the practice of writing and running unit tests that directly test the schema, storage, and functionality of application databases. Following a review of the available PostgreSQL unit testing frameworks, we’ll review examples of testing tables, views, columns, constraints, indexes, triggers, and functions. The idea is to promote complete test coverage every aspect of a database, independent of application unit tests, to ensure reliably canonical data integrity.

Pizza and networking at 6:30pm, 7pm talk, beer afterwards.

The Oracle Development Upgrade team will be delivering this seminar to provide best practices and helpful tips to make your Oracle Database upgrades quick and successful.

Breakfast and lunch will be served. Must be registered to attend -- follow Website link to register.

At last, we have confirmed a May Meetup topic!
Constituent Relationship Management Systems or Databases!

A good system for managing your clients, constituents, donors, and/or volunteers will ease your troubles away! Well...we're not sure that any database can be completely pain-free, there are some good solutions available for nonprofits but before a tool is decided upon, some essential questions must be asked. Join us on May 25, when Tompkins Spann will talk unbiased on how to determine your nonprofits' needs for data management and what you need to evaluate when choosing a CRM or database.

Then, you will have the opportunity to talk to Tompkins and others (we invite you to attend if you have a CRM solution to talk up!) about specific solutions and how they might integrate into your nonprofit's work flow.

We are proud to be bringing you this meetup in collaboration with the Portland Nonprofit Salesforce Users Group and Convio.

..............................................................................................................................

Tompkins is the Sr. Market Strategist for Convio focused exclusively on the Common Ground product, Convio’s CRM solution for nonprofits. He has worked for Convio (and formerly) GetActive for more than 5 years in various roles, from account services to product marketing. His experience working with nonprofits began when he exited the Peace Corps in 2000 to create his own 501c3. He then began working for a large advocacy-based organization in DC serving as the lead on all technology projects ranging from website strategy to database development. Tompkins has a passion for nonprofit-tech and truly enjoys helping organizations pick the right solutions and apply the right strategies to help further their mission.

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.

Come join us August 9th for the PMUG General Meeting as Mark Ezell presents BENTO by FileMaker. This is a database application that is very easy to use. It is good for organizing your personal information.

Monday, August 9th, 6:30pm - 9:00pm Where: Ecotrust Center, 2nd Floor, 721 NW 9th Avenue, Portland, OR (map) Description: General Q&A 6:30 to 7:30; announcements 7:30 to 8:00; main speaker 8:00 to 9:00 PM.

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.

A new meetup for data herders focusing on distributed databases, scaling, and any related data or messaging systems.

The first presentation will be by Michael Schurter on MongoDB - particularly the pros and cons Urban Airship has discovered while running half a dozen MongoDB servers.

Erik Onnen will be giving a 5 minute lightning talk on how he plans to use Kafka at Urban Airship.

Beer and possibly snacks will be provided by Urban Airship.

Please RSVP so we know about how many people to expect.

Idealist.org recently rolled out a new support which included a completely re-architectured backend. 3 developers from Idealist.org will be presenting on different components of infrastructure:

Long Talks: (~30min)

• Michel Pellitier on Using Xapain for Full-Text Search
• Jason Kirtland on Using RabbitMQ for Pub/Sub

Short Talk: (~15 min)

• Dan Colish on Redis - "If you're not using Redis, you suck"

Please RSVP on the meetup site and sign up for the mailing list.

ABOUT THE GROUP: With new databases springing up faster than new food carts this meetup aims to cut through the hype and disseminate knowledge from people who have been using, scaling, and getting-paged-by databases and other systems in production environments.

Meetups will be a presentation on someone's experience with a database or related technology in production preceded by 1 or 2 people giving 5 minute lightning talks on technologies they've just begun using and are excited about.

Hopefully a few months after giving a lightning talk the speaker will return to present on their experience as the main presentation.

If nothing else, come by to have a beer and share war stories with others trying to fight through the hype and keep their systems humming.

Please RSVP on the meetup site and sign up for the mailing list.

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.

PLEASE RSVP AT http://couchbase-meetup-pdx-erec.eventbrite.com/

In conjunction with JSConf, Couchbase will be in Portland for this one-time meetup!

Our own J. Chris Anderson and Dustin Sallings will be hosting an afternoon event. In this live coding tutorial, they will take you from never having downloaded CouchDB or Couchbase, all the way through to a running jQuery-based real time chat app.

We will also have some lightning talks by some of our community members.

Thanks to JSConf and Update Portland for helping us put this together.

Couchbase is the name of the new NoSQL database company and product family created through the merger of CouchOne and Membase. Couchbase products, which are built on Apache CouchDB, Membase, and memcached open source software, represent the most comprehensive family of data management solutions for building scalable web and mobile applications, with indexing, flexible querying and ease of use that developers love; and elastic clustering, robust storage management and consistently high performance relied on by system administrators and operators. Couchbase is a privately held company funded by Accel Partners, Mayfield Fund, North Bridge Venture Partners and Redpoint Ventures. www.couchbase.com

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.

Mark your calendars, the time has come.

NEW LOCATION! We're testing out a new location, so this time we will be meeting at the Papa's Pizza on Coberg Rd.(1577 Coburg Road Eugene, OR 97401). Look for us in the private room area in the back.

Same time 11:30am

This Month's Topic: On the 31st Anniversary of Mt St. Helen's eruption, I thought we would talk about catastrophic failures, and what you learned from them.

Also this month we will be raffling a few more books.

Be sure to check out our website:http://eugene.sqlpass.org/Home.aspx

Please join our chapter. If you are not already a member, please register (it's free), then join our chapter. This will get us access to speakers and possibly even our own SQL Saturday some day in the future!

Please email me your RSVP so I can keep a tally for our sponsor, and order enough Pizza

Feel free to pass on this request to anyone else you may think is interested. They still need to RSVP.

See you there!

-- Dan Guzman [email protected]

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

See PDXPUG blog (linked) for 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.

December meeting sponsored by EdgeLink

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

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

10gen: Intro to MongoDB and Schema Design

One of the challenges that comes with moving to MongoDB is figuring how to best model your data. While most developers have internalized the rules of thumb for designing schemas for RDBMSs, these rules don't always apply to MongoDB. The simple fact that documents can represent rich, schema-free data structures means that we have a lot of viable alternatives to the standard, normalized, relational model. Not only that, MongoDB has several unique features, such as atomic updates and indexed array keys, that greatly influence the kinds of schemas that make sense. Understandably, this begets good questions:

• Are foreign keys permissible, or is it better to represent one-to- many relations withing a single document?
• Are join tables necessary, or is there another technique for building out many-to-many relationships?
• What level of denormalization is appropriate?
• How do my data modeling decisions affect the efficiency of updates and queries?

In this session, we'll answer these questions and more, provide a number of data modeling rules of thumb, and discuss the tradeoffs of various data modeling strategies.

ABOUT THE GROUP: The Portland Ruby Brigade is a user group for Ruby programmers in the Portland Oregon area. Join other developers for presentations and discussions about Ruby, libraries, tools and techniques. The group usually meets on the first Tuesday of the month, "Ruby Tuesday".

See PDXPUG blog (linked) for details. Also, "beware the Ides of March", &c.

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

Sqitch information is at http://sqitch.org/

See PDXPUG blog (linked) for details.

Hi, and welcome to the Portland Riak Group.

There are plenty of Riak Users in the PDX area, so it's time we had an official meetup. The team at AppFog was gracious enough to loan their space for the inaugural meeting, and a few members of the Basho team will be on hand to deliver pizza, beer, and stickers.

Here are the talks we have lined up:

7:15

Next Generation Searching with Yokozuna

Eric Redmond; Engineer, Basho Technologies

Riak Search was created to expand Riak's query options. It's worked well enough the past couple years, but it's time to move forward. Yokozuna is the next generation of Riak search, built on the solid Distributed Solr platform. We'll see a preview of what Yokozuna does, what it's going to do, and how that's a marked improvement from the existing Riak Search.

8:00

Riak & Node.js: The Hunt for Cheap, Easy Nines

Nathan Aschbacher; Developer, Coradine

Portland-based Coradine makes an innovative aviation application that helps pilots the world over. Riak powers a lot of this application. Nathan Äschbacher, developer at Coradine, will take you through:

• A quick history of our experience with Riak
• How it came to be we opted to use it at Coradine
• Some of the known hurdles we were going to have to overcome (like cloud deployment)
• Some of the development issues we've encountered
• Why Node.js was a good fit for us and interfacing with Riak
• Abandoning Redis in favor of Riak Memory-store for caching and 2i

---

Hope to see you on November 19th. Let me know if you have any questions .

Mark

twitter.com/pharkmillups

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.

See PDXPUG blog (linked) for details.

Jeremiah Peschka @peschkaj will be giving a talk on the open source .NET Riak Library CorrugatedIron (http://corrugatediron.org/).

Presentation: Riak doesn't have to be limited to the world of open source startups. CorrugatedIron is a full feature .NET Riak client. In this presentation, Jeremiah Peschka will demonstrate using CorrugatedIron and Riak to replace a traditional database in existing applications. We'll cover real world use cases, examine potential problems working with Riak, dive into workarounds and solutions, and even talk about places where Riak isn't a good fit for solving problems.

So get on the RSVP list (via meetup http://www.meetup.com/Portland-Riak/) now to ensure we plan for appropriate seating, food, drinks & prospective hacking.

Ahoy everyone! This shindig is going to be the first ever Meetup of the Portland MongoDB User Group. This event is going to be entirely about socializing, getting to know each other, and enjoying some savory spirits! In the future, I like to have a healthy mix of socializing, hands on coding, lectures and anything else you folks throw my way!

See PDXPUG blog (linked) for details.

This Workshop will cover the following material: -> Install Riak & setup a devrel, and if resources are available, we'll spool up a cluster in AWS, Google Compute or other environment. -> We'll choose a language stack/framework (i.e. C#, Java, Erlang, Ruby, JavaScript or such) and work through connecting to the database and getting data in and out of the database.

So bring your laptop!

We'll also have discussions around architectural guidance, patterns and practices for development.

About this talk

Riak is a masterless, dynamically scalable key-value database. Adron Hall from Basho, the company behind Riak, will be presenting on Riak's design and giving a cluser setup demonstration.

Speaker: Adron Hall

About TechTalks

COPIOUS Labs 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.

Alright Portland, we all love and know the local home grown startup Cloudability here in town, but do we know how they make it all happen? Well, Brad Heller is going to come and enlighten us on how they use Riak at Cloudability. Come and give a listen, we'll have food (give me ideas if you're up for something that isn't Pizza, but we could do both!) and prospectively we'll also be having some other surprises.

An Evening with MongoDB Portland

free

Agenda:

• 6:30-7:00pm: Networking ( A salad and pizza buffet will be out)
• 7:00-7:10pm: Welcome and Introduction
• 7:10-7:15pm: Sponsorship (Dice)
• 7:15-7:45pm: Building Your First App with MongoDB: Tyler Brock
• 7:45-8:15pm: Schema Design: Emily Stolfo
• 8:15-9:00pm: MongoDB at Gilt Groupe: Sean Sullivan

RSVP: http://mongodbportland-2013.eventbrite.com/

RSVP on meetup.com

The very first PDX Graph Meetup!

Huston will be giving an introduction to Graphs, the Graph data model advantage, as well as some tools on how to get your own ideas and Graph Applications up and running!

Basho coworking office hours are every month. The meetup is during the day to come and hack on, deploy or just get a kick start on Riak, Riak CS or discuss NoSQL Solutions and Riak. Our first Coworking Office Hours will be from 9am until 11am on February the 4th. The regular meeting is scheduled for the same day at 7:00pm, generally we always meet at NedSpace unless otherwise mentioned in the meetup.

This Monday meet Eric Redmond AKA @coderoshi and I AKA @adron will be here to answer any questions, strike up discussions about Riak or help with any architectural or data oriented questions you may have. So come and join us, cheers!

Is the siloed internet over? It's too early to tell, but personal cloud is showing tremendous promise as a counter-paradigm that holds the promise of both providing most or all of the services that we currently enjoy and doing so in a way that is vastly more consistent with more stringent understanding of privacy and consent. While there are numerous countries making slow progress on the personal cloud front, none, as far as I know, are considering Riak as a data store for personal clouds. In this talk, I'd like to make the case for Riak as being an ideal technology for this.

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: Ben Kaplin, Systems & Automation Engineer

Datomic leverages distributed storage systems, functional programming and a radical change in information-system architecture to achieve screaming fast write throughput and elastically scalable reads, all while hewing to the Clojure mantra of simplicity in design and engineering.

In the grand finale to our Databases series, Ben will present on the Datomic architecture; the Datalog query language and wax philosophical about the value of programming models that match our mental models. Join us and learn how to bring time as a first-class concept into your data store.

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.

Developers, mobile app builders, NoSQL enthusiasts - join Orchestrate.io for discussions about databases, sharing war stories from production, and to have a little fun.

Please sign up here.

The meetup takes place at Ceili Ballroom at Kells Irish Restaurant on Wednesday, October 16, 2013. Led by Antony Falco, CEO of Orchestrate.io, and Adam DuVander, Developer Communications Director at SendGrid, we'll reflect on the life of infrastructure and databases as we once knew them, and raise our glasses to a future without them.

Libations and appetizers will be provided, with Interment to follow.

CRM: "He Who Has the Data Wins" presented by Rusty Lee

Each of these questions will be presented from both the perspective of you as a business owner, and also as a consultant helping your clients make decisions.

What is CRM?
Why from a business perspective is CRM important?
How can it benefit my business?
What will it cost me?
What's the payback?
How can a small business have an effective CRM program that works?

Agenda: 6:00--6:20 Networking 6:20--7:00 No-host dinner 7:00--7:30 Introductions and announcements 7:30--8:30 Main Presentation (followed by Q&A):

Presented by: Rusty Lee lives in the Battle Ground area and has been supporting the IT needs of Small Business for the last 10 years as CEO for CallMyPcDr.com . He has presented to audiences large and small on a wide range of topics. In a previous life he was Director of Marketing for a manufacturing firm in Portland, responsible for sales and marketing worldwide.

During his over 20 years of Sales and Marketing experience he learned the old fashioned way about the importance of customer data. Back then it was called database marketing. He's kept in touch with his Marketing Roots and now can add the Technology Perspective to the equation of CRM.

In conjunction with the Portland Big Data User Group (http://www.meetup.com/Hadoop-Portland/), Basho Technologies engineer Eric Redmond talks about the NoSQL Key/Value datastore Riak).

A huge thanks to the Copious (http://www.copio.us/) guys for hosting the event!

Food and Refreshments on the house!

Agenda:

6 - 6:30 : Meet and Greet

6:30 - 7 : Intro to Riak

7 - 7:30 : Eric Redmond's Magic Recipe to master Riak

7:30 - 8 : Q&A

8 - 9 : Food & Networking

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.

PLEASE NOTE YOU MUST REGISTER AT THE LINK BELOW TO ATTEND https://hazelcast.com/events/free-instructor-led-training-portland/

Hazelcast Essentials Training Overview:

Hazelcast Essentials is a course designed for Java Developers looking to take their first steps in understanding In-Memory Data Grids (IMDG). By the end of the course the attendee will be able to construct Hazelcast Clusters and deliver basic caching services.

The candidates should be familiar with Core Java concepts and APIs (collections, concurrency). Students will be introduced to the fundamental features of Hazelcast and how they may be applied to solve various use cases. This course is suitable for Developers and Architects with no prior or very basic knowledge of Hazelcast.

AGENDA:

Topics to be covered in the training: Hazelcast Architecture Cluster formation with various discovery mechanisms Cluster deployment strategies Fault Tolerance and Failure Recovery Distributed operations: Caching, Computing and Messaging Distributed Caching: IMap Partitioning and Replication Persistence High Density Memory Store and Hot Restart Hazelcast Serialization

WHAT TO BRING: Bring your laptop, prepared with: A recent Java 8 JDK Your IDE of choice installed – IntelliJ Idea, Eclipse, NetBeans etc. Download lab code from https://github.com/hazelcast/training/tree/master/essentials Build the labs using Maven or Gradle and set as Java project

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.

Presented by Amit Vij (Standard Ins. Atrium) Kinetica, President & Co-founder

RSVP at https://www.eventbrite.com/e/rsvp-for-damapdx-real-time-databases-with-amit-vij-tickets-46502705845

Free for Members! $15 for Non-Members $5 for Students with valid student ID

Modern business is fluid.  Critical business events must be responded to when they occur.  Delays mean lost opportunities and sub-optimal outcomes.  Modern analytics must be as agile as the business itself.

The days of looking at your data in the rear-view mirror are coming to an end.  We are at the dawn of a new analytic revolution:  the real-time database.  

Millisecond latency is the new analytic performance standard.  A new class of GPU-accelerated databases enable this level of performance.  GPU-accelerated databases are over 100x more performant than even the “fastest” in-memory data stores. 

GPU-accelerated databases can provide extreme levels of scalability without negative performance impacts.  They are also easy to implement; thanks to their use of ANSI-standard SQL and hybrid visualization capabilities.  This makes them particularly attractive for some of the most demanding analytic tasks; like scoring of predictive models, and geospatial visualizations.

Join Amit Vij from Kinetica to learn how GPU-accelerated databases can enable real-time businesses.

Speaker

Amit is President and Co-Founder of Kinetica. Amit is responsible for the vision and strategic decisions for the company. Having a background in computer engineering, he has over a decade of software development experience in the commercial and federal space, with an emphasis in analyzing and visualizing big data, and helped architect Kinetica. Amit served as the chief GEOINT technical architect as a contractor for a major Top Secret cloud initiative between the US Army, NSA, and the DIA. Prior to Kinetica, Amit was a subject matter expert on geospatial intelligence with General Dynamics AIS and had been chief architect for several Department of Defense and Department of Homeland Security contracts. Amit received a B.S. in Computer Engineering from the University of Maryland with concentrations in Computer Science, Electrical Engineering, and Mathematics.

When

July 19th, 2018 (Chapter Meetings, 3rd Thursday)

Schedule 8:30 – 9:00 am – Sign In 9:00 – 10:15 am – Presentation 10:15 – 10:30 am – Break, Chapter Announcements 10:30 – 11:30 am – Presentation continued

Standard Insurance Tower (900 SW 5th, please note Standard Ins. has multiple downtown locations) Atrium Room at top of lobby escalators

Nearby parking options that are reasonably priced:

Smart Park (818 SW 4th Ave, Portland, OR 97204) Fifth Taylor Park (545 SW Taylor St, Portland, OR 97204) City Center Parking (337 SW Salmon St, Portland, OR 97204)

Cost

Free for Members! $15 for Non-Members $5 for Students with valid student ID See our corporate members

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.

Want to take your career to the next level?

Practical, Hands-on Training for Advanced Excel Formulas & Functions

Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale, “ 80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.

STRUCTURE OF COURSE

Advanced functions and formulas

 *Logical functions
 *Conditional functions
 *Financial functions
 *Text functions
 *Date functions
 *Array formulas

Lookups and data tables

 *Using lookup functions
 *Using MATCH and INDEX
 *Creating data tables

Advanced data management

 *Validating cell entries
 *Advanced filtering

Advanced charting

 *Chart formatting options
 *Combination charts
 *Graphical objects

PivotTables and PivotCharts

 *Working with PivotTables
 *Rearranging PivotTables
 *Formatting PivotTables
 *PivotCharts

Exporting and Importing Data

 *Exporting and importing text files
 *Getting external data

Analytical Tools

 *Goal Seek
 *Scenarios

Macros and Visual Basic

 *Running and recording a macro
 *Working with VBA code

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

BENEFITS

Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

MAKE YOUR RESUME STAND OUT

They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!

INCREASE YOUR EARNING POTENTIAL

Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical. Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.

INSPIRING ENTREPRENEUR?

A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.

WHO SHOULD COME?

People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.

ADDITIONAL BENEFITS?

FOR FURTHER INFORMATION: PLEASE CONTACT US AT [email protected].

SOLD OUT?

This is one of our high demand classes. In the case, we sale out; email us at [email protected] and ask when our next course will be in

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.

For those who are unable to join MySQL at Oracle OpenWorld, we are hosting an exclusive happy hour in downtown Portland on Tuesday, September 10th. Join MySQL experts and your peers for an evening of complimentary premium cocktails and hors d’oeuvres at the cool speakeasy style bar, Clyde Common!

Kenny Gryp, MySQL’s high-availability expert and evangelist, will be in town to provide a brief update on the latest advancements in MySQL 8.0 and answer all of your questions. Register today and take advantage of this casual evening to share best practices while mingling with your peers and MySQL experts!

Register for virtual conference code; https://www.eventbrite.com/e/rsvp-for-damapdx-mongodb-with-jai-karve-from-mongodb-tickets-95641639719

High level “Who is MongoDB”

MongoDB Architectural Overview

The Document Data Model

Intelligently Place Data Where You Need It

Freedom to Run Anywhere

Live Atlas demonstration

MongoDB has become one of the fastest growing databases since its inception a little over 10 years ago. In this session, representatives from MongoDB will provide an introduction to the fundamentals of the database, including data storage, data retrieval, and deployment. We will also walk attendees through a demonstration of Atlas, our fully-managed database-as-a-service. Attendees will gain a deeper understanding of where MongoDB shines, and how to get started using MongoDB for their own projects.

When

April 16th, 2020 (Chapter meetings held on third Thursday of the month)

Schedule

8:30 – 9:00 – Warm-up 9:00 – 10:30 – Presentation Location TBA

Cost

Free

Presented by NASA Scientists Sponsored by Snowflake

Calling all data enthusiasts and/or space nerds in Portland, Oregon and beyond. Join us for an exciting, all-day virtual event with NASA scientists. Attendees will work with actual NASA data and have an opportunity to collaborate on matters of data analysis directly with our presenters.

Opening Remarks: 8:30 AM: DAMA PDX Board

Morning Session: 9AM – 11:30 AM: Eric Lyness and Victoria Da-Poian, NASA

Eric Lyness is the NASA software and operations lead at Goddard Space Flight Center for the Mars Organic Molecule Analyzer on the ExoMars 2020 rover and Victoria Da-Poian is an Aerospace Engineer. They will present their talk, Machine Learning to Find Life on Mars and Beyond.

In 2021 the European ExoMars rover will land on Mars with the Mars Organic Molecular Analyzer (MOMA) laboratory to analyze soil samples searching for past or present life. NASA is developing machine learning algorithms to help the scientists more quickly analyze the data when it arrives from Mars. In this talk, we will present the current work using MOMA mass spectrometer data acquired during ground testing. Using this data we are aiding the scientists by matching new spectra with the most similar spectra from past experiments. We will present the nuances of mass spectra, our limitations with respect to data, and our approach to the problem. We hope to elicit feedback from the attendees.

More details at https://phys.org/news/2020-06-nasa-life-mars.html.

30 minute Break

Lunch Session: 12:00 – 1:00 PM: Snowflake Presentation, Drew Swanson and Brian Whittington

30 minute Break

Afternoon Session: 1:30 PM – 3:30PM: Details soon!

15 minute Break

Closing Remarks and Next Steps: 3:45 – 4:00 PM: DAMA PDX Board

Times above may be revised in the days before our event.

Event will be presented via a Zoom bridge. Analytical discussions and collaboration will be hosted via a Slack workspace that will begin on event day and last for a few weeks afterwards. This is a BYOAE (bring your own analytical environment). However, attendees will have access to the data via Snowflake and to notebook templates via Zepl.

Pre-event tasks for analysis setup will be shared on 10/19 via email.

Date – Thursday, Oct. 22nd Time – 8:30 – 4:00pm

NOTE: This is an all day event

From the perspective of a DBA and database professional, this session will provide prescriptive guidance to plan and build an enterprise BI solution correctly using best practice design. The mindsets of self-service BI and database development are often different, so using common language and a best-of-breed approach is a crucial step for designing futureproof BI solutions, and “doing Power BI the right way”.

https://www.meetup.com/oregonsql/events/cgrlpsydcdbmb/

Bio: Semih Salihoğlu is an Associate Professor and a David R. Cheriton Faculty Fellow at University of Waterloo. His research focuses on developing systems for managing, querying, or doing analytics on graph-structured data. His main on-going systems project is Kùzu, which is a new graph database management system that integrates novel storage, indexing and query processing techniques. He holds a PhD from Stanford University and is a recipient of the VLDB 2018 Best Paper and the VLDB 2022 Best Experiments and Analysis Paper awards.

Abstract: In this talk, I will present the Kùzu graph database management system (GDBMS) that we are developing at University of Waterloo. Datasets and workloads of popular applications that use GDBMSs require a set of storage and query processing features that relational DBMSs (RDBMSs) do not traditionally optimize for. These include optimizations for: (i) many-to-many (m-n) joins; (ii) cyclic joins; (iii) recursive joins; (iv) semi-structured data storage; and (v) support for universal resource identifiers. Kùzu aims to integrate state-of-art storage, indexing, and query processing techniques to highly optimize for this feature set. I will start by presenting the overall vision of Kùzu and then talk about the novel join operators in the system that performs joins using compressed factorized representations of intermediate tables. Kùzu is actively being developed to be a fully functional open-source DBMS with the goal of wide user adoption and under a permissible license.

Bill Inmon known as the father of the data warehouse and has written 68 books, selling over a million copies in total and translated into 9 languages.

Bill was named by Computerworld as one of the ten most influential people in history of computing. Bill’s company, Forest Rim Technology, has created textual ETL which reads raw text and turn it into a database. Bill lives in Denver Colorado with his wife and his two Scotty dogs.

Abstract

Certain vendors have suggested that the organization throw data into a data lake and then let end users analyze the data in the data lake. The data lake quickly turns into a data swamp or sewer. No one gets any value out of the data lake. In order to turn your data into something useful you need to turn your data lake into a Data Lakehouse. This presentation is all about the evolution of architecture and how to start to get value out of your data lake.

What You Will Learn

In this presentation Bill will discuss:

· The evolution of data architecture

· Data Lakes – where did they come from

· The Data Lakehouse and the analytic infrastructure

· Getting a handle on text – text analytics

RSVP for Google Meet or Zoom link

Cost

Free! (suggested donation $5 for non-members)

If you’ve paid any Data PDX/DAMA membership dues during 2019-2021 or are an employee of a corporate member, please choose Member RSVP.

Where

RSVP for Google Meet or Zoom link

Date – Thursday, January, 19th

Time – 4pm

Speaker

Kamran Shirazi, Google Cloud

Kamran started his career at Teradata as a DWH consultant in 2006, after completing his bachelors in computer sciences with majors in Data warehousing and Data Mining. He worked in Europe with large financial and telecom companies before moving to Portland in 2010. As BI Architect at Nike, he led the DWH CoE group that owned the creation of design patterns and data modeling standards. Later, he joined Intel as an Engineering Manager and led the migration of a mission critical SQL Server platform to the cloud. Kamran carries over 15 years of experience in the data management space and holds certifications in Snowflake, Teradata and Google Data Engineering.

Abstract

Data Governance Overview Components of Data Governance Data Governance through Dataplex Key Features Use Cases Demo Q&A

RSVP for entry ticket. This is an IN PERSON event at Google Portland

Cost

Free! (suggested donation $5 for non-members)

If you’ve paid any DAMA membership dues during 2019-2021 or are an employee of a corporate member, please choose Member RSVP.

Where

555 SW Morrison, Portland, OR Suite 500, Meier and Frank building

RSVP for entry, this is an IN PERSON event

Time – 4pm