Tag Archives: SQL Prompt

Quick Tips – SQL Prompt with SSF

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into … Continue reading

Posted in Blog | Tagged , , , | 8 Comments

From the Labs of SQL Prompt

I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used to certain shortcut combinations that make it easy for me to write T-SQL quickly and get information on parameters without … Continue reading

Posted in Blog | Tagged , , , | 4 Comments

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id   Ugly to read, at least to me, and in a poorly … Continue reading

Posted in Blog | Tagged , , , | 1 Comment