Tableau ShadowDB on Azure Database for PostgreSQL
Avoid granting privileged access to non-admins and reduce database loads on a Tableau production server by building a copy of the transaction database on Azure Database for PostgreSQL.
An Angular directive for handling click events outside an element. Useful for things like reacting to clicking outside of a dropdown menu or modal dialog.
Solr - Facet Query
The Solr query for the facets filter click is similar to the query for the page overall, with a change in the filter parameter in the JSON.
Solr - Server Health Status
The Solr Ping request handler is an endpoint for load balancers or service warning systems can use to check the "up" status of a Solr server or container.
Python - snips
The following notes and examples might be useful when trying use Python for manipulating Tableau server content, getting data from Solr, or posting content to Lucidworks Fusion.
WordPress - snips
A few notes on integrating WordPress into a personal HTML website and implementing it in an enterprise as a team blogging platform.
Search App Framework
Proposal for a (mostly) API-driven Docker and microservices-based Angular search application framework.
Calling all Noahs
Wistful thinking about how "container solutions" could provide adaptations to global warming.
Practical reasons for social distancing aren't purely physical.
An ancient DevOps culture devoted to containers for virtualization.
Apache Solr and Docker
Reference notes on running SolrCloud in Docker on Ubuntu Linux.
Docker - basics
One way to spare yourself from a deluge of server resource requests is to build on a platform that supports containers.
Apache web server SSL certificates
Crib notes for adding SSL certificates to an Apache web server on different Linux operating systems.
A collection of guidelines for handling CSS.
Apache Solr - Configuration Examples and Resources
A small collection of tips, file snippets and resources that may be useful when configuring an Apache Solr search engine.
Install Elasticsearch, Kibana, Apache, PHP and ODBC on CentOS 7
Dynamically display ERStudio models that could be viewed by everyone in the enterprise.
Fusion Server - Query Pipelines
A collection of examples demonstrating how to use a variety of Lucidworks Fusion Query Pipeline stages.
Fusion Server - Storing and Analyzing Signals
Fusion signals data can reveal a lot about how people use a search-based web application.
In Linux, most of the console commands that can be run from the command line can be scripted and run by an automation program called shell.
Fusion App Studio - Tracking Clicks
A Lucidworks App Studio web application connected to a Fusion Search server collects interactions as "signals."
Fusion Server - Backup
Copy live files to static local files on each server in a Fusion high-availability cluster.
Tableau Server - Permissions
In Tableau Server v2018.2.3, all data asset permissions are found in the next_gen_permissions table.
Fusion Server - Index Pipelines
A collection of examples demonstrating how to use a variety of Lucidworks Fusion Index Pipeline stages.
A collection of notes on Regular Expressions in a variety of situations.
On Linux servers, cron can be used to schedule jobs that run commands and shell scripts at fixed times, dates or intervals.
Tableau Server - SQL Queries
A collection of PostgreSQL queries for old time's sake.
Fusion App Studio – A Collection of Code Snips
A collection of code snips using Lucidworks App Studio – a modular code framework for developing bespoke, data-anywhere search and discovery web applications.
F-F-F-Fade Away Text …
My favorite way to trim a text element is to fade it away the at end instead tailing it with ellipses. . . because the approach is a more subtle invitation to click for more information and it’s simple to do without a lot of code.
Embed WordPress blog in site with version control and automated deploy
Here’s one way to embed a WordPress blog into an existing website already managed by a version control system and a continuous deployment service workflow to a cloud server.
Principal BI Platform Engineer
Raised the mission's core competence in AI-powered search through technical leadership in enterprise insight engines and related digital products.
An EDW infrastructure
Enterprise data warehouse infrastructure diagram representing how current and future plans might play out.
Brave are they
Uncovering what does not want to be found can be dangerous.
myHIway Data Catalog
A mobile and desktop search application for finding, collecting, comparing and accessing data assets across multiple enterprise business intelligence platforms.
If datasets were city blocks, their metadata would be the streets and houses.
Flash mob of cheer
A holiday greeting delivered at last minute though a flash mob of well-wishing clones.
Fusion Server – V2.1 Start Up as Non-root User in CentOS 6.6
Starting up Lucidworks Fusion 2.x automatically on a single CentOS 6.6 server is tricky, because the Fusion 2.1 Users Guide assumes you are using Ubuntu Linux and Upstart scripts. On CentOS or Red Hat Linux, you’ll have to roll your own.
To keep data governance program sponsors awake through the technical bits of a platform proposal, I used a tree metaphor for describing platform elements.
Semaphore 4.x ontology model not flushing properly when published
Smartlogic Search Application Framework (SAF) search dialog box suggestions context did not change after the underlying Smartlogic Semaphore 4.x ontology names changed from “Locations” to “Organizations.”
Fusion Server – V2.1 SQL datasource connector returns only one document
When working with Lucidworks Fusion 2.1 search, one of the first steps is to index content from a data source. You’ll find it can index just about anything, but when indexing a MS SQL table it might fail silently and not return all documents.
Some day, my search platform will be so smart, it can positively correlate a clinical business concept like "Primary Care" with providers, clinicians and physicians, while negatively correlating with bartenders.
How lucky do you feel
Without governance, SharePoint 2010 search became a landfill of old, abandoned, and redundant documents with little authoritative value. The chances of finding something meaningful were about as good as winning big at the lottery.
Knowledge Organization Systems
Broadly speaking, a Knowledge Organization System (KOS) stimulates a business by turning an understanding of users, facts and aspirations into different types of structured data and unstructured content. The concept was fun to illustrate.
Data governance programs help get the most facts to the most people in the most elegant way possible through methodologies like master data stewardship, element models, ontologies, data glossaries, and data catalogs.
When working with data in a large healthcare enterprise, one needs to be fluent in a few dozen languages and vocabularies, many of which sound like they were created to communicate with aliens.
Tiles web part
An easy to maintain SharePoint web part that grouped document links into colored category boxes and resized to fit all desktop display devices.
I like you
A study in silliness and ink on Bristol board.
'Tis the season'
A fishy commentary on the commercialization of Christmas.
Sometimes a great potion
Cooking up insights from data sometimes involves a bit of magic, a few strange incantations and mysterious ingredients.
Following the beaten path makes life easier, but you should still be prepared for the worst.
A mobile and desktop search application that helps Providence caregivers quickly find basic information about all enterprise employed, contracted or affiliated providers.
Home Medical Equipment KMS
A mobile and desktop search application for finding durable medical equipment that aligns a patient's therapeutic needs and payment plan.
Someday, someone will try to capitalize on light pollution by creating new constellations.
Senior Information Architect
Played a central and crucial role in the vision and work that became a strategic enterprise data information portal.
Life is but a dream
Finding joy in code, because programming should be fun.
An enterprise SharePoint web application which identified and curated the "top" reports from multiple reporting platforms.
Display Tableau dashboard in SharePoint web part
When the business needs to view Tableau dashboards or visualizations in SharePoint 2010, the most complete solution is to install the Tableau Server Service Application into the SharePoint farm. But what if it is not installed or supported on the farm?
People like to avoid SharePoint 2010’s Rich Text and Enhanced Rich Text editors until they find out they can paste in their Word document.
Standard Workflows Dial
An enterprise SharePoint web application for finding best practice clinic workflows.
Reporting Services web parts on SharePoint page
Adding Report Builder web parts to SharePoint 2010 made the page colorful and intelligent, but the UI lacked a bit.
Using “Append Text to Query” in Search Core Results
SharePoint Search indexes and returns as much as it can, and it depends on you to filter out what you don’t want.
Open SharePoint List/Library Link in New Window
Why can’t a SharePoint list/library web part open links in a new window by default?
Calculated Columns for Cascading Drop-Downs in SharePoint Lists and Libraries
SharePoint list or library users need a simple way to enter data in one column that depends on what was entered in another, but out-of-the-box SharePoint 2007 or 2010 does not support direct cascading functionality.
Generate a hierarchical XML file from SharePoint list
Get data from a SharePoint 2010 list and generate a hierarchical XML file that can be used as a data source for a Flash movie on a site without SharePoint Designer.
Automatically close a SharePoint 2010 Edit form opened from a Reporting Services web part
SharePoint 2010 Edit and Display forms can be modified with InfoPath. This opportunity comes with a few new bugs, but the UI and functionality can be compelling.
Using HTTP-EQUIV to refresh a page
Using an HTTP-EQUIV meta tag is a simple way to automate this thank-you and form refresh process. The InfoPath form’s meta tag just needs to contain an &Source reference back to the original page.
Access Denied for Visitors on a SharePoint Page with Reporting Services Webpart
If you are working in SharePoint 2010 and discover that users in the Visitors group or All Authenticated Users are unable to open pages that contain a Report Services web part with an Access Denied error.
Get the BDC Identity value from a SharePoint 2010 External List to SQL Server
Say you have a Reporting Services web part, and you want to change an indicator on the report from red to green with a single click. To do this, without relying on SharePoint Server Admins, build a Visual Studio 2010 C# Express Console Application following the Client Object Model.
Health Plans KMS
A high functioning SharePoint Intranet website and web application for health plan content.
A SharePoint Intranet website for Providence caregivers to find Clinic providers, locations and specialties in Oregon.
Built out-of-the-box and custom SharePoint platforms, websites, applications, forms, workflows, document management and BI solutions.
Reduced operational costs of Physician IT Outreach and System Support Services teams with SharePoint platform work.
Edenbound Brand Logo & Stationery
Company name, logo and stationery for beneficial microbials startup.
Street of Greens
Development proposal for 25 affordable two-story single family 'green' homes modeling a sustainable Northwest lifestyle measured by the Living Building and Sites Challenge of the Cascadia Region - Green Building Council
When the benefits of hanging on outweigh the discomforts.
Dove Creek Acres Logo & Stationery
Logo and stationery for equine assisted therapy business.
IMR Logo & Stationery
Logo and stationery upgrade for information technology and business management company.
Simple back-of-napkin garden design for a residence in Redmond, Washington.
Accountable for company reorganization, sale of IT consulting service line, market testing and implementation of innovations in sustainable housing, carbon sequestration, equine assisted behavioral health therapy, e-commerce, education, and beneficial microbes startups.
Greeting card - Flowers
A hand inked and colored greeting card for a special birthday.
Bottom of heart
Designing a space for love with the aid of CAD software.
Plans, details, specs and planting guide for a residential garden in Beaverton, Oregon, built over three years from 1994 to 1997.
Lincoln High School Fence
A wall of painted steel window shapes set atop a thick cast-in-place concrete wall with bronze inlay and glazed tile relief work.
Senior IT Consultant
Accountable for company operations, P & L, tenant improvements, hiring, technical infrastructure, customer relations, project delivery, and service quality.
MAX Westside Light Rail
Portland's Westside MAX light rail's precedents in urban transit design, engineering, accessibility and collaboration became a model for other surface rail systems in the United States and other countries.
Mt. Angel Abbey Hilltop Master Plan
Master plan for a monastic community that coalesced goals for growth into specific improvements to campus and building facilities on a landmark Willamette Valley hilltop.
Illustration for church playground with happy kids playing on a pre-engineered modular structure system.
Landscape design for hillside house on a busy street in a Portland, OR neighborhood.
Northgate Transit Center
Bus transit station on First Avenue next to the Northgate Shopping Mall north of Seattle, WA.
IMR Logo & Stationery
Logo and stationery for information technology and business management consulting company.
A pair of free-form flowering plant art pieces on watercolor board with integral hand-cut mat board.
Holladay Street improvements
Street improvements for rail transit along NE Holladay Street in Portland, OR.
Residential garden addition and hillside stabilization afforded by property line and fence adjustments.
This Oriental looking out-building was the centerpiece of ambitions for a Japanese style garden.
Rodman Dentistry Logo & Stationery
Logo and stationery for dental care company.
Gold Leaf Series
Free form organic shapes on watercolor board that featured gold leaf and integral hand-cut matting.
Landscape schematics and build for residential garden in Southwest Portland OR.
On the Wing
Poster of hillside sanctuary for a country girl and her wildlife.
Copper, stainless steel and precast concrete public art proposal that paid homage to the 'City of Roses' in downtown Portland, OR.
Embarcadero Waterfront Parkway
Urban design study for the Embarcadero roadway from Mission Bay to Fisherman's Wharf in San Francisco, CA.
Houses of the Batammaliba
Poster on the essentials of a book called "The Anatomy of Architecture" for a University of Oregon graduate study class.
Greeting card - Merry Moons
A hand inked greeting card for year-end holidays.
Portland Pioneer Square Study
This poster of Pioneer Courthouse Square in downtown Portland, Oregon was a byproduct of graduate studies in Urban Design Studio at the University of Oregon. It brought talking points to a broader group discussion on urban spaces.
Landscape design for a residence in the west hills of Portland, OR extended the main internal axis of the house into outdoor rooms at front and back entries.
Stained Glass Windows
A couple of ornamental glass windows.
Concept proposal for new Oregon Public Broadcasting headquarters located on the historic Police Block in downtown Portland, OR.
Greeting card - Leon
A hand inked greeting card for the end-of-year holidays.
Arch 585 - Camp Melinda Studio
Architectural Design studio site plan and building proposal for a youth camp in Florence, OR.
Greeting card - Onward
A hand inked greeting card for college graduate.
Police Headquarters Renovation
Cutaway isometric illustrating interior renovation proposals for the historic Police headquarters building in downtown Portland, OR.
Bellevue CBD Zoning Study
A planning study for Bellevue, WA which illustrated floor area ratio (FAR) policy changes affected the downtown cityscape.
Sought with others to improve deficient transit, community and urban spaces through solutions that outperformed the commonplace.
Valley River Center Offices
Proposal for new buildings and landscaping on land near the Valley River Center Mall in Eugene, OR.
Independent consulting work on planning, garden, and visual art projects.
Greeting card - Hollywood
A hand inked greeting card for someone moving to Los Angeles.
For Barefeet Only
Poster of valley sanctuary for a barefoot girl and her cat.
JaDo Peace Garden
Garden, building and circulation improvements design for a 4.5 acre rural property mindful of a family's wish to build a restorative place to live and share with their community.
Construction work with five person construction crew on pool, pond and fiberglass spa installation, repair and maintenance projects.
Greeting card - Bear
A hand inked greeting card for birthdays.
Sometimes, success comes from hanging loose rather than striving.
Gaslight Corporation Logo & Stationery
Logo and stationery for resort development company.
Residential pool and spa design proposal for a family with horses in Eugene, OR.
McCredie Hot Springs Resort
Comprehensive site plan and building concept for health resort community on Highway 58 near Oakridge, OR.
Livingry Systems Logo & Stationery
Logo and stationery for systems design company.
Winter season work designing and detailing plans for improving business storefront through low cost office interior and exterior landscape improvements
Graphic introducing freelance art skills to clients in job interviews during college.
The girlfriend of a friend used this flyer to find housecleaning work. After she married that friend, she no longer needed to leave the house to find housecleaning work.
Forward-thinking economic, social and ecological design for land reclamation and sustainable community development on a property near Concord, CA.
Hult Center Sculpture
Illustration for newspaper article announcing a performing arts center's plans to commission a wall sculpture honoring donors.
S Corporation Logo & Stationery
Logo and stationery for an event production company.
Greeting card - Easter
A hand inked greeting card for Easter.
Graphic for university newspaper article about Soviet visions of power and persecution in 1982.
Graphic for university newspaper article about the drug trade and civil war in El Salvador.
LA 260 - Understanding Landscapes
Illustrations reflecting on a three-week trip through parts of Egypt with my father from a Landscape Architecture course.
Part time work with architectural designer and clients in analysis, design, model building, delineation of a handful of projects.
Less is more
Editorial cartoon about proposed cuts to the state's higher education budget in 1982
Sacred Heart brochure
Sacred Heart General Hospital in Eugene, Oregon asked me to layout and illustrate a flyer that introduced a new paid time off policy to employees. I appreciated their patience and courage.
Time to move
Graphic for university newspaper article about the annual Civil War football game between the University of Oregon Ducks and Oregon State Beavers.
Race for the roses
This two-color graphic for newspaper article about likelihood of the University of Oregon football team going to the Rose Bowl.
Graphic for university newspaper article about diversionary board games.
Fall Orientation cover
Two page graphic for Fall Orientation edition of student newspaper.
A repelling thought
Graphic for university newspaper article about handheld CS gas as a rape deterrent.
The Elegant Duck
Poster-sized front page graphic for Fall Fashion Supplement of university newspaper.
Fall Preview cover
Two full-page graphics with a collage of scenes representing campus life for a Fall preview edition of university newspaper.
University crucial to local business
Graphic for university newspaper article about the extent many businesses in Eugene, OR depended on an unpredictable campus population for survival.
The olde Oregon Trail
Graphic for university newspaper article about a raise in tuition fees.
Graphic for university newspaper article about a hand-and-foot-powered bicycle.
Graphic for university newspaper article about how to identify the elusive "Eugenean."
Graphic for university newspaper article about the arrival of cable TV to Eugene, Oregon.
Graphic for university newspaper article needing a map to highlight where to find a new running trail along a Willamette River park in Eugene, Oregon.
Graphic for university newspaper article about the deficiencies of a Liberal Arts major in a technological age.
Campus thieves thrive
Graphic for university newspaper article encouraging students to be more active about reporting campus thefts.
Losses increase hospital bills
Graphic for university newspaper article about rising patient medical costs.
Graphic for university newspaper article about generating revenue from summer conferences on campus.
Postal Service decision
Graphic for university newspaper article about an increase in postage stamp cost.
Another one for the budget
Editorial cartoon for university newspaper about the swearing in party for the University of Oregon's 13th president.
Graphic for university newspaper article about "deadheads" inundating Eugene for a Grateful Dead concert at Autzen Stadium.
Graphic for university newspaper article about farm produce available to readers.
Graphic for university newspaper article about child abuse.
New coalition backs candidates
Graphic for university newspaper article about student elections.
Area drownings increase
Graphic for university newspaper article about water hazards around Eugene, OR.
Job supply remains low
Graphic for university newspaper article about the impacts of a national economic downturn.
Graphic for university newspaper article about a new tool library in a renovated house near the University of Oregon campus.
Tuition due to rise
Graphic for university newspaper article about tuition hikes.
LA 489 - Site Planning and Design
Economic revitalization proposal for a central Eugene, OR neighborhood group from a Landscape Architecture design studio.
LA 366 - Site Construction
Process diagram for sewage treatment plant.
LA 366 - Site Construction
Written procedure for repairing a hillside and prevent water erosion from a Landscape Architecture course.
Part time work with architect and designer during site analysis, design and delineation of a phased ecological land use development proposal.
LA 366 - Site Construction
Illustration describing the process of making a stained-glass lamp from a Landscape Architecture course.
Work as a self-employed graphic artist on a handful of private and commercial initiatives.
LA 511 - Land Planning Analysis
Rural development analysis and planning proposal for the Eugene-Springfield Metro Region from a Landscape Architecture course.
Summer work on contract documents for Tektronix buildings and Planning projects.
Landscape design and plans for forested hillside residence in Eugene, OR.
Part time work serving beer, wine and food.
LA 389 - Landscape Architecture Design
Proposal for economic development of an island in Reedsport, OR owned by the Bohemia Lumber company from a Landscape Architecture design studio.
Part time work as a member of the University of Oregon student newspaper's editorial board creating a wide range of oft experimental and opinion-laced graphics.
LA 389 - Landscape Architecture Design
Site analysis and impressions sketches from early Landscape Architecture design studio.
LA 459 - Site Grading
Contour drawing exercise from Landscape Architecture course.
Huntley Carriage Shed
Balsawood model and hand drawings for New England style carriage shed garage.
Union Laborer Local 185
Six month job as the only laborer on a multi-trade crew of ten erecting five 20,000sf tilt-up concrete warehouse buildings.
LA 289 - Landscape Architecture Design
Clay totem from an early Landscape Architecture design studio exercise on storytelling.
LA 408 - Irrigation Workshop
Irrigation system drawings, calculations and specs from a Landscape Architecture course.
ARCH 333 - Introduction to Architectural Media
Isometric and perspective pencil sketches from Architectural media course.
Fall season work landscaping private gardens with crew of three, planting, building railroad tie retaining walls, weeding, raking, mulching and fertilizing residential and commercial gardens.
Summer and Fall season carpentry work on custom homes.
ART 291 - Drawing
Sketches channeling da Vinci with a somewhat loose antenna from a live model drawing Art studio.
ARCH 400 - Fundamentals of Drafting
Plans and details of Frank Lloyd Wright's Hull House as part of a learn-by-doing exercise from an Architectural drafting course.
Stained Glass Lamps
Projects resulting in a 24-inch curved Tiffany shaped lamp and an 18-inch flat-panel lamp.
Union Laborer Local 483
Summer work as the youngest of five Union laborers in a construction crew of over 60 on a 164,000 square foot tilt-up concrete shopping center.
Heart Lab Volunteer
Summer work assisting Heart Surgeon and Medical Resident in heart valve implant surgery testing on large dogs.
One day in second grade, my teacher obliged us kids to "write about what your fathers did for a living."