Oregon Data Community - A Data and SQL Server Community

Data professionals, despite the scary news and reality of the COVID-19 virus, we will still be holding our monthly DATA meeting, just virtually for now.

Instead of using Eventbrite, we will be using GotoWebinar for our meeting. Please register at this link (will change monthly):

https://register.gotowebinar.com/register/1043102691190981391

After registering, you will receive a JOIN link via email along with a .ics file to schedule the meeting automatically.

We will still have our Social networking opportunities, but we will be using the question feature in GotoWebinar during the presentations.

Bear with us during this upcoming meeting and please let us know how we can do better.

We will be starting at 6:30.

Want to get the Oregon Data Community monthly newsletter?

Go to http://oregondatacommunity.org and click on the little NEWS icon on the right hand side of the website.

Schedule (may be fluid):
6:30 - 6:45 PM - Announcements
6:45 - 7:15 PM - 1st Presentation
7:30 - 8:45 PM - 2nd Presentation

We have a raffle each meeting!

Many thanks to PASS for providing us with our virtual meeting solution!

1st Presentation -
Don Crawford
Big Data in your Personal Life

We have all heard Arnie talk about “Big Data”. This a small demonstration of the “Big Data” at just one of the “ancestry information” vendors.
We will trace ancestry of a volunteer.

• Started in “Data Processing” in May, 1969 at $1.25 per hour. RAM (core in this case) was 50 cents per byte.
• Worked at Lane County, Multnomah County, Software ag, Tektronix, CACI, Tektronix, OHSU, LocalDial, Kamind Inc
• Don Crawford and Associates since 1979 (consulting for Providence Health System, Scottsdale Memorial Hospital, Kaiser Connecticut, various Microsoft Partners and more)
• Active in all areas of IT including development, projects and management
• Very interested in making things simpler and easier to repeat
• Off hours: amateur vintage sports car racer; cars, racing, travel, food and wine.

2nd Presentation -
Michael Wall
Polybase – It’s What’s for Dinner

Polybase is Microsoft’s great new replacement to linked servers. With the current version in SQL Server 2019, one can connect to multiple data sources such as Teradata, Apache, Hadoop, Oracle, and many many more. We will review best practices for setting up Polybase and its Scale-Out groups as well as showing how it interacts in an AlwaysOn Availabilty Group. When Scaling-Out (up!), Polybase is able to work harder and deliver more data. What happens when one of its node disappears? We will have a live demo demonstrating how to manage the Scale-Out group when bad things happen. In addition, the DMVs for managing Polybase will be reviewed, and finally, there will be results of the impact of using multiple nodes in the Scale-Out group on the Polybase queries!

Michael Wall has been an IT professional going back to when he had his own software store and worked with his customers with their “dose” problems. Originally hired by a small consulting firm to write web pages, he was thrust into the SysAdmin world when their lead consultant changed the passwords of all of the servers at a major pulp and paper company’s systems to 100%s$%t and walked out the door. He was sent down with a copy of UNIX for Dummies and 50 cents for the bus ride back. Fast forward a few years, he was asked if he wanted to be a DBA after successfully managing a fifty server Y2K upgrade. Since then, he’s never looked back and has survived a number of data and system challenges.
When not wrangling cats at home, he currently keeps busy with being active in the SQL Community by presenting and coordinating. He is blessed with a wonderful family and two lazy cats and keeps treading water literally down at the local pool.

Many thanks to Serverlogic for their continued support!