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
SQL Snippets Galore, Added to SQL Prompt
Imagine having at your fingertips all the metadata queries you need to explore your SQL Server databases and then, a few clicks later, all your diagnostic queries to troubleshoot their performance. Phil Factor demonstrates how it can be done, by storing each set of snippets in a standard JSON collection and using PowerShell to convert them to SQL Prompt snippet files. Read moreCreating a SQL Code Snippet in SQL Prompt and SSMS
Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets. Read moreSQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies
Louis Davidson provides a pair of SQL Prompt snippets that will help you deal with dependencies, whenever you need to drop columns or tables. Read moreUsing SQL Prompt Code Snippets for Repetitive Tasks
Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries. Read moreTesting 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
