BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20190310T020000 RDATE:20190310T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20191103T020000 RDATE:20191103T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190906T011159Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190911T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190911T183000 DTSTAMP;VALUE=DATE-TIME:20190906T011159Z LAST-MODIFIED;VALUE=DATE-TIME:20190906T011159Z UID:http://calagator.org/events/1250476174 DESCRIPTION:Michael Wall \;\nPoSh for SSRS: Essential Skills to Manage Your Report Server with PowerShell \;\n \;\nWhether you are a cas ual report designer or a DBA who has the responsibility of managing the SSRS installs at your company\, you will find the new PoSH tools for SSR S to be very useful. This demo heavy presentation will do a deep dive on a number of the new PoSh tools for SSRS. From deploying new SSRS instal lations to easily and *QUICKLY* backing up and restoring your reports\, everyone will come away from this presentation ready to go to work with PowerShell! \;\n \;\nMichael Wall has been a Database Administrato r since he was asked if he wanted to be one after successfully managing the Y2K upgrade project on over fifty UNIX servers. Immediately thrust i nto a major Oracle upgrade project\, he has since then managed multiple challenges and now is the sole DBA for a global food processing company responsible for both SQL Server and Ingres databases. \;\nHe was hono red to speak at PASS Summit in 2018 and hopes to have the experience aga in! \;\nHe is currently very active in his SQL Server community (PACN W) both as a presenter and assisting with multiple SQL Saturdays. Having experienced the Power BI community\, he has now gone back to basics and is working with his VAXen at work again. \;\n \;\nAlberto Santaba lla \;\nJSON In and Out “Ins and Outs” \;\n \;\nEven if you’re not planning to use JSON in the database yourself\, you may come up agai nst JSON in the SQL environment at some time. Let’s review some simple t echniques to parse elements from a JSON formatted field and to generate JSON from SQL queries. \;\n \;\nAlberto SantaballaAl is a lifelong software developer but with a strong data gene. Always curious about ho w to bend SQL to do interesting things and totally drawn in when someone says “I don’t think you can do that with SQL”. Happy transplant from th e very muggy Southeast and member of OregonSQL for the five years here i n Portland. \;\n \;\n \;\nRefreshments graciously provided by S erverLogic. \;\n \;\nWe wish to acknowledge the OSHU Information T echnology Group for supporting Oregon SQL by generously providing the me eting venue. \;\n \;\n\n\nTags: #SQL #DATA\n\nImported from: http: //calagator.org/events/1250476174 URL:http://oregonsql.org SUMMARY:Oregon Data Community (also known as Oregon SQL) - PoSh for SSRS: Essential Skills to Manage Your Report Server with PowerShell LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190930T001101Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191009T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191009T180000 DTSTAMP;VALUE=DATE-TIME:20190930T001101Z LAST-MODIFIED;VALUE=DATE-TIME:20190930T001101Z UID:http://calagator.org/events/1250476255 DESCRIPTION:Query Optimization Statistics – The Driving Force Behind Quer y Performance \;\n \;\nWhen the SQL Server optimizer evaluates a q uery to determine how best to execute it\, the statistics are quite poss ibly the most important information at its disposal. But SQL Server stat istics objects aren’t perfect because they only contain estimated summar y information. In this session\, we’ll start with an overview of what th e statistics objects are\, how the optimizer uses them\, and some genera l guidelines for their maintenance. Then we’ll look at some of the issue s\, how to find them\, and how to solve them\, that can arise due to the ir imperfection: ascending keys (the most prevalent statistics based per formance killer?)\, skewed distribution\, or downright bad summary infor mation. There’ll be many examples\, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss\, you WILL see improved query performance. \;\n \;\nVern is an independe nt SQL Server consultant and contract trainer in Portland\, OR\, and lea der of the OregonSQL user group. He has attained MCSE\, MCITP (both Admi nistration and Development)\, and MCT certifications\, among others. Ver n has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server know ledge gained from the mixture of academic and practical experiences acqu ired from his classroom instructing and varied consulting contracts. \;\n \;\nMichael Curry \;\nTheory Driven Data Science: Cybersecuri ty Improvement using SQL\, R and machine learning \;\n \;\nData sc ience seeks to uncover actionable data relationships to solve pressing o rganizational needs e.g. improved cyber security behavior\, and this tal k presents three steps for doing just that. The goal is a clear picture on how to leverage those actionable data relationships\, e.g. how effect ive was a cyber security training program? The aim of this presentation is to provide an exemplary theory driven approach to building evidence o f being better prepared against a cybersecurity threat. \;\n \;\nD r. Michael Curry is a Cyber security behavioral researcher utilizing dat a science methodologies to develop actionable data relationships to solv e pressing organizational needs e.g. improved cyber security behavior. H e is part of the OregonSQL Leadership and also an instructor for Oregon State University. \;\n \;\n\n\nTags: #OregonSQL #Data #SQLServer\n \nImported from: http://calagator.org/events/1250476255 URL:http://oregonsql.org SUMMARY:OregonSQL/Oregon Data Community - Query Optimization Statistics – The Driving Force Behind Query Performance LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20191024T052000Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191114T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191114T183000 DTSTAMP;VALUE=DATE-TIME:20191024T052000Z LAST-MODIFIED;VALUE=DATE-TIME:20191024T052000Z UID:http://calagator.org/events/1250476352 DESCRIPTION:Janis Griffin \;\nHiHo! HiHo! SQL Server on Linux\, we go! \;\n \;\nAre you being forced to the ‘Cloud’ to reduce costs? SQL Server 2017 now runs on Windows\, Linux\, and Docker containers. \;\ n \;\nNow SQL Server can be installed on Linux in order to provide a consistent database platform across Window and Linux servers\, as well a s on-premises and in the cloud. This presentation will discuss the advan tages of using SQL Server on Linux\, comparing architecture\, cost and p erformance. Several demonstrations on installing and maintaining SQL Ser ver on different Linux distributions and Docker will be shown\, as well as best practice considerations for production/development environments. Also\, several useful Linux commands for monitoring\, managing and back ing up SQL Server will be demonstrated. Finally\, client connectivity an d tools will be discussed – plus the new Azure Data Studio UI with the a bility to add monitoring widgets will be demonstrated.\n\nTags: #SQLSERV ER #LINUX\n\nImported from: http://calagator.org/events/1250476352 URL:http://oregonsql.org/announcements/november-13-2019-hiho-hiho-sql-ser ver-on-linux-we-go SUMMARY:Oregon SQL - HiHo! HiHo! SQL Server on Linux\, we go! LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20191204T055340Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191211T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191211T180000 DTSTAMP;VALUE=DATE-TIME:20191204T055340Z LAST-MODIFIED;VALUE=DATE-TIME:20191204T055340Z UID:http://calagator.org/events/1250476483 DESCRIPTION:Reid Havens \;\nDemystifying Chart Types and Report Design Principles in Power BI \;\n \;\nFailing to deliver a well-designe d Power BI Report can be a common reporting pitfall. What good is qualit y data if it is not presented in a way that is meaningful or easily unde rstood? Someone without any prior knowledge should be able to quickly un derstand a report without explanation and be quickly drawn to the key el ements you want them to view. This talk will walk through many elements of bad report design. Learn about visual cues and how certain chart type s can convey data more accurately than others. Also\, learn about the ba sic dos and don’ts of report design and layout\, using easy-to-learn tec hniques that bring data to life. \;\n \;\nPaul Turley \;\nPrevi ew: A Best Practice Guide and Checklist for Power BI Projects \;\n 3\;\nWhether designing moderate-scale reports for a few business users o r large-scale solutions with loads of data for an entire corporation\, t his session provides best practice guidance for the essential components of Power BI projects. Power BI is a very flexible platform with an vast range of options and often overwhelming design choices. We will discuss recommended practices to manage datasets and reports for team collabora tion\, version control\, query optimization for scale\, data modeling de sign patterns\, measure design\, dataset certification and governance. W e will conclude with a complete checklist of important items to ensure p roject success. \;\n\n\nTags: #PowerBI\n\nImported from: http://calag ator.org/events/1250476483 URL:http://www.oregonsql.org SUMMARY:OregonSQL - Reid Havens - Demystifying Chart Types and Report Des ign Principles in Power BI LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200102T155102Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200108T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200108T180000 DTSTAMP;VALUE=DATE-TIME:20200102T155102Z LAST-MODIFIED;VALUE=DATE-TIME:20200102T155102Z UID:http://calagator.org/events/1250476631 DESCRIPTION:Data professionals\, we love being able to offer you amazing tech presentations every month\, networking opportunities\, and most imp ortantly snacks so you can focus on the presentation! While not everyone may want food\, we rely heavily on the registration count in Eventbrite (NOT Meetup) to ensure we have enough food for everyone. If you can ple ase help us and register through Eventbrite\, even if you RSVP in Meetup \, then we can aim to feed you all. Thanks for your help!! \;\n \; \nhttps://www.eventbrite.com/e/2020-oregon-data-community-meetings-ticke ts-86227949117 \;\n \;\nWant to get the OregonDataCommunity monthl y newsletter? \;\n \;\nGo to http://oregonsql.org and click on the little NEWS icon on the right hand side of the website. \;\n \;\n Schedule: \;\n6:00 - 6:30 PM - Hearty Snack and Networking \;\n6:3 0 - 6:45 PM - Announcements \;\n6:45 - 7:15 PM - 1st Presentation \;\n7:30 - 8:45 PM - 2nd Presentation \;\n \;\nWe have a raffle ea ch meeting! \;\n \;\nIn December’s short session\, Paul introduced a set of guidelines for Power BI projects. This deep-dive session will explore those best practices with several examples and hands-on demonstr ations. \;\n \;\nWhether designing moderate-scale reports for a fe w business users or large-scale solutions with loads of data for an enti re corporation\, this session provides best practice guidance for the es sential components of Power BI projects. Power BI is a very flexible pla tform with an vast range of options and often overwhelming design choice s. We will discuss recommended practices to manage datasets and reports for team collaboration\, version control\, query optimization for scale\ , data modeling design patterns\, measure design\, dataset certification and governance. We will conclude with a complete checklist of important items to ensure project success. \;\n \;\nWilliam Aguilar \;\n Glad I Pushed Back \;\n \;\nAn anecdotal presentation about Q & \; A including a use-case for the RAND operator in T-SQL. I am an interm ediate Data Analyst with not quite a full year of professional experienc e. After being tasked with a project to compare tables between two serve rs to check for inconsistencies\, I developed a method for screening lar ge random samples. My suggestion was turned down for a method developed by someone with over 20 years of BI experience. I obviously went with th e advice of my co-worker and followed his format… once or twice. I later compared the results of his method to that of my Q&\;A which had a m uch more profound impact than my previous explanation.\n\nTags: #PowerBI #Data\n\nImported from: http://calagator.org/events/1250476631 URL:http://oregondatacommunity.org SUMMARY:Paul Turley Part 2 – A Best Practice Guide and Checklist for Powe r BI Projects LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200206T145846Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200212T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200212T180000 DTSTAMP;VALUE=DATE-TIME:20200206T145846Z LAST-MODIFIED;VALUE=DATE-TIME:20200206T145846Z UID:http://calagator.org/events/1250476773 DESCRIPTION:Python: Turn your SQL ETL up to 11 \;\n \;\nAlmost ever ywhere you look in the data community you see Python being used (job-pos tings\, Azure Services\, AWS Service etc…). But what is Python\, and why has it become such a popular tool for Data Professionals? During this d iscussion we will talk about what is Python\, why is it being used so he avily\, what benefits it provides\, and what is in store for future uses of Python. There will be demos using Jupyter Notebooks doing data analy sis\, importing data into database (ETL)\, and light visualization.\n\nT ags: #Python\n\nImported from: http://calagator.org/events/1250476773 URL:http://oregonsql.org/announcements/february-12-2020-moving-to-python- for-a-sql-developer SUMMARY:Moving to Python for a SQL Developer LOCATION:OHSU IT Group\, 1515 SW 5th Ave\, Suite 900\, Portland OR 97201: 1515 SW 5th Ave\, Suite 900\, Portland OR 97201 USA SEQUENCE:1 END:VEVENT END:VCALENDAR