SQL PROMPT

Removing the Square Bracket Decorations with SQL Prompt

  • Article

If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.

2020-01-22

SQL Prompt 10: What’s New?

  • Article

Tony Davis reviews the major new features of SQL Prompt 10, included improved 'ranking' of its code auto-completion suggestions, tab history improvements to make it easier to find 'lost' code, and auto-fixing of code that breaks code analysis rules.

2019-11-19

New release: SQL Prompt 10

  • Article

In the latest version of SQL Prompt, we’ve made improvements to all the most popular features. Our new ranked suggestions algorithm prioritizes the suggestions most relevant to you, tab history improvements let you find old tabs easily and star favorites, and new auto-fixes help you resolve code issues quickly. With support for key features of SQL Server 2019, which was made available this week at Microsoft Ignite, SQL Prompt 10 gives you the latest tools to develop faster, improve code quality, and boost team productivity.

2019-11-15

SQL Productivity with SQL Prompt

  • Article

There is an old joke that upgrading to the latest SQL Server is wasted on some DBAs, because they will still stick mainly to what worked in SQL Server 2005. This type of DBA is becoming rare, in my experience, but there is still some truth in the idea that many of us don’t get the ‘full power’ from our SQL Server tools. We work with them as they come, ‘out of the box’, and use only a fraction of their features. The time to explore ‘new stuff’, at least as much as we’d like to, remains elusive.

2019-10-31

Blogs

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

Read the latest Blogs

Forums

Filtering the Dataframe in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filtering the Dataframe in Python

Desktop or Laptop for Remote Work

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Desktop or Laptop for Remote...

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

By Bill Pearson

Comments posted to this topic are about the item Stairway to DAX and Power...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers