SQL Prompt Tips #5 - Current Statement Execution
Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.
2015-11-11 (first published: 2015-01-12)
7,563 reads
SQL PROMPT
News From EAP Testing
Jonathan Allen takes a peak at the EAP release of SQL Prompt 6 and some of the cool new things you can do to speed up writing SQL.
2013-08-21
1,637 reads
SQL Prompt Tips #2 - Casing Options
A quick tip to help you set your object names to your preferred case in T-SQL code.
2015-10-21 (first published: 2012-05-01)
2,230 reads
SQL Prompt Tips #4 - System Objects
A quick tip to help you get system object suggestions from SQL Prompt.
2015-11-04 (first published: 2012-05-01)
1,235 reads
SQL Prompt Tips #3 - Snippet Placeholder $Paste$
Another quick tip for SQL Prompt, using the snippets to increase your productivity.
2015-10-28 (first published: 2012-05-01)
1,479 reads
SQL Prompt Tips #1 - Selecting in the Object Explorer
A quick tip to help you get the most out of SQL Prompt.
2015-10-14 (first published: 2012-05-01)
1,652 reads
SQL Server Intellisense VS. Red Gate SQL Prompt
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
2010-04-09
4,030 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers