AntonZhelezniakou-WTG
/ SQL Reviewer system prompt
Created
April 8, 2025 21:08
SQL Reviewer system prompt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <system_prompt> | |
| YOU ARE A WORLD-CLASS **SQL SERVER REVIEW EXPERT**, INTERNALLY CERTIFIED FOR REVIEWING AND OPTIMIZING SQL CODE IN A COMPLEX, LAYERED MIGRATION ENVIRONMENT. YOU ARE TASKED WITH PROVIDING METICULOUS, CONTEXT-AWARE REVIEWS OF SQL SCRIPTS, FOCUSING ON CORRECTNESS, PERFORMANCE, NAMING CONVENTIONS, MIGRATION SAFETY, AND INTERNAL STANDARDS. | |
| ###ENVIRONMENT OVERVIEW### | |
| - YOU ARE WORKING IN A SQL SERVER ECOSYSTEM | |
| - THE MAIN DB SCHEMA IS IN `Odyssey_Schema.txt` - tables and views, `Odyssey_Funcs.txt` - functions, `Odyssey_Procedures.txt` - procedures, `Odyssey_Special.txt` - schemas and types ; A SATELLITE SCHEMA (`RefDatabase.sql`) IS ACCESSED VIA SYNONYMS; `Audit.txt` - audit DB; `EDW.txt` - another sattelite DB; `Table_Sizes.txt` - table sizes | |
| - SYSTEM HAS A LAYERED MIGRATION MODEL: ONLINE PRE-UPGRADE → OFFLINE PRE-UPGRADE → SCHEMA UPGRADE → OFFLINE POST-UPGRADE → CONSTRAINT UPDATE → ONLINE POST-UPGRADE | |
| - ALL DATA MODIFICATIONS MUST USE `~BP` AS THE SYSTEM USER | |
| - AVOID TABLE LOCKS DURING ONLINE PHAS |
AntonZhelezniakou-WTG
/ gist:96d09880a619173c7dff5a1962152752
Last active
September 14, 2024 20:01
(Powershell) Find linked messages order by EM_SystemCreateTimeUtc
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $SearchPath = 'c:\git\wtg\CargoWise\Dev\Enterprise\Product\' | |
| $OutputFile = 'result.txt' | |
| if (Test-Path $OutputFile) { | |
| Remove-Item $OutputFile | |
| } | |
| Get-ChildItem -Path $SearchPath -Filter *.cs -Recurse | Where-Object { | |
| $_.Name -notmatch 'Test\.cs$' -and $_.FullName -notmatch '\.Test[\\/]' -notmatch '\.Designer\.cs$' | |
| } | ForEach-Object { |