Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
Product articles SQL Prompt SQL Code Snippets
Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt
With SQL Prompt and Phil Factor's chk code snippet, you can, with a few clicks, get a list of all the SQL statements executed within a batch, in SSMS, their execution plans, and their execution statistics, such as duration, CPU, logical reads and so on. Read moreBuilding reusable table build scripts using SQL Prompt
With SQL Prompt snippets you can invoke your favorite time-saving routines with a few clicks, and they also help standardize coding practices during team development . Phil Factor shows how to create a 'table-build generator' that will save you a lot of time, especially if you use a lot of working tables in your code. Read moreDriving up database coding standards using SQL Prompt
A strategic view of how a development team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets. Read more
Customizing the SQL Prompt built-in snippets: a better ALTER TABLE ADD (ata) snippet
Phil Factor improves SQL Prompt's built-in ALTER TABLE ADD (ata) snippet so that it enforces certain coding standards, such as specifying whether the column acceptsNULL values, and ensuring the new column is well-documented. Read more
