Improving productivity with SQL snippets

SQL snippets can be a big boost to productivity when writing T-SQL. First, to use a SQL snippet in a script you do not need to know the syntax, only the purpose of that SQL snippet (e.g. Delete an object, Create a table, etc.). Using snippets also reduces of the lines of code that has to be typed, and thus decreases the potential for errors that could occur from typing.

May 5, 2016

Retrieve unsaved SQL query scripts due to SQL Server Management Studio crash

Recovering work after SQL Server Management Studio crashes

Imagine a situation of working in SSMS, and suddenly the power goes out, the system gets crashed, SSMS gets crashed or your work session was abruptly terminated for any other reason, which causes the loss of unsaved work on various SQL scripts. In this situation SSMS provide prompt dialog window for recovered data after restarting:

March 21, 2016

How to improve SQL code layout and presentation

In this article we’ll describe how to improve T-SQL code layout and presentation using various features and options in ApexSQL Complete. We’ll examine the Code structure feature, how ApexSQL Complete highlights identifiers with brackets, how it manages closing characters, aliases, and column list.

March 4, 2015

How to track executed SQL Server queries

In this article, we’ll introduce a feature in ApexSQL Complete that keeps track of executed queries. ApexSQL Complete is a productivity add-in for SSMS and Visual Studio, that features SQL auto-complete, SQL formatting, and more.

March 4, 2015

How to code faster with SQL Server code snippets

ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in designed to speed up coding. It completes SQL statements automatically, fills in SQL fragments, generates outlines for the SQL script structure and speeds up coding with T-SQL code snippets.

February 24, 2015