Built by Data Professionals.
For Data Professionals.
Most Popular
SQLYARD SQL SERVER Intelligence Center
● LIVE
Launch →
AI-powered operational intelligence for SQL Server environments. Get smart insights, actionable recommendations and automation guidance. Analyze health, performance, security, and more, all powered by AI.
HEALTH & PERFORMANCE
QUERY ANALYSIS
SECURITY
RECOMMENDATIONS
AI RECOMMENDATIONS
New
SQLYARD PostgreSQL Intelligence Center
AI-powered operational intelligence for PostgreSQL environments. Get smart insights, actionable recommendations and automation guidance. Analyze health, performance, vacuum & bloat, replication, security, and more — all powered by AI.
Health & Performance
Query Analysis
Vacuum & Bloat
Replication
Security
AI Recommendations
● LIVE
Learn More →
SQLYARD MigrateIQ
Intelligent database migration for SQL Server professionals. Migrate PostgreSQL & MySQL to or from SQL Server with AI-assisted stored procedure conversion, pre-flight assessment, and auto naming conflict resolution.
PostgreSQL ↔ SQL Server
MySQL ↔ SQL Server
AI Stored Proc Conversion
Pre-Flight Assessment
Windows Desktop App
● LIVE
Learn More →
From $299 • One-time license
Browser Tools
Statistics IO & TIME Parser
Paste raw SET STATISTICS IO and TIME output. Get a formatted table sorted by logical reads with totals and instant identification of your heaviest tables.
Execution Plan Splitter
SSMS chokes on plans over 10MB. Paste your execution plan XML, pick a split point, and download valid .sqlplan files you can actually open. No more hand-editing XML.
Wait Stats Analyzer
Paste output from sys.dm_os_wait_stats. Get a ranked breakdown of your top waits with category classification and actionable insights for each wait type.
MAXDOP Advisor
Enter your server hardware specs and live CXPACKET wait stats to get a runtime-informed MAXDOP recommendation — not just the install formula, but what your workload is actually telling you.
Query Plan Warning Detector
Paste your .sqlplan XML and scan for known warning signs — missing indexes, implicit conversions, tempdb spills, key lookups, and residual predicates. Prioritized findings, no graphical plan required.
PL/pgSQL to T-SQL Converter
Paste any PostgreSQL stored procedure, function, or trigger. AI converts it to T-SQL with a confidence score, performance suggestions, and flagged review items. No install required.
Scripts and Advisors
Compression and Partitioning Advisor
Stored procedure that analyzes every table and index in any database. Recommends PAGE, ROW, COLUMNSTORE, or None based on live workload signals and allocation unit composition. Includes partitioning candidacy, priority ordering, and auto-generated sp_estimate commands. SQL Server 2016 through 2025.
Orphan Users Fix Scripts
Three production stored procedures: spDBA_FixOrphanUsers, spDBA_FixOrphanUsersPassword, and spDBA_DropOrphanUsers. Diagnose and fix orphaned database users after migrations, restores, and AG failovers. Self-contained, safe to run in any user database. SQL Server 2016 through 2025.
Deadlock Alert Setup Script
Complete one-run setup script covering sp_altermessage, the SQL Agent alert, the Extended Events session, and the Agent notification job. Install once and SQL Server alerts you on every deadlock automatically. SQL Server 2016 through 2025.
Morning Health Check Script
Daily DBA health check script covering backup status, SQL Agent job failures, disk space, blocking sessions, top wait types, and error log review. Run it every morning before the phone starts ringing. SQL Server 2016 through 2025.