6:30PM – 8:30PM
Congratulations to Eric Burger, the winner of the April 2020 ODC Raffle of a year’s worth of training from Pragmatic Works.
Test Your Database Code or Your Users Will
Database bugs in the wild can be massively destructive and expensive. Professional database developers need to take every reasonable step to prevent bugs from reaching production servers. This session focuses on how to use tSQLt to create a suite of reusable, automatable, informative tests to protect your code and your customers from unexpected change. Develop, Deploy, and Refactor with confidence.
I’ve been studying databases ever since I learned to write random-access files to floppy discs on my father’s TRS-80 back in the 1980’s. I’ve migrated a mini-mainframe PICK R91 database to Microsoft SQL Server using MS Access to help scrub the data. I’ve used MySQL in a LAMP environment for web sites, and used Neo4j to track my genealogy. I am an advocate of automation, testing, and continual integration. I gladly speak at length about Database Unit Testing.
Data Modeling Solutions for Challenging Data Modeling Problems
Do you suffer from “ambiguous relationships”? Have you expanded your vocabulary while encountering errors trying to relate multiple tables in a data model?
Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In this session, we will enumerate common challenges and demonstrate modeling techniques to resolve them. Learn to model star and snowflake patterns, many-to-many relationships, role-playing dimensions, disconnected slicers and dynamic, slicer-driven measures.
Paul (Blog | LinkedIn | Twitter) 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.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.