Custom Vista Notifiers
SQL-triggered alerts for job cost overruns, PO approval exceptions, AP invoice anomalies, change order thresholds, compliance expiry. Route via email, Teams, or Slack.
Vista by Viewpoint SQL Development
MS SQL Server development inside Vista by Viewpoint. Custom notifiers, triggers, stored procedures, custom tables, and data automation — the technical work generalist Vista partners refer out. AI-accelerated, senior-led.
What we build
Direct SQL Server development against Vista’s schema. No middleware, no scraping, no hope.
Custom Tables & Extensions
Extend Vista's schema without breaking upgrades. Project-specific fields, subcontractor tracking, certification management, custom cost types — cleanly integrated.
Stored Procedures & Functions
Write and optimize stored procs for WIP calculations, cost-to-complete logic, custom aging, and batch processing. Indexed, parameterized, performant.
Triggers & Data Integrity
Audit triggers, data validation, cross-table integrity rules, soft-delete patterns. Catches bad data before it pollutes job cost history.
SQL Performance Tuning
Slow month-end? Bloated databases? Reports timing out? We profile with Query Store and Extended Events, add indexes, rewrite queries. Typical 5-50x speedups.
Data Migration & Cleanup
Mass corrections to job history, vendor consolidation, cost code restructuring. Staging, validation, and rollback scripts — not hope-and-pray updates.
Frequently asked questions
What is a Vista notifier and who can build one?+
A Vista notifier is a SQL-triggered alert that fires when specific events happen in Vista (cost overrun, PO exception, AP anomaly). They're implemented as SQL triggers or scheduled procedures that write to Vista's notifier tables or send external notifications via email/Teams/Slack. MRU builds custom Vista notifiers across US deployments.
Can I add custom tables to Vista without breaking upgrades?+
Yes — when done right. Custom tables must follow Trimble's naming conventions (prefix), use non-conflicting IDs, and avoid modifying standard Vista tables. We design custom tables that survive Vista upgrades and integrate cleanly via views and stored procedures.
Do you work directly in SQL Server Management Studio?+
Yes. All development is direct SQL Server work — SSMS, Azure Data Studio, source-controlled .sql files. We follow Trimble and Microsoft best practices: parameterized queries, set-based logic, proper indexing, minimal cursor use.
Can you fix a slow stored procedure in Vista?+
Yes. Slow procedures in Vista typically stem from missing indexes on Job Cost History, RTL_Cost_Hist, or AP tables, SARGable predicate violations, or cursors where set-based logic should be used. We profile, fix, and benchmark. Most fixes deliver 5-50x improvement.
Is direct SQL access to Vista safe or will it void support?+
Reading Vista's SQL Server is standard practice and fully supported by Trimble — it's how Crystal Reports and most integrations work. Writes are more sensitive and must go through Vista APIs or vetted custom procedures that follow Trimble's schema rules. We respect that line.
Need Vista SQL work that generalist consultants won't touch?
Book a 30-minute scoping call. Notifiers, triggers, custom tables, performance fixes — we quote fast and ship faster.
Book a Free Scoping Call
30 minutes. No obligation. Hourly or fixed-price if we work together.