August 12, 2020: potpourri

In support of social distancing, Oregon Data Community meetings will be online until further notice.
6:30PM – 8:30PM Pacific

Congratulations to Kim Gushulak, the winner of the July ODC raffle of a year’s worth of training from Pragmatic Works; and Dana Harding, the winner of the July 2020 ODC raffle of a Redgate SQL Prompt license.


Join us for a special five star line-up of presentations, each between 15 and 30 minutes long.


Register NowDon’t miss this meeting!


Tim Combs
What is Developer Advocacy?

Download Tim’s presentation slides here.

Developer Advocacy is a new field in software development that has grown out of AGILE and Open Source methodologies and encompasses digital marketing, sales engineering, customer satisfaction.

Tim Combs
Tim Combs is a Web Development Educator with OpenClassrooms.

 


Glenn Berry
Hardware 301: Evaluating and Choosing Database Hardware for SQL Server 2019

Download Glenn’s presentation slides here.

Microsoft made some sweeping changes to their software licensing model for SQL Server 2012, moving from socket-based licensing to core-based licensing. This new licensing model alters much of the conventional criteria for hardware selection for database servers that will be running SQL Server 2012 and newer. This change still causes a significant amount of angst, with fears of huge increases in SQL Server licensing costs compared to older versions of the product. This session will cut through the uncertainty and hype to show you how to properly evaluate and choose your database hardware for usage with SQL Server 2012 and newer. You will learn how to choose hardware for different types of workloads and how to get the best performance and scalability for the lowest licensing cost, whether you are running in a physical or virtualized environment.

Glenn Berry
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University – University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dive and SQL Server MVP Deep Dives Volume 2 books. Glenn blogs regularly at https://glennsqlperformance.com/. He is active on Twitter as @GlennAlanBerry.

 


Jody Pilsworth
Azure Data Studio Recent Feature Updates…Plus DBAtools + Diagnostics + SQL Notebooks = Awesome!

Download Jody’s presentation slides here.

This session will highlight recent 2020 updates to ADS and look at a dbatools command that creates a diagnostics SQL notebook.

Jody Pilsworth
Jody Pilsworth is a BI/ETL/Data Warehouse Architect with PacificSource Health Plans.

 


Joe Dunn
Build Communities Today

Download Joe’s presentation slides here.

Our communities are changing with the world that we live in, what can we reimagine for the communities of tomorrow?

Joe Dunn

 


Paul Turley
Futureproofing Power BI solutions

When starting a Power BI project, you have many choices to make. Decisions like how to source your data, where and how to create queries to cleanse, transform and reshape the data; where and how to create calculations and the nuances of modeling are just the tip of the iceberg. The purpose of this presentation is to provide some guidance to help you design Power BI solutions that can survive the journey through these stages with as little “throw-away” design as possible. There will always be prototyping and redesign in any project but if you follow proven design patterns and lessons learned from prior experience, you’ll have a much better chance of building a reporting solution that will endure.

Paul TurleyPaul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter & user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox & Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

 


ServerLogic


Register NowDon’t miss this meeting!


 

Posted in Announcements | Comments Off on August 12, 2020: potpourri